Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Employee Education


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

HR_EDUCATION_DETAIL

Data about degrees earned by MIT employees. This information is self reported using the SAP Self-Service application.

Fact

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

HR_EMPLOYMENT_CIP_TYPE

Table containing description about the types of CIP (Classification of Instructional Programs) records for a discipline

Dimension

Human Resources, SAP

MIT ONLY

Daily

08-JAN-2020

HR_EMPLOYMENT_CIP_DETAIL

Table containing information about MIT employees' CIP(Classification of Instructional Programs) records, 2000 Edition, as published by the National Center for Education Statistics in April 2002.

Fact

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

HR_DEGREE_TYPE

Master data table identifying the type/level of a degree. (Example: High School, Trade/Technical School, Graduate Certificate, Master's Degree)

Dimension

Human Resources, SAP

MIT ONLY

Daily

08-JAN-2020

HR_DEGREE

Master data table containing a list of Degrees and their corresponding codes. (Example: Associate Degree 60, Post-Doctorate 10).

Dimension

Human Resources, SAP

MIT ONLY

Daily

08-JAN-2020

HR_PERSON_EMPLOYEE

Table containing information about MIT employees as recorded and maintained in SAP HR.

Dimension

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

HR_CIP

Master data table containing the CIP(Classification of Instructional Programs) records, 2000 Edition, as published by the National Center for Education Statistics in April 2002.

Dimension

Human Resources, SAP

MIT ONLY

Daily

08-JAN-2020

HR_EDU_INSTITUTION

Master data tabe containing the names and addresses of Institutions where employees have received their degrees.

Dimension

Human Resources, SAP

MIT ONLY

Daily

08-JAN-2020