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

	Related Links:
	Data and Reporting Services

All Data Warehouse Tables

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
ACADEMIC_TERMS	Information pertaining to academic terms	Dimension	Student Services Information Technology (SSIT)	PUBLIC	Daily	24-JUL-2008
ACAD_CHAIR	Academic chair information	Dimension	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
ACAD_CHAIR_CATEGORY	This table contains information about the various categories of academic chair.	Dimension	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
ACAD_CHAIR_COST_COLLECTOR	The various cost objects (for the chair, for salary and wages, and for scholarly allowance) associated with an academic chair.	Dimension	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
ACAD_CHAIR_DETAIL	Academic chair	Fact	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
ADM_GRAD_APPLICANT	Graduate admissions applicants.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_APPLICATION_DETAIL	Each record in this table represents an application to a graduate program at MIT. Information included in the record: entry term, entry date, graduate program applied, degree objective, decision and reply status of the application, and name, demographic, geographical region and previously attended schools of the applicant.	Fact	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_ATTD_SCH_1	This table contains information about the previously school/college attended by the graduate admissions applicant. Usually this is the school from which the applicant received a bachelor degree.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_ATTD_SCH_2	This table contains information about the previously school/college attended by the graduate admissions applicant. Usually this is the school from which the applicant received an advanced (or post-undergraduate) degree.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_ATTENDED_SCHOOL	This table contains information about all the previously attended schools of the graduate admissions applicant. There is one record for a school attended.	Fact	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_CITIZENSHIP	This is a dimension table used for querying the graduate admissions application data. This table contains the nationality and citizenship status of the applicants as recorded in the admissions system when the decision to the application is made official.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_DECISION	This table contains all the decision status (e.g. 'Admitted','Not Admitted','Wait Listed') of the graduate admissions application.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_DEGREE_OBJECTIVE	Initial and final degree objectives of the graduate admissions application.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_DEMOGRAPHIC	This table contains the gender and ethnicity of the graduate admissions applicants which are recorded in the admissions system when the decision to the application is made official.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_ENROLL_SCHOOL	Graduate schools where MIT graduate applicants choose to enroll at the end of the admission cycle	Dimension	Graduate Admissions	SENSITIVE	As Needed	20-JUL-2003
ADM_GRAD_FEE_STATUS	Application fee status of the graduate admissions application.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_HOME_ADDR_GEO	The geographical region of the applicant's home address.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_PROGRAM	This table contains information about graduate admissions programs, including joint programs and research areas.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_REPLY	This table contains all the reply status (e.g. 'Accepts offer','Not enrolling','Defer Enrollment') of the graduate admissions application.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_REPLY_ADDR_GEO	The geographical region of the applicant's reply address.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_SCHOOL	This table contains a list of universities and colleges previously attended by the graduate admissions applicants. Information of the school include the ETS code, name, and address of the school.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_SURVEY	Graduate Admissions Survey Data. This table contains results of surveys sent to admitted applicants (either via e-mail or regular mail) on factors that influence their enrollment decisions.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_TEST	Information about the various standardized graduate admissions tests such as: GRE, and TOEFL.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_TEST_SCORE_DETAIL	This is a fact table which contains a record for a test score of a standardized graduate admissions test (e.g. GRE, TOEFL). The record also includes the date the test was taken and the source of the test score.	Fact	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_TEST_TAKEN_TIME	Information about time (month and year) when the graduate admissions tests were taken.	Dimension	Graduate Admissions	SENSITIVE	Weekly	20-JUL-2008
ADM_GRAD_TIME	This table is used as a time dimension for querying the graduate admissions data. Included in this table are fields such as the expected entry term, expected entry year, expected entry month, corresponding to the academic year.	Dimension	Graduate Admissions	SENSITIVE	As Needed	03-JUL-2001
ALUMNI_BY_COURSE	This table contains MIT Alumni's biographic, degree, address, and employment data. Access to records in this table is granted according to the course(s) of major of the Alumni. There is one record per person in this table.	Fact	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_ADDRESS_DETAIL	This is a fact table which contains address information of MIT Alumni.	Fact	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_ADDRESS_TYPE	This table contains information about the different address types stored in the ALUM ADDRESS DETAIL table. Some of the Address Types are: Business, Home, Season, Student Term Address, Past Home, Alternate Business, and MIT Employee Campus Address.	Dimension	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_BIOGRAPHIC	Biographic information of MIT Alumni - there is one record per person.	Dimension	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_DEGREE_DETAIL	This table contains degree information of MIT Alumni.	Fact	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_DEGREE_TYPE	This table contains information about the different degree types available in the ALUM DEGREE DETAIL table.	Dimension	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_DEPARTMENT	This table contains information about MIT academic departments as used in the Alumni's system.	Dimension	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_DISPLAY_OPTION	Alumni table with display options (ie. whether to display a field) for specific fields in an alumni record.	Fact	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_INSTITUTION	XXX	Dimension	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_MAJOR	This table contains information about the courses of major as used in the Alumni's system.	Dimension	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_MIT_OCCUPATION	This table contains the Occupation Codes and Descriptions for the Alumni data.	Dimension	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_MIT_SIC	This table contains the Standard Industrial Codes and Decriptions for the Alumni data	Dimension	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_OCCUPATION_DETAIL	XXX	Fact	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
ALUM_SIC_DETAIL	XXX	Fact	Alumni Office	SENSITIVE	Weekly	19-JUL-2008
APPOINTMENT_ALL	Old Personnel Data in CYBORG - Contains all employee appointments (current and old) and related information. A record of personnel actions, including salary reviews, terminations, hires, transfers, etc.	Fact	Human Resources	SENSITIVE	As Needed	08-MAR-2006
APPOINTMENT_BASIC	Old Personnel Data in CYBORG - Limited view of HR appointment data	Fact	Human Resources	SENSITIVE	As Needed	08-MAR-2006
APPOINTMENT_LIMITED	Old Personnel Data in CYBORG - Contains current appointment data without salary information for all employees. A record of personnel actions, including salary reviews, terminations, hires, transfers, etc.	Fact	Human Resources	SENSITIVE	As Needed	08-MAR-2006
APPOINTMENT_OLD	Old Personnel Data in CYBORG - Contains all the employee appointments and related information for appointments that are old/not current today. A record of personnel actions, including salary reviews, terminations, hires, transfers, etc.	Fact	Human Resources	SENSITIVE	As Needed	08-MAR-2006
ASA_EARLYRETURN_REQ_DETAIL	Association of Student Activities Early Return Requests	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
ASA_MIDWAY_REQ_DETAIL	Association of Student Activities Midway Requests	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
ASA_OFFICER_DETAIL	Association of Student Activities Student Group Officers	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
ASA_OFFICER_ROLE	Association of Student Activities Student Group Officer Roles	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
ASA_REQUEST_STATUS	Association of Student Activities Request Status	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
ASA_RESOURCE_ALLOC_DETAIL	Association of Student Activities Resource Allocations	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
ASA_RESOURCE_REQ_DETAIL	Association of Student Activities Resource Requests	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
ASA_RESOURCE_TYPE	Association of Student Activities Resource Types (Office, Locker, Mailbox, Bulletin Board)	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
ASA_STUDENT_GROUP	Association of Student Activities Student Groups	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
BALANCES	Contains financial information, balance & budget data by cost collector ID as of yesterday. Use this table to view a current balance, or to compare several past fiscal years in total. Normally the limit selected for this table is by Fiscal Year. (Taken from SAP tables COSP & COSS.)	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BALANCES_BY_FISCAL_PERIOD	Contains summary financial information, balance, and department and institute budgets for Cost Collectors. To look at balances as of the end of a fiscal period, use this table. Join this table with TIME_MONTH to select the time period your interested in. (If you pick more than one Fiscal Period, create computed items to separate out FYTD_Amount, Cumulative_Amount and Institute_Budget by fiscal period. Otherwise the totals for these fields will be inflated.)	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BALANCES_BY_FISCAL_PERIOD_3YRS	Contains 3 years of summary financial information, balance, and department and institute budgets for Cost Collectors. Use this table instead of BALANCES_BY_FISCAL_PERIOD if you don't need more than 3 years worth of data.	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BALANCE_SHEET_ACCOUNT	Sub set of cost collectors which represent balance sheet accounts.	Dimension	SAP Financial	MIT ONLY	Daily	24-JUL-2008
BALANCE_SHEET_ACCOUNT_ALL	All balance sheet accounts: Cost Collectors and pure GL Accounts	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BALANCE_SHEET_ACCOUNT_CUR	Balance sheet account for campus (CUR)	N/A	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BALANCE_SHEET_BALANCES	Contains balances data for all balance sheet accounts: cost collectors and pure GL accounts -- organized by fiscal year	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BALANCE_SHEET_BALANCES_BY_FP	Contains balances data for all balance sheet accounts: Cost Collectors and pure GL Accounts -- organized by Fiscal Period.	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BENEFITS_ADJUSTMENT_REASON	This table contains benefits adjustment reason codes and descriptions.	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BENEFITS_ADJ_REASON_DETAIL	This table contains a history of changes to employees' benefits, complete with reasons for these changes	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BENEFITS_DETAIL	Benefits Enrollments: history of health, insurance and FSA enrollments of employees and their dependents	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BENEFITS_ELIGIBILITY_CURRENT	Current benefits eligibility for employees	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BENEFITS_ELIGIBILITY_HISTORY	The history of employees' benefits eligibility	Fact	SAP Financial	SENSITIVE	Daily	08-MAR-2005
BENEFITS_PERSON_EMPLOYEE	MIT employee data including benefits-related fields which are excluded from other employee views	Dimension	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
BENEFITS_PLAN	Benefits Plans: health, insurance and flexible benefits accounts.	Dimension	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
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	24-JUL-2008
BENEFIT_COST_RULE	This table contains information about employee, employer, and provider costs for various plans, depending on coverage levels	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BILLING_PLAN	Billing plan data	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BUDGET	Institute and Departmental Budgets	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
BUDGET_GROUPINGS	Budget groupings	Fact	Planning & Budget Office	MIT ONLY	Daily	24-JUL-2008
BUILDINGS	Physical Plant data -- buildings	Dimension	Physical Plant	MIT ONLY	Daily	24-JUL-2008
BUILDING_WORKORDER_DETAIL	Building workorder detail	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
CIP	This table contains the CIP (Classification of Instructional Programs) records, 2000 Edition, as published by the National Center for Education Statistics in April 2002.	Dimension	Data Warehouse	MIT ONLY	As Needed	27-MAR-2003
CIP_WITH_VERSION	This table consists of multiple versions of the CIP (Classification of Instructional Programs) records as published by the National Center for Education Statistics. The 1990 version is loaded from the publication in July 1999. The 2000 version is loaded from the 2000 Edition published in April 2002.	N/A	Data Warehouse	MIT ONLY	As Needed	27-MAR-2003
CIS_COURSE_CATALOG	Curricular Information System (CIS) Course Catalog. This table contains the final version of each active subject for each academic year, whether or not it is enrollable.	Fact	Student Services Information Technology (SSIT)	MIT ONLY	Weekly	24-JUL-2008
COMMITMENT_HISTORY	Cointains commitment information to create views "as of" a certain date, available for dates from July 1999 to present. This table must be joined to the TIME_DAY table, joining the Record_Value_From_Date (use a simple join and select Greater than or Equal) AND the Record_Value_Thru_Date (use a simple join and select Less than or Equal) to the Calendar_Date field.	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
COMMITMENT_TYPE	A dimension table to be used with commitment fact tables, to identify types of commitments, such as blanket orders or LDS. Also includes commitment type codes and descriptions.	Dimension	SAP Financial	MIT ONLY	As Needed	01-MAR-1999
COSTING_SHEET	Costing sheet data	N/A	SAP Financial	SENSITIVE	Daily	24-JUL-2008
COST_CENTER	Contains MIT Cost Center Ids and related information. It can be used for browsing, establishing limits on fact table queries, and providing descriptive information about Cost Centers.	Dimension	SAP Financial	MIT ONLY	Daily	24-JUL-2008
COST_CENTER_HISTORY	Contains the history of Cost Center Data for each fiscal period and fiscal year.	Dimension	SAP Financial	MIT ONLY	Daily	24-JUL-2008
COST_COLLECTOR	Contains Master data information about all three types of cost collectors (Cost Centers, Internal Orders, & Projects/WBS Elements). It only contains the fields common to all three. Cost Collector is a term synonymous with Cost Object.	Dimension	SAP Financial	MIT ONLY	Daily	24-JUL-2008
COST_COLLECTORS_ACCESSIBLE	Contains Master data information about all three types of cost objects (Cost Centers, Internal Orders, & Projects/WBS Elements). It contains the fields common to all three, and additional fields such as surcharge percentage and overrun information. This table will only return information about cost collectors that you have been granted access to.	Dimension	SAP Financial	MIT ONLY	Daily	24-JUL-2008
COST_COLLECTOR_CATEGORY	A list of Cost Collector Category codes and descriptions. This table is used as a dimension only in those queries that involve MASTER PROJECT HISTORY DETAIL.	Dimension	SAP Financial	MIT ONLY	As Needed	10-FEB-2003
COST_COLLECTOR_HISTORY	Contains the history of Cost Collector Data by fiscal period and fiscal year.	Dimension	SAP Financial	MIT ONLY	Daily	24-JUL-2008
CREDIT_CARD_ACCT_ASSIGNMENT	Contains information about default account assignment rules for credit cards.	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
CREDIT_CARD_DETAIL	Credit card Transactions. Taken from table BSEG in SAP.	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
CREDIT_CARD_MASTER	Contains information about credit cards and their users.	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
CREDIT_CARD_MASTER_OLD	This table is occasionally used to load old credit card master data to compare it with current data. Its structure is identical to CREDIT_CARD_MASTER	Dimension	SAP Financial	SENSITIVE	Daily	20-JUL-2000
CREDIT_CARD_VERIFIER	Contains information about credit card verifiers.	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
CURRENT_COMMITMENTS	Shows current commitment information, including commitment amount, reference document number, material group, and quantity. Includes keys to join to Cost Collector, GL Account, Vendor, Material Group, and Commitment Type tables.	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
CUSTOMER	Customer data	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
CUSTOMER_ALL	All campus customers (company code 'CUR')	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
CUSTOMER_TECR	TechReview customers	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
DAPER_ATHLETE_CREW	This table is created specifically for use by the Department of Athletics, Physical Eudcation, Recreation (DAPER) to capture the data DAPER sends to Data Warehouse for Athletic Eligibility information for athletes and crew members.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
DAPER_ELIG_ENROLLMENT	This table is created specifically for use by the Department of Athletics, Physical Eudcation, Recreation (DAPER) to retrieve student term enrollment data for Athletic Eligibility Requirements. There is one record per student per term (including prior, current, and future terms in which the student has an enrollment profile). The STUDENT YEAR field is not populated if the student has asked to have the information suppressed.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
DAPER_ELIG_FINAID	This table is created specifically for use by the Department of Athletics, Physical Eudcation, Recreation (DAPER) to retrieve financial aid data from the Data Warehouse to monitor the athletic eligibillity of crew members. There is one record per student per term per fund/award offered. Only active (ie. not cancelled, not declined and with offered amount > 0) financial awards are included.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
DAPER_ELIG_STUDENT	This table is created specifically for use by the Department of Athletics, Physical Eudcation, Recreation (DAPER) to retrieve student data from the Data Warehouse to monitor the athletic eligibililty of student athletes. There is one record per student in the table. Data items include student biographic information, term and home addresses, previous college name, cumulative GPA, registration information for all athletes; and course(s) of major and degree requirements for Crew members. Students who have asked to have their email address, term and home addresses, or course information suppressed, the corresponding fields of their records are not populated.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
DAPER_PE_STUDENT	This table is created specifically for use by the Department of Athletics, Physical Eudcation, Recreation (DAPER) to retrieve PE student data from the Data Warehouse. The table contains records of students who are eligible to register in the current and the upcoming academic terms. The fields of e-mail address, term address, home address and Course information are not populated if the student has asked to have the information suppressed.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
DEPARTMENT_EMPLOYEE_DIRECTORY	Departmental Employee Telephone Directory for DLC Adminitrators	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
DOCUMENT_TYPE	Describes the type of document that the data is (internal order, purchase order, invoice, etc.)	Dimension	SAP Financial	MIT ONLY	Daily	24-JUL-2008
DUNNING_AREA	Dunning Areas used at the Institute. Can be joined to FINANCIAL_DETAIL using the field DUNNING_AREA_KEY.	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
EHST_CERTIFICATION	EHS Training certification data	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHST_CERT_STATUS	EHS Training certification status	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHST_CERT_TRIGGER	EHS Training certification trigger	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHST_DETAIL	EHS Training detail	Fact	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHST_DLC	EHS Training DLC data	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHST_PI	EHS Training PI data	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHST_TRAINEE	EHS Trainee information	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHST_UNIT	EHS Training Unit data	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHST_UNIT_STATUS	EHS Training Unit status	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHS_CONTACT_PERSON	EHS Contact Person information	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHS_FUNCTION	Information about people Functions within an EHS system	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHS_HAZARD	EHS information about hazards	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHS_PERSON	Ehs ROLE person information	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHS_ROLES_DETAIL	EHS Roles detail	Fact	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHS_ROLES_FUNCTION	EHS Roles function	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHS_ROLES_QUALIFIER	EHS Roles qualifier	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHS_ROOM	EHS Room information	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHS_ROOM_SET	List of EHS ROOMS (LABS)	Dimension	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHS_ROOM_SET_CONTACT_DETAIL	EHS room_set->contact_person->room detail information	Fact	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EHS_ROOM_SET_DETAIL	EHS room_set ->room->hazard->function->role-person detail information	Fact	Environment, Health, and Safety Office (EHS)	SENSITIVE	Daily	24-JUL-2008
EMPLOYEE	Old Personnel Data in CYBORG - Contains personal information about all employees.	Dimension	Human Resources	SENSITIVE	As Needed	08-MAR-2006
EMPLOYEE_BASIC	Old Personnel Data in CYBORG - Directory data plus service, tenure and chair data	Dimension	Human Resources	SENSITIVE	As Needed	08-MAR-2006
EMPLOYEE_BASIC_PLUS	Old Personnel Data in CYBORG - Directory data plus service, tenure, chair data and ethnicity	Dimension	Human Resources	SENSITIVE	As Needed	08-MAR-2006
EMPLOYEE_DIRECTORY	Contains directory information about current employees only.	Dimension	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
EMPLOYEE_DIRECTORY_FULL	A more basic version of DEPARTMENT_EMPLOYEE_DIRECTORY	Dimension	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
EMPLOYEE_LIMITED	Old Personnel Data in CYBORG - Contains employee data without home address information for all employees.	Dimension	Human Resources	SENSITIVE	As Needed	08-MAR-2006
ESTIMATED_SURCHARGES	Overhead, EB, and Allocation surcharges calculated on expenses for the open period(s) in which Costing Sheets have not run yet.	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
EXTERNAL_CREDIT_GENERATED	This table "integrates" the test scores with the credit results generated. Join this table with the EXTERNAL TEST SCORE DETAIL table to get the credit results generated from the tests.	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
EXTERNAL_CREDIT_RESULT_DETAIL	This table contains credit results that are generated from and/or applied to the freshmen external tests such as Advanced Placement, International Baccalaureate, GCE A-Level, Transfer Credit, and Advanced Standing. Generated credits result from applying the MIT credit rules associated with specific tests. Applied credit is the actual credit applied to a student's academic record. Students and/or the Registrar's Office may apply credit differently from the way it is initially generated based on the subjects the student students register for and also other factors. Credit comes in two forms: Credit for a specific subject (as specified in SUBJECT CODE and SUBJECT NUMBER) with associated units, and general elective credit units.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
EXTERNAL_CREDIT_RULE	A dimension table for the External Test Credit Result Star Schema. It contains the credit rule names and categories.	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
EXTERNAL_CREDIT_SUBJECT	A dimension table for the External Test Credit Result Star Scema. It contains the generated, applied and registration subject codes and numbers for the credit results.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
EXTERNAL_TEST	A dimension table for the External Test Score Star Schema which contains all the external tests and test scores maintained by the Registrar's Office. Data items include Test Category (eg. "AP" for Advanced Placement, "TC" for Transfer Credit, "GC" for GCE A-Level, "AS" for Advanced Standing, etc.), Test Code, Test Component Code, Test Description, and Test Score Source.	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Weekly	20-JUL-2008
EXTERNAL_TEST_GENERATED	This table "integrates" the credit results with the test scores. Join this table with the EXTERNAL CREDIT RESULT DETAIL table to get the tests from which the credit results were generated.	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
EXTERNAL_TEST_SCORE_DETAIL	This table contains (freshman) external test score information. Data in the table includes all tests and raw test scores maintained by MIT for Advanced Placement (AP), International baccalaureate exams, A-level exams, Transfer credit, Advanced Standing and Freshman Essay Evaluation. Students included in this table are those with an entrance term code of Summer 2003 (2003SU) and beyond, and who were eligible to register for the term.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
EXTERNAL_TEST_TIME	The time dimension table for the External Test Score Star Schema. It contains information about the year and the month the test was taken.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Weekly	20-JUL-2008
FACILITIES_WORKORDER_DETAIL	Facilities workorder detail	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
FACULTY_DIRECTORY	Faculty directory	Dimension	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
FIELDS	Contains a list of fields and their descriptions, as well as the tables where the fields appear.	Dimension	Data Warehouse	PUBLIC	Daily	Unavailable
FINAID_AID_APPLICANT	(Access to this table is restricted to the staff of Student Financial Services. Other authorized users are given access to the FINAID APPLICANT table.) This table contains the yearly status and summary information of all prospective financial aid applicants, including incoming freshmen and applicants, at MIT since financial aid year 1994. Information includes biographical data, financial aid data, enrollment profile data, admissions data, and summary of award data. There is one record per aid applicant per financial aid year.	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_APPLICANT	This table contains the yearly status and summary information of all prospective financial aid applicants, including incoming freshmen and applicants, at MIT since aid year 1994. Information includes biographical data, financial aid data, enrollment profile data, admissions data, and summary of award data. There is one record per aid applicant per financial aid year.	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_AWARD_DETAIL	This table contains financial aid award packages for each of the financial aid applicant since financial aid year 1994. Data in this table are organized by financial aid terms of an aid year and fund codes -- there is one record for each fund/award an aid applicant receives in a term of an aid year.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_AWARD_STATUS	Contains all the financial aid award and note statuses. For each award status (eg. ACTL, CANC, ESTI), there exists all the possible loan promissory note status codes (eg. RECM, SIGN) for promissory loan notes of Federal Direct Loans, Perkins Loans, Parent Loans, and Technology Loans; and also the status codes of outside scholarship checks (eg. wether the checks were received or signed for deposit).	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_BUDGET_COMPONENT	Contains the estimated amount of the standard financial aid budget items (eg. Tuition, Room and Board, Book and Supplies) for the different budget types (FEDR, INST, or PELL), aid periods (eg. Full Academic Year, Fall Term only, Spring Term only) and budget groups (eg. Regular Undergraduates, International Undergraduates, Regular Graduate Students) of a financial aid year.	Dimension	Student Services Information Technology (SSIT)	MIT ONLY	Daily	24-JUL-2008
FINAID_FUND_MANAGEMENT	This table contains aid year based financial aid fund rules and management information. Funds/awards are grouped by fund source (Federal, Institutional, Other), fund type (loan, grant, outside scholarship, tuition award, stipend, etc.) and fund category (a more detailed subgroup of fund type).	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_FWS_POSITION	A dimension table to be used in the Financial Aid Student Work Study (off-campus work) Star Schema. It contains all off-campus positions (with job title, description, program code, organization name, organization type, etc.) for the Financial Student Work Study program. The positions are grouped by program year.	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_FWS_TIMESHEET_DETAIL	Each record in this table represents a weekly time sheet for an off-campus position held by a student. Information in the time sheet record include: begin and end date of the week, total hours work for the week and on each day, weekly earnings, and payroll account information.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_GRANT	Contains aid year based rules and management information about the MIT Alumni/ae & Friends Funds (ie. MIT Grants or SubFunds).	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_GRANT_PCKG_DETAIL	Contains the detail of the current package of "MIT Alumni/ae and Friends" fund assignments for students who have been awarded MIT Grant in a financial aid year. Data since financial aid year 1994 are included in this table.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_OUTSIDE_SCHOL	This table contains outside scholarships information -- such as outside scholarhip codes, outside scholarship names, types, renewable status -- which may be included in a student's financial aid package.	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_PAYROLL_CWSP_STATUS	A dimension table for the CWSP (College Work Study Program) account status for each of the student payroll distribution record.	Dimension	Student Services Information Technology (SSIT)	MIT ONLY	Daily	24-JUL-2008
FINAID_PAYROLL_DIST_DETAIL	Financial Aid Student Payroll Distribution Detail ("Student Employment") Table. It contains detailed distribution transactions of all student payroll data. Each record represents a single payroll distribution.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_PAY_DIST_TYPE	A dimensional table for the Financial Aid Campus Work Star Schema. It contains the following data items: Payroll System (for either undergraduate or graduate students), Distribution Type (Undergraduate Timesheet, Graduate Appointment, Undergraduate Voucher, Adjustments, etc.), Personnel Rank (RA, TA, Instructor, etc.). Personnel Rank is not applicable to the undergraduate payroll system.	Dimension	Student Services Information Technology (SSIT)	MIT ONLY	Daily	24-JUL-2008
FINAID_TERM	Contains information about financial aid terms	Dimension	Student Services Information Technology (SSIT)	MIT ONLY	Academic Term	01-JUN-2008
FINAID_WORK_EARNINGS_DETAIL	Contains student's work earnings data from on campus jobs such as fellowships, teaching assistant, research assistant, undergraduate on campus work. Only the latest three financial aid years of data are included in this table.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_WORK_STUDENT	This table contains records of students who have worked on campus. Fields of records include MIT ID, full name, and some enrollment information.	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
FINAID_YEAR	Contains information about financial aid years	Dimension	Student Services Information Technology (SSIT)	MIT ONLY	Academic Term	01-JUN-2008
FINANCIAL_DETAIL	Contains information about all detail transactions as entered into SAP. This is taken from BSEG. It also contains current open commitment transactions taken from COOI.	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
FINANCIAL_DETAIL_ALL	Contains information about all detail transactions as entered into SAP. This has both sides of the transaction. It is taken from BSEG.	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
FINANCIAL_PROCESSING_STATUS	Table containing data which displays the current status of several financial processing areas. Examples: costing sheets, payroll, facilities processing, fiscal period complete, etc.	Fact	SAP Financial	SENSITIVE	Daily	24-JUL-2008
FUND	Contains data about sources of revenue (funds & fund centers).	Dimension	SAP Financial	MIT ONLY	Daily	24-JUL-2008
FUNDS_REPORTING	Departmental funds reporting data	Fact	SAP Financial	SENSITIVE	Monthly	10-JUL-2008
FUND_ACCOUNT	Subset of cost collectors defined as Sponsored or Non-Sponsored Funds. (This table should not be confused with SAP funds or fund centers.)	Dimension	SAP Financial	MIT ONLY	Daily	24-JUL-2008
FUND_COST_COLLECTOR	Subset of cost collectors defined as Sponsored and Non-Sponsored Funds.	Dimension	SAP Financial	MIT ONLY	Daily	24-JUL-2008
FUND_COST_COLLECTOR_HISTORY	Fund cost collector history	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
FUND_DESCRIPTION	Fund description	Dimension	Development Research and Systems	SENSITIVE	Daily	24-JUL-2008
FUND_DESCRIPTION_HISTORY	Fund description history	Fact	Development Research and Systems	SENSITIVE	Daily	24-JUL-2008
GL_ACCOUNT	GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
GL_ACCOUNT_REPORT	GL Account and Cost Element Dimension with built-in mechanism for organizing in preset Cost Element (GL Account) groups, derived from Cost Element Hierarchies (groups) in SAP. The value in the field Report-Type describes the type of grouping as it is defined in SAP. IMPORTANT: "REPORT TYPE" MUST BE SPECIFIED as a limit, for the query to return correct results.	Dimension	SAP Financial	MIT ONLY	Daily	24-JUL-2008
GL_ACCOUNT_TECR	TechReview GL accounts	Dimension	SAP Financial	SENSITIVE	Daily	24-JUL-2008
GRADUATE_APPOINTMENT_TYPE	This dimension table contains the definitions for the various types of graduate student appointment (e.g. Fellowship, Reseach Assistant, Teaching Assistant) and the associated fund type (Tuition, Stipend, Insurance) and fund/award status (Actual, Cancelled, etc.)	Dimension	Student Services Information Technology (SSIT)	MIT ONLY	As Needed	28-MAR-2002
GRADUATE_AWARDING_DEPARTMENT	The dimension table consists of all the academic departments and their schools at MIT. Limit on the awarding department fields in this table, and join it to the GRADUATE AWARD TERM DETAIL table for graduate awards that are awarded by the specific department.	Dimension	Student Services Information Technology (SSIT)	MIT ONLY	Daily	24-JUL-2008
GRADUATE_AWARD_TERM_DETAIL	Graduate Award Term Detail	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
GRADUATE_AWARD_WORK_AREA	This table contains work area information (such as the subject/course as well as the supervisor/faculty in which the graduate student is a TA or RA) about a graudate award.	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	24-JUL-2008
HR_ABSENCE_BALANCE	In this table, for a non-exempt employee, there is one balance quota record for each of these balance quotas: Vacation, Fifth Week Vacation, Sick Leave, and Personal Leave. For exempt employees, there is one balance quota record for the Vacation quotas, and a balance quota record for the Fifth Week Vacation quotas.	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
HR_ABSENCE_BALANCE_TYPE	A dimension table which contains the different types of absence balance quotas for exempt and non-exempt employees. There are Vacation and 5th Week Vacation quotas for exempt employees; and the quotas for non-exempt employees are: Vacation, 5th Week Vacation, Sick, and Personal.	Dimension	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
HR_ABSENCE_DETAIL	This table contains absence data for non-exempt employees (beginning in July 2006) and exempt employees (beginning in September 2006). It shows the dates and the number of hours/days taken as an absence day for vacation, fifth week vacation, sick leave, personal leave, etc.	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
HR_ABSENCE_TYPE	A dimension table which contains the different types of absences for exempt and non-exempt employees. Eg.: Vacation, Sick, Personal Leave, Bereavement Leave, 5th Week Vacation, Sick - Family, Leave Without Pay.	Dimension	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
HR_APPOINTMENT_BASIC_DETAIL	A simplified version of the HR_APPOINTMENT_DETAIL table.	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-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	24-JUL-2008
HR_APPOINTMENT_LIMITED_DETAIL	This table contains the detail transactions for all the employee appointments excluding salary/pay data. This table contains data for appointments that were current as of the conversion to SAP/HR on 8/29/2003.	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
HR_APPOINTMENT_SU_DETAIL	This table contains the detail transactions for all the employee appointments. This view contains data for appointments that were current as of the conversion to SAP/HR on 8/29/2003.This table displays the salary for confidential employees accurately.	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
HR_APPT_ACTION_DETAIL	This table contains one record per personnel action (such as New Hire, Transfer, Annual Salary Review, Salary Change, Leave of Absence, Promotion) pertaining to an appointment for an employee. This is a new table created in July 2006 to allow an employee more than one personnel action per appointment on the same day. Prior to that, personnel action in the HR_APPT_TX_DETAIL table has always retained only the latest action for an appointment on a particular date.	Fact	Human Resources, SAP	SENSITIVE	Daily	10-JUL-2006
HR_APPT_LETTER_DETAIL	This table contains all of the letters sent to Employees by HR. One letter is sent for every appointment transaction that occurs. This table includes salary information for all employees and its use is restricted to HR_Superusers.	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-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	24-JUL-2008
HR_APPT_TX_LIMITED_DETAIL	This table contains all of the transactions that effect employee appointments, excluding salary/pay data. This table contains data for appointments that were current as of the conversion to SAP/HR on 8/29/2003.	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
HR_APPT_TX_SU_DETAIL	This table contains all of the transactions that effect employee appointments. This view contains data for appointments that were current as of the conversion to SAP/HR on 8/29/2003.This table displays the salary for confidential employees accurately.	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-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	24-JUL-2008
HR_BENEFIT_ELIGIBILITY_CURRENT	XXX	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
HR_BENEFIT_ELIGIBILITY_HISTORY	XXX	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
HR_CIP	Master data table containing the CIP(Classification of Instructional Programs) records, 2000 Edition, as published by the National Center for Education Statistics in April 2002.	Dimension	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
HR_DEGREE	Master data table containing a list of Degrees and their corresponding codes. (Example: Associate Degree 60, Post-Doctorate 10).	Dimension	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
HR_DEGREE_TYPE	Master data table identifying the type/level of a degree. (Example: High School, Trade/Technical School, Graduate Certificate, Master's Degree)	Dimension	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
HR_EDUCATION_DETAIL	Data about degrees earned by MIT employees. This information is self reported using the SAP Self-Service application.	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
HR_EDU_INSTITUTION	Master data tabe containing the names and addresses of Institutions where employees have received their degrees.	Dimension	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
HR_EMPLOYEE_AFFILIATION_DETAIL	Data about MIT employee's research affiliations.	Dimension	Human Resources, SAP	SENSITIVE	Daily	Unavailable
HR_EMPLOYEE_AFFILIATION_TYPE	Data identifying the type of research affiliation (high,medium,low)	Dimension	Human Resources, SAP	SENSITIVE	Daily	03-MAY-2005
HR_EMPLOYMENT_CIP_DETAIL	Table containing information about MIT employees' CIP(Classification of Instructional Programs) records, 2000 Edition, as published by the National Center for Education Statistics in April 2002.	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
HR_EMPLOYMENT_CIP_TYPE	Table containing description about the types of CIP (Classification of Instructional Programs) records for a discipline	Dimension	Human Resources, SAP	MIT ONLY	Daily	24-JUL-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	24-JUL-2008
HR_JOB_FULL	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	24-JUL-2008
HR_JOB_HISTORY	Master data table containing a list of jobs, job titles, pay grade, salary ranges and other job related data.	Fact	Human Resources, SAP	MIT ONLY	Daily	24-JUL-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	24-JUL-2008
HR_ORG_UNIT_HIERARCHY	Master data table containing the new HR organization unit hierarchy.	Dimension	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
HR_ORG_UNIT_HISTORY	Master data table containing the new 8 digit department nuber, title, old department codes, and organization levels.	Fact	Human Resources, SAP	MIT ONLY	Daily	24-JUL-2008
HR_PERSONNEL_ACTION_DETAIL	SAP HR personnel actions data.	Fact	Human Resources, SAP	SENSITIVE	Daily	24-JUL-2008
HR_PE