PeopleSoft HCM/Payroll - Core Tables list

Human Resources Information/ Personal Data:

PERSONAL_DATA

PERS_DATA_EFFDT

PERS_NID

Employment Data:

EMPLOYMENT- - general employment data, such as various service dates, etc.

DEPT_TBL --This is one of foundation tables in HR.    

JOBCODE_TBL --This is also a foundation table. 

JOB-- Job Table (main HR, Payroll record) -Contains job records along with other

data.    

Benefits Data:

BEN_PROG_PARTIC – Stores the Benefit Program to which the employee is assigned.

LEAVE_PLAN – Stores enrollment in leave plans.

HEALTH_BENEFIT – Stores enrollment in health insurance plans

SAVINGS_PLAN --  Stores enrollment in TDA, ORP and Deferred Compensation

LIFE_ADD_BEN --  Stores enrollment in life insurance plans.

RTRMNT_PLAN – Stores TRS enrollment.

DISABILITY_BEN – Stores enrollment in disability plans.

Tax Data:

FED_TAX_DATA – Contains federal tax data, including nonresident alien data

STATE_TAX_DATA – State Tax Data

Payroll Data:

Payroll processing check data (records used by the payroll process to store check history)

PAY_CALENDAR

PAY_CHECK                                  

PAY_LINE                                                                                       

PAY_EARNINGS                                    

PAY_OTH_EARNS                                 

PAY_DEDUCTION                                

PAY_TAX

Payroll funding distribution data (records that tie funding to payroll actual):

PAY_ERN_DIST

PAY_DED_DIST

PAY_TAX_DIST

                                              

Other employee level payroll data:

GENL_DEDUCTION

GENL_DED_CD

ADDL_PAY_EFFDT

ADDL_PAY_DATA

ADDL_PAY_ERNCD

DIRECT_DEPOSIT

DIR_DEP_DISTRIB

PS_EMPLOYEE - Used for Reporting which contains almost all employee level data. Refreshed periodically.