Staff Position Assignment Extract
Contents
Introduction
The Staff Assignment extract is used to track staff assignments. The extract is generated in a comma-delimited format.
Selection Criteria
Selection criteria determine which database records are used in the report.
Staff Assignment Selection
The Staff Assignment extract includes staff assignment records from the [S_NE_USR_StaffAssignment_C] table that meet the following criteria:
- Staff members with an Assignment Date that is on or after the report start date.
- Staff members with an Assignment Date that is on or before the report end date.
- Staff members whose assignment has not yet completed. In other words, the Completion Date is 0/0/0 or after the report end date.
- Staff members who are associated with a school that is not excluded from state reporting.
Report Input
For help with navigation and report generation, see How to Find and Generate a Report.
Field | Description |
Select Schools | Choose one of the following:
Notes:
|
Start Date | Enter the first in session day of the school year. |
End Date | Enter the current date. The end date is automatically populated with 6/30/YY. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms. |
Report 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.
Element # | Data Element | Description | [Table]FieldName |
1 | Record Number | The sequential and unique number starting with 1 for the first number. | N/A |
2 | District Code | NDE number for the district. | [Prefs]Name=districtnumber [Prefs]Value |
3 | School Number | The school associated with the staff assignment. If the alternate school number is populated for the school, then that value is reported. Otherwise, the school number is reported. | [Schools]Alt_School_Number [Schools]School_Number |
4 | NDE Staff ID | The identifier assigned to the staff member by the NDE. | [S_NE_USR_X]Staff_ID |
5 | Local Staff ID | The locally assigned staff identifier. | [Users]TeacherNumber |
6 | Last Name | The staff member’s last name. | [Users]Last_Name |
7 | First Name | The staff member’s first name. | [Users]First_Name |
8 | Middle Name | The staff member’s middle initial. | [Users]Middle_Name |
9 | Suffix | Not reported. The staff member’s name suffix. | N/A |
10 | Controlling District Code | A six digit code assigned by the NDE to identify the entity that holds the contract for the staff member. This value should only match the current District Code if the staff member is assigned to a different district. | [S_NE_USR_StaffAssignment_C]ControlDistrict [S_NE_USR_ASSIGN_C]Control_District |
11 | Position Assignment Code | A five digit code identifying the staff member’s position. | [S_NE_USR_StaffAssignment_C]StaffAssignCode [S_NE_USR_ASSIGN_C]Position_Title |
12 | Full-Time Equivalency (FTE) | A value between 1 and 100 representing the percentage of the staff member’s time allocated to the assignment. This value is extracted without a decimal. | [S_NE_USR_StaffAssignment_C]StaffAssignPercent [S_NE_USR_ASSIGN_C]Assign_Percent |
13 | Assignment Date | The date of the assignment for the current term. This value is extracted in the format YYYY-MM-DD. | [S_NE_USR_StaffAssignment_C]StaffAssignDate [S_NE_USR_ASSIGN_C]Assign_Date |
14 | Completion Date | The date the assignment ends. This date must occur on or after the Assignment date. This value is extracted in the format YYYY-MM-DD. | [S_NE_USR_StaffAssignment_C] StaffAssignCompleteDate [S_NE_USR_ASSIGN_C]Complete_Date |
15 | School Year | The current fiscal school year. This value is extracted as June 30th. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms. | [Terms]LastDay |