Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PayrollYear | smallint | 2 | null |
|
|
|||
| PostingNumber | int | 4 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| PayrollLineSeq | smallint | 2 | null |
|
|
|||
| PayCode | varchar | 10 | √ | null |
|
|
||
| GLCode | varchar | 15 | √ | null |
|
|
||
| GLSubAllocationCode | varchar | 15 | √ | null |
|
|
||
| PayRate | varchar | 80 | √ | null |
|
|
||
| PayUnits | decimal | 12,5 | √ | null |
|
|
||
| PayFactor | decimal | 12,8 | √ | null |
|
|
||
| PayAmount | varchar | 80 | √ | null |
|
|
||
| Description | varchar | 50 | √ | null |
|
|
||
| LeaveHistorySeq | int | 4 | √ | null |
|
|
||
| PayrollEmployeePayDetailGUID | int identity | 4 | √ | null |
|
|
||
| LeaveTransactionsSeq | int | 4 | ((0)) |
|
|
|||
| tPayrollEmployeePayDetailBackPaysSeq | int | 4 | √ | null |
|
|
||
| SuperContributionTax | varchar | 80 | √ | null |
|
|
||
| tPayrollEmployeeSuperannuationFundSeq | int | 4 | √ | null |
|
|
||
| ETPReasonCode | varchar | 15 | ('') |
|
|
|||
| PayrollEmployeeStandardPayDetailGUID | int | 4 | √ | null |
|
|
||
| ChildSupportPaymentCode | varchar | 15 | ('') |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tPayrollEmployeePayDetails | Primary key | Asc/Asc/Asc/Asc | PayrollYear + PostingNumber + ID + PayrollLineSeq |
| AK_tPayrollEmployeePayDetails | Performance | Asc/Asc/Asc | PostingNumber + ID + PayrollLineSeq |
| AK_tPayrollEmployeePayDetails_ID | Performance | Asc | ID |
| AK_tPayrollEmployeePayDetails_LeaveHistorySeq | Performance | Asc | LeaveHistorySeq |
| AK_tPayrollEmployeePayDetails_LeaveTransactionsSeq_includes | Performance | Asc | LeaveTransactionsSeq |
| AK_tPayrollEmployeePayDetails_PayCode | Performance | Asc | PayCode |
| AK_tPayrollEmployeePayDetails_PayrollEmployeePayDetailGUID | Must be unique | Asc | PayrollEmployeePayDetailGUID |
| AK_tPayrollEmployeePayDetails_PayrollEmployeeStandardPayDetailGUID | Performance | Asc | PayrollEmployeeStandardPayDetailGUID |
| AK_tPayrollEmployeePayDetails_tPayrollEmployeePayDetailBackPaysSeq | Performance | Asc | tPayrollEmployeePayDetailBackPaysSeq |
| AK_tPayrollEmployeePayDetails_tPayrollEmployeeSuperannuationFundSeq | Performance | Asc | tPayrollEmployeeSuperannuationFundSeq |