Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AbsenceSeq | int | 4 | null |
|
|
|||
| StaffID | int | 4 | null |
|
|
|||
| StaffSurname | varchar | 30 | null |
|
|
|||
| StaffPreferred | varchar | 20 | null |
|
|
|||
| NameExternal | varchar | 100 | null |
|
|
|||
| StaffSchoolStaffCode | varchar | 30 | null |
|
|
|||
| StaffCampus | varchar | 3 | null |
|
|
|||
| StaffCampusDescription | varchar | 30 | √ | null |
|
|
||
| StaffCategory | varchar | 15 | null |
|
|
|||
| StaffCategoryDescription | varchar | 50 | √ | null |
|
|
||
| StaffDepartmentCode | varchar | 15 | null |
|
|
|||
| StaffDepartmentDescription | varchar | 80 | √ | null |
|
|
||
| StaffActiveFlag | bit | 1 | null |
|
|
|||
| SynergyMeaning | varchar | 15 | √ | null |
|
|
||
| StaffStartDate | datetime | 16,3 | √ | null |
|
|
||
| StaffLeavingDate | datetime | 16,3 | √ | null |
|
|
||
| AbsenceDate | datetime | 16,3 | √ | null |
|
|
||
| ArrivalTime | varchar | 5 | null |
|
|
|||
| DepartureTime | varchar | 5 | null |
|
|
|||
| FractionOfDay | decimal | 7,2 | null |
|
|
|||
| AbsenceType | varchar | 15 | null |
|
|
|||
| AbsenceTypeDescription | varchar | 30 | null |
|
|
|||
| ReasonCode | varchar | 15 | null |
|
|
|||
| AbsenceReasonDescription | varchar | 30 | null |
|
|
|||
| AbsenceDescription | varchar | 50 | null |
|
|
Table contained 0 rows