PAR_TAX_ACH_BENEFITS Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home

PAR_TAX_ACH_BENEFITS Table

Note: This table is no longer updated, following the retirement of the mainframe Personnel/Payroll system and the implementation Workday@Penn in July 2019.

Explanation
Contains data about tax and benefits information and amounts, by employee and pay cycle.

Common Uses
To determine taxable entities, benefits amounts, and clearing house (ACH) values by employee and pay cycle.

PAR_SEQUENCE_NUMBER
PAY_CYCLE
PAY_END_DATE
PAY_SCHEDULE
SSN

EXTRACT_DATE
HOME_DEPT_ORG
HOME_SCHOOL_CTR
LOCAL_TAX_CODE1
PAR_SEQUENCE_NUMBER
PAY_CYCLE
PAY_END_DATE
PAY_SCHEDULE
PENN_ID
SSN
STATE_EMPLOYMENT
STATE_TAXED

PAR_DOLLAR_GTN_ADJUSTMENTS (DWPAY)
PAR_EARNINGS (DWPAY)
PAR_GROSS_TO_NET (DWPAY)
PAR_HOUR_ADJUSTMENTS (DWPAY)
PAR_MAIN (DWPAY)

Cautions

• Access to PAR_TAX_ACH_BENEFITS is restricted to select central organizations. Contact Human Resources if you need information from this table. Access to SSN is further restricted to specifically authorized individuals.

• The Data Warehouse is updated with PAR, payments and encumbrance data directly following Salary Management, which may actually be a couple days in advance of BEN Financials. To pull matching data from BEN Financials, Salary Management and the Data Warehouse at the end of a period you'll need to run your system reports and Warehouse queries between the Tuesday after payroll runs, producing the last weekly check for the month, and before the Monday of the following week. By that last Tuesday, monthly payroll has already been run, so those actuals and updated encumbrances will be correct. This limits the risk of retrieving data from Salary Management or the Warehouse for the last weekly pay of the month which may, in fact, be posted to the next BEN Financials Accounting Period. (For example, for AUG-99, reports would have to have been run between August 27 and August 30th.).

• The PAR_TAX_ACH_BENEFITS table can be found in the DWPAY schema.

PAR_TAX_ACH_BENEFITS Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home