S_NE_USR_ASSIGN_C (ver 16.1.0)
This is an extension of the User table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 16.1.0 | Number(10,0) | Primary key. |
USERSDCID | 16.1.0 | Number(10,0) | Primary key. |
Assign_Code | 16.1.0 | Varchar2(15) | Assignment code. |
Assign_Date | 16.1.0 | Date | Date the assignment began. |
Assign_District | 16.1.0 | Varchar2(7) | Place brief description here. |
Assign_Grade | 16.1.0 | Varchar2(2) | Place brief description here. |
Assign_Location | 16.1.0 | Varchar2(3) | Place brief description here. |
| Assign_Percent | 16.1.0 | Number(25,10) | Percent of time allocated to the assignment. |
| Assign_Subject | 16.1.0 | Varchar2(2) | Assignment Subject Code. |
| Assign_Year | 16.1.0 | Number(11,0) | Year of the assignment. |
| Complete_Date | 16.1.0 | Date | Date the assignment ended. |
| Control_District | 16.1.0 | Varchar2(7) | District code if the assignment is not associated with the current school. |
| Position_Title | 16.1.0 | Varchar2(30) | Position title of the of the staff member. |
| SchoolID | 16.1.0 | Number(11,0) | School ID. |
| Staff_Classification | 16.1.0 | Varchar2(30) | Classification of the staff member. |