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

SENSITIVE

Daily

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

06-OCT-2008

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

06-OCT-2008

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

06-OCT-2008

HR_PERSON_EMPLOYEE

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

Dimension

Human Resources, SAP

SENSITIVE

Daily

06-OCT-2008

HR_POSITION_STATUS

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

Dimension

Human Resources, SAP

MIT ONLY

Daily

06-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.