Loading Raw Data
Raw payroll data resides in two places:
-
Payroll tables, which are populated by PeopleSoft Payroll for North America.
-
A set of pension clones, where you can archive the data to protect it from the periodic purging to which the payroll tables are subject.
If you load raw payroll data, do not put the data in the Payroll for North America tables. These tables are managed by Payroll for North America, not by Pension Administration, and they are subject to periodic purging. Instead, load the data into the Pension Administration clones.
During consolidations, Pension Administration first checks the Payroll for North America tables. If those tables do not contain data for the period being consolidated, the system checks the pension clone tables. If the system finds data in the clone tables, it ignores data in the source tables. The system does not compare the data in the two tables; after it determines which tables to use, it ignores the others. If neither set of tables contains data, the consolidation displays zero earnings, hours, or contributions for the period.
Periodic processing enables you to copy data from payroll tables to the pension clones for archiving. In Payroll for North America, you use this process to archive raw data on an ongoing basis.
The data that you need depends on your consolidation definition. For example, if you consolidate hours based on W-2 earnings (which requires you to provide an earnings-to-hours divisor), you need data from the W2_AMOUNTS table.
Note:
Consolidated earnings and hours both require PAY_CHECK data as the source of the consolidation accumulate based on date (the earned date, payroll end date, or paycheck date, depending on your consolidation definition).
| Original Payroll Table | Pension Clone | Used For |
|---|---|---|
|
PAY_EARNINGS |
PA_HST_PAY_EARN |
Earnings, Hours |
|
PAY_OTH_EARNS |
PA_HST_OTH_EARN |
Earnings, Hours |
|
PAY_SPCL_EARNS |
PA_HST_SPL_EARN |
Earnings, Hours |
|
PAY_CHECK |
PA_HST_PAY_CHK |
Earnings, Hours |
|
W2_AMOUNTS |
PA_HST_W2_AMTS |
Earnings, Hours |
|
YE_AMOUNTS |
PA_HST_YE_AMTS |
Earnings, Hours |
|
EARNINGS_BAL |
PA_HST_EARN_BAL |
Earnings, Hours |
|
PAY_DEDUCTION |
PA_HST_PAY_DED |
Contributions |