Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StaffJobPositionsSeq | int | 4 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| JobPositionsSeq | int | 4 | √ | null |
|
|
||
| JobPositionCode | varchar | 15 | null |
|
|
|||
| JobPositionDescription | varchar | 80 | null |
|
|
|||
| AwardCode | varchar | 15 | null |
|
|
|||
| AwardLevelCode | varchar | 15 | null |
|
|
|||
| JobPositionCategoryCode | varchar | 15 | null |
|
|
|||
| JobPositionActiveFlag | bit | 1 | null |
|
|
|||
| ReportsToJobPositionsSeq | int | 4 | √ | null |
|
|
||
| MailNamePrimary | varchar | 100 | null |
|
|
|||
| NameInternal | varchar | 100 | null |
|
|
|||
| Surname | varchar | 30 | null |
|
|
|||
| Preferred | varchar | 20 | null |
|
|
|||
| OccupEmail | varchar | 100 | null |
|
|
|||
| StaffName | varchar | 123 | null |
|
|
|||
| SchoolStaffCode | varchar | 30 | null |
|
|
|||
| CurrentJobPositionFlag | bit | 1 | √ | null |
|
|
||
| FutureJobPositionFlag | bit | 1 | √ | null |
|
|
||
| JobLevel | tinyint | 1 | null |
|
|
|||
| JobLevelNextIncrementDate | datetime | 16,3 | √ | null |
|
|
||
| StartDate | datetime | 16,3 | √ | null |
|
|
||
| EndDate | datetime | 16,3 | √ | null |
|
|
||
| AppointmentLetter | varchar | 2147483647 | √ | null |
|
|
||
| FTE | decimal | 8,4 | null |
|
|
|||
| JobLevelNextIncrementYears | smallint | 2 | null |
|
|
|||
| NextReviewDate | datetime | 16,3 | √ | null |
|
|
||
| OverrideReportsToJobPositionsSeq | int | 4 | √ | null |
|
|
||
| StaffJobPositionsGUID | varchar | 32 | null |
|
|
|||
| StaffCampus | varchar | 3 | null |
|
|
|||
| LeavingDate | datetime | 16,3 | √ | null |
|
|
Table contained 0 rows