Staff Position Assignments Report
The following table lists the field number, field name, description, data type, size, and location of the data for the Staff Position Assignments report.
Field Number | Field Name | Description | Data Type | Location |
|---|---|---|---|---|
1 | Record Number | A Sequential and unique number starting with 1 for the first record. | Numeric(5) | Record count when the records are reported. |
2 | County District Number | A six-digit NDE-assigned number to identify the district/system, including leading zeros and the hyphen. The format is xx-xxxx. | Char(7) | nssrs_assignment.district_code |
3 | School Number | The three-digit NDE assignment number to identify the school location, including leading zeros. | Char(3) | nssrs_assignment.location |
4 | NDE Staff ID | The ten-digit NDE Staff ID. | Char(10) | nssrs_assignment.nde_id |
5 | Local Staff ID | A unique number used to designate a staff member at the local level. | VarChar(20) | nssrs_assignment.empl_no |
6 | Last Name | The last name of the staff member. | VarChar(30) | nssrs_mnt.lname |
7 | First Name | The first name of the staff member. | VarChar(30) | nssrs_mnt.fname |
8 | Middle Initial | The middle initial of the staff member. | Char(1) | nssrs_mnt.mid_init |
9 | Name Suffix | The suffix for the staff member's surname, if applicable. | VarChar(10) | nssrs_mnt.name_suffix |
10 | Controlling District Code | The six-digit NDE-assigned number that identifies the entity that holds the contract for the staff reported. The format is xx-xxxx. | Char(7) | nssrs_assignment.controlling_district |
11 | Position Assignment Code | The five-digit code to identify the staff person's position. The format is x-yyyy where
| Char(6) | nssrs_assignment.spi,"-",nssrs_assignment.code |
12 | Full-Time Equivalency (FTE) | A value between 1 and 100 that indicates the percentage of the staff member's time allocated to the assignment. Do not use decimals. | Numeric(3) | nssrs_assignment.fte |
13 | Assignment Date YYYY-MM-DD | The date when the staff member starts the assignment during the current school year. | Char(10) | nssrs_assignment.asn_date |
14 | Completion Date YYYY-MM-DD | The date when the staff member completes the assignment in the current school year. | Char(10) | nssrs_assignment.comp_date |
15 | School Year | June 30th of the current school year. The format is YYYY-MM-DD. | Char(10) | "20",fam_prof.yr,"-06-30" |
16 | Days Worked | The number of days worked by each substitute teacher. | Decimal(4,1) | nssrs_assignment.days_worked |