PayrollEmployeeStandardPayDetailsHistory


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 decimal 12,5 √ null
PayUnitsSource char 1 √ null
PayUnits decimal 12,5 √ null
PayFactorSource char 1 √ null
PayFactor decimal 12,8 √ null
PayAmountSource char 1 √ null
PayAmount money 21,4 √ null
Description varchar 50 √ null
FTE decimal 8,4 √ null
CampusCode varchar 5 √ null
CensusClass varchar 5 √ null
SuperannuationMemberNumber varchar 15 √ null
StopSuperAutoCalculationFlag bit 1 √ null
SuperannuationJoinedDate datetime 16,3 √ null
PayrollEmployeeStandardPayDetailGUID int 4 √ null
StartDate datetime 16,3 √ null
StopDate datetime 16,3 √ null
EmployeeName varchar 100 √ null
StandardPayLineIdentifier int 4 √ null
IncludeInTimesheetFlag bit 1 null
tPayrollEmployeeSuperannuationFundSeq int 4 √ null
DeleteFlag bit 1 null
tPayrollEmployeeStandardPayDetailsHistorySeq int identity 4 null
ETPReasonCode varchar 15 √ null
SuperannuationCalculationMode varchar 1 √ null
ChildSupportPaymentCode varchar 15 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views