Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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

MIT Student Information System

PUBLIC

Daily

25-JUL-2014

ACAD_CHAIR

Academic chair information

Dimension

Human Resources, SAP

MIT ONLY

Daily

25-JUL-2014

ACAD_CHAIR_CATEGORY

This table contains information about the various categories of academic chair.

Dimension

Human Resources, SAP

MIT ONLY

Daily

25-JUL-2014

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

25-JUL-2014

ACAD_CHAIR_DETAIL

Academic chair

Fact

Human Resources, SAP

MIT ONLY

Daily

25-JUL-2014

ADM_GRAD_APPLICANT

Graduate admissions applicants.

Dimension

Graduate Admissions

SENSITIVE

Weekly

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

ADM_GRAD_ATTD_SCH_2

This table contains information about the previously school/college attended by the graduate admissions applicant. Usually this is the last/latest school attended by the applicant, and most probably from which the applicant received an advanced (or post-undergraduate) degree.

Dimension

Graduate Admissions

SENSITIVE

Weekly

25-JUL-2014

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. Join this table with ADM_GRAD_APPLICANT by adm_grad_applicant_key to get all the schools previously attended by the applicant.

Fact

Graduate Admissions

SENSITIVE

Weekly

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

ADM_GRAD_DEGREE_OBJECTIVE

Initial and final degree objectives of the graduate admissions application.

Dimension

Graduate Admissions

SENSITIVE

Weekly

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

ADM_GRAD_HOME_ADDR_GEO

The geographical region of the applicant's home address.

Dimension

Graduate Admissions

SENSITIVE

Weekly

25-JUL-2014

ADM_GRAD_PROGRAM

This table contains information about graduate admissions programs, including joint programs and research areas.

Dimension

Graduate Admissions

SENSITIVE

Weekly

25-JUL-2014

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

25-JUL-2014

ADM_GRAD_REPLY_ADDR_GEO

The geographical region of the applicant's reply address.

Dimension

Graduate Admissions

SENSITIVE

Weekly

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

ADM_GRAD_TEST

Information about the various standardized graduate admissions tests such as: GRE, and TOEFL.

Dimension

Graduate Admissions

SENSITIVE

Weekly

25-JUL-2014

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

25-JUL-2014

ADM_GRAD_TEST_TAKEN_TIME

Information about time (month and year) when the graduate admissions tests were taken.

Dimension

Graduate Admissions

SENSITIVE

Weekly

25-JUL-2014

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_ADDRESS

This table contains one record per person (alum). Each record contains the home, business, and email addresses of each person.

Fact

Alumni Office

SENSITIVE

Weekly

19-JUL-2014

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

ALUM_ADDRESS_DETAIL

This is a fact table which contains address information of MIT Alumni. Join this table to the ALUM_ADDRESS_TYPE table using the ALUM_ADDRESS_TYPE_KEY field to get the specific types of address for the person.

Fact

Alumni Office

SENSITIVE

Weekly

19-JUL-2014

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

ALUM_BIOGRAPHIC

Biographic information of MIT Alumni - there is one record per person.

Dimension

Alumni Office

SENSITIVE

Weekly

19-JUL-2014

ALUM_DEGREE_DETAIL

This table contains degree information of MIT Alumni.

Fact

Alumni Office

SENSITIVE

Weekly

19-JUL-2014

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

ALUM_DEPARTMENT

This table contains information about MIT academic departments as used in the Alumni's system.

Dimension

Alumni Office

SENSITIVE

Weekly

19-JUL-2014

ALUM_DISPLAY_OPTION

Alumni table with display options (ie. whether to display a field) for specific fields in an alumni record. '1' in the specific field means to display the information, '0' not to display.

Fact

Alumni Office

SENSITIVE

Weekly

19-JUL-2014

ALUM_EMPLOYMENT

This table contains MIT alumni's employment records

Fact

Alumni Office

SENSITIVE

Weekly

19-JUL-2014

ALUM_INSTITUTION

XXX

Dimension

Alumni Office

SENSITIVE

Weekly

19-JUL-2014

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

ALUM_MIT_OCCUPATION

This table contains the Occupation Codes and Descriptions for the Alumni data.

Dimension

Alumni Office

SENSITIVE

Weekly

19-JUL-2014

ALUM_MIT_SIC

This table contains the Standard Industrial Codes and Decriptions for the Alumni data

Dimension

Alumni Office

SENSITIVE

Weekly

19-JUL-2014

ALUM_OCCUPATION_DETAIL

XXX

Fact

Alumni Office

SENSITIVE

Weekly

19-JUL-2014

ALUM_SIC_DETAIL

XXX

Fact

Alumni Office

SENSITIVE

Weekly

19-JUL-2014

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_CYBORG

This is the old HR system (Cyborg)'s appointment records. Pre-2003

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

ARRA_PERSON

New HR (SAP) Employee Data

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

ARRA_REPORTING_DETAIL

Fact table for VPF ARRA reporting

Fact

SAP Financial

SENSITIVE

Monthly

Unavailable

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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

BALANCE_SHEET_ACCOUNT

Sub set of cost collectors which represent balance sheet accounts.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

BALANCE_SHEET_ACCOUNT_ALL

All balance sheet accounts: Cost Collectors and pure GL Accounts

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

BALANCE_SHEET_ACCOUNT_CUR

Balance sheet account for campus (CUR)

N/A

SAP Financial

SENSITIVE

Daily

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

BENEFITS_ADJUSTMENT_REASON

This table contains benefits adjustment reason codes and descriptions.

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

BENEFITS_ADJ_REASON_DETAIL

This table contains a history of changes to employees' benefits, complete with reasons for these changes

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

BENEFITS_COSTSHARE_DETAIL

Data about retirees and benefits subscribers who page a percentage of their full medical cost

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

BENEFITS_COSTSHARE_TYPE

A dimension table holding fields specificying benefits cost sharing conditions, as well as billing specifics

N/A

Human Resources, SAP

SENSITIVE

Daily

Unavailable

BENEFITS_DETAIL

Benefits Enrollments: history of health, insurance and FSA enrollments of employees and their dependents

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

BENEFITS_ELIGIBILITY_CURRENT

Current benefits eligibility for employees

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

BENEFITS_ELIGIBILITY_HISTORY

The history of employees' benefits eligibility

Fact

Human Resources, SAP

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

25-JUL-2014

BENEFITS_PLAN

Benefits Plans: health, insurance and flexible benefits accounts.

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

BILLING_PLAN

Billing plan data

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

BUDGET

Institute and Departmental Budgets

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

BUDGET_DOCUMENT_TYPE

XXX

Dimension

Budget, Finance and Treasury

SENSITIVE

Daily

25-JUL-2014

BUDGET_DRAFT_REASON

XXX

Dimension

Budget, Finance and Treasury

SENSITIVE

Daily

25-JUL-2014

BUDGET_DRAFT_STATUS

XXX

Dimension

Budget, Finance and Treasury

SENSITIVE

Daily

25-JUL-2014

BUDGET_GROUPINGS

Budget groupings

Fact

Budget, Finance and Treasury

MIT ONLY

Daily

25-JUL-2014

BUDGET_POSTRULE

XXX

Dimension

Budget, Finance and Treasury

SENSITIVE

Daily

25-JUL-2014

BUDGET_PRIVATE_COMMENT

XXX

Dimension

Budget, Finance and Treasury

SENSITIVE

Daily

08-DEC-2010

BUDGET_TRANSACTION_DETAIL

XXX

Fact

Budget, Finance and Treasury

SENSITIVE

Daily

25-JUL-2014

BUILDINGS

Physical Plant data -- buildings

Dimension

Facilites -- Physical Plant

MIT ONLY

Daily

25-JUL-2014

BUILDING_WORKORDER_DETAIL

Building workorder detail

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

CIP

This table contains the CIP (Classification of Instructional Programs) records, 2010 Edition, as published by the National Center for Education Statistics.

Dimension

Data Warehouse

PUBLIC

As Needed

17-OCT-2010

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, 2000, and 2010 versions are included in the table.

Fact

Data Warehouse

PUBLIC

As Needed

17-OCT-2010

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

MIT Student Information System

MIT ONLY

Weekly

25-JUL-2014

CIS_HASS_ATTRIBUTE

More detailed descriptions of HASS Attributes in CIS Course Catalog

Dimension

MIT Student Information System

PUBLIC

Weekly

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

COST_CENTER_HISTORY

Contains the history of Cost Center Data for each fiscal period and fiscal year.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

CREDIT_CARD_ACCT_ASSIGNMENT

Contains information about default account assignment rules for credit cards.

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

CREDIT_CARD_DETAIL

Credit card Transactions. Taken from table BSEG in SAP.

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

CREDIT_CARD_MASTER

Contains information about credit cards and their users.

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

CUSTOMER

Customer data

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

CUSTOMER_ALL

All campus customers (company code 'CUR')

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

CUSTOMER_TECR

TechReview customers

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

DEPARTMENT_EMPLOYEE_DIRECTORY

Departmental Employee Telephone Directory for DLC Adminitrators

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

DOCUMENT_TYPE

Describes the type of document that the data is (internal order, purchase order, invoice, etc.)

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

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

25-JUL-2014

EECS_DEGREE_AWARDED

Degrees awarded information, specific to EECS students. For use by EECS users only.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

EECS_FRESHMAN

Freshmen for the academic year. For use by EECS users only.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

EECS_STUDENT_PERSONAL

Student biographic and address information specific to EECS students. For use by EECS users only. Included in this table are terms from the current and prior academic years.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

EECS_SUBJECT_ENROLLMENT

