Peoplesoft HRMS

Core payroll tables are the tables that are required to implement the Payroll for North America application,
including organization tables, compensation and earnings tables, deduction tables, pay calendar tables,
garnishment tables, vendor tables, general ledger interface, tax tables, retroactive processing, and tip
allocation.

Employee pay data includes personal data, job data, benefits data, federal, state/provincial, and local tax
information, general and benefit deductions, additional pay, garnishments, savings bonds, and direct deposits.

The basic steps of payroll processing are: create paysheets, pay calculation, pay confirmation, and generate
checks and direct deposits. You can employ audit reports and data review pages to verify and correct the
results of each step before moving on. You can also review and adjust employee balances.

Enterprise One General Ledger to transfer the expenses and liabilities incurred from a pay run to the General Ledger application.

PeopleSoft Enterprise Payables to transmit tax data to the Payables application for
automatic payment to tax authorities.

integration with Payables to transmit employee and employer deductions such as garnishments and
benefit deductions to the Payables application for automatic payment to third parties.

The Load Paysheet Transactions process loads transactions from sources other than PeopleSoft
applications to paysheets for processing. Such transactions require a paysheet update source of Other Sources.

PeopleSoft Setup Manager enables you to generate a list of setup tasks.The setup tasks include the components that you must set up, listed in the order in which you must enter data into the component tables

Payroll for North America also provides component interfaces to help you load data from your existing
system into Payroll for North America tables.

The components that have component interfaces:
`
PAY_RUN_TABLE - Setting Up Pay Calendars - Creating Pay Run IDs.
GENL_DEDUCTION_TBL - Defining General Deductions
GDED_COM_TABLE - Defining Deductions - Assigning General Deductions to a Company
TAX_LOCATION_TBL - Setting Up CompanyTax Tables for North America.
COMP_LOCAL_TAX_TBL - Setting Up CompanyTax Tables for North America.
SPCL_EARNS_TABLE - Establishing Special Accumulator Codes
TERM_ACTN_REASON - Setting Up the Payroll Process, Defining the Final Check Process
TERM_PGM_TABLE - Setting Up the
FLSA_CALENDAR - Creating Pay Calendars and FLSA Calendars.
TAX_TYPE_TABLE - Setting Up Tax Types for PeopleSoft Enterprise Payables Integration.
CO_UI_RPTCD_TABLE - Setting Up Payroll Tax Tables, (USA) Establishing UI Report Codes
TREATY_NR_ALIEN_TA - Understanding TaxTreaties.
US_SOC_TABLE - Establishing Standard Occupational Classifications.
CAN_WCB_CU_RATES - DefiningCanadian WCB AssessmentReporting,
RETROPAY_PGM_TBL - Setting Up RetroPay Processing
TIPS_ESTAB_TBL - Setting Up the Payroll System for Tip Allocation




Tax tables store tax information that the system requires to calculate and report taxes.

The pages for Federal/State Tax, Taxable Gross Definition, and Canadian Tax tables reference more
than one table.

These are the PeopleSoft-maintained tables for U.S. employers:
• Federal/State Tax and Local Tax tables,(STATE_TAX_TABLE). which contain rates and other constants
• State and Local Tax Reciprocity tables
• Taxable Gross Definition table, which identifies differences between states or localities and the federal
government in the definition of taxable wages.
PeopleSoft delivers sample taxable gross component IDs for Group Term Life (GTL), Section 125 (125),
domestic partner benefits (DPB), Health Savings Accounts (HSA), and Health Savings Account employer
contributions (HSR).
• SWT Marital Status table, which defines the valid tax marital status codes for each state.

U.S. employers must set up and maintain the following tables:
• Tax Location table, which contains the work locations for which you process payroll and taxes.
• Company State Tax and Company Local Tax tables, which store tax identification numbers,
unemployment and disability experience rates, and general ledger codes for the states and localities for
which your company collects and pays taxes.
• Tax Reporting Parameters table, which controls the execution of many of your quarterly and annual tax
reports and specifies data needed for magnetic media filing.


Pennsylvania Local Services Tax ?

On the Federal/State Tax Table - Additional Rates page, the Tax Class LS Tax represents the Local Services
Tax (LST) for Pennsylvania employees. The total LST paid by any individual in a calendar year is limited to
52 USD, regardless of the number of political subdivisions in which the individual works during the year.
Certain LST processing requirements relate to the combined LST rate for municipalities and school districts.
These entries have the letter "C" in position 8 of the Locality Code.For example, the locality code O430212C

It is deducted as a lump sum from the employee's first paycheck of the year in the taxing jurisdiction. If the LST is levied at a combined rate exceeding 10 USD annually, the tax is divided equally across the number of pay periods in the employee's pay frequency. When calculating prorated pay period deductions, employers are required to round down to the nearest cent.

The state-level Pennsylvania LST Memo tax record keeps track of how much Pennsylvania LST an employee
has paid for the year.

If you need to set up Local Tax Data records for multiple LS Tax jurisdictions for an employee in order to
clear Payroll Error 92 ("Local Tax Not Found: The local tax record for the locality cannot be found for this
employee."), then you can limit the employee to one active LST by setting all but one of the employee's Local
Tax Data records for LST to the Special Tax Status of "Do Not Maintain Taxable Gross and Do Not Withhold
Tax".