We need to know a
table structure for reporting and understanding flow in people soft,
here are the summarize commonly used table in People HRMS, Benefit,
Position Management and North American Payroll.
NAMES
PERS_NAME_TYPE
PERS_NID
ADDRESSES
ADDRESS_TYPE
EMAIL_ADDRESSES
PERSONAL_PHONE
PERSONAL_DATA
PERS_DATA_EFFDT
CITIZENSHIP
DIVERSITY
DISABILITY
PERSON_SA
EMPLOYMENT-
general employment data, such as various service dates, etc.
BEN_PROG_PARTIC
– Stores the Benefit Program to which the employee is assigned.
LEAVE_PLAN
– Stores enrollment in leave plans.
HEALTH_BENEFIT
– Stores e nrollment 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.
FED_TAX_DATA
– Contains federal tax data, including nonresident alien data
STATE_TAX_DATA
– Although there is no state withholding in Texas, this record is necessary to
PAY_CALENDAR
PAY_CHECK
PAY_LINE
PAY_CHECK
PAY_EARNINGS
PAY_OTH_EARNS
PAY_DEDUCTION
PAY_TAX
PAY_ERN_DIST
PAY_DED_DIST
PAY_TAX_DIST
GENL_DEDUCTION
- Genearl deduction.
GENL_DED_CD - General deduction code.
ADDL_PAY_EFFDT
- additional pay effdt.
ADDL_PAY_DATA - additional pay data.
ADDL_PAY_ERNCD
- additional pay earn code.
DIRECT_DEPOSIT - Direct deposit.
DIR_DEP_DISTRIB
- Direct deposit distribution.
POSITION_DATA—identifies
position data for each business unit.
EG_TENURE Tenure Data.