Subject enrollment data specific to EECS students. For use by EECS users only.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

EECS_TERM_ENROLLMENT

Student term enrollment data specific to EECS students. Included in this table are terms from the current and prior academic years. For use by EECS users only.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

EHST_CERTIFICATION

EHS Training certification data

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHST_CERT_STATUS

EHS Training certification status

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHST_CERT_TRIGGER

EHS Training certification trigger

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHST_DETAIL

EHS Training detail

Fact

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHST_DLC

EHS Training DLC data

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHST_PI

EHS Training PI data

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHST_TRAINEE

EHS Trainee information

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHST_UNIT

EHS Training Unit data

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHST_UNIT_STATUS

EHS Training Unit status

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHS_CONTACT_PERSON

EHS Contact Person information

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHS_FUNCTION

Information about people Functions within an EHS system

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHS_HAZARD

EHS information about hazards

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHS_PERSON

Ehs ROLE person information

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHS_ROLES_DETAIL

EHS Roles detail

Fact

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

25-JUL-2014

EHS_ROLES_FUNCTION

EHS Roles function

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

25-JUL-2014

EHS_ROLES_QUALIFIER

EHS Roles qualifier

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

25-JUL-2014

EHS_ROOM

EHS Room information

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHS_ROOM_SET

List of EHS ROOMS (LABS)

Dimension

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHS_ROOM_SET_CONTACT_DETAIL

EHS room_set->contact_person->room detail information

Fact

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

EHS_ROOM_SET_DETAIL

EHS room_set ->room->hazard->function->role-person detail information

Fact

Environment, Health, and Safety Office (EHS)

SENSITIVE

Daily

27-APR-2012

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

25-JUL-2014

EMPLOYEE_DIRECTORY_FULL

A more basic version of DEPARTMENT_EMPLOYEE_DIRECTORY

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

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

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

EXTERNAL_CREDIT_RULE

A dimension table for the External Test Credit Result Star Schema. It contains the credit rule names and categories.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

MIT ONLY

Weekly

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Weekly

25-JUL-2014

FACILITIES_WORKORDER_DETAIL

Facilities workorder detail

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

FACULTY_DIRECTORY

Faculty directory

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

FAC_BUILDING

Facilities Building Info

N/A

Facilites -- Physical Plant

SENSITIVE

Unavailable

Unavailable

FAC_BUILDING_ADDRESS

Facilities Building/Address Info

N/A

Facilites -- Physical Plant

SENSITIVE

Unavailable

Unavailable

FAC_FLOOR

Facilities Floor Info

N/A

Facilites -- Physical Plant

SENSITIVE

Unavailable

Unavailable

FAC_MAJOR_USE

Facilities Major Use Info

N/A

Facilites -- Physical Plant

SENSITIVE

Unavailable

Unavailable

FAC_ORGANIZATION

Facilities Organization Info

N/A

Facilites -- Physical Plant

SENSITIVE

Unavailable

Unavailable

FAC_ROOMS

Facilities Room Information

N/A

Facilites -- Physical Plant

SENSITIVE

Unavailable

Unavailable

FIELDS

Contains a list of fields and their descriptions, as well as the tables where the fields appear.

Dimension


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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

MIT ONLY

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

FINAID_GRANT

Contains aid year based rules and management information about the MIT Alumni/ae & Friends Funds (ie. MIT Grants or SubFunds).

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

FINAID_GRANT_STUDENT_INTEREST

Financial Aid Grant -- student interests. This table is granted to users in the Office of Student Financial Services and Resource Development only.

N/A

MIT Student Information System

SENSITIVE

Unavailable

Unavailable

FINAID_GRANT_STUDENT_INTEREST1

Financial Aid Grant -- student interests. This table is granted to users in the Office of Student Financial Services and Resource Development only.

N/A

MIT Student Information System

SENSITIVE

Unavailable

Unavailable

FINAID_GRANT_STUDENT_INTEREST2

Financial Aid Grant -- student interests. This table is granted to users in the Office of Student Financial Services and Resource Development only.

N/A

MIT Student Information System

SENSITIVE

Unavailable

Unavailable

FINAID_GRANT_STUDENT_INTEREST3

Financial Aid Grant -- student interests. This table is granted to users in the Office of Student Financial Services and Resource Development only.

N/A

MIT Student Information System

SENSITIVE

Unavailable

Unavailable

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

MIT ONLY

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

MIT ONLY

Daily

25-JUL-2014

FINAID_TERM

Contains information about financial aid terms

Dimension

MIT Student Information System

MIT ONLY

Academic Term

01-JUN-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

FINAID_YEAR

Contains information about financial aid years

Dimension

MIT Student Information System

MIT ONLY

Academic Term

01-JUN-2014

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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

FUND

Contains data about sources of revenue (funds & fund centers).

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

FUNDS_REPORTING

Departmental funds reporting data

Fact

SAP Financial

SENSITIVE

Monthly

10-JUL-2014

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

25-JUL-2014

FUND_CENTER_HIERARCHY

Fund Center Hierarchy

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

FUND_COST_COLLECTOR

Subset of cost collectors defined as Sponsored and Non-Sponsored Funds.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

FUND_COST_COLLECTOR_HISTORY

Fund cost collector history

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

FUND_DESCRIPTION

Fund description

Dimension

Development Research and Systems

SENSITIVE

Daily

25-JUL-2014

FUND_DESCRIPTION_HISTORY

Fund description history

Fact

Development Research and Systems

SENSITIVE

Daily

25-JUL-2014

GL_ACCOUNT

GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

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. For more details see: GL Account Overview

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

GL_ACCOUNT_TECR

TechReview GL accounts

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

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

MIT Student Information System

SENSITIVE

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

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

GRADUATE_AWARD_APPOINTMENT

This dimension table consists of all the graduate appointments/awards, ie. RA (Research Assistant), TA (Teaching Assistant), and FE (Fellowship) created for the graduate students. There is one record per appointment.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

GRADUATE_AWARD_TERM_DETAIL

This table contains information about graduate awards and appointments, ie. RA (Research Assistant), TA (Teaching Assistant), and FE (Fellowship). Each graduate appointment/award includes information about the student, the amount, the status of the award, the fund type (Tuition, Stipend, Insurance), the cost object and GL which the award is charged to, and the awarding department. Each of the graduate award/appointment is set up by academic terms (Summer, Fall, Spring) for the financial aid year. This table may be joined together with the GRADUATE_AWARD_WORK_AREA table to get more information about the supervisor for which the graduate student is a TA or RA.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

GRADUATE_AWARD_WORK_AREA

This table contains work area information (such as the the supervisor/faculty for which the graduate student is a TA or RA) about a graudate award.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

HR_APPOINTMENT_BASIC_DETAIL

A simplified version of the HR_APPOINTMENT_DETAIL table.

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

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

25-JUL-2014

HR_APPOINTMENT_LIMITED_DETAIL

DEPRICATED. Please use HR_APPOINTMENT_DETAIL that restricts for limited access.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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

HR_APPT_TX_DETAIL

This table contains all the various states of an 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

25-JUL-2014

HR_APPT_TX_LIMITED_DETAIL

DEPRICATED. Pleaase use HR_APT_TX_DETAIL that restricts for limited access. This table contains all the various states of an 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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

HR_BENEFIT_ELIGIBILITY_CURRENT

XXX

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

HR_BENEFIT_ELIGIBILITY_HISTORY

XXX

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

HR_EMPLOYEE_AFFILIATION_DETAIL

Data about MIT employee's research affiliations.

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2009

HR_EMPLOYEE_AFFILIATION_TYPE

Data identifying the type of research affiliation (high,medium,low)

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2009

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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

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

25-JUL-2014

HR_ORG_ACCESSIBLE

This table contains a view of HR Organizations filtered by what the user has access to. For use in driving selection screens

Dimension

Human Resources, SAP

MIT ONLY

Unavailable

Unavailable

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

25-JUL-2014

HR_ORG_UNIT_HIERARCHY

Master data table containing the new HR organization unit hierarchy.

Dimension

Human Resources, SAP

MIT ONLY

Daily

25-JUL-2014

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

25-JUL-2014

HR_PERSONNEL_ACTION_DETAIL

SAP HR personnel actions data.

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

HR_PERSONNEL_ACTION_TYPE

Codes and descriptions of personnel actions and personnel action reasons. This table should be used in conjunction with HR_PERSONNEL_ACTION_DETAIL table.

Dimension

Human Resources, SAP

MIT ONLY

Daily

25-JUL-2014

HR_PERSON_EMPLOYEE

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

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

HR_PERSON_EMPLOYEE_BASIC

This is a simplifed version of HR_PERSON_EMPLOYEE. It contains information about MIT employees as recorded and maintained in SAP HR.

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

HR_PERSON_EMPLOYEE_LIMITED

DEPRECATED. Please use HR_PERSON_EMPLOYEE view that restircts for limited access.This is a version of HR_PERSON_EMPLOYEE which does not include data items that contain sensitive information, such as home address and emergency contact information.

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

HR_PERSON_EMPLOYEE_YEAR_END

This table contains annual snapshots of HR_PERSON_EMPLOYEE table (only relevant fields are represented). It is used by HR-Payroll for government reporting

Fact

SAP HR Payroll

SENSITIVE

Yearly

31-DEC-2013

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

MIT ONLY

Daily

25-JUL-2014

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

25-JUL-2014

HR_POSITION_DETAIL_HISTORY

This table contains information about position budgets and statuses, from 2004 to present. 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

25-JUL-2014

HR_POSITION_FULL

Master data table containing position information, such as position title, position area/subarea and employee group/subgroup, for the current fiscal period. It also includes position's salary information

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

