tPayrollEmployeeStandardPayDetailsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayrollYear smallint 2 null
ID int 4 null
StandardPaySeq smallint 2 null
StandardPayModifiedBy varchar 50 √ null
StandardPayModifiedDate datetime 16,3 √ null
PayCode varchar 10 √ null
GLCodeSource char 1 √ null
GLCode varchar 15 √ null
GLSubAllocSource char 1 √ null
GLSubAllocationCode varchar 15 √ null
PayRateSource char 1 √ null
PayRate varchar 80 √ null
PayUnitsSource char 1 √ null
PayUnits decimal 12,5 √ null
PayFactorSource char 1 √ null
PayFactor decimal 12,8 √ null
PayAmountSource char 1 √ null
PayAmount varchar 80 √ null
Description varchar 50 √ null
FTE decimal 8,4 √ null
CampusCode varchar 5 √ null
CensusClass varchar 5 √ null
SuperannuationMemberNumber varchar 80 √ null
StopSuperAutoCalculationFlag bit 1 √ null
SuperannuationJoinedDate datetime 16,3 √ null
tPayrollEmployeeStandardPayDetailsHistorySeq int identity 4 √ null
StartDate datetime 16,3 √ null
StopDate datetime 16,3 √ null
StandardPayLineIdentifier int 4 √ null
IncludeInTimesheetFlag bit 1 √ null
PayrollEmployeeStandardPayDetailGUID int 4 √ null
DeleteFlag bit 1 ((0))
tPayrollEmployeeSuperannuationFundSeq int 4 √ null
ETPReasonCode varchar 15 √ null
SuperannuationCalculationMode varchar 1 √ null
ChildSupportPaymentCode varchar 15 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
AK_tPayrollEmployeeStandardPayDetailsHistory_ID Performance Asc/Asc PayrollYear + ID
AK_tPayrollEmployeeStandardPayDetailsHistory_tPayrollEmployeeSuperannuationFundSeq Performance Asc tPayrollEmployeeSuperannuationFundSeq