063 – Staff Member Class Assignment
Introduction
This extract includes a record for each section taught by a staff member during the current school year.
Extracting Data for a Specific Staff Member Class Assignment
You can recreate and extract a staff member class assignment for individual sections and/or for an individual staff member. The next time the extract is created, the recreated data will be included.
To recreate and extract a staff member class assignment for an individual section:
- Navigate to the School Setup > [select course] > Edit Section page for the section.
- Select the Recreate 063 - Staff Member Class Assignment checkbox.
- Navigate to Special Functions > Interfaces to other systems > Tennessee Education Information System (EIS) > Recreate Section/Staff Transactions.
- Select the 063 - Staff Member Class Assignment checkbox.
- Click Submit.
To recreate and extract a staff member class assignment for an individual staff member:
- Navigate to the Staff > [select staff] > Information page for the staff member.
- Select the Recreate 063 - Staff Member Class Assignment checkbox.
- Navigate to Special Functions > Interfaces to other systems > Tennessee Education Information System (EIS) > Recreate Section/Staff Transactions,
- Select the 063 - Staff MemberClass Assignment checkbox.
- Click Submit.
Report Input
For help with navigation and extract generation, see Create Selected District/School/Staff 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 "063" | 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 | 3 | N |
6 | School ID | The school number. | [Schools]Alternate_School_Number - if populated [Users]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 | Staff Social Security Number | The staff member's social security number. | [Users]SSN | 9 | N |
9 | Teacher License Number | The staff member's license number. | [S_TN_USR_X]LicenseNumber | 9 | N |
10 | Local Staff Key | The internal ID assigned to the staff member's record in the PowerSchool database. | [Sections]Teacher | 10 | N |
11 | 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 | [Sections]ID or Course_Number+Section_Number | 15 | Y |
12 | Staff Class Begin Date | The first day that the class meets. This date is determined by the term associated with the section. | [Terms]FirstDay [Sections]TermID = [Terms]ID | 8 | N |
13 | Staff Class End Date | The end date associated to the teacher assignment to the section. Generally, this is the last day of the term, but this may not be the case if a teacher leaves a class prior to the term end-date. | [Terms]LastDay [Sections]TermID = [Terms]ID | 8 | N |
14 | Teacher of Record | This indicator is determined by the teacher status. If the teacher is a lead teacher the teacher will be reported as the teacher of record. If the teacher is a co-teacher or job share teacher the teacher will be not be reported as the teacher of record. | Calculated based on the lead teachers associated to the section. | 1 | Y |
15 | Federally Funded | Indicates whether this section is federally funded (Yes, No or blank). No and blank both indicate that the section is not federally funded. | [S_TN_SEC_X]FederallyFunded | 1 | Y |
16 | Filler | N/A | N/A | 18 | N |
999 | Track Only | N/A | [Sections]TermID | N/A | Y |