HR_POSITION_FULL_HISTORY

Master data table containing position information, such as position title, position area/subarea and employee group/subgroup. It also includes position's salary information

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

HR_POSITION_HISTORY

Master data table containing position information, such as position title, position area/subarea and employee group/subgroup.

Dimension

Human Resources, SAP

MIT ONLY

Daily

25-JUL-2014

HR_POSITION_LIMITED_DETAIL

The table contains information about position statuses for the current fiscal period. For filled positions, the data specifies who holds them and for what periods of time. For unfilled positions, it specifies their sub-status. Unlike HR_POSITION_DETAIL, it does not contain position budgets.

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

HR_POSITION_LIMITED_HISTORY

XXX

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

HR_POSITION_LIM_DET_HISTORY

The table contains information about position statuses. For filled positions, the data specifies who holds them and for what periods of time. For unfilled positions, it specifies their sub-status. Unlike HR_POSITION_DETAIL, it does not contain position budgets.

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

HR_POSITION_STATUS

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

Dimension

Human Resources, SAP

MIT ONLY

Daily

25-JUL-2014

HR_ROLES_DETAIL

HR Roles detail

Fact

Roles Authorization System

SENSITIVE

Daily

25-JUL-2014

HR_ROLES_FUNCTION

HR Roles function

Dimension

Roles Authorization System

SENSITIVE

Daily

25-JUL-2014

HR_ROLES_QUALIFIER

HR Roles qualifier

Dimension

Roles Authorization System

SENSITIVE

Daily

25-JUL-2014

HR_VISA_TYPE

This table contains the different types of visas.

Dimension

Human Resources, SAP

SENSITIVE

Daily

12-AUG-2013

IAP_ACTIVITY

IAP Non-Credit Activities. One record per IAP term per activity. Multi-session activities are marked with "MULTI-SESSION" in the iap_activity_date field. The current IAP term records in this table are refreshed daily from November 1 to the end of IAP.

Fact

MIT Student Information System

MIT ONLY

As Needed

31-JAN-2012

IAP_ACTIVITY_SESSION

IAP Non-Credit Activity session data. One record per session per activity. This table contains only the session data for the current IAP term. The data are refreshed daily from November 1 to the end of IAP.

Fact

MIT Student Information System

MIT ONLY

As Needed

31-JAN-2012

INSTRUCTOR_VIEW

This table contains directory information plus tenure date for active employees whose Employee Type are "Faculty".

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

INTERNAL_ORDER

Internal Order Dimension. Contains Master data about all Internal Orders

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

INTERNAL_ORDER_HISTORY

Contains the history of internal order data by fiscal period and fiscal year.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

IR_AWARD

Awards

Dimension

Institutional Research

SENSITIVE

Daily

25-JUL-2014

IR_AWARD_HONOR_DETAIL

Honors bestowed.

Fact

Institutional Research

SENSITIVE

Daily

25-JUL-2014

IR_AWARD_PERSON

Recipients of awards and honors.

Dimension

Institutional Research

SENSITIVE

Daily

25-JUL-2014

KERBEROS_NAME_CURRENT_STUDENT

This table contains kerberos name (kerberos principal) of all current students.

Dimension

Moira Accounts

SENSITIVE

Daily

18-MAY-2013

KEYS

Contains a list of keys that have been allocated, and the name of the person the keys have been allocated to.

Fact

Facilites -- Physical Plant

SENSITIVE

Weekly

25-JUL-2014

KRB_MAPPING

This table contains the Kerberos Name/Kerberos Principal of all people associated with the Institute. Information is fed from Moira and refreshed in this table every 3 hours between 10:20 am and 12:20am.

Dimension

Moira Accounts

SENSITIVE

Unavailable

Unavailable

KRB_PERSON

This table contains all people associated with the Institute who have a Kerberos Principal in Moira. Data items in the table include Kerberos Name, directory information, and the person's primary association (Student, Employee, Other) at MIT. This table is refreshed every 3 hours between 10am and 10pm with updated Kerberos information from Moira; and it is refreshed daily around 4 am with updated information from Moira, HR, and MITSIS.

Dimension

Moira Accounts

SENSITIVE

Daily

18-MAY-2013

LAB_MGMNT_DIRECTORY

EH&S lab management personnel directory information.

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

LIBRARY

Includes codes and descriptions of the MIT Libraries. This is the library that "owns" the item. (these are defined as Sub Libraries in Aleph, and include SAS, Document Services, Physics Reading Room, etc.). Use this table to limit the query by library that owns the item. Use the LIBRARY_FUND "Paying Library" field to limit the query by the library that paid for the item.

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_ALLOCATION_DETAIL

Includes details of the Budget Transactions for Allocations, Transfers, and Year End Carryovers only (e.g., Transaction Dates, Amounts). See LIBRARY_FINANCIAL_DETAIL for other transaction types. Data in this table is taken from the Z601 table in Aleph.

Fact

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_BORROWER_STATUS

Includes codes and desciptions about the borrower's status (Graduate student, Boston Library Consortium, etc.) and type (BLC - Umass-Amherst, Undrgraduate Student - Wellesley, etc.). Use this table to limit Circulation statistics by borrower status or type.

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_CALL_NO_STRUCTURE

Includes codes and descriptions of Classification Schemes. Use this table to limit the query by whether there is a Call Number, Classification type and Prefix (Dewey Decimal, SCORE, etc.)

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_CALL_NUMBER_SEARCH

Includes the classification number and a calculated classification number. Use this table to limit the query by classification.

Dimension

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_CATALOG

Includes bibliographic data such as Title, Author, Imprint, Year of Publication, ISSN/ISBN, Call Number, bib record creation and update dates and the bib system number (from MIT01). Data in this table is taken from the Z13 table in Aleph. Do not use the call number for limiting queries, use the LIBRARY_CALL_NUMBER_SEARCH table to limit the query by classification.

Dimension

Libraries

MIT ONLY

Daily

05-APR-2012

LIBRARY_CIRCULATION_DESK

Includess the IP Address of the client (GUI or Web), the 3-digit Code for where the item was checked out (the library or self-check desk), and the Name of the Library or Location to which the item belongs.

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_CIRCULATION_DETAIL

Includes information about the circulation transaction including dates, hours and staff checking out the item; as well as the type of material (BOOK, ISSUE, etc.). This data comes from the Aleph Z35 Events Table. Note: Do not use this table to determine the Total counts of Circulation prior to 7/9/2001; there is no detail information available in the Circulation Detail table until this date. Refer to the Item Detail table to obtain this data.

Fact

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_CIRC_EVENT_TYPE

Includes codes and desciptions about the event type (return, loan, hold), and the circulation type (i.e., the source such as PC Client, Self-Check, Your Acct). Excluded are details about active holds (Z37) or active loans (Z36). If you want a historical report about holds, contact the MIT Libraries Aleph Administrator. Use this table to limit Circulation statistics by event or circulation types.

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_CIRC_ITEM_STATUS

