062 – Staff Member Current Assignment
Introduction
This extract includes a record for each staff member assignment during the current school year, such as Title I, kindergarten, consulting, etc.
Extracting Current Assignment Data for a Specific Staff Member
You can recreate and extract current assignment data for an individual staff member. The next time the extract is created, the recreated data will be included.
- Navigate to the Staff > [select staff] > Information page for the staff member.
- Select the Recreate 062 - Staff Member Current Assignment checkbox.
- Navigate to Special Functions > Interfaces to other systems > Tennessee Education Information System (EIS) > Recreate Section/Staff Transactions,
- Select the 062 - Staff MemberCurrent 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 "062" | 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. | [Schools]Alternate_School_Number - if populated Otherwise: [SchoolStaff]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. | [SchoolStaff]ID | 10 | N |
11 | Current Assignment | The staff member's current assignment. See the Appendix for code values. | [S_TN_USR_StaffAssignments_C] StaffAssignment | 2 | Y |
12 | Current Assignment Begin Date | The date that the assignment began. | [S_TN_USR_StaffAssignments_C] AssignmentBeginDate | 8 | Y |
13 | Current Assignment End Date | The date that the assignment ended. | [S_TN_USR_StaffAssignments_C] AssignmentEndDate | 8 | Y |
| 14 | Federal Funding type | The type of Federal Funding granted. | [S_TN_USR_StaffAssignments_C]LocalFundingType | 8 | Y |
| 15 | Local Funding type | The type of Local Funding granted. | [S_TN_USR_StaffAssignments_C]LocalFundingType | 8 | Y |
14 | Other Funding types | Other funding types if applicable. | [S_TN_USR_StaffAssignments_C]OtherFunding Type | 8 | Y |