Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR Appointment Transactions


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_APPT_TYPE

Master data table identifying the type of appointment (Primary, Additional, and Dual) and sub-type(Academic, Non Academic). This view also contains flages identifyinf whether the appointment is current, future, or exempt.

Dimension

Human Resources, SAP

MIT ONLY

Daily

28-MAR-2024

HR_JOB

Master data table containing a list of jobs, job titles, pay grade, salary ranges and other job related data.

Dimension

Human Resources, SAP

MIT ONLY

Daily

28-MAR-2024

HR_PERSON_EMPLOYEE

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

Dimension

Human Resources, SAP

SENSITIVE

Daily

28-MAR-2024

HR_APPT_TX_DETAIL

This table contains all the various states of an employee appointments . This table contains data for appointments that were current as of the conversion to SAP/HR on 8/29/2003. The salary for confidential employees is set to $0.01.

Fact

Human Resources, SAP

SENSITIVE

Daily

28-MAR-2024

HR_ORG_UNIT

Master data table containing the new 8 digit department nuber, title, old department codes, and organization levels.

Dimension

Human Resources, SAP

MIT ONLY

Daily

28-MAR-2024

HR_POSITION

Master data table containing position information, such as position title, position area/subarea and employee group/subgroup, for the current fiscal period.

Dimension

Human Resources, SAP

MIT ONLY

Daily

28-MAR-2024