tPayrollEmployeePays


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayrollYear smallint 2 null
PostingNumber int 4 null
ID int 4 null
FrequencyCode varchar 5 √ null
PayPeriods decimal 10,4 √ null
OverridePayMethodCode varchar 5 √ null
GrossPay varchar 80 √ null
HECS varchar 80 √ null
TotalTaxation varchar 80 √ null
TaxationOverrideFlag bit 1 √ null
NettPay varchar 80 √ null
ChequeNumber varchar 80 √ null
EmployerSuperannuation varchar 80 √ null
Description varchar 255 √ null
NormalPay varchar 80 √ null
SalarySacrifice varchar 80 √ null
TaxableAllowances varchar 80 √ null
NonTaxableAllowances varchar 80 √ null
Deductions varchar 80 √ null
EmployeeSuperannuation varchar 80 √ null
TerminationPay varchar 80 √ null
ChequeDate datetime 16,3 √ null
PayrollEmployeePayGUID int identity 4 √ null
OverrideBankDetailsFlag bit 1 √ null
LeaveByHoursCalculatedFlag bit 1 ((0))
PayrollEmployeeDocumentsSeq int 4 √ null
BackPayTax varchar 80 √ null
BackPayHECS varchar 80 √ null
SuperContributionTax varchar 80 √ null
CreatedDate datetime 16,3 √ (getdate())
CreatedBy varchar 30 √ null
ModifiedDate datetime 16,3 √ null
ModifiedBy varchar 30 ('')
OtherPaymentGross varchar 80 √ null
OtherPaymentWithholding varchar 80 √ null
SalarySacrificeSuperannuation varchar 80 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_PayrollEmployeePays Primary key Asc/Asc/Asc PayrollYear + PostingNumber + ID
AK_tPayrollEmployeePays_ID Performance Asc ID
AK_tPayrollEmployeePays_PayrollEmployeePayGUID Must be unique Asc PayrollEmployeePayGUID