vPayrollEmployeeLeaveEntitles


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayrollYear smallint 2 √ null
ID int 4 √ null
EmployeeCategory 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 smallint 2 √ null
EmployeeGroupCertPrinted smallint 2 √ null
EmployeeGroupCertPrintedDate datetime 16,3 √ null
EmployeeGroupCertATONotified smallint 2 √ null
EmployeeGroupCertATONotifiedDate datetime 16,3 √ null
EmployeeTaxFileNumber int 4 √ null
EmployeeTaxScale varchar 3 √ null
EmployeeTaxDependantRebate money 21,4 √ null
EmployeeTaxHECSFlag smallint 2 √ null
EmployeeTaxHELPFlag smallint 2 √ null
EmployeeFringeBenefitsTax money 21,4 √ null
EmployeeTerminated smallint 2 √ null
EmployeeTerminationDate datetime 16,3 √ null
EmployeeNameInternal varchar 100 √ null
EmployeeNameExternal varchar 100 √ null
EmployeeLegalFullName varchar 150 √ null
EmployeeSurname varchar 30 √ null
EmployeePreferred varchar 20 √ null
EmployeePreferredFormal varchar 20 √ null
EmployeeMailName varchar 100 √ null
BirthDate datetime 16,3 √ null
EmployeePayGroup varchar 5 √ null
PayFrequency varchar 5 √ null
LeaveAwardCode varchar 1 null
LeaveCode varchar 15 null
LeaveDescription varchar 30 √ null
LeaveCodeSynergyMeaning varchar 10 √ null
LeaveEntitlementBalanceDate datetime 16,3 √ null
LeaveUnitsUsed decimal 40,4 null
LeaveEntitlementBalance decimal 12,4 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views