Payroll Process Input Tables

For payroll process input tables, you set up much of the controlling information for running payrolls, information having to do with the specifics of particular earnings, deductions, or taxes. You can find these tables online in the Set Up HCM, and then Product Related, and then Payroll for North America menu, unless otherwise indicated.

The fact that an employee works in the state of New York is employee-level data stored in the employee data input tables. But to calculate that employee's taxes, the system checks the appropriate pay process input table that defines tax rates for employees who work in New York:

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

Table Name	Online Page Name
ACCT_CD_TBL PYCF_VERTGRID_WK	Account Code Table
BALANCE_ID_TBL BALANCE_ID_DEF BALANCE_ID_QTR	Balance ID Table
BANK_EC_TBL BANK_BRANCH_TBL	Bank Table
COMP_RATECD_TBL	Comp Rate Code Table
DEDUCTION_TBL DEDUCTION_CLASS DEDUCTION_FREQ EARNS_SPCL_DEDN DED_SUBSET_CD	Deduction Table
DEPT_BUDGET DEPT_BUDGET_DT DEPT_BUDGET_ERN DEPT_BUDGET_DED DEPT_BUDGET_TAX DEPT_BUDGET_CTX DEPTBDGT_SUSPNS	Department Budget Table (found online in the setup menu for the Commitment Accounting business process)
DED_SUBSET_TBL	Deduction Subset Table
EARNINGS_TBL EARNINGS_ACCRL EARNINGS_SPCL	Earnings Table
ENCUMB_DEFN_TBL ENCUMB_DEFN_DED ENCUMB_DEFN_TAX	Encumbrance Definition Table (found online in the setup menu for the Commitment Accounting business process)
ERN_PROGRAM_TBL ERN_PROGRAM_DEF	Earnings Program Table
VENDOR	Garnishment Payee Table
GARN_RULE_TBL GARN_DE_EARN GARN_EXEMPT_TBL GARN_OPERANDS	Garnishment Rules Table
GARN_DE_DEFN GARN_DE_DED GARN_DE_DEF_LNG	Garnishment DE Definition Garnishment DE Definition Related Language Table
GARN_DE_DED	Garnishment Disposable Earnings Deduction Table
GARN_DE_EARN	Garnishment DE Earnings Table
GARN_EXEMPT_TBL	Garnishment Exemption Table
GARN_OPERANDS	Garnishment Operands Table
GARN_PRORATE_DF	Garn Prorate Defn
GARN_PRORATE_RL	Garnishment Proration Rules
GENL_DED_TBL	General Deduction Table
HOLIDAY_TBL HOLIDAY_DATE	Holiday Schedule Table
LIMIT_TBL LIMIT_EXCLD_TBL LIMIT_INCLD_TBL LIMIT_IMPIN_TBL LIMIT_COORD_TBL	Limit Table (found online in the Benefits menu)
PAY_FORM_TBL	Form Table
PAYGROUP_TBL PAYGRP_EMPLTYPE PY_PAYGRP_TASK	Pay Group Table
PAY_CALENDAR	Pay Calendar Table
PAY_MESSAGE_TBL	Pay Message Table
PAY_OL_PRNTCTL	Configure Online Printing
PAY_RUN_TBL	Pay Run Table
COMPRT_GRP_TBL	Rate Code Groups
SAVINGS_PLN_TBL SAVINGS_INV_TBL	Savings Table (found online in the Benefits menu)
SHIFT_TBL	Shift Table
SPCL_EARNS_TBL	Special Accumulator Table
TERM_ACTN_RSN	Final Check Action/Reason
TERM_PGM_TBL	Final Check Program Table
EG_AUDIT	Application Trace (Set Up HCM, and then Product Related, and then Workforce Administration, and then Flexible Service EG, and then Service Rules, and then Flexible Service Trace Setting
EG_CAL_DEFN_TBL EG_CAL_DETP_TBL	Calendar (Workforce Administration, and then Flexible Service EG, and then Define Flexible Service Rules
EG_DATE_CNV_OPT	Date Conversion Table (Set Up HCM, and then Product Related, and then Workforce Administration, and then Flexible Service EG, and then Service Rules, and then Service Rules Date Conversion
EG_DURATION_OPT	Duration Option Table (Set Up HCM, and then Product Related, and then Workforce Administration, and then Flexible Service EG, and then Service Rules, and then Flexible Service Duration
EG_DATE_RND_OPT	Date Round Option Table (Set Up HCM, and then Product Related, and then Workforce Administration, and then Flexible Service EG, and then Service Rules, and then Flexible Service Date Round
EG_DFN_SCAT_CAT EG_DFN_SVC	Service Rules Table (Workforce Administration, and then Flexible Service EG, and then Define Flexible Service Rules
EG_HR_ACTION	HR Action/Reason Category Table (Workforce Administration, and then Flexible Service EG)

Tax Tables	Online Page Name
EG_CALC_GRP_TBL EG_FNC_RSLT_DFN EG_FUNCTN_RESLT	Calculation Group Table
CO_LOCALTAX_TBL	Company Local Tax Table
CO_STATETAX_TBL	Company State Tax Table
LOCTX_RECIP_TBL	Local Tax Reciprocity Table
LCLWK_TXRCP_TBL	Local Work-Work Reciprocity Table
LOCAL_TAX_TBL	Local Tax Table
LOCAL_TAX_TBL2	Local Tax Table - User defined fields
US_SOC_TBL	U.S. SOC Table
STATE_TAX_TBL STATE_TAXRT_TBL ST_OTH_TAX_TBL	Federal/State Tax Table
STTAX_RECIP_TBL	State Tax Reciprocity Table
SWT_MARSTAT_TBL	SWT Marital Status Table
TAXFORM_TBL TAXFORM_BOX TAXFORM_DED TAXFORM_ERN	Tax Form Definition Table Payroll for North America, and then U.S. Annual Processing, and then Define Annual Tax Reporting, and then Tax Form Definitions)
TAXGR_BASE_TBL TAXGR_DEFN_TBL TAXGR_CMPNT_TBL	Taxable Gross Definition Table
TREATY_NRA_TBL TREATY_EARN_TBL	Treaty/Non-Resident Alien Table
TAX_LOCATION1 TAX_LOCATION2	Tax Location Table
VENDOR	Tax Collector Table
CO_UI_RPTCD_TBL	UI Report Code Table
VDI_ADMIN_TBL	VDI/FLI Administrator Table
CAN_USR_TAX_TBL CAN_USR_TAX_PRV	Canadian Company Tax Table
CAN_TAX_CITLUMP CAN_TAX_CITRATE CAN_TAX_PROV CAN_TAX_PROVNCT CAN_TAX_PROVTHR CAN_TAX_QITLUMP CAN_TAX_QITRATE CAN_TAX_TBL	Canadian Tax Table
WAGELS_PLAN_TBL WGLS_LIA_GL_ACC WGLS_EXP_GL_ACC	Canadian Wage Loss Plan Table
CAN_WCB_PROV CAN_WCB_RT_GRP CAN_WCB_CU	Canadian WCB Classifications
BANK_BRANCH_TBL	Bank Branch Table