Data Sources
The consolidations functions get all the earnings, hours, and contributions data from PeopleSoft payroll tables. If you are running a standalone version of Pension Administration, you have to bring your payroll data into the PeopleSoft tables before running the consolidation.
If you use PeopleSoft to track multiple concurrent jobs and you have the Single Job Environment check box deselected, the consolidation functions do not distinguish earnings, hours, or contributions based on job. The other calculation functions only use data for the first job; however, the consolidation functions incorporate the data for all jobs.
Following are the payroll tables that provide data to each of the three consolidation functions. When you populate these tables, whether during the initial data conversion or to bring data into a standalone system, be sure to populate all of the indicated tables. Consolidations do not work unless an employee has data in every table. If the data is unavailable, create a row with zeros in all of the numeric fields.
| Consolidated Earnings | Consolidated Hours | Consolidated Contributions |
|---|---|---|
|
PAY_EARNINGS |
PAY_EARNINGS |
PAY_DEDUCTIONS |
|
PAY_OTH_EARNS |
PAY_OTH_EARNS |
|
|
PAY_SPCL_EARNS |
PAY_SPCL_EARNS |
|
|
PAY_CHECK |
PAY_CHECK |
|
|
W2_AMOUNTS |
W2_AMOUNTS |
|
|
EARNINGS_BAL |
Pension Administration includes a periodic process to copy payroll data into pension history tables. This enables you to purge data from the payroll tables while still leaving the necessary information available for pension processing.
The consolidation process always uses data from the payroll tables if it is available. If the payroll tables do not have data for a period, the consolidation process looks for data in the pension archive versions of the tables. If you enter an override in the pages where you maintain consolidated data, the process does not look at either table for the period.
If you reconsolidate after purging data from the payroll tables, data for the reconsolidation comes from the pension archive tables. The pension archive table names are similar to the payroll source table names, and they have the prefix PA_HST_.
| Payroll Source Table | Pension Archive Table |
|---|---|
|
PAY_EARNINGS |
PA_HST_PAY_EARN |
|
PAY_OTH_EARNS |
PA_HST_OTH_EARN |
|
PAY_SPCL_EARNS |
PA_HST_SPL_EARN |
|
PAY_CHECK |
PA_HST_PAY_CHK |
|
W2_AMOUNTS |
PA_HST_W2_AMTS |
|
YE_AMOUNTS |
PA_HST_YE_AMTS |
|
EARNINGS_BAL |
PA_HST_EARN_BAL |
|
PAY_DEDUCTION |
PA_HST_PAY_DED |
You also use the pension archive tables if you load historical payroll data at the time of the initial Pension Administration implementation. If you use Application Designer to look at the pension archive tables, you can see which fields the system copies.