Advanced Coursework
Contents
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
The report selects records based on the following criteria:
- The Students must be scheduled into a section for course that is specified as an Advanced Coursework Course.
- The Course must not be indicated to be excluded from State Reporting.
- The Students cannot be excluded from State Reporting.
- The Start of the class must be before the user specified End Date.
- The End Date of the class must be on after the user specified Start Date.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools | If run at the district level, choose one of the following:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Start Date | Enter the Start Date for this report. |
End Date | Enter the End Date for this report. |
| Scheduling Options | Description |
Scheduling – Run Now | Leave Run Now selected to run the report now. |
Submit | Click Submit to run the report now. |
Scheduling – Please Select When to run | Click the Schedule button to schedule this report to run. |
Please Select Schedule Settings | Enter the Start Date and Start time. Click the Repeat button. |
Please select repeat cycle options. | Choose the applicable option. |
Please select end date range option | Enter the appropriate information. |
Submit | Click Submit to schedule the report |
Districts using the Automated Data Transfer (ADT) system may utilize the SQL script for state reporting purposes provided at the bottom of the report page.
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Column | Data Element | Description | [Table]FieldName | Field Type | Field Length |
A | DISTCODE | This field contains the two-digit local education agency code (LEA). This field is extracted from the District Information page, Start Page > District Setup > District Information. | [Pref]districtnumber | Numeric | 2 |
B | SCHCODE | This field contains the four-digit code that identifies the school building. This field is extracted from the Edit School page, Start Page > District Setup > Schools/School Info > Edit School. | [S_RI_SCH_X]Ride_ID | Numeric | 5 |
C | SASID | This field contains the student identification number assigned by the Rhode Island State Department of Education. This field is extracted from the Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information. | [Students]State_StudentNumber | Text | 10 |
D | LASID | This field contains the PowerSchool student number assigned to the student. This field is extracted from the Demographics page, Start Page > Student Selection> General Demographics. | [Students]Student_Number | Text | 16 |
E | LASTNAME | This field contains the last name of the student. This field is extracted from the Demographics page, Start Page > Student Selection> General Demographics. | [Students]Last_Name | Text | 50 |
F | COURSEENROLLTYPE | This field contains the enrollment type for this enrollment. This field is extracted the edit course page, Start Page > School > Courses > Edit Course District Information > Advanced Coursework or from the Start Page > Sections > Edit Section > Advanced Coursework. Reported Values: Dual - Student is taking the course at the post-secondary institution. Concurrent - Student is taking the course in enrolled LEA at a public school and taught by a public-school teacher while earning post-secondary credit. Other - An advanced course that is not a DUAL or a CONCURRENT course | [S_RI_SEC_DCE_X]PS_Enrolltype OR [S_RI_CRS_DCE_X]PS_Enrolltype | Text | 10 |
G | PROVIDERID | This field contains the RIDE ID for the Provider. This field is extracted the edit course page, Start Page > School > Courses > Edit Course District Information > Advanced Coursework or from Start Page > Sections > Edit Section > Advanced Coursework. | [S_RI_SEC_DCE_X]Instituion_ID OR [S_RI_CRS_DCE_X]Instituion_ID | Numeric | 4 |
H | PROVIDERCOURSEID | This field contains the Course ID used by the Provider. This field is extracted the edit course page, Start Page > School > Courses > Edit Course District Information > Advanced Coursework or from the Start Page > Sections > Edit Section > Advanced Coursework. | [S_RI_SEC_DCE_X]Instituition_CourseID OR [S_RI_CRS_DCE_X]Instituition_CourseID | Text | 50 |
I | PROVIDERCOURSENAME | This field contains the Provider Course Name for this enrollment. This field is extracted the edit course page, Start Page > School > Courses > Edit Course District Information > Advanced Coursework or from the Start Page > Sections > Edit Section > Advanced Coursework. | [S_RI_SEC_DCE_X]Instituition_CourseName OR [S_RI_CRS_DCE_X]Instituition_CourseName | Text | 100 |
J | PROVIDERCOURSECREDITS | This field contains the Provider credits available to the student who completes the course. This field is extracted the edit course page, Start Page > School > Courses > Edit Course District Information > Advanced Coursework or from the Start Page > Sections > Edit Section > Advanced Coursework. | [S_RI_SEC_DCE_X]Instituition_CourseCredits OR [S_RI_CRS_DCE_X]Instituition_CourseCredits | Text | 4 |
K | LOCALSECTIONID | This field contains the reporting section id. It is the ‘sectionid – teacher number’. For example, ‘1000-100’ | [Sections]ID | Text | 20 |
L | PROVIDERCREDITEARNED | This field contains the number of Provider credits the student earned. This field is extracted the edit course page, Start Page > School > Courses > Edit Course District Information > Advanced Coursework or from the Start Page > Sections > Edit Section > Advanced Coursework. | [S_RI_SEC_DCE_X]Instituition_CourseCredits OR [S_RI_CRS_DCE_X]Instituition_CourseCredits The Post-Secondary Credit Earned is submitted only when a student earns credit for completing the course. This is determined by the Store Code specified for the TCS Section Student Submission. Start Page > School > Years and Terms > Edit Terms > Edit Terms. | Text | 4 |
| M | PROVIDERNUMERICGRADEEARNED | This field contains a final indicator of student performance in a course as submitted by the instructor/Provider. Not currently extracted. | NA | ||
| N | PROVIDERLETTERGRADEEARNED | This field contains a final indicator of student performance in a course as submitted by the instructor/Provider. Not currently extracted | NA | ||
O | COURSETERM | This field contains the Post-Secondary Course Credits Earned by the student who completes the course. This field is extracted the edit course page, Start Page > School > Courses > Edit Course District Information > Advanced Coursework or from the Start Page > Sections > Edit Section > Advanced Coursework Reported values: FALL - Fall Session WINTER - Winter Session SPRING - Spring Session YEARLONG -Year Long Course INTERSESSION - Term in between 2 Sessions OTHER - Other Term - Not Included Above | [S_RI_SEC_DCE_X]Course_Term or [S_RI_CRS_DCE_X]Course_Term | Text | 15 |
P | HSCREDITEARNED | This field contains the High School Credit earned by the student. This field is extracted from the Edit Stored Grade page, Start Page > Student Selection> Historical Grades > Edit Stored Grade | [StoredGrades]Credit_Earned High School | Text | 4 |
Q | EXITREASON | This field contains the reason the student exited the course. This field is extracted from the Edit Enrollment page, Start Page > Student Selection> All Enrollments > Select an Enrollment > Edit. Reported values: DROPPED - Fall Session WITHDREW - Winter Session MOVED - Spring Session | [S_RI_CC_X]Exit_Reason | Text | 8 |
R | ADNETWORKCOURSE | This field is extracted the edit course page, Start Page > School > Courses > Edit Course District Information > Advanced Coursework or from the Start Page > Sections > Edit Section > Advanced Coursework Reported values: Y If Advanced_Network = 1 else N | [S_RI_SEC_DCE_X]Advanced_Network or [S_RI_CRS_DCE_X]Advanced_Network | Text | 1 |