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

	Related Links:
	Data and Reporting Services

Benefits Detail

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
BENEFITS_RECIPIENT	A record exists in this table for each person who receives health, insurance, or flexible spending account benefits at MIT. Therefore, there are records not just for employees, but for their dependents.	Dimension	Human Resources, SAP	SENSITIVE	Daily	12-OCT-2008
BENEFITS_PERSON_EMPLOYEE	MIT employee data including benefits-related fields which are excluded from other employee views	Dimension	Human Resources, SAP	SENSITIVE	Daily	12-OCT-2008
BENEFITS_DETAIL	Benefits Enrollments: history of health, insurance and FSA enrollments of employees and their dependents	Fact	SAP Financial	SENSITIVE	Daily	12-OCT-2008
BENEFITS_PLAN	Benefits Plans: health, insurance and flexible benefits accounts.	Dimension	Human Resources, SAP	SENSITIVE	Daily	12-OCT-2008
BENEFITS_ADJUSTMENT_REASON	This table contains benefits adjustment reason codes and descriptions.	Dimension	SAP Financial	SENSITIVE	Daily	12-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.