Student Course Enrollment Template (EWS)

Schools to Include*

Indicate which schools to include in the report by selecting from the following options:

If sub-districts are not enabled:

• 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 sub-districts are enabled:

• Select Sub-district – Select sub-districts to include in the report. To select a single sub-district, click that sub-district. To select multiple schools, use Ctrl+Click and select each sub-district to be included.
• 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 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.

Report Start Date*

Enter the start date using the format mm/dd/yyyy for the first day of the reporting period.

Report End Date*

Enter the end date using the format mm/dd/yyyy for the last day of the reporting period.

Field Delimiter

Choose the field delimiter for the extract file from the pop-up menu.

Include Header Labels in output file?

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.

Scheduling

Select when to run the report.

• Run Now – Execute the report immediately.
• Schedule - Execute the report on the date and time specified.
  • Start Date - Enter a start date to run the report.
  • Start Time – Enter a start time to run the report.
  • Select Run Once or Repeat to schedule how often the report is run.

1

District Code

[Prefs]District_Number

If sub-districts are enabled:

[CST_SubDistricts]Subdistrict_Number

Numeric

R

2

Location Code

[Schools]School_Number

If sub-districts are enabled:

[CST_SchoolSubDistricts]SchoolID

Numeric

R

3

School Year Date

A single date indicating the whole school year. June 30, at the end of the standard school year, is used to designate a school year. Thus, the 2014-2015 school year would be indicated by 2015-06-30.

Derived from [Terms]

Date

R

4

Enrollment Period Number

All LEAs should enter a value of 002 in the Enrollment Period Number field.

static value = 002

Numeric

R

5

Effective Date

The date on which the enrollment information becomes effective. If the actual entry date is unknown, the first day of the marking period should be used.

[CC]DateEnrolled[CC]DateLeft

Date

R

6

Enrollment Code

The enrollment code that indicates the type of course enrollment activity that occurred.

Derived from CC table when student enrolls into a course exact E1. When student drops from class extract W1. Only report student with a W1 when they have dropped from the class.

AlphaNumeric

R

7

Student ID

The unique, 10-digit PAsecureID assigned to the student.

[Students]State_StudentNumber

Numeric

R

10

Request Sequence

The request sequence is derived from the internal DCID assigned to a section.

Derived based on the internal DCID assigned to a section

Numeric

CR

13

The supplemental course differentiator that represents the general span of time in which the course and its sections are offered. This value is used as a unique indicator when the same Course Code is offered during more than one time period for the school year.

See the Appendix for valid values.

14

Course Code Long

[Sections]Course_Number

AlphaNumeric

O

20

Section Code Long

Class section number assigned by LEA to identify distinct classes.

This field should be the local section number only.

[Sections]Section_Number

AlphaNumeric

R

22

Homeroom Indicator

Indicates whether the class is considered the student's Homeroom.

[S_SEC_X]Homeroom_Indicator

[S_CC_X]Homeroom_Indicator

Y/N

R