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.
