S_AL_USR_StaffPosition_C ver 22.5.2.2
This table is a child table extension of the Users table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 22.5.2.2 | Number(19,0) | The primary key that indicates a unique ID |
| UsersDCID | 22.5.2.2 | Number(19,0) | The primary key that relates the child table back to the Users table |
| End_Date | 22.5.2.2 | Date | Date when Staff member ended the position |
| SchoolID | 22.5.2.2 | Varchar2(9) | The primary key that relates the child table back to the Schools table |
| Staff_Position | 22.5.2.2 | Varchar2(4000) | The name of the staff position |
| Start_Date | 22.5.2.2 | Date | Date when Staff member was assigned the position |
| Staff_Position_Cat | 22.2.2.0 | Varchar2(40) | Staff Position Category |