S_MN_SSF_NonLicAssign_C (Version 17.9.0)
This table is a child table of the SCHOOLSTAFF table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 17.9.0 | Number (10,0) | Primary Key. |
ForeignKey | 17.9.0 | Number (11,0) | SCHOOLSTAFF table ID. |
| SchoolStaffDCID | 17.9.0 | Number (10,0) | Foreign key used to link back to the SCHOOLSTAFF table. |
| Unique_ID | 17.9.0 | Number (11,0) | Primary key from the Virtual Table. |
| Emp_Class | 17.9.0 | Number (11,0) | A code used to identify the general occupation of the employee. |
| Full_Part_Time | 17.9.0 | Varchar2 (1) | Indicates if the staff member is a full- or part-time employee. |
| Hrs_Per_Week | 17.9.0 | Number (25,10) | A number representing the typical number of hours the non-licensed staff person works per week, not including overtime. |
| New_Non_Lic_Staff | 17.9.0 | Varchar2 (2) | A code used to identify the employment status of all non-licensed staff. |
| SchoolID | 17.9.0 | Number (11,0) | The state assigned school number associated with this staff member. |
ForeignKey_Alpha | 17.9.0 | Varchar2 (31) | Default field. No longer used. |