Loading Consolidated Data

Rather than loading raw payroll data into the system, you might load consolidated amounts. In this case, study the tables where the consolidation processes store their results so that the data you load is consistent with the data that the system's consolidation processes might create. The following tables contain consolidated data:

Consolidation Function	Table
Consolidated earnings	PA_CONS_ARRAY
Consolidated hours	PA_CONS_HRS_AY
Consolidated contributions	PA_CONS_DED_AY

Note:

When you load consolidated data, the period start and end dates should reflect full periods. For example, if you consolidate by calendar year, the first row for an employee hired in 2001 is dated January 1, 2001, regardless of the actual hire date. (This differs from the way in which the service and account history functions treat the first period.) Use the partial period fraction to indicate the portion of the period that is active.