Skip to main content
Skip table of contents

Student Course Enrollment Template

Contents

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

21Not CollectedA blank placeholder is extracted.N/AN/AN/A
22Not CollectedA blank placeholder is extracted.N/AN/AN/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
24Dual Enrollment Course PassIndicates whether the student passed the course or not.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/N1
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.