Financial Data
The first phase (Accounting data) and the second phase (Employment data) of the Financial Data Warehouse have been completed. The third and final phase (Purchasing data) is in the processing of being developed and tested.
A PowerPoint presentation that provides an overview of the Financial Data Warehouse is available here.
The Financial Data Warehouse consists of Accounting, Employment and Purchasing data as well as the related supporting data.
Below is a list of the major classes of data currently in the Financial Data Warehouse:
- Account
- Account Snapshot
- Account Balance Snapshot
- Accounting Activity
- Cost Sharing Activity
- Employment Data (Employee Snapshot, Postion Snapshot, Appointment, Assignment, Payroll Expense, etc.
- Encumbrance Document Balance
- Endowment Account Distribution
- PBL Data (PBL Account Object Balance, PBL Account Position Balance, PBL Account Object Activity, PBL Position Activity, etc.)
- Purchasing Data (Blanket Authorization, Payment Request, Purchase O
- Supporting Data
For more details on these classes and the data objects that they contain see the data warehouse universe documentation.
In the future, Purchasing data will include Service Center Billing, Travel Card, and Purchasing Card data.