Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Payroll


Business area which contains HR Payroll data.


Follow the links in the Tables in Group column to see a list of all the tables used in the star/group, together with information on how to combine the tables in a query.

Follow the links in the Data Model Diagram column (if available) to see a pictorial representation of the star.

Star/Table Group

Description

Tables in Group

Data Model Diagram

Payroll Deductions

This area contains information about payroll deductions. This information enables each central area making payroll deductions, such as Credit Union, Parking, to report on the deductions by person made by that area.

Payroll Deductions tables

Payroll Deductions data model

Payroll Distributions

This area contains FYTD payroll (e-DACCA) distribution information that shows the percent distribution of salaries to Cost Object.

Payroll Distributions tables

Payroll Distributions data model

Payroll e-DACCA Certifications

This area contains the Quarterly Dacca Certification information. Data include cost collectors by supervisor and cost object, with name of certifier and date certified. The date certified field is blank if the cost object has not yet been certified.

Payroll e-DACCA Certifications tables

Payroll e-DACCA Certifications data model