nssrs_assignment
The nssrs_assignment table stores position assignment details.
The following table lists the field names, data types, and descriptions of the nssrs_assignment table.
Field Name | Data Type | Description |
|---|---|---|
rpt_date | Date | Report date |
empl_no | Integer(6) | Employee number |
ssn | Char(11) | Social Security |
location | Char(4) | School ID |
spi | Char(1) | SPI |
code | Char(4) | Code |
fte | Decimal(7,6) | FTE (Full-time equivalent) |
subject | Char(2) | No longer reported |
grade | Char(2) | No longer reported |
qual_status | Char(1) | Professional assessment passed |
highly_qualified | Char(1) | No longer reported |
asn_date | Date | Assignment date |
comp_date | Date | Completion date |
lock_flag | Char(1) | No longer used |
controlling_dist | Char(7) | Controlling District |
district_code | Char(7) | District |
assignment | Char(12) | Assignment |
nde_id | Char(10) | NDE Staff ID |
days_worked | Decimal(4,1) | Days worked |