Payroll Personnel Data Warehouse

Information Model

The information models diagram the relationship of groups of information (seen as tables within the data warehouse) and their relationships to other. See How to Interpret The Information Models for information on how to interpret the Information Models and example.

select Employee information regarding....

1. Demographics : Information about the employee's department, etc. (edbper, edbfnw, etc.)
2. Benefits : Information about the employee's benefits (edbbel, edbben, etc.)
3. Payroll : Information about the employee's pay (edbpay, parern, ethtoe, etc.)
4. Job Roles : Information about which jobs/roles the employee fills (edbapp, edbdis, etc.)