Includes codes and descriptions about the item status (2 Day Loan, ILB Loan, 2 Week Loan, etc. Use this table to limit circulation reports by item status.

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_COLLECTION

Includes codes and definitions of library collections as well as the type of material. Data in this table is taken from the Z30 table in Aleph. Use this table to limit the query to collection (e.g., Stacks, Electronic Journals, Basement, etc.)

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_CURRENCY

Includes codes and definitions of ISO defined currencies used in Aleph (USD for United States dollar, EUR for Euro, GBP for British pounds, etc.) Usually not needed to link to other tables, the Currency Code is in the LIBRARY_FINANCIAL_DETAIL, LIBRARY_INVOICE_DETAIL and LIBRARY_INVOICE_SUMMARY tables.

Dimension

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_FINANCIAL_DETAIL

Includes details of the Budget Transactions for Invoices and Encumbrances only (e.g., Transaction Dates, Amounts). See LIBRARY_ALLOCATION_DETAIL for other transaction types. Data in this table is taken from the Z601 table in Aleph.

Fact

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_FUND

Includes information from the Budgets (Funds) in Aleph (e.g., Fund Code, Fund Name, Budget Groups). Cost Collector and GL Account numbers are included for linking to SAP data. Data in this table is taken from the Z76 table in Aleph. Use this table to limit by Fund or Paying Library. Use the LIBRARY table to limit by the Library that owns the item.

Dimension

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_FUND_BALANCES

Includes current Allocation, Expenditure, and Commitment (Encumbrance) information for each Budget (Fund). Data in this table is calculated from Z601 data from Aleph.

Fact

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_FUND_ORDER_DETAIL

DO NOT USE: TABLE HAS BEEN REPLACED BY LIBRARY_FUND_ORDER_MAPPING

Fact

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_FUND_ORDER_MAPPING

Includes only fields containing Keys for linking tables together. Use to join the LIBRARY_FUND, LIBRARY_ORDER, LIBRARY_CATALOG, LIBRARY_ORDER_TYPE AND LIBRARY_ORDER_STATUS tables.

Fact

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_INVOICE_DETAIL

Includes information from the Invoice Line Items (e.g., Invoice Line Item Note, Line Item Amounts) as well as information from the General Invoice (e.g., Currency and Total Amount). Data in this table is taken from Z75, Z77, and Z601 tables in Aleph.

Fact

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_INVOICE_STATUS

Lists the codes and descriptions for the method of payment for "invoice" documents (e.g., CHK for Check, DRT for Foreign Draft VIS for Visa). Also lists the codes and descriptions for the Payment Status for "invoice" documents (e.g., N for Not Ready to be Paid, P for Paid)

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_INVOICE_SUMMARY

Includes information from the General Invoice (Invoice Header) in Aleph (e.g., Invoice Number, Invoice Date, Vendor, Total Price)

Fact

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_INVOICE_TYPE

Lists the codes and descriptions for the type of "invoice" document being processed (e.g., REG for Regular, PAR for Partial, CRE for Credit). Use this table to limit your report to a specific kind of invoice document. Data in this table is taken from the Z77 table in Aleph.

Dimension

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_ITEM_DETAIL

Includes detailed information contained in the Item Records in Aleph (e.g., Barcode, Serial Levels, Call Number, Update Date). Data in this table is taken from the Z30 table in Aleph

Fact

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_ITEM_STATUS

Includes descriptions of both the Item Status (e.g., 28 Day Loan, 1 Week Loan) and the Item Processing Status (e.g., On Order, Received, Claimed). Note that only the description of the codes are currently included (e.g., Received) and not the codes themselves (e.g., RD). Use this table to limit by statuses.

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_ORDER

Detailed information about the order records in Aleph (e.g., PO number, vendor code, pricing information, notes, etc.) Most of the data in this table is taken from the Z68 table in Aleph.

Dimension

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_ORDER_ARRIVAL_DETAIL

Includes detailed information about Monograph Arrivals (receipts) in Aleph (e.g., arrival date and number of units received). Data in this table is taken from the Z78 table in Aleph.

Fact

Libraries

MIT ONLY

Daily

25-JUL-2014

LIBRARY_ORDER_STATUS

Includes order, arrival and invoice statuses (e.g., Sent to Vendor, Closed, Library Cancelled, Partial or Complete). Note that only descriptions are includes and not the Aleph codes (e.g., SV). Use this table to limit the query by statuses.

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_ORDER_TYPE

Includes order type (e.g., Monograph or Serial), acquisition method (e.g., Purchase, Gift, etc.), and material type (used for ARL statistics reporting, e.g., Book, Computer File, Microform, etc.), and whether or not it is a Rush order. Use this table to limit the query by any of the above.

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_TRANSACTION_TYPE

Includes codes and descriptions for the types of budget transactions (Allocation, Carryover, Encumbrance, Invoice, Transfer). Use this table to limit the query by type of budget activity.

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_VENDOR

Lists codes and names of all vendors used in Aleph. All Monograph vendor codes end in -M and all Serial vendor codes end in -S. Data is taken from the Z70 table in Aleph.

Dimension

Libraries

MIT ONLY

Daily

25-JUL-2014

LOOKUP_MASTER

Master table containing all Personnel lookup data.

Dimension

Human Resources

MIT ONLY

Daily

Unavailable

LSO_ATTENDEE

People taking classes via LSO, includes people external to MIT

Dimension

SAP Financial

SENSITIVE

Daily

28-FEB-2011

LSO_BUILDING

Buildings in LSO system (SAP)

Dimension

SAP Financial

SENSITIVE

Daily

28-FEB-2011

LSO_COURSE

Courses offered through E-learning catalog

Dimension

SAP Financial

SENSITIVE

Daily

28-FEB-2011

LSO_INSTRUCTOR

List of instructors in E-learning (LSO) module

Dimension

SAP Financial

SENSITIVE

Daily

28-FEB-2011

LSO_INSTRUCTOR_SCHEDULE_DETAIL

Table for reporting on sections instructors teach

Fact

SAP Financial

SENSITIVE

Daily

28-FEB-2011

LSO_LOCATION

Session Locations as described in LSO module

Dimension

SAP Financial

SENSITIVE

Daily

28-FEB-2011

LSO_PROVIDER

MIT Org unit information (SAP HR)

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

LSO_QUALIFICATION

List of LSO qualifications

Dimension

SAP Financial

SENSITIVE

Daily

28-FEB-2011

LSO_QUALIFICATION_DETAIL

Fact table for reporting on LSO Attendee qualifications

Fact

SAP Financial

SENSITIVE

Daily

28-FEB-2011

LSO_REGISTRATION_DETAIL

Fact table for reporting on registrations in E-learning module

Fact

SAP Financial

SENSITIVE

Daily

28-FEB-2011

LSO_REGISTRATION_STATUS

List of valid course registration statuses

Dimension

SAP Financial

SENSITIVE

Daily

28-FEB-2011

LSO_SESSION_DETAIL

Fact table for reporting statistics on course sessions in E-learning module

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

LSO_SESSION_SCHEDULE_DETAIL

Fact table for reporting session schedules

Fact

SAP Financial

SENSITIVE

Daily

28-FEB-2011

LSO_SESSION_STATUS

List of LSO session statuses

Dimension

SAP Financial

SENSITIVE

Daily

28-FEB-2011

MAILING_LABELS

MIT address view of the Employee table for use by Mail Services only.

Fact

Human Resources, SAP

SENSITIVE

As Needed

08-MAR-2006

MASTER_PROJECT_HISTORY

A history of master project data. This table is used as a dimension only in those queries that involve MASTER PROJECT HISTORY DETAIL.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

MASTER_PROJECT_HISTORY_DETAIL

Balance Amounts and Project Authorized totals summarized at the master project level

Fact

SAP Financial

SENSITIVE

Monthly

10-JUL-2014

MATERIAL_GROUP

Contains codes and descriptions of material groups used in categorizing items ordered through Purchase Orders.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

MATERIAL_TECR

Material Data used in Tech Review Sales Orders

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

MEDICAL_INVOICES

Medical invoices including check numbers. This is a subset of financial detail documents, combined with payment information.

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

MITID_DB_ACTIVE

All people with an active (not obsolete) MIT ID in the MITID database

Dimension

MIT ID Database

SENSITIVE

Daily

25-JUL-2014

MITID_DB_PERSON

All people with a MIT ID in the MITID database

Dimension

MIT ID Database

SENSITIVE

Daily

25-JUL-2014

MIT_CARD_DATA

Contains MIT Card information

N/A

MIT Card Office

SENSITIVE

Daily

25-JUL-2014

MIT_CARD_PICTURE

This table contains the image file of the picture on the MIT card of students and employees. There is one record per person.

Fact

MIT Card Office

SENSITIVE

Daily

25-JUL-2014

MIT_MEDICAL_DETAIL

MIT medical benefits

N/A

SAP Financial

SENSITIVE

Daily

25-JUL-2014

MIT_MEDICAL_RECIPIENT

This table is created for use by the Medical Department. It contains basic biographic and health plan converage information for all current recipients of the MIT Health Plans (both the MITT, Traditional, and the MITF, Flexible, Health Plans).

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

MIT_STUDENT_DIRECTORY

Same as the STUDENT DIRECTORY table in that it contains student directory data, but without the student's MIT ID. This is a public table available to all Data Warehouse users.

Dimension

MIT Student Information System

PUBLIC

Daily

25-JUL-2014

MOIRA_LIST

A dimension table used in the Moira List data model. It contains the name of all the visible Moira lists.

Dimension

Moira Accounts

PUBLIC

Daily

25-JUL-2014

MOIRA_LIST_DETAIL

Fact table contains information about all the visible Moira Lists, including the last updated date, members on the list, and owner of the list.

Fact

Moira Accounts

PUBLIC

Daily

25-JUL-2014

MOIRA_LIST_OWNER

A dimension table used in the Moira List data model. It contains the owners and the type of owners (eg. USER, LIST) of all visiable Moira Lists.

Dimension

Moira Accounts

PUBLIC

Daily

25-JUL-2014

OPA_DISCLOSURE

OPA Disclosures

N/A

OSP - MIT Office of Sponsored Programs

SENSITIVE

Unavailable

Unavailable

OPA_DISCL_ACTIVITIES

OPA Disclosure Activities

N/A

OSP - MIT Office of Sponsored Programs

SENSITIVE

Unavailable

Unavailable

OPA_DISCL_COMPENSATION

XXX

N/A

OSP - MIT Office of Sponsored Programs

SENSITIVE

Unavailable

Unavailable

OPA_PERSON

OPA Person Information

N/A

OSP - MIT Office of Sponsored Programs

SENSITIVE

Unavailable

Unavailable

OSP_ACTIVITY_TYPE

Activity type for OSP Proposal

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_AWARD

Contains all project data for WBS Elements stored in COEUS.

Dimension

OSP - MIT Office of Sponsored Programs

MIT ONLY

Daily

25-JUL-2014

OSP_AWARD_COMMENT

Contains OSP Award Comments. An award can have no comments or multiple comments of various Comment Type. When joining this table with OSP Award table in Brio, use an unequal join so that awards with no comments are retrieved. You will probably want to limit by Comment Type.

Fact

OSP - MIT Office of Sponsored Programs

MIT ONLY

Daily

25-JUL-2014

OSP_AWARD_COSTSHARE

COEUS award cost sharing data

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_AWARD_IDC

Award Underrecovery Information: on- and off-campus rates, source and destination cost collectors by fiscal year.

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_AWARD_SPEC_REVIEW_DETAIL

OSP Award Special Review Details

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_AWARD_TERMS_DETAIL

Contains the different OSP award terms and conditions from COEUS. For each award, there are one or multiple award terms and conditions.

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_AWARD_TERMS_TYPE

Dimension table contains the different types of OSP award terms and conditions.

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_COSTSHARE_COMMENT

OSP Award Cost Sharing Comments

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_COST_SHARING_TYPE

OSP Cost Sharing Type

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_IDC_COMMENT

Contains Award Comments of type 'Indirect Cost Comments'. When joining this table with OSP Award table, use an unequal join if you want awards with no comments of this type to be retrieved also.

Fact

OSP - MIT Office of Sponsored Programs

MIT ONLY

Daily

25-JUL-2014

OSP_IDC_RATE_TYPE

XXX

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_INVESTIGATOR

OSP Proposal Investigator information

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_INVESTIGATOR_DETAIL

XXX

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_PROPOSAL

OSP Proposals

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_PROPOSAL_DETAIL

XXX

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_PROPOSAL_IDC_RATE_DETAIL

OSP Proposal Inderect Cost Detail: on- and off-campus rates, source and destination cost collectors by fiscal year.

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_PROPOSAL_STATUS

Status for OSP Proposals

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_PROPOSAL_TO_AWARD_MAP

XXX

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_PROPOSAL_TYPE

Type of OSP Proposal

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_PROP_COSTSHARING_DETAIL

OSP Proposal Cost Sharing

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OSP_UNIT

OSP Proposal Unit Investigator

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

OVERHEAD_RATES

EB, Lab Allocation, and Overhead rates

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

PAYMENTS

Payment data

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

PAYROLL_DEDUCTION_DETAIL

This table contains payroll deductions information, including requested deduction amount, the amount taken during the payroll run, arrears/deduction not taken amount, as well as -- for some types of deductions -- the amount paid-to-date and the remaining balance. The data starts in July 2006 and records are added to this table after every payroll.

Fact

SAP HR Payroll

SENSITIVE

As Needed

25-JUL-2014

PAYROLL_DIST_RULE_DETAIL

This table contains the appointment distribution data (no salary information) for employees and students beginning July 2006.

Fact

SAP HR Payroll

SENSITIVE

Daily

25-JUL-2014

PAYROLL_EDACCA_CERT

This table contains e-DACCA Certification information.

Dimension

SAP HR Payroll

SENSITIVE

Daily

25-JUL-2014

PAYROLL_EDACCA_CERT_DETAIL

This table contains e-DACCA Certification detail information.

Fact

SAP HR Payroll

SENSITIVE

Daily

25-JUL-2014

PAYROLL_EDACCA_CERT_SCHED

This is a time dimension table for e-DACCA Certification which contains the fiscal year data.

Dimension

SAP HR Payroll

SENSITIVE

As Needed

09-JUL-2007

PAYROLL_EDACCA_CERT_STATUS

This table contains information that describes the e-DACCA certification status.

Dimension

SAP HR Payroll

SENSITIVE

As Needed

09-JUL-2007

PAYROLL_EDACCA_DETAIL

This table contains salary distribution data for employees and students, beginning July 2006. Records are added to it after every payroll.

Fact

SAP HR Payroll

SENSITIVE

As Needed

23-JUL-2014

PAYROLL_FOR_PERIOD

Information about payroll FOR-period, including the type of payroll (monthly vs.weekly), service start and end dates, payment date, etc. "For-period" specifies the period for which the employee is paid, as opposed to the "In-period" which specifies the period in which the payroll runs. The two are usually identical, e.g., an employee paid in August 2006 for his work in August 2006, but can be different, as in case of retroactive adjustments, when an August payroll may be recalculated in September. In this case the For-period will be August, and the In-period, September.

Dimension

SAP HR Payroll

SENSITIVE

Daily

25-JUL-2014

PAYROLL_GROSS_PAY_DETAIL

XXX

Fact

SAP HR Payroll

SENSITIVE

Daily

25-JUL-2014

PAYROLL_HRLY_STU_SAL_DETAIL

This fact table contains salary/appointment information for hourly paid students.

Fact

SAP HR Payroll

SENSITIVE

Daily

25-JUL-2014

PAYROLL_IN_PERIOD

Information about payroll IN-period, including the type of payroll (monthly vs.weekly), service start and end dates, payment date, etc. "In-period" specifies the period in which a payroll runs, as opposed to the "For-period" which specifies the period for which the person is paid. The two are usually identical, e.g., an employee paid in August 2006 for his work in August 2006, but can be different, as in case of retroactive adjustments, when an August payroll may be recalculated in September. In this case the For-period will be August, and the In-period, September.

Dimension

SAP HR Payroll

SENSITIVE

Daily

25-JUL-2014

PAYROLL_PERSON

This table is used for payroll reporting. It contains all employees and students at MIT who have been paid through SAP payroll beginning July 2006.

Dimension

SAP HR Payroll

SENSITIVE

Daily

25-JUL-2014

PAYROLL_PERSON_FULL

XXX

N/A

SAP Financial

SENSITIVE

Unavailable

Unavailable

PAYROLL_ROLES_DETAIL

Authorizations for payroll data access in the Roles Database.

Fact

Roles Authorization System

SENSITIVE

Daily

25-JUL-2014

PAYROLL_ROLES_FUNCTION

All the functions for payroll authorizations in the Roles Database.

Dimension

Roles Authorization System

SENSITIVE

Daily

25-JUL-2014

PAYROLL_ROLES_QUALIFIER

All the qualifiers for payroll authorizations in the Roles Database.

Dimension

Roles Authorization System

SENSITIVE

Daily

25-JUL-2014

PAYROLL_SALARY_DETAIL

This table contains appointment/salary information for employees (exempts and non-exempts), graduate students, and hourly paid students.

Fact

SAP HR Payroll

SENSITIVE

Daily

25-JUL-2014

PAYROLL_SALARY_DIST_DETAIL

This table contains the salary and account distribution (percent and amount) information for employees and students.

Fact

SAP HR Payroll

SENSITIVE

Daily

25-JUL-2014

PAYROLL_WAGE_TYPE

Most of payroll reporting occurs by wage types and this table contains all wage types used in payroll reporting. Wage types are combined into Wage Type Categories that have been created to facilitate reporting. Some of the wage type categories are: Gross Pay, Deductions, Taxes. Each deduction, each type of tax, gross pay, and gross pay component is identified as a specific wage type.

Dimension

SAP HR Payroll

SENSITIVE

Daily

25-JUL-2014

PAYROLL_WORK_HOURS_DETAIL

This table contains the breakdown of gross pay and hours worked by type of pay, e.g, regular, premium, vacation, etc. It has records for non-exempt employees and hourly paid students beginning July 2006. Records are added to this table after every non-exempt payroll.

Fact

SAP HR Payroll

SENSITIVE

As Needed

25-JUL-2014

PENSION_ACTION_DETAIL

Pension Actions data (Action Begin and End date,SAP Status, Last Update Date,etc)

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

PENSION_ACTION_TYPE

Dimension Table for Pension Action Detail, consists information about Pension Action Types and Action Reasons (Types:Initial Pension Set-up, Pension Termination, etc, Reason: Deceased, Suspension,etc)

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

PENSION_BENEFITS_DETAIL

Pension Benefits data

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

PENSION_BENEFITS_ELIG_DETAIL

Pension Benefits Eligibility

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

PENSION_BENEFITS_RECIPIENT

SAP HR Pension Benefits Recipients

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

PENSION_MIT_MEDICAL_DETAIL

MIT Medical health plan enrollment records of Pension Annuitants

Fact

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

PENSION_MIT_MEDICAL_PERSON

This view includes pension annuitants personal data if they subscribe for MIT Medical health plans

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

PENSION_MIT_MEDICAL_RECIPIENT

Pension annuitants who subscribe to MIT Medical health plan, and their dependents

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

PENSION_PERSON

SAP HR Pension Person data

Dimension

Human Resources, SAP

SENSITIVE

Daily

25-JUL-2014

PERSONNEL_ACTION_DETAIL

The history of Personnel Actions in HR

Fact

SAP Financial

SENSITIVE

Daily

08-MAR-2005

PERSONNEL_ACTION_TYPE

Types of Personnel Actions

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

PERSON_HELP

View of the employee table for use by the IS Help system only.

Dimension

Human Resources, SAP

SENSITIVE

Daily

13-JUL-2009

POOL_UNITS_HISTORY

History of Cost Collector Pool Units by fiscal period, beginning with June 1997.

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

POOL_UNIT_VALUE_HISTORY

History of Pool Unit Values by fiscal period, beginning with June 1997.

Fact

SAP Financial

SENSITIVE

Monthly

Unavailable

POOL_YIELD_HISTORY

XXX

Dimension

SAP Financial

SENSITIVE

As Needed

15-JUN-2004

POSTING_KEY

Contains a list of all SAP posting key codes and their descriptions.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

PRE_REG_DETAIL

This table contains Student's Pre Registration information for the upcoming academic term. There is one record per subject a student pre-registers for the term. Pre-registration information about the subject includes the specific sections (Lecture, Recitation, Lab, Design), number of units (for a variable unit subject) the student pre-registers for, and also whether the student pre-registers the subject as a Listener, Pass/Fail, Doctor or Master Thesis, or at a Graduate Level or a Higher Level Graduate.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

PRE_REG_SECTION

This is a dimension table for the Pre Registration Data. It contains all the possible sections for Lecture, Lab, Recitation, and Design that a student has pre-registered for.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

PRE_REG_STUDENT_STATUS

This is a dimension table for the Pre Registration Data. There is one record for an academic term that a student has pre-registered. The record contains the status information of the pre-registration process.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

PRE_REG_SUBJECT

This is a dimension table for the Pre Registration Data. It contains all the subjects that students have pre-registered for the academic term.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

PRICING_ELEMENT

Pricing elements codes and descriptions -- used by Tech Review

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

PROFIT_CENTER

Profit Center Dimension. Master data information on Profit Centers including name and id.

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

PROFIT_CENTER_GROUP

Structure for creating reports of grouped Profit Centers taken from SAP. Multiple hierarchies are represented in the groups.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

PROFIT_CENTER_HIERARCHY

Structure for creating reports which rollup by Profit Center or Profit Center Node. Taken from SAP's Profit Center Hierarchy.

Dimension

SAP Financial

MIT ONLY

Daily

15-APR-1999

PROJECT

Contains a record for each project work breakdown structure element (WBS Element). Can be used for browsing, establishing limits on fact table queries and providing descriptive information about WBS Elements.

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

PROJECT_HISTORY

Contains the history of project data by fiscal period and fiscal year.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

PROJECT_HISTORY_FLAG

This table contains Project WBS activity summary flags which specify whether there was expense activity for the wbs during the fiscal year or not

Dimension

SAP Financial

MIT ONLY

Yearly

12-JUL-2014

PROJECT_OSP

Contains both Project information from SAP and additional information from COEUS

Dimension

OSP - MIT Office of Sponsored Programs

MIT ONLY

Daily

25-JUL-2014

PROJECT_WBS_HIERARCHY

Contains information used to represent the WBS hierarchies. Reporting can be done at the top (level 1) level (Master Project) on the entire WBS hierarchy structure, or at lower levels in the hierarchy.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

PURCHASE_ORDER_TYPE

Contains information about the type of purchase order.

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

PURCHASING_DETAIL

The Purchasing Detail table provides a detailed view of purchase order information, right down to the Account Distribution (or Account Assignment) level. Thus each record in this table represents the fraction of a PO Line Item that was assigned to a single account (or more accurately a given Cost Collector/GL Account pair). A record in this table is uniquely identified by the combination of PO Number, PO Line Number and Account Assignment Number. The only additive fields in this table are ordered qty & amount (representing qty & dollars on the PO assigned to the account), commitment qty &amount (the current open commitment qty & dollar amount for this record) and invoiced qty &amount (the qty & dollar amount for this record which has been invoiced). All other numeric amounts on the table are informational only - they should not be summed on a report.

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

PURCHASING_GROUP

Contains codes, descriptions and phone numbers for MIT's Purchasing Groups

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

PURCHASING_ORG

Contains codes and descriptions for all MIT's Purchasing Organizations

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

REQUISITION_DETAIL

Purchasing requisition information

Fact

Procurement

SENSITIVE

Daily

25-JUL-2014

REQUISITION_TYPE

Purchasing requisition type codes and descriptions

Dimension

Procurement

SENSITIVE

Daily

25-JUL-2014

REWARDS_RECOGNITION_MAP

Mapping of org units to costs objects used by the Rewards and Recognition Office

Fact

Human Resources, SAP

MIT ONLY

Daily

25-JUL-2014

RT_CUSTOM_FIELD

Contains the custom fields used in Request Tracker's tickets.

Dimension

Request Tracker

SENSITIVE

Daily

25-JUL-2014

RT_CUSTOM_FIELD_DETAIL

Contains all custom field names and the values used in Request Tracker's tickets.

Fact

Request Tracker

SENSITIVE

Daily

25-JUL-2014

RT_QUEUE

Contains information about the existing queues in Request Tracker.

Dimension

Request Tracker

SENSITIVE

Daily

25-JUL-2014

RT_TICKET

This is a dimension table with information about tickets in Request Tracker, to be used in the RT Custom Field Detail and RT Transaction Detail stars for ticket information.

Dimension

Request Tracker

SENSITIVE

Daily

25-JUL-2014

RT_TICKET_CREATOR

Contains the Kerberos Name, and if known, the MIT ID, name, department, and office address of the person who created the ticket in Request Tracker.

Dimension

Request Tracker

SENSITIVE

Daily

25-JUL-2014

RT_TICKET_DETAIL

Contains detail information about each ticket in Request Tracker.

Fact

Request Tracker

SENSITIVE

Daily

25-JUL-2014

RT_TICKET_REQUESTOR

Contains the Kerberos Name, and if known, the MIT ID, name, department, and office address of the person who submitted the request in Request Tracker.

Dimension

Request Tracker

SENSITIVE

Daily

25-JUL-2014

RT_TICKET_STATUS

Contains the status of the tickets in Request Tracker.

Dimension

Request Tracker

SENSITIVE

Daily

25-JUL-2014

RT_TRANSACTION_CREATOR

Contains the Kerberos Name, and if known, the MIT ID, name, department, and office address of the person who created the Transacton for a ticket in Request Tracker.

Dimension

Request Tracker

SENSITIVE

Daily

25-JUL-2014

RT_TRANSACTION_DETAIL

Contains Request Tracker ticket transactions data.

Fact

Request Tracker

SENSITIVE

Daily

25-JUL-2014

RT_TRANSACTION_TYPE

Contains all the type of transactions (eg. Create, Comment, Correspond, Take) added to the ticket in Request Tracker.

Dimension

Request Tracker

SENSITIVE

Daily

25-JUL-2014

SALES_CONTRACT

Sales contract data

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

SALES_ORDER_DETAIL

Sales Order information -- currently contains Tech Review data only

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

SALES_ORDER_PARTNER

Sales Order Partners information-- currently contains Tech Review data only

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

SAP_ROLES_DETAIL

SAP Financial roles and authorizations.

Fact

Roles Authorization System

SENSITIVE

Daily

25-JUL-2014

SAP_ROLES_FUNCTION

SAP Financial Functions, including "CAN SPEND OR COMMIT FUNDS", "INVOICE APPROVAL UNLIMITED", "TRAVEL DOCUMENTS APPROVAL".

Dimension

Roles Authorization System

SENSITIVE

Daily

27-JUL-2009

SETTLEMENT_RULE_CURRENT

Current Settlement Rules

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

SETTLEMENT_RULE_HISTORY

Settlement Rules History

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

SIS_COURSE_DESCRIPTION

Descriptions of Course Numbers (ie. Courses of Major Departments, Degree Programs) for both undergraduate and graduate levels with specific academic terms. (SIS=Student Information System.)

Dimension

MIT Student Information System

MIT ONLY

Weekly

25-JUL-2014

SIS_DEPARTMENT

This table contains information about academic departments and schools as recorded in MITSIS.

Dimension

MIT Student Information System

MIT ONLY

Daily

25-JUL-2014

SIS_LOOKUP

Contains descriptions of codes used in MTSIS, the Student Information System.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

SIS_MINOR_DESCRIPTION

Descriptions for student's minor programs

Dimension

MIT Student Information System

MIT ONLY

Daily

25-JUL-2014

SIS_SUBJECT_CODE

Descriptions of subject codes (or course numbers) with their associated departments, and schools. (SIS=Student Information Sytems)

Dimension

MIT Student Information System

MIT ONLY

Daily

25-JUL-2014

SIS_TERM_ADDRESS_CATEGORY

Descriptions of student term address category. Categories of term address include on-campus dormitories, living groups, and off-campus housing.

Dimension

MIT Student Information System

SENSITIVE

Daily

19-FEB-2013

SPACE_DETAIL

Physical Plant data -- rooms.

Fact

Facilites -- Physical Plant

PUBLIC

Daily

25-JUL-2014

SPACE_FLOOR

Physical Plant data -- floors

Dimension

Facilites -- Physical Plant

MIT ONLY

Daily

25-JUL-2014

SPACE_UNIT

Physical Plant data -- org units

Dimension

Facilites -- Physical Plant

MIT ONLY

Daily

25-JUL-2014

SPACE_USAGE

Physical Plant data -- space usage

Dimension

Facilites -- Physical Plant

SENSITIVE

Daily

25-JUL-2014

SPONSOR

Contains data about each sponsor.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

SPONSORED_BILLING_CUSTOMER

Customer Information which joins with the Sponsor Billing Detail. This is a subset of the Customers from SAP.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

SPONSOR_BILLING_DETAIL

Contains information about Sponsor Billing.

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

SPONSOR_HIERARCHY

Sponsor Hierarchy maintained in COEUS.

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

25-JUL-2014

SPONSOR_HIERARCHY_HISTORY

Historic data for sponsor hierarchy maintained in COEUS.

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

Unavailable

SSM_STUDENT_REVENUE

This is a dimension table which contains the different groupings of the Courses (majors) and levels (eg. graduate, undergraduate) in which the students are enrolled. This table is used in the Sloan School of Management (SSM)'s tuition/revenue sharing project.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

SSM_SUBJECT

This is a version of Subject Offered table built specifically for the Sloan School of Management.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

SSM_SUBJECT_ENROLLMENT_DETAIL

This version of the Subject Enrollment table is specifically built for the Sloan School of Management.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

SSM_UNIQID_REVENUE

This is a dimension table which contains the different groupings of the Courses (majors) and levels (eg. graduate, undergraduate) in which the students are enrolled. This table is used in the Sloan School of Management (SSM)'s tuition/revenue sharing project to get a unique/non-duplicate count of students in the different groups.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT

Contains biographic, registration, address (home, term, and office), and awarded degree data about all (current, former, and graduated) students of MIT. Access to this table is controlled by the home department of the students. If a student requests that certain data be kept confidential, the "Is_(field name)_confidential" flag (eg. is_e_mail_confidential) appearing under that field name will be set to Y; administrators with access to this data should handle it accordingly.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_ACADEMIC

This table contains student's academic information such as GPA, required & completed GIR units, swim test. There is one record per student.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_ACADEMIC_BY_TERM

This table contains the term GPA and other academic information, with one record per student per academic term.

Fact

MIT Student Information System

SENSITIVE

Daily

29-AUG-2013

STUDENT_ADDRESS

This table contains students' home, term and office addresses

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_ADVISOR

Contains students and their advisors for the current academic term. A student may have multiple courses of major and multiple advisors for each of the courses of major. The IS_PRIMARY_COURSE field indicates the primary course of major and the IS_PRIMARY_ADVISOR field indicates the primary advisor for each of the course(s) of major. There is one record per student per academic term per course of major and course level per advisor.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_ALL

Contains biograpic, registration, address (home, term, and office), and awarded degree data about all students (including both current and graduated students) of MIT. This table also contains records of applicants to MIT. Only users who are authorized to view records of all students have access to this table. Other users are given access to the STUDENT table.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_ALL_ENROLLMENT

This table contains registration status information and awarded degree data for all students, including current and graduated students There is one record per student.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_AUDIT_STRIP

Student's degree audit strip text. There are multiple records for the mulitple lines of strip text for a student. The LINE_TYPE field identifies the types of line (Beginning, Detail, Ending, etc.) and the LINE_SEQ_NUMBER field can be used to sequence/order the lines of text into a statement/paragraph.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_AUDIT_SUMMARY

Student's degree audit profile and summary data. One record per student per degree level (Undergraduate or Graduate).

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_BASIC

Basic student information with MIT ID, name; and registration information such as whether the student is eligible to register, registered, and the student year, home department and course of major for the current academic term.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_COURSE_ENROLLMENT

This table contains the student course/degree program enrollment information, including advisor(s), by academic term. There is one record for each course of major (or degree) program (ie. course department, course option, and course level) and the student's advisor(s) for each student in each academic term.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_CURRENT

Contains biographic, enrollment, and address (home, term, and office addresses) data about current students. Current students are students who are registered or eligible to register for the current academic terms. There is one record per student.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_CURRENT_ENROLLMENT

This table contains the current academic term enrollment/registration information. It is a simplified version of STUDENT_TERM_ENROLLMENT.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_DEGREE

This table contains information of MIT degrees that have been awarded to students and degrees that are expected to be received by students. There is one record for a degree a student was awarded or is expected. Each record contains information such as the type of degree (eg. SB, MS, PHD), the term and date as well as the department (Course of major) of the degree awarded/expected. The DEGREE STATUS DESC field (which contains values such as 'Degree awarded', 'Degree candidate', 'Degree applicant') differentiates between an awarded and an expected degree. For an awarded degree, there are also various indicators showing if the particular degree was the first undergraduate degree, the first MIT degree, or the highest MIT degree the student received.

Dimension

MIT Student Information System

SENSITIVE

Weekly

21-JUL-2014

STUDENT_DEGREE_AWARDED

This table contains one record for a degree a student was awarded by MIT. A record contains information such as the the type of the degree (eg. SB, MS, PHD), the term and date as well as the department from which the degree was awarded.

Dimension

MIT Student Information System

SENSITIVE

Weekly

21-JUL-2014

STUDENT_DEGREE_CANDIDATE

This table contains MIT degree candidates and applicants for the upcoming degree-award term.

Dimension

MIT Student Information System

SENSITIVE

Weekly

21-JUL-2014

STUDENT_DEGREE_PROGRAM

Student degree information including degree code, degree name, degree type, and effective academic terms.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_DEGREE_THESIS

Student Thesis

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_DIRECTORY

Contains student directory data for current students.

Dimension

MIT Student Information System

MIT ONLY

Daily

25-JUL-2014

STUDENT_DIRECTORY_FULL

Contains directory information for current students, including term address, year of degree, and department.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_ENROLLMENT_WEEK5

Student term enrollment information as of the fifth week (ADD Date) of the academic term. There is one record per student per term.

Dimension

MIT Student Information System

SENSITIVE

Academic Term

12-MAR-2014

STUDENT_ENROLLMENT_Y_REPORT

Student term enrollment information as reported in the Yearly Enrollment Report generated by the Registrar's Office.

Dimension

MIT Student Information System

SENSITIVE

Academic Term

12-MAR-2014

STUDENT_ETHNICITY

Student ethnicity summary data.

N/A

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_ETHNICITY_DETAIL

Student ethnicity information.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_ETHNIC_SUBGROUP

This table contains all the ethnic groups (White, Asian, Black or African American, Hispanic or Latino, International, etc.) and the ethnic subgroups (Hispanic or Latino, Mexico, Puerto Rico, Japan, Chinese, Korea, Vietnam, Philippines, Pakistan, India, Spain, Samoa, Guam, Europe, Carribbean, Alaska Native, etc.) as defined in the Student Information System. This table is used as a master table with STUDENT_ETHNICITY_DETAIL.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_ETHNIC_SUBGROUP_ACTIVE

The current ethnicity and ethnic subgroups self-selected by the students. Ethnicity includes: White, Asian, Black or African American, Hispanic or Latino, International, etc. Ethnic subgroups are: Hispanic or Latino, Mexico, Puerto Rico, Japan, Chinese, Korea, Vietnam, Philippines, Pakistan, India, Spain, Samoa, Guam, Europe, Carribbean, Alaska Native, etc.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_GRAD_ENROLLMENT

This table contains the enrollment information of all current as well as incoming (for the upcoming academic term) graduate students. Enrollment status (including registration, degree course, load level) for the current academic term is included as well as the entry term, entrance type, home department, email address, office address, and whether the student is eligible to register for the upcoming term. New incoming students are marked with a "Y" in the "Is New Incoming Student" field.

Dimension

MIT Student Information System

SENSITIVE

Weekly

25-JUL-2014

STUDENT_GRAD_GEN_EXAM_DETAIL

This table contains graduate students' general exam credit dates.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_MINOR_DETAIL

This fact table contains all the proposed and completed minors of the students. It also includes the minor start term and expected graduation term.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_MINOR_FIELD

A dimension table used together with fact table STUDENT_MINOR_DETAIL. It contains the characteristics of a minor field, including the minor field (eg. Music, Compartive Media Studies, Architecture, Biomedical Engineering, Chinese, Economics), minor type (Proposed, Completed), minor sequence (Minor 1 or Minor 2), the department offers the minor (eg. HASS, Sloan, Physics, etc.)

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_TERM_ENROLLMENT

Contains data about the student's registration status, by academic term. There is one enrollment record for a student per academic term.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

STUDENT_TUITION_ASSESSMENT

This table contains the tuition assessment for students by academic term.

Dimension

MIT Student Information System

SENSITIVE

Weekly

19-JUL-2014

SUBJECT_ATTRIBUTE

Descriptions of attributes of subject in degree audit.

Dimension

MIT Student Information System

MIT ONLY

Daily

25-JUL-2014

SUBJECT_AUDIT_DETAIL

Degree audit data.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

SUBJECT_ENROLLABLE

Enrollable subjects by academic terms. No section information, and not including non-MIT subjects. This table contains a small number of fields, and it does not include descriptive fields. For a more complete listing, see the SUBJECT_OFFERED_SUMMARY or the SUBJECT_OFFERED tables. The ULT_MASTER_SUBJECT_ID in this table maybe helpful in tracking clusters of subjects that contain both "Joint" and "Meet with" subjects.

Dimension

MIT Student Information System

MIT ONLY

Daily

25-JUL-2014

SUBJECT_ENROLLMENT_DETAIL

Contains subject registration/enrollment information, ie. The "Class List". In this table, there is one record for a section of a subject which a student has registered for the academic term. For subjects that do not "section" the enrollment of student, the enrollment records are marked with a section ID of '000'.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

SUBJECT_ENROLLMENT_EHS

Subject enrollment data with specific subjects/classes, tailored for the EH&S Office.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

SUBJECT_ENROLLMENT_SUMMARY

Subject enrollment data at subject level. There is one record per academic term, per student, per subject regardless of the sections the student is enrolled in.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

SUBJECT_ENROLL_GRADED_DETAIL

Subject enrollment records (or class lists) with grades.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

SUBJECT_IAP_SCHEDULE

Schedule (meet time and meet place) data for IAP for-credit subjects (courses). There is one record per subject per session (time period) as it is offered during IAP.

N/A

MIT Student Information System

MIT ONLY

Daily

19-DEC-2013

SUBJECT_OFFERED

Contains all enrollable offered subjects in each academic term, since Fall Term of 1994-1995 (1995FA), as maintained on MITSIS. Data items include master subject number, subject number, section ID, and subject title. There is one record for each section (eg. Lecture, Recitation, Lab) of a subject in an academic term. Each of the subjects in this table has a record with section ID '000' that serves as the default record for the subject regardless of whether there is section information in the table for the subject.

Dimension

MIT Student Information System

MIT ONLY

Daily

25-JUL-2014

SUBJECT_OFFERED_EHS

The version of subject_offered table tailored for the EH&S Office. It contains all subjects offered by the School of Engineering, the School of Science, and Whitaker College in the most recent 3 years.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

SUBJECT_OFFERED_SUMMARY

Contains all enrollable offered subjects in each academic term, since Fall Term of 1994-95 (1995FA), as maintained on MITSIS. Data items include master subject number, subject number, subject title, offer department, and number of units. There is one record for a subject in an academic term. The table does not contain any section information.

Dimension

MIT Student Information System

MIT ONLY

Daily

25-JUL-2014

SUBJECT_REG_STATUS

Subject registration status codes and descriptions

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

SUMMARY_STATEMENT_DETAIL

Summary Statement reporting table which contains data from July 1999 through the current fiscal period. It is similar to Balances by Fiscal Period, except that it contains calculated overhead for those fiscal period(s) where costing sheets have not been run yet. Field RECORD_TYPE contains values "Posted" or "Calculated" and should be used in reports to clarify what the entries are.

Fact

SAP Financial

SENSITIVE

Daily

05-MAR-2009

SURCHARGE_PERCENTAGES

Contains Overhead, EB, and Lab Allocation rates as they would have been calculated by the SAP costing sheets yesterday.

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

SURCHARGE_POSTINGS

Surcharge postings

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

TABLES

Contains a list and description of all tables in the warehouse that are available to users.

Dimension


PUBLIC

As Needed

Unavailable

TEACHING_FACULTY

This table contains a record for an instructor per academic term in which the instructor was teaching a class/subject and/or a graduate thesis supervisor. Users will need to have the authorizations to view both subject enrollment and teaching data in order to access data in this table.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

TELEPHONE_BILLING_NUMBERS

Contains information about telephone numbers at MIT, including default cost collectors, profit center assignments, and listed directory names. The Telephone_Billing_Number is the source telephone charges are billed to.

Dimension

Telecommunications

MIT ONLY

Monthly

26-JUN-2014

TELEPHONE_CHARGE_TYPE

Contains information about the types of telephone charges broken down into categories and subcategories. Categories include Itemized, Local summary and Phone charges. subcategories include Basic Service Charges; Voice Mail Charges; Telephone Equipment Charges; Voice Mail Equipment Charges; Calling Card Calls; Itemized Calls, Customer Assigned; Itemized Calls, Not Customer Assigned; and Local Summary Charges.

Dimension

Telecommunications

MIT ONLY

As Needed

15-JUN-1999

TELEPHONE_DETAIL

Contains information about telephone charges. Detailed information about charge amounts resides in this table. Data about call length, total calls, total minutes, date of call, and time of call is also available.

Fact

Telecommunications

SENSITIVE

Monthly

26-JUN-2014

THESIS_SUPERVISOR_DETAIL

This table contains records for graduate thesis supervisor by academic term, ie. Information about the supervisor, the student, and the THG subject.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

TIME_DAY

Daily calendar information. For use in joining tables to include a time dimension to the report.

Dimension


PUBLIC

As Needed

14-JUN-2003

TIME_MONTH

Monthly calendar information. For use in joining tables to include a time dimension to the report. Use the Time_Month_Key to join.

Dimension


PUBLIC

As Needed

14-JUN-2003

TIP_DETAIL

Information about the course materials fed into the Data Warehouse from COOP. Based on the on-line form submitted by the faculty members.

Fact


SENSITIVE

Weekly

27-DEC-2012

TIP_MATERIAL

Inforamtion about Course Material (Author,Title,ISBN, Publisher, etc.)

Dimension


SENSITIVE

Weekly

27-DEC-2012

TIP_MATERIAL_STATUS

Course Material status (Ex. Required,Recommended, No Material, etc.)

Dimension


SENSITIVE

Unavailable

Unavailable

TIP_SUBJECT_OFFERED

Subjects Offered offered for a particular academic Term

Dimension


SENSITIVE

Daily

25-JUL-2014

TOP_LEVEL_DOMAIN

List of internet top-level domains and descriptions. For use with web statistics reporting. Top level domains are the codes which come at the end of a URL and can describe the type of organization or refer to a country. Example - 'COM' (Company) or 'CA' (Canada).

Dimension


PUBLIC

As Needed

17-JUN-1999

TQF_DEPARTMENT_ACCESS

TQF Table

Dimension

Human Resources

MIT ONLY

Daily

Unavailable

UNIT

Contains departmental data from the personnel system.

Dimension

Human Resources

MIT ONLY

Daily

08-MAR-2006

UROP_DEPARTMENT

A dimension table used in the UROP Project Star. It contains the codes and descriptions of the UROP project departments (the departments that coordinate the projects and the participants) and also the academic departments to which URN credit applied.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

UROP_FUNDING_TYPE

A dimension table used in the UROP Project Star. It contains all the possible values for Funding Type (Credit, Direct Funded, Sponsored Research, Volunteer), Special Fund, and Fund Change.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

UROP_INSTRUCTOR

This is a dimension table used in the UROP Project Star. It contains the MIT ID, full name, gender, title, and home department of all faculty supervisors, instructors, mentors, and intellectual guidances who have participated in an UROP Project. There is one record per person per UROP term in this table.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

UROP_PROJECT_DETAIL

The fact table which contains one record per UROP (Undergraduate Research Opportunities Program) project. Projects included are applications in UROP Office review, and projects at Approved, Cancelled, Returned/Rejected status. Expired, draft, faculty review, and department review applications/projects are not included.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

UROP_STATUS

A dimension table used in the UROP Project Star. It contains the status of a UROP project, as well as other status fields and flags pertaining to the project (eg. Is Continuing, Is URN Credit Granted, etc.).

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

UROP_STUDENT

This is a dimension table used in the UROP Project Star. It contains the MIT ID, full name, gender, and enrollment information (year, course of major, home department) of students who have participated in an UROP project. There is one record per student per UROP term. Enrollment information is term based. Enrollment information for special UROP terms, "FJ" and "JS", are retrieved from the academic terms "FA" and "SP" respectively.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

UROP_TERM

A dimension table used in the UROP Project Star. It contains the UROP term codes and descriptions, as well as the academic year.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

VENDOR

Contains data about vendors: vendor name, address, vendor number in SAP, telephone and fax numbers, and other contact information.

Dimension

SAP Financial

MIT ONLY

Daily

25-JUL-2014

VENDOR_CLASSIFICATION

Vendor classification data

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

VENDOR_DNB

Vendor Dun and Bradstreet data

Dimension

SAP Financial

SENSITIVE

Daily

25-JUL-2014

VENDOR_FULL

XXX

Fact

SAP Financial

SENSITIVE

Daily

25-JUL-2014

WEB_HITS_DETAIL

Detailed 'web hits' information. Provided for the MIT community to report on hits on their web pages. Information includes the URL accessed, the date of the access and various information about the accessor (for example the browser and operating system used to access the URL). The counter represents the number of hits on the web page on a given day from users with the same OS, browser, domain code etc.

Fact

counter.mit.edu

MIT ONLY

Weekly

21-JUL-2014

WEB_HITS_LOCKER

Master list of all AFS (Athena) lockers in which web pages are stored and which have web hits information in the warehouse. Used in the Web Hits reports to select locker name(s) for reporting. For example, if your web pages are at the adress "http://web.mit.edu/chemistry/" then the locker name you need to choose will be "chemistry". This is a dimension table and is designed to be joined to the WEB_HITS_DETAIL table via the LOCKER_KEY field.

Dimension

counter.mit.edu

PUBLIC

Weekly

21-JUL-2014

WTW_ACADEMIC_TERM

Academic term information for the Who-is-Teaching-What data.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

WTW_INSTRUCTOR

This table includes all instructors in the Who-is-Teaching-What data.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

WTW_INSTRUCTOR_ROLE

This is a dimension table used in the Who-is-Teaching-What data model. It contains all the teaching roles (eg. Lecturer, Recitation Instructor, Teaching Assistant, Writing Instructor, etc.)

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

WTW_OLD_INSTRUCTOR

This table contains all instructors in the OLD Who-is-Teaching-What data model.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

WTW_OLD_INSTRUCTOR_ROLE

This is a dimension table used in the OLD Who-is-Teaching-What data model. The table contains all the instructor roles -- example: Lecturer, Administration, Recitation Instructor, Lab Instructor, etc.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

WTW_OLD_SUBJECT_SECTION

This is a dimension table used in the OLD Who-is-Teaching-What data model. The table contains information about the subjects and sections for the teaching data. There is one record per academic term per subject per section in this table.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

WTW_OLD_TEACHING_DETAIL

This table contains the detail of the OLD Who-is-Teaching-What data, from Fall 1999 ("2000FA") through Spring 2009 ("2009SP"). Used the "KEY" field in this table to join to the same-name tables (ie. Joining from this table to the WTW_OLD_SUBJECT_SECTION table using the WTW_OLD_SUBJECT_SECTION_KEY field, and joining from this table to the WTW_OLD_INSTRUCTOR table using the WTW_OLD_INSTRUCTOR_KEY field, and joining from this table to the WTW_OLD_INSTRUCTOR_ROLE table using the WTW_OLD_INSTRUCTOR_ROLE_KEY, and joining from this table to the WTW_ACADEMIC_TERM table using the WTW_ACADEMIC_TERM_KEY) to get the instructor roles of each of the instructors in the different terms, subjects and sections.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

WTW_SUBJECT_GROUPING

This is a dimension table used in the Who-is-Teaching-What data model. Data in this table are used to identify the cluster subjects for specific academic term by department and school.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

WTW_SUBJECT_SECTION

This is a dimension table used in the Who-is-Teaching-What data model. The table contains information about the subjects and sections for the teaching data. There is one record per academic term per subject per section in this table.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

WTW_SUBJECT_SUMMARY

This is a dimension table used in the Who-is-Teaching-What data model. The table contains information about the subjects for the teaching data. Unlike WTW_SUBJECT_SECTION, this table DOES NOT contain section information of the subjects. There is one subject per term in this table.

Dimension

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014

WTW_TEACHING_DETAIL

This table contains the detail of the Who-is-Teaching-What data since Fall Term 2009 (ie. 2010FA). Used the "KEY" field in this table to join to the same-name table (eg. Joining from this table to the WTW_SUBJECT_SECTION table using the WTW_SUBJECT_SECTION_KEY field, and joining from this table to the WTW_INSTRUCTOR table using the WTW_INSTRUCTOR_KEY field, and joining from this table to the WTW_INSTRUCTOR_ROLE table using the WTW_INSTRUCTOR_ROLE_KEY, and joining from this table to the WTW_ACADEMIC_TERM table using the WTW_ACADEMIC_TERM_KEY) to get the teaching roles of each of the instructors in the different terms, subjects and sections.

Fact

MIT Student Information System

SENSITIVE

Daily

25-JUL-2014