Contains dollar and gross-to-net adjustments entered for this pay transaction.
To determine the amount of dollar or gross-to-net adjustments for an employee, by pay cycle.
||Indexed Data Elements
- Because the PAR_DOLLAR_GTN_ADJUSTMENTS table stores records for each dollar or gross-to-net adjustment by data element, there may be more than one record per employee,
pay cycle, pay schedule and pay end date. The PAR_DGA_Sequence_Number is used to distinguish
one adjustment from another for the employee, pay cycle, pay schedule, and pay end date.
- Access to the PAR_DOLLAR_GTN_ADJUSTMENTS 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_DOLLAR_GTN_ADJUSTMENTS table can be found in the DWPAY schema.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania