Effective dates Used for Benefit Deduction Calculations
I had a hard time finding what dates are considered by Payroll processes for Benefit Deduction Calculation. With the aid of google search results, Peoplebooks and spending some time I formed the below list of tables along with the dates that are used in each of these tables for Benefits deduction calculations in Benefits Administration, Payroll and Payroll Interface. I request PeopleSoft consultants to correct me if I am wrong in specifying any of these. Thanks in advance.
Table Name
|
Description
|
Date Used
|
BEN_PROG_PARTIC
|
Benefit Program
|
Pay End Date
|
BENEFIT_PARTIC
|
Employee Enrollments
|
Pay End Date
|
CALC_RULES_TBL
|
Calculation Rules Table
|
Pay End Date
|
BN_FORMULA
|
Coverage Formula Table
|
Pay End Date
|
BN_RATE_TBL
|
Benefits Rate Table
|
Pay End Date
|
SAL_RATECD_TBL
|
Salary Rate Table
|
Pay End Date
|
AGE RATE TBL
|
Aged Rate Table
|
Pay End Date
|
SERVICE RATE TBL
|
Service Rate Table
|
Pay End Date
|
SVC_STEP_TBL
|
Service Step Table
|
Pay End Date
|
LIMIT_TBL
|
Limit Tables
|
Pay End Date
|
DEDUCTION_TBL,
|
Deduction Table/Class/Frequency
|
Check Date
|
DED_CLASS and
DEDUCTION_FREQ |
||
GENL_DED_FREQ
|
General Deduction Frequency
|
Check Date
|
LIFE_ADD_BEN and LIFE_ADD_BENEFC
|
Life AD/D Plan Table
|
Check Date
|
DISABILITY_BEN
|
Disability Plan Table
|
Check Date
|
SAVINGS_PLAN
|
Savings Plan Table
|
Check Date
|
FSA_BENEFIT
|
FSA Plan Table
|
Check Date
|
RTRMNT_PLAN
|
Retirement Plan Table
|
Check Date
|
COVG_GROUP_TBL
|
Coverage Group Table
|
Check Date
|
PENSION_PLAN
|
Pension Plan Table
|
Check Date
|
LEAVE_PLAN
|
Vacation Plan Table
|
Check Date
|
DEDUCTION_BAL, CAN_DED_BALANCE, PI_DED_BAL
|
Deduction Balances
|
Check Date
|
Payroll management is not an easy task it need good knowledge to deal with financial aspects of employee's salary, allowances, deductions, gross pay, net pay etc. Payroll service is very effective for this.
ReplyDeleteRegard