Employee Data Input Tables

Employee data input tables can be classified as employee jobs, benefits, and deductions. Online, some of these tables are found in the Workforce Administration menu, others in the Employee Pay Data menu, and some in the Benefits menu.

You hire employees and set up their job data; enroll them in benefits programs and set up their benefits data; set them up for general deductions and enter this information on the database. You insert rows into their various job, benefits, and deduction tables:

This table lists the Payroll for North America employee data input tables and the pages where you enter the data.

Table Name	Online Page Name
ADDL_PAY_DATA ADDL_PAY_EFFDT ADDL_PAY_ERNCD	Additional Pay
DIRECT_DEPOSIT DIR_DEP_DISTRIB	Direct Deposit
EMPL_DED_PROC	General Deduction Override
GENL_DEDUCTION GENL_DED_CD	General Deduction Data
GARN_SPEC GARN_SCHED GARN_RULE GARN_EMPL_DED	Garnishment Specification Data
TAX_DIST_EFFDT TAX_DISTRIB	Update Tax Distribution
JOB	Job
PAYROLL_DATA ADDRESSES	Payroll Data
PERS_DATA_EFFDT PERSON ADDRESSES PERSONAL_PHONE EMAIL_ADDRESSES	Personal Data
BEN_PROG_PARTIC	Assign to Benefit Program
DEP_BEN DEP_BEN_EFF DEP_BEN_NAME DEP_BEN_ADDR	Dependent/Beneficiary Data
DISABILITY_BEN BENEFIT_PARTIC	Disability Benefits
FSA_BENEFIT BENEFIT_PARTIC	FSA Benefits
HEALTH_BENEFIT BENEFIT_PARTIC	Health Benefits
LEAVE_ACCRUAL	Leave Accruals
LEAVE_PLAN BENEFIT_PARTIC	Leave Plans
LIFE_ADD_BEN BENEFIT_PARTIC	Life and AD/D Benefits
RTRMNT_PLAN BENEFIT_PARTIC	Retirement Plans
SAVINGS_PLAN SAVINGS_BENEFIC SAVINGS_INVEST BENEFIT_PARTIC	Savings Plans
VACATION_BEN BENEFIT_PARTIC	Vacation Benefit
PENSION_BENEFC PENSION_PLAN	Pension Plans
CAN_TAX_DATA CAN_TAX_PRVDATA EMPL_WAGELS_CAN	Canadian Income Tax Data
FED_TAX_DATA STATE_TAX_DATA LOCAL_TAX_DATA TAX_DIST_EFFDT TAX_DISTRIB TREATY_EARN_TBL (E&G only)	Federal Tax Data State Tax Data Local Tax Data Update Tax Distribution
CONTRACT	Contract Pay Data
EG_FLX_SVC_DT EG_PRIOR_CREDIT EG_SVC_HIST EG_SVC_HIST_FLX EG_TENURE_DATA	Flexible Service Data Prior Credit Data Service History Data Flexible Service History Data Tenure Data

Employee data tables all have EMPLID as a key, so if you must find them all, a good way to start is to look at those tables containing EMPLID. To do this, use the Records and Fields PeopleTools Cross Reference Report (XRFFLRC).