HR Appointments
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 |
|---|---|---|---|---|---|---|
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 |
02-JAN-2025 |
|
Table containing information about MIT employees as recorded and maintained in SAP HR. |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
02-JAN-2025 |
|
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 |
02-JAN-2025 |
|
This table contains the detail information for all employee appointments (such as: shift eligibility, pay basis, and . 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 |
02-JAN-2025 |
|
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 |
02-JAN-2025 |
|
Master data table containing the new 8 digit department nuber, title, old department codes, and organization levels. |
Dimension |
Human Resources, SAP |
MIT ONLY |
Daily |
02-JAN-2025 |