S_MB_SSF_Employment_C (ver 14.3.0)
This table is a child table of the [SchoolStaff] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SchoolStaffDCID | 14.3.0 | Number(10,0) | Primary key that relates the extended table to the [SchoolStaff] table. |
PositionCode | 14.3.0 | Varchar2(3) | Code of the Teacher Position. |
Percentage | 14.3.0 | Number(25,10) | Percentage of full time equivalent that this employment record is allotted. |
StartDate | 14.3.0 | Date | Start date of employment record. |
EndDate | 14.3.0 | Date | End date of employment record. Null indicates that no end date is set. |
LeaveReason | 14.3.0 | Varchar2(3) | Code of the Teacher Leave Reason. |