Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR Positions


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_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

08-JAN-2020

HR_POSITION_DETAIL

This table contains information about position budgets and statuses, for the current fiscal period. For filled positions, it specifies who holds them and for what periods of time. For unfilled positions, it specifies their sub-status.

Fact

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

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

08-JAN-2020

HR_POSITION_STATUS

This table contains the list of relevant position statuses and their descriptions.

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_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

08-JAN-2020