12/4/11

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


1 comment:

  1. 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.

    Regard

    ReplyDelete

Please refrain for marketing messages and unnecessary back links.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month