Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PayrollYear | smallint | 2 | √ | null |
|
|
||
| ID | int | 4 | null |
|
|
|||
| EmployeeNameInternal | varchar | 100 | √ | null |
|
|
||
| EmployeeNameExternal | varchar | 100 | √ | null |
|
|
||
| EmployeeLegalFullName | varchar | 150 | √ | null |
|
|
||
| EmployeeSurname | varchar | 30 | √ | null |
|
|
||
| EmployeePreferred | varchar | 20 | √ | null |
|
|
||
| EmployeePreferredFormal | varchar | 20 | √ | null |
|
|
||
| EmployeeGiven1 | varchar | 20 | √ | null |
|
|
||
| PayGroup | varchar | 5 | √ | null |
|
|
||
| PayGroupDescription | varchar | 40 | √ | null |
|
|
||
| Category | varchar | 5 | √ | null |
|
|
||
| CategoryDescription | varchar | 50 | √ | null |
|
|
||
| AwardCode | varchar | 15 | null |
|
|
|||
| AwardDescription | varchar | 100 | √ | null |
|
|
||
| LeaveCode | varchar | 15 | null |
|
|
|||
| LeaveDescription | varchar | 30 | √ | null |
|
|
||
| EntitlementBalanceDate | datetime | 16,3 | √ | null |
|
|
||
| EntitlementBalanceEndDate | datetime | 16,3 | null |
|
|
|||
| EntitlementBalanceBroughtFwd | decimal | 13,4 | √ | null |
|
|
||
| LastEntitlementUnitsAdded | decimal | 12,4 | null |
|
|
|||
| EntitlementBalance | decimal | 12,4 | null |
|
|
|||
| EntitlementLeaveTaken | decimal | 40,4 | null |
|
|
|||
| ManualChangeFlag | bit | 1 | null |
|
|
|||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| ModifiedByID | int | 4 | √ | null |
|
|
||
| ModifiedBy | varchar | 50 | √ | null |
|
|
Table contained 0 rows