PayrollEmployeePays


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 money 21,4 √ null
HECS money 21,4 √ null
HELP money 21,4 √ null
TotalTaxation money 21,4 √ null
TaxationOverrideFlag bit 1 √ null
NettPay money 21,4 √ null
ChequeNumber int 4 √ null
EmployerSuperannuation money 21,4 √ null
Description varchar 255 √ null
NormalPay money 21,4 √ null
SalarySacrifice money 21,4 √ null
SalarySacrificeSuperannuation money 21,4 √ null
TaxableAllowances money 21,4 √ null
NonTaxableAllowances money 21,4 √ null
Deductions money 21,4 √ null
EmployeeSuperannuation money 21,4 √ null
TerminationPay money 21,4 √ null
BackPayTax money 21,4 √ null
BackPayHECS money 21,4 √ null
BackPayHELP money 21,4 √ null
SuperContributionTax money 21,4 √ null
OtherPaymentGross money 21,4 √ null
OtherPaymentWithholding money 21,4 √ null
ChequeDate datetime 16,3 √ null
OverrideBankDetailsFlag bit 1 √ null
PayrollEmployeePayGUID int 4 √ null
PayrollEmployeeDocumentsSeq int 4 √ null
CreatedDate datetime 16,3 √ null
CreatedBy varchar 30 √ null
ModifiedDate datetime 16,3 √ null
ModifiedBy varchar 30 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views