Skip to content Accesskey=4Skip to sub-navigation Accesskey=3View our Accessibility Options MIT Information Services and Technology Home About IS&T Contact IS&T Site Map Search Advanced Search
Getting StartedGetting Services by Topic or Alphabetically Getting Help

data warehouse logo

 
Related Links:
 

Data and Reporting Services


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

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

11-OCT-2008

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

11-OCT-2008

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

SENSITIVE

Daily

11-OCT-2008

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

11-OCT-2008

HR_PERSON_EMPLOYEE

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

Dimension

Human Resources, SAP

SENSITIVE

Daily

11-OCT-2008

HR_APPOINTMENT_DETAIL

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

11-OCT-2008

MIT Home | Getting Started | Getting Services | Getting Help | About IS&T | Accessibility
Ask a technology question or send a comment about this web page.