		Home About IS&T Contact IS&T Site Map	Search Advanced Search

	Related Links:
	Data and Reporting Services

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_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_APPT_TX_DETAIL	This table contains all of the transactions that effect 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	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_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_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_PERSON_EMPLOYEE	Table containing information about MIT employees as recorded and maintained in SAP HR.	Dimension	Human Resources, SAP	SENSITIVE	Daily	11-OCT-2008


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