Student Course Enrollment Template

Introduction

This report contains information on student enrollment in each course/section combination. The report includes students enrolled in course sections as of the reporting date.

Selection Criteria

Selection criteria determine which database records is used in the report. Refer to selection criteria for analysis when the report does not return the correct records:

The date enrolled in the course must be on or before the Report End Date.
The date of leaving the course must be on or after the Report Start Date.

Selection Info

Graduated students who meet the selection criteria above are also included.

Report Input

For help with report generation and navigation, see Student Course Enrollment Template.

Field	Description
Use	Choose one of the following from the pop-up menu: If sub-districts are not enabled: Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools (default) – Run the report for all schools. Includes all student records on the PowerSchool server that meet the selection criteria If sub-districts are enabled: Select Sub-district - Select the sub-district for which you want to run the report. Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria. 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.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) - Execute the report immediately in the background. ASAP - Execute the report in the order it is received in the Report Queue. At Night - Execute the report during the next evening. On Weekend - Execute the report during the next weekend. On Specific Time - Execute the report on the date and time specified.
Report Start Date	Enter the start date of the reporting period.
Report End Date	Enter the end date of the reporting period.
Field Delimiter	Select the field delimiter for the extract file.
Enrollment Period Number	Enter the enrollment period number. See the PIMS Manual Template for the appropriate value.
Show Column field Headers	Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report.
Run From Extract Viewer	Choose one of the following from the pop-up menu: No (default) - The records that currently exist in the Extract Viewer are replaced. Yes - Create an extract file from the records in the Extract Viewer. Use the extract viewer to view and edit records before submitting the file to the state.

Report Output

Each of the fields displayed in the output of the report are described below. See Student Course Enrollment Template for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	District Code	The unique 9-digit Administrative Unit Number assigned by the PDE. This field is extracted from Start Page > District Setup > District Information. If sub-district is enabled, the selected sub-district appears in this field.	[Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number	Alpha-numeric	9
2	Location Code	The 4-digit code identifying the school assigned by the PDE. This field is extracted from Start Page > District Setup > Schools/School Info > Edit School.	[S_PA_SCH_X]PIMS_Location_Code [Schools]School_Number If sub-districts are enabled: [CST_SchoolSubDistricts]SchoolID	Alpha-numeric	4
3	School Year Date	This field is calculated based on the last day of the school year for the term selected at the top of the page when running the report.	[Terms]LastDay	Alpha-numeric	10
4	Enrollment Period Number	002 is automatically be extracted for this field.	N/A	Numeric	3
5	Effective Date	The date the course enrollment became effective. This applies to both enrollment activity and withdrawal activity. This field is extracted from Start Page > Student > All Enrollments.	[CC]DateEnrolled [CC]DateLeft	Numeric	10
6	Enrollment Code	This field is calculated on the term Id on the student’s cc record and the dates the student is enrolled into the course and what dates are entered at the runtime of the report.	Data is derived based on the following combination of fields and date entered at the runtime of the report [CC]TermID [CC]DateEnrolled	Alpha-numeric	6
7	Student ID	The PAsecureID assigned to the student. This field is extracted from Start Page > Student > State/Province - PA > PA SecureID.	[Students]State_StudentNumber	Alpha-numeric	9
8	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
9	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
10	Request Sequence	The code used to distinguish between enrollments in identical Course/Section combinations for the same student. Identical enrollments may occur for Independent Study projects or Study Hall, for example. This field is extracted from Start Page > Student > All Enrollments. 0 is the default if no value is entered.	[S_PA_CC_X]Reqest_Sequence_Code	Alpha-numeric	3
11	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
12	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
13	Supplementary Course Differentiator	The general span of time in which a course and its sections are offered. This value is used as a unique indicator when the same Course Code is offered in for more than one-time period during the school year. This field is extracted from Start Page > District Setup > Courses > Edit Course District Information.	[S_PA_CRS_X]Semester_Code	Alpha-numeric	2
14	Course Code Long	The locally assigned course number. This field is extracted from Start Page > School Setup > Sections > Edit Section.	[CC]Course_Number	Alpha-numeric	12
15	Course Delivery Model Code	The method in which the course instruction is delivered to the student. This field is extracted from Start Page > Student > All Enrollments.	[S_PA_CC_X]Course_Delivery_Model_Code	Alpha-numeric	4
16	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
17	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
18	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
19	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
20	Section Code Long	The locally assigned section number. This field is extracted Start Page > School Setup > Sections > Edit Section.	[CC]Section_Number	Alpha-numeric	25
21	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
22	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
23	Dual Credit Student Take Credit	Indicates whether the student took credit for a dual credit course. If Dual Credit field in the Enrollment record is Y, then this field is required.	[S_PA_CC_X]Dual_Credit_Taken		1
24	Dual Enrollment Course Pass	Indicates whether the student passed the course or not.	[S_PA_CC_X]Dual_Credit_Pass, if blank then the following logic applies If a student is enrolled in a Dual Credit course AND has earned credit for the course, a value of Y is reported. Else, N is reported. Note: A blank value is extracted for students who are not enrolled in a Dual Credit course.	Y/N	1