pvPayrollCalcEmployeeWeeklyEarningsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 null
ModifiedDate datetime 16,3 null
ModifiedBy varchar 255 null
tPayrollEmployeesHistorySeq int 4 null
PayrollYear int 4 null
AnnualSalary float 8 null
WeeklySalary float 8 null
CalculationAsAtDate datetime 16,3 null
PayPeriodEndDate datetime 16,3 null
EmployeeStartDate datetime 16,3 null
StandardNormalPay float 8 null
StandardDividedByWeeks float 8 null
StandardWeeklyPay float 8 null
AnnualDividedByWeeks float 8 null
OrdinaryPayPeriodStartDate datetime 16,3 null
OrdinaryNormalPayAmount float 8 null
OrdinaryDividedbyWeeks float 8 null
OrdinaryEquals float 8 null
AvgPayPeriodStartDate datetime 16,3 null
AvgNormalPayAmount float 8 null
AvgDividedbyWeeks float 8 null
AvgEquals float 8 null
PayrollEmployeeLeaveRateHistorySeq int 4 null
AgreedWeeklyPayAmount float 8 null

Table contained 0 rows