vPayrollPaySlip


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 null
NameInternal varchar 100 null
NameExternal varchar 100 null
LegalFullName varchar 150 null
Surname varchar 30 null
Given1 varchar 20 null
Given2 varchar 50 null
Preferred varchar 20 null
PreferredFormal varchar 20 null
MailNamePrimary varchar 100 null
AddressFull varchar 200 √ null
AddressDPID varchar 8 √ null
AddressDPIDBarcode varchar 60 √ null
AddressSortPlanNumber varchar 3 √ null
AddressPAFVersion varchar 10 √ null
Email varchar 100 null
OccupEmail varchar 100 null
OverrideEmail varchar 100 null
DefaultEmailCode varchar 1 null
DefaultEmail varchar 201 null
ExternalSystemRegistrationNumber varchar 30 null
EmploymentCategory varchar 5 √ null
EmploymentCategoryDescription varchar 50 √ null
EmploymentStatus varchar 1 √ null
EmploymentStatusDescription varchar 50 √ null
EmploymentStatusContractFlag smallint 2 √ null
EmploymentStatusSynergyMeaning varchar 10 √ null
PayGroup varchar 5 √ null
PayGroupDescription varchar 40 √ null
PayrollYear smallint 2 null
PayCodeDescription varchar 50 √ null
PostingDate datetime 16,3 √ null
PostingNumber int 4 null
PayDetailPayLineSeq smallint 2 null
PayDetailPayRate decimal 12,5 √ null
PayDetailPayUnits decimal 12,5 √ null
PayDetailPayFactor decimal 12,8 √ null
PayDetailPayAmount money 21,4 √ null
PayDetailDescription varchar 50 √ null
HECS money 21,4 √ null
HELP money 21,4 √ null
TotalTaxation money 21,4 √ null
BackPayTax money 21,4 √ null
BackPayHECS money 21,4 √ null
BackPayHELP money 21,4 √ null
SuperContributionTax money 21,4 √ null
NettPay money 21,4 √ null
Description varchar 255 √ null
PayCodeType varchar 3 √ null
PayDetailPayCode varchar 10 √ null
OverridePayslipNotifyMethod varchar 2 √ null
PayCodeSortOrder tinyint 1 √ null
CurrentFTE decimal 8,4 √ null
SuperannuationMemberNumber varchar 20 √ null
SuperannuationJoinedDate datetime 16,3 √ null
PostingDescription varchar 60 √ null
PayFrequencyCode varchar 5 √ null
PayFrequencyDescription varchar 20 √ null
GrossPay money 21,4 √ null
TaxableAllowances money 21,4 √ null
NonTaxableAllowances money 21,4 √ null
TerminationPay money 21,4 √ null
OtherPaymentGross money 21,4 √ null
AnnualSalary money 21,4 √ null
HiddenDelimiter varchar 66 √ null
InstallCountryCode varchar 8000 √ null
PayEndDate datetime 16,3 √ null
PayStartDate datetime 16,3 √ null
PaymentAvailableDate datetime 16,3 √ null
SuperPaymentDate datetime 16,3 √ null
TaxFileNumber int 4 √ null
TaxScale varchar 3 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views