060 – Staff Member
Introduction
This extract includes a demographic record for each staff member serving the school during the current school year.
Extracting Data for a Specific Staff Member
You can recreate and extract 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 060 - Staff Member checkbox.
- Navigate to Special Functions > Interfaces to other systems > Tennessee Education Information System (EIS) > Recreate Section/Staff Transactions,
- Select the 060 - Staff Member 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 "060" | 3 | N |
2 | Record Version | The version of this record. | Always "02" | 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 Otherwise: [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 | Instructional Program Number | The number used to uniquely identify the program within the school. Valid values: 01, 02, 03, 04, 05, or 06. | [S_TN_USR_X]InstructionalProgramNbr | 2 | Y |
9 | Staff Social Security Number | The staff member's social security number. | [Users]SSN | 9 | Y |
10 | Teacher License Number | The staff member's license number. | [S_TN_USR_X]LicenseNumber | 9 | Y |
11 | Local Staff Key | The internal ID assigned to the staff member's record in the PowerSchool database. | [Users]ID | 10 | Y |
12 | First Name | The staff member's legally recognized first name. | [Users]First_Name | 15 | Y |
13 | Middle Name | The staff member's legally recognized middle initial, if applicable. | [Users]Middle_Name | 15 | Y |
14 | Last Name | The staff member's legally recognized last name. | [Users]Last_Name | 25 | Y |
15 | Suffix | The staff member's legally recognized suffix, if applicable. The suffix is extracted from the last name as entered on the Edit Information staff page. Valid values: Jr, Sr, I, II, III, IV. | [Users]Last_Name | 3 | N |
16 | Date of Birth | The staff member's date of birth. | [UsersCoreFields]DOB | 8 | Y |
17 | Staff Previous Social Security Number | The staff member's previously reported social security number, if applicable. | [S_TN_SSF_X]PrevSSN | 9 | Y |
18 | Staff Previous Teacher License Number | The staff member's previously reported license number, if applicable. | [S_TN_SSF_X]PrevLicenseNumber | 9 | Y |
19 | Previous First Name | The staff member's previously reported first name, if applicable. | [S_TN_SSF_X]PrevFirstName | 15 | Y |
20 | Previous Last Name | The staff member's previously reported last name, if applicable. | [S_TN_SSF_XPrevLastName | 25 | Y |
21 | Gender | The staff member's gender. Valid values:
| [UsersCoreFields]Gender | 1 | Y |
22 | Race/Ethnic | The staff member's race/ethnicity. | [Users]Ethnicity | 1 | Y |
23 | Filler | N/A | N/A | 4 | N |
24 | Licensure Check | The reason the staff member may not be located in licensure. Valid values:
| [S_TN_USR_X]LicensureCheck | 1 | Y |
25 | Waiver Request Course | The SDE course code of a course the teacher is teaching, but not currently endorsed to teach. | [S_TN_SSF_X]WaiverCourse | 4 | Y |
26 | Staff Status | The staff member's work status. Valid values:
| [S_TN_USR_X]WorkStatus | 1 | Y |
27 | Staff Work Email Address | The staff member's work email address. | [Users]Email_Addr | 128 | Y |