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: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. 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 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
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

Back to Top