Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PayrollYear | smallint | 2 | null |
|
|
|||
| PostingNumber | int | 4 | null |
|
|
|||
| PostingDate | datetime | 16,3 | √ | null |
|
|
||
| PayCode | varchar | 10 | √ | null |
|
|
||
| ID | int | 4 | null |
|
|
|||
| PayGroup | varchar | 5 | √ | null |
|
|
||
| Category | varchar | 5 | √ | null |
|
|
||
| TerminatedFlag | smallint | 2 | √ | 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 |
|
|
||
| ShortDescription | varchar | 15 | √ | null |
|
|
||
| Description | varchar | 50 | √ | null |
|
|
||
| PayCodeTotal | money | 21,4 | √ | null |
|
|
Table contained 0 rows