048 – Student Class Assignment
Introduction
This extract includes a record for each section enrollment for students in the current school year.
For students who attend classes at another school (concurrent enrollments), the class assignment is reported both for the school at which the section is taught (the concurrent school) and for the school at which the student is enrolled (the student's primary school).
Report Input
For help with navigation and extract generation, see Create Selected Student Related Extract File.
Extract 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.
Item # | Data Element | Description | [Table]FieldName | Field Length | Track |
|---|---|---|---|---|---|
1 | Record ID | The identifier of this record. | Always "048" | 3 | N |
2 | Record Version | The version of this record. | Always "01" | 2 | N |
3 | Record Type | One of the following record types is reported in order to indicate how to modify the state data to match data in PowerSchool. The data in this record either needs to be added to, modified in, or deleted from the state data:
| N/A | 1 | N |
4 | Filler | N/A | N/A | 2 | N |
5 | District ID | The district number. | [Prefs]Value [Prefs]Name=districtnumber | 3 | N |
6 | School ID | The school number. If the student is taking this class at another school, then the class assignment is included in the file for both the school at which the section is taught (the concurrent school) and at the student's primary school. PowerSchool determines that the class assignment is a concurrent enrollment if the SchoolID of the class enrollment record does not match the SchoolID of their primary school. | [Schools]Alternate_School_Number - if populated Otherwise: [CC]SchoolID | 4 | N |
7 | School Year | The four-digit year that the instructional program will be operated to provide instructional services to students. This is the current full year term, as defined using the special operation. See the District Setup > Years & Terms section for more information. | [Terms]FirstDay [Terms]LastDay | 4 | N |
8 | Instructional Program Number | The number used to uniquely identify the program within the school. Valid values: 01, 02, 03, 04, 05, or 06. | [Students]Track | 2 | N |
9 | Student Social Security Number | The student's social security number. | [Students]SSN | 9 | N |
10 | Student PIN | The student's PIN, if the social security number is not provided or reported. | [S_TN_STU_X]StudentPIN | 9 | N |
11 | Local Student Key | The internal ID assigned to the student's record in the PowerSchool database. | [CC]StudentID | 10 | N |
12 | Local Class Number | The internal section id value from the section enrollment record or the course number + section number Note: Setting is defined in the district > district info setting: Extract as course.section Yes/No | [CC]SectionID or [CC]Course_Number+[CC]Section_Number | 15 | N |
13 | Student Class Begin Date | The date the student was scheduled to first attend the course. | [CC]DateEnrolled | 8 | Y |
14 | Student Class End Date | The date the student left the course. This value is reported as the day before the date recorded in PowerSchool. The date recorded in PowerSchool must be the day after the student's last day in class. Note: If the class does not have an end date, this field is reported as a zero (0). | [CC]DateLeft, if populated. Otherwise: '0' | 8 | Y |
15 | Vocational Outside LEP | Indicates that the student's course meets vocational qualification above the base 23.5 Special Ed. If using EDPlan the vocational status is determined from the vocational indicator found on the student > state > Special Education information page. If not using EDPlan the indicator found in Student > Special Programs page will be used to determine vocational status. | [S_TN_SEN_X]VocOutsideIEP | 1 | Y |
16 | State Assigned Student ID | The student's state assigned identifier. | [Students]State_StudentNumber | 9 | N |
17 | Filler | N/A | N/A | 11 | N |