Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | null |
|
|
|||
| Surname | varchar | 30 | null |
|
|
|||
| Preferred | varchar | 20 | null |
|
|
|||
| Given1 | varchar | 20 | null |
|
|
|||
| Given2 | varchar | 50 | null |
|
|
|||
| EmploymentCategory | varchar | 5 | √ | null |
|
|
||
| EmploymentStatusSynergyMeaning | varchar | 10 | √ | null |
|
|
||
| TerminatedFlag | bit | 1 | √ | null |
|
|
||
| TerminationDate | datetime | 16,3 | √ | null |
|
|
||
| PayrollYear | smallint | 2 | null |
|
|
|||
| PayGroup | varchar | 5 | √ | null |
|
|
||
| PayFrequencyDescription | varchar | 20 | √ | null |
|
|
||
| PostingNumber | int | 4 | null |
|
|
|||
| PayPeriods | decimal | 10,4 | √ | null |
|
|
||
| HECS | money | 21,4 | √ | null |
|
|
||
| HELP | money | 21,4 | √ | null |
|
|
||
| TotalTaxation | money | 21,4 | √ | null |
|
|
||
| NettPay | money | 21,4 | √ | null |
|
|
||
| Description | varchar | 255 | √ | null |
|
|
||
| PostingDate | datetime | 16,3 | √ | null |
|
|
||
| YTDTotalTaxation | money | 21,4 | null |
|
|
|||
| YTDNettPay | money | 21,4 | null |
|
|
|||
| YTDGrossPay | money | 21,4 | null |
|
|
|||
| YTDHECS | money | 21,4 | null |
|
|
|||
| YTDHELP | money | 21,4 | null |
|
|
|||
| YTDSuperContributionTax | money | 21,4 | null |
|
|
|||
| PreviousNettPay | money | 21,4 | null |
|
|
Table contained 0 rows