tPayrollEmployeeStandardPayDetails


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
tPayrollCodeDefinitions.PayCode FK_tPayrollEmployeeStandardPayDetails_tPayrollCodeDefinitions R
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
PayrollEmployeeStandardPayDetailGUID int identity 4 √ null
StartDate datetime 16,3 √ (NULL)
StopDate datetime 16,3 √ (NULL)
StandardPayLineIdentifier int 4 √ null
IncludeInTimesheetFlag bit 1 ((1))
tPayrollEmployeeSuperannuationFundSeq int 4 √ null
tPayrollEmployeeSuperannuationFund.tPayrollEmployeeSuperannuationFundSeq FK_tPayrollEmployeeStandardPayDetails_tPayrollEmployeeSuperannuationFund R
ETPReasonCode varchar 15 ('')
SuperannuationCalculationMode varchar 1 ('A')
ChildSupportPaymentCode varchar 15 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_PayrollEmployeeStandardPayDetails Primary key Asc/Asc/Asc PayrollYear + ID + StandardPaySeq
AK_tPayrollEmployeeStandardPayDetails_PayrollEmployeeStandardPayDetailGUID Must be unique Asc PayrollEmployeeStandardPayDetailGUID
AK_tPayrollEmployeeStandardPayDetails_StandardPayLineIdentifier Performance Asc StandardPayLineIdentifier
AK_tPayrollEmployeeStandardPayDetails_tPayrollEmployeeSuperannuationFundSeq Performance Asc tPayrollEmployeeSuperannuationFundSeq

Relationships

Close relationships within degrees of separation