OSU Data Warehouse

Human Resource (HRIS) Data Warehouse FAQ

Table of Contents

General Questions

1. Why are the dollars for pay for a specific month in the HRIS data warehouse Pay object different from the FIS data warehouse Payroll Ledger?

1. Why are the dollars for pay for a specific month in the HRIS data warehouse Pay object different from the FIS data warehouse Payroll Ledger?

In addition to the HRIS DW Pay object organizing data by Calendar Year (CY) and the FIS DW Payroll Ledger organizing data by Fiscal Year (FY), they also differ because in the HRIS DW data is shown by pay period, and in the FIS DW, data is shown by fiscal period. Initially both amounts are usually the same. However, any manual checks or adjustments and redistributions will cause reconciling items. If you process an adjustment in November that corrects September's pay, in the HRIS DW Pay object the correction will show up in pay period 9 September, but in the FIS DW Payroll Ledger it will show up in fiscal period 5 November.

Top of page

---