vPayrollEmployeePayDetails


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayrollYear smallint 2 √ null
ID int 4 √ null
EmployeeNameInternal varchar 100 √ null
EmployeeNameExternal varchar 100 √ null
EmployeeLegalFullName varchar 150 √ null
EmployeeSurname varchar 30 √ null
EmployeeGiven1 varchar 20 √ null
EmployeeGiven2 varchar 50 √ null
EmployeePreferred varchar 20 √ null
EmployeePreferredFormal varchar 20 √ null
EmployeeMailName varchar 100 √ null
BirthDate datetime 16,3 √ null
EmployeeCategory varchar 5 √ null
EmployeePayGroup varchar 5 √ null
PayFrequency varchar 5 √ null
EmployeeStartDate datetime 16,3 √ null
EmploymentStatus varchar 1 √ null
EmploymentStatusDescription varchar 50 √ null
EmploymentStatusContractFlag smallint 2 √ null
EmploymentStatusSynergyMeaning varchar 10 √ null
EmployeeAnnualAllowance money 21,4 √ null
EmployeeAnnualSalary money 21,4 √ null
EmployeeCalcAnnualSalary bit 1 √ null
EmployeeAnnualBudget money 21,4 √ null
EmployeeGroupCertPrinted bit 1 √ null
EmployeeGroupCertPrintedDate datetime 16,3 √ null
EmployeeGroupCertATONotified bit 1 √ null
EmployeeGroupCertATONotifiedDate datetime 16,3 √ null
EmployeeTaxFileNumber int 4 √ null
EmployeeTaxScale varchar 3 √ null
EmployeeTaxDependantRebate money 21,4 √ null
EmployeeTaxHECSFlag bit 1 √ null
EmployeeTaxHELPFlag bit 1 √ null
EmployeeFringeBenefitsTax money 21,4 √ null
EmployeeTerminated bit 1 √ null
EmployeeTerminationDate datetime 16,3 √ null
EmployeeReferenceSuperBase money 21,4 √ null
PayCodeType varchar 3 √ null
PayCodeSortOrder int 4 null
PayCodeDescription varchar 50 √ null
ReportCode varchar 30 √ null
ReportDescription varchar 40 √ null
ReportColumn tinyint 1 √ null
PostingDate datetime 16,3 √ null
PostingCompleteFlag bit 1 √ null
PostingNumber int 4 null
PayDetailGLCode varchar 15 √ null
PayDetailGLSubAllocationCode varchar 15 √ null
PayDetailPayCode varchar 10 √ 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
PayDetailSuperContributionTax money 21,4 √ null
PayDetailPayAmountNett money 21,4 √ null
PayDetailDescription varchar 50 √ null
PayDetailSuperannuationPayCode char 1 √ null
PayCodeSuperannuationIncludeFlag bit 1 √ null
SuperannuationMemberNumber varchar 20 √ null
SuperannuationFundCode varchar 15 √ null
SuperannuationFundDescription varchar 100 √ null
SuperannuationFundNickname varchar 15 √ null
YTDAmount money 21,4 √ null
PayrollYearStartDate varchar 72 √ null
PayrollYearEndDate varchar 72 √ null
PayrollFrequencyDesc varchar 20 √ null
StaffJobPosition varchar 80 √ null
StaffFTE decimal 8,4 √ null
PayCodeTypeDescription varchar 50 √ null
InstallCountryCode varchar 8000 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views