Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Payroll e-DACCA Certifications


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

PROFIT_CENTER_GROUP

Structure for creating reports of grouped Profit Centers taken from SAP. Multiple hierarchies are represented in the groups.

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

COST_COLLECTOR

Contains Master data information about all three types of cost collectors (Cost Centers, Internal Orders, & Projects/WBS Elements). It only contains the fields common to all three. Cost Collector is a term synonymous with Cost Object.

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

PAYROLL_EDACCA_CERT_SCHED

This is a time dimension table for e-DACCA Certification which contains the fiscal year data.

Dimension

SAP HR Payroll

SENSITIVE

As Needed

09-JUL-2007

PAYROLL_EDACCA_CERT_DETAIL

This table contains e-DACCA Certification detail information.

Fact

SAP HR Payroll

SENSITIVE

Daily

08-JAN-2020

PAYROLL_EDACCA_CERT_STATUS

This table contains information that describes the e-DACCA certification status.

Dimension

SAP HR Payroll

SENSITIVE

As Needed

09-JUL-2007