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 |
|---|---|---|---|---|---|---|
Stores Affirmative Action Plan (AAP) metrics and targets by plan year, unit, job group, and plan type, including utilization, incumbents, hires, promotions, transfers, terms, retention, availability, and related narrative/AI text fields. |
N/A |
Yocom and McKee Affirmative Action |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores calendar attributes and plan-year date ranges used to map AAP plan years to calendar periods and month keys, including indicators for current/previous fiscal periods and fiscal year. |
N/A |
Yocom and McKee Affirmative Action |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores normalized metadata for scholarly articles and conference publications associated with Academic Analytics (AA). Each row represents a unique article and includes bibliographic details, journal information, author attribution, institutional identifiers, and matching metadata. |
N/A |
Academic Analytics |
MIT ONLY |
As Needed |
26-FEB-2026 |
|
Stores award and honor information associated with Academic Analytics (AA), including awarding organization details, award names, recipient details, and the year the award was received. Each row represents a single award received record. |
N/A |
Academic Analytics |
MIT ONLY |
As Needed |
26-FEB-2026 |
|
Stores metadata for books associated with Academic Analytics (AA). Each row represents a unique book record and includes bibliographic details, author attribution, institutional identifiers, and warehouse load metadata. |
N/A |
Academic Analytics |
MIT ONLY |
As Needed |
26-FEB-2026 |
|
Stores grant and funding records associated with Academic Analytics (AA), including agency identifiers, grant identifiers, project details, date ranges, dollar amounts, research indicator, and associated faculty identifiers. Each row represents a single grant record. |
N/A |
Academic Analytics |
MIT ONLY |
As Needed |
26-FEB-2026 |
|
Stores crosswalk mappings between Academic Analytics client identifiers and MIT person identifiers, including source system and name attributes. Each row represents an identifier mapping record. |
N/A |
Academic Analytics |
MIT ONLY |
Unavailable |
Unavailable |
|
Stores journal reference data for Academic Analytics (AA), including journal titles and ISSN identifiers. Each row represents a unique journal. |
N/A |
Academic Analytics |
MIT ONLY |
As Needed |
30-SEP-2014 |
|
Stores academic term reference data and key academic calendar dates (term start/end, registration, add/drop, and related milestones). Each row represents a single academic term. |
N/A |
MIT Student Information System |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores academic chair reference information, including chair type, origin, effective dates, associated cost collectors, and donor-specified attributes. Each row represents an academic chair. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores category reference data for academic chairs. Each row represents a chair category. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores associations between academic chairs and cost collectors. Each row represents a chair?cost collector mapping. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores appointment-level details for academic chairs, including chair holder, appointment dates, vacancy indicators, titles, and associated cost collectors. Each row represents a chair appointment. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Stores reference information for academic chair holders, including organizational and school affiliations. Each row represents a person who has held an academic chair. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
Unavailable |
|
Graduate admissions applicants. |
Dimension |
Graduate Admissions |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
This table contains all the decision status (e.g. 'Admitted','Not Admitted','Wait Listed') of the graduate admissions application. |
Dimension |
Graduate Admissions |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
Initial and final degree objectives of the graduate admissions application. |
Dimension |
Graduate Admissions |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Graduate schools where MIT graduate applicants choose to enroll at the end of the admission cycle |
Dimension |
Graduate Admissions |
SENSITIVE |
As Needed |
27-FEB-2026 |
|
Application fee status of the graduate admissions application. |
Dimension |
Graduate Admissions |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
XXX |
N/A |
Graduate Admissions |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
XXX |
N/A |
Graduate Admissions |
SENSITIVE |
Weekly |
27-MAR-2023 |
|
The geographical region of the applicant's home address. |
Dimension |
Graduate Admissions |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
This table contains information about graduate admissions programs, including joint programs and research areas. |
Dimension |
Graduate Admissions |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
The geographical region of the applicant's reply address. |
Dimension |
Graduate Admissions |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Information about the various standardized graduate admissions tests such as: GRE, and TOEFL. |
Dimension |
Graduate Admissions |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Information about time (month and year) when the graduate admissions tests were taken. |
Dimension |
Graduate Admissions |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Graduate Admissions |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Airgas |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Airgas |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Airgas |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Airgas |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
26-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
Alumni Office |
SENSITIVE |
Unavailable |
26-FEB-2026 |
|
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 |
26-FEB-2026 |
|
Biographic information of MIT Alumni - there is one record per person. |
Dimension |
Alumni Office |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
This table contains degree information of MIT Alumni. |
Fact |
Alumni Office |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
This table contains information about the different degree types available in the ALUM DEGREE DETAIL table. |
Dimension |
Alumni Office |
SENSITIVE |
Weekly |
26-FEB-2026 |
|
This table contains information about MIT academic departments as used in the Alumni's system. |
Dimension |
Alumni Office |
SENSITIVE |
Weekly |
26-FEB-2026 |
|
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 |
26-FEB-2026 |
|
This table contains MIT alumni's employment records |
Fact |
Alumni Office |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
XXX |
Dimension |
Alumni Office |
SENSITIVE |
Weekly |
26-FEB-2026 |
|
This table contains information about the courses of major as used in the Alumni's system. |
Dimension |
Alumni Office |
SENSITIVE |
Weekly |
26-FEB-2026 |
|
This table contains the Occupation Codes and Descriptions for the Alumni data. |
Dimension |
Alumni Office |
SENSITIVE |
Weekly |
05-FEB-2021 |
|
This table contains the Standard Industrial Codes and Decriptions for the Alumni data |
Dimension |
Alumni Office |
SENSITIVE |
Weekly |
05-FEB-2021 |
|
XXX |
Fact |
Alumni Office |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
XXX |
Fact |
Alumni Office |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
*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 |
Daily |
08-MAR-2006 |
|
*Old Personnel Data in CYBORG* - Limited view of HR appointment data |
Fact |
Human Resources |
SENSITIVE |
As Needed |
08-MAR-2006 |
|
This is the old HR system (Cyborg)'s appointment records. Pre-2003 |
Fact |
Human Resources |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
*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 |
Daily |
08-MAR-2006 |
|
*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 |
Daily |
08-MAR-2006 |
|
New HR (SAP) Employee Data |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Fact table for VPF ARRA reporting |
Fact |
SAP Financial |
SENSITIVE |
Monthly |
22-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
HR Diviersity - PeopleFluent ATS system |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
HR Diviersity - PeopleFluent ATS system |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
HR Diviersity - PeopleFluent ATS system |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
HR Diviersity - PeopleFluent ATS system |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
HR Diviersity - PeopleFluent ATS system |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Stores summarized financial balances and budget measures by cost collector, general ledger account, and fiscal period (month). Each row represents balances for a specific COST_COLLECTOR_KEY, GL_ACCOUNT_KEY, and TIME_MONTH_KEY combination. |
N/A |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Sub set of cost collectors which represent balance sheet accounts. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
All balance sheet accounts: Cost Collectors and pure GL Accounts |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
26-FEB-2026 |
|
Balance sheet account for campus (CUR) |
N/A |
SAP Financial |
SENSITIVE |
Daily |
26-FEB-2026 |
|
Contains balances data for all balance sheet accounts: cost collectors and pure GL accounts -- organized by fiscal year |
Fact |
SAP Financial |
SENSITIVE |
Daily |
26-FEB-2026 |
|
Contains balances data for all balance sheet accounts: Cost Collectors and pure GL Accounts -- organized by Fiscal Period. |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
This table contains benefits adjustment reason codes and descriptions. |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
This table contains a history of changes to employees' benefits, complete with reasons for these changes |
Fact |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Data about retirees and benefits subscribers who page a percentage of their full medical cost |
Fact |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
A dimension table holding fields specificying benefits cost sharing conditions, as well as billing specifics |
N/A |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Benefits Enrollments: history of health, insurance and FSA enrollments of employees and their dependents |
Fact |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Current benefits eligibility for employees |
Fact |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
The history of employees' benefits eligibility |
Fact |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
MIT employee data including benefits-related fields which are excluded from other employee views |
Dimension |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Benefits Plans: health, insurance and flexible benefits accounts. |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
This table contains information about employee, employer, and provider costs for various plans, depending on coverage levels |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Billing plan data |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
MIT Card Office |
SENSITIVE |
Unavailable |
Unavailable |
|
Institute and Departmental Budgets |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
Dimension |
Budget, Finance and Treasury |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
Dimension |
Budget, Finance and Treasury |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
Dimension |
Budget, Finance and Treasury |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Human Resources |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Budget groupings |
Fact |
Budget, Finance and Treasury |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Budget, Finance and Treasury |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
Dimension |
Budget, Finance and Treasury |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
Dimension |
Budget, Finance and Treasury |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
Fact |
Budget, Finance and Treasury |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Physical Plant data -- buildings |
Dimension |
Facilities -- Physical Plant |
MIT ONLY |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
Capital Database data from NIMBUS |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Capital Database data from NIMBUS |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Capital Database data from NIMBUS |
SENSITIVE |
Unavailable |
Unavailable |
|
Building workorder detail |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
FRC APPLICATION |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
|
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 |
|
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 |
27-FEB-2026 |
|
More detailed descriptions of HASS Attributes in CIS Course Catalog |
Dimension |
MIT Student Information System |
PUBLIC |
Weekly |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
03-JAN-2021 |
|
Costing sheet data |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Contains the history of Cost Center Data for each fiscal period and fiscal year. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores cost collector master data, including identifiers, names, organizational and profit center rollups, funding attributes, effective/expiration dates, budget/authorization amounts, and administrative flags for financial reporting and processing. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
04-JAN-2021 |
|
Contains the history of Cost Collector Data by fiscal period and fiscal year. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Data Warehouse |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Data Warehouse |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Contains information about default account assignment rules for credit cards. |
Dimension |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Stores credit card transaction detail records, including financial amounts, posting information, merchant details, card holder identifiers, and accounting attributes for financial reporting and analysis. |
N/A |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Contains information about credit cards and their users. |
Dimension |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Contains information about credit card verifiers. |
Dimension |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Customer data |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
All campus customers (company code 'CUR') |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
TechReview customers |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Cybersource MIT storefront transactions |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
02-FEB-2023 |
|
XXX |
N/A |
Department of Athletics, Physical Education and Recreation |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Departmental Employee Telephone Directory for DLC Adminitrators |
Dimension |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Stores reference data defining document types used across systems. Each row represents a unique document type identifier and its associated description. |
N/A |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Dunning Areas used at the Institute. Can be joined to FINANCIAL_DETAIL using the field DUNNING_AREA_KEY. |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Degrees awarded information, specific to EECS students. For use by EECS users only. |
Fact |
MIT Student Information System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Freshmen for the academic year. For use by EECS users only. |
Fact |
MIT Student Information System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
Subject enrollment data specific to EECS students. For use by EECS users only. |
Fact |
MIT Student Information System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Daily |
Unavailable |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
EHS Training certification data |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Daily |
27-APR-2012 |
|
EHS Training certification status |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
17-OCT-2016 |
|
EHS Training certification trigger |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
17-OCT-2016 |
|
EHS Training detail |
Fact |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
12-OCT-2016 |
|
EHS Training DLC data |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
17-OCT-2016 |
|
EHS Training PI data |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
12-OCT-2016 |
|
EHS Trainee information |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
12-OCT-2016 |
|
EHS Training Unit data |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
17-OCT-2016 |
|
EHS Training Unit status |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
17-OCT-2016 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
Unavailable |
|
EHS Contact Person information |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-APR-2012 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
Unavailable |
|
Information about people Functions within an EHS system |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-APR-2012 |
|
EHS information about hazards |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-APR-2012 |
|
Ehs ROLE person information |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-APR-2012 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Daily |
27-APR-2012 |
|
EHS Roles detail |
Fact |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Daily |
27-FEB-2026 |
|
EHS Roles function |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Daily |
27-FEB-2026 |
|
EHS Roles qualifier |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Daily |
27-FEB-2026 |
|
EHS Room information |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-APR-2012 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
List of EHS ROOMS (LABS) |
Dimension |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-APR-2012 |
|
EHS room_set->contact_person->room detail information |
Fact |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-APR-2012 |
|
EHS room_set ->room->hazard->function->role-person detail information |
Fact |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
27-APR-2012 |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Environment, Health, and Safety Office (EHS) |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
*Old Personnel Data in CYBORG * - Contains personal information about all employees. |
Dimension |
Human Resources |
SENSITIVE |
Unavailable |
08-MAR-2006 |
|
*Old Personnel Data in CYBORG * - Directory data plus service, tenure and chair data |
Dimension |
Human Resources |
SENSITIVE |
Unavailable |
08-MAR-2006 |
|
*Old Personnel Data in CYBORG * - Directory data plus service, tenure, chair data and ethnicity |
Dimension |
Human Resources |
SENSITIVE |
Unavailable |
08-MAR-2006 |
|
Contains directory information about current employees only. |
Dimension |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
A more basic version of DEPARTMENT_EMPLOYEE_DIRECTORY |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
*Old Personnel Data in CYBORG * - Contains employee data without home address information for all employees. |
Dimension |
Human Resources |
SENSITIVE |
Unavailable |
08-MAR-2006 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
08-MAR-2006 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Enrollment Manager Extracts |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Stores employee award and honor records, including award names, effective dates, and source information, used for recognition reporting and academic/professional achievement analytics. |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Facilities workorder detail |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Alumni Office |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Faculty directory |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Facilities Building Info |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
Facilities Building/Address Info |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
Facilities Floor Info |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
Facilities Major Use Info |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
Facilities Organization Info |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Unavailable |
Unavailable |
|
Facilities Room Information |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Financial Aid |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
13-JAN-2015 |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Unavailable |
26-FEB-2026 |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
15-JAN-2014 |
|
Contains a list of fields and their descriptions, as well as the tables where the fields appear. |
Dimension |
PUBLIC |
Daily |
Unavailable |
||
(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 |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
Daily |
27-FEB-2026 |
|
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 |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Contains information about financial aid terms |
Dimension |
MIT Student Information System |
MIT ONLY |
Academic Term |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
15-OCT-2002 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Contains information about financial aid years |
Dimension |
MIT Student Information System |
MIT ONLY |
Academic Term |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Stores detailed financial transaction line items from the general ledger, including amounts, dates, document attributes, cost collector and account assignments, vendor/customer references, and payment and purchasing details for financial reporting and analysis. |
N/A |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
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 |
26-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
26-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
23-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
eFPR (Faculty Professional Record) |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
FRC APPLICATION |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
FRC APPLICATION |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
FRC APPLICATION |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
FRC APPLICATION |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
FRC APPLICATION |
SENSITIVE |
Unavailable |
01-MAR-2015 |
|
XXX |
N/A |
FRC APPLICATION |
SENSITIVE |
Unavailable |
30-JAN-2026 |
|
XXX |
N/A |
FRC APPLICATION |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
FRC APPLICATION |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
FRC APPLICATION |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Contains data about sources of revenue (funds & fund centers). |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
26-FEB-2026 |
|
Departmental funds reporting data |
Fact |
SAP Financial |
SENSITIVE |
Monthly |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Fund Center Hierarchy |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Subset of cost collectors defined as Sponsored and Non-Sponsored Funds. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Fund cost collector history |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Fund description |
Dimension |
Development Research and Systems |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Fund description history |
Fact |
Development Research and Systems |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Stores general ledger account master data, including account identifiers, names, classifications, account type attributes, cost element details, and financial reporting flags used for financial processing and reporting. |
N/A |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores mappings of general ledger accounts to company-specific attributes, including posting restrictions and financial statement group classifications used for financial reporting. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Stores mappings of general ledger accounts to hierarchical reporting categories by report type, including multi-level rollups, sort orders, and account attributes for financial reporting. |
N/A |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
TechReview GL accounts |
Dimension |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
|
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 |
27-FEB-2026 |
|
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 |
Unavailable |
Unavailable |
|
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 |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Stores mappings between AAP organizational units and HR organizational units by AAP plan year, including titles, department abbreviations, and change tracking. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores AAP organizational unit reference data by plan year, including unit names and change tracking. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores employee absence balance measures by balance type and balance period, including beginning, deducted, and ending balances in hours and days, and related eligibility and change tracking. |
N/A |
Human Resources, SAP |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores absence balance type reference data, including type codes, names, and indicators for whether a type maintains a balance. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores employee absence event details by date, including start/end times, actual hours/days, deducted hours/days, and change tracking. Each row represents an absence entry. |
N/A |
Human Resources, SAP |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores absence type reference data, including type codes, names, associated balance types, and employee group applicability. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores employee appointment records (all appointments) including appointment dates, position/job/org attributes, pay basis, and reported/original/temporary compensation and effort measures. Each row represents an appointment record for a person and position over a date range. Almost identical to HR_APPOINTMENT_DETAIL, which also has FTE_REPORT_BASE_AMOUNT, FTE_ORIGINAL_BASE_AMOUNT, FTE_TEMP_CHANGE_BASE_AMOUNT BUT this view includes graduate student appointments. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores basic employee appointment details by person, position, appointment type, and date range. Each row represents a basic appointment record. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores detailed employee appointment records including tenure in position, work begin/end dates, pay basis, reported/original/temporary compensation and effort measures, and schedule attributes. Each row represents an appointment record for a person and position over a date range. |
N/A |
Human Resources, SAP |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
DEPRECATED - USE HR_APPOINTMENT_DETAIL!! Stores a limited set of employee appointment attributes focused on dates, pay basis, effort/employment percentages, schedule attributes, and temporary change indicators. Each row represents an appointment record for a person and position over a date range. |
N/A |
Human Resources, SAP |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores employee appointment details including reported/original/temporary compensation measures, work schedule attributes, premiums, and MAP indicators. Each row represents an appointment record for a person and position over a date range. |
N/A |
Human Resources, SAP |
RESTRICTED-PII |
Unavailable |
27-FEB-2026 |
|
Stores HR Actions with a valid, non-N/A, PERSONNEL_ACTION_TYPE_KEY. Some leave-of-abscences are not assocaited with a PERSONNEL_ACTION_TYPE_KEY in PA0000, PA9003, PA9010 and so we default those items to N/A and exclude them from this view. To see all records, regardless of the PERSONNEL_ACTION_TYPE_KEY, look at HR_APPT_ACTION_DETAIL_ALL. |
N/A |
Human Resources, SAP |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
StoresHR Actions with a any PERSONNEL_ACTION_TYPE_KEY. Some leave-of-absences are not associated with a PERSONNEL_ACTION_TYPE_KEY in PA0000, PA9003, PA9010 and so we default those items to N/A, but include them in this view. To see a view of non-N/A records, look at HR_APPT_ACTION_DETAIL, which is the standard view the majority of HR Reporting will use. _ALL was created to address a PFML need in specific HR reports without disrupting existing reports that assume N/A records are excluded. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores appointment-related personnel action records identified as missing or requiring reconciliation, including action begin/end date ranges, sequencing, and associated compensation/effort measures. Each row represents a personnel action segment flagged for data quality or completeness review. |
N/A |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores appointment letter details associated with personnel actions, including sponsor/letter codes, appointment amounts, vacation terms, and other letter attributes. Each row represents an appointment letter record for a person and position over a date range. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
DEPRECATED - use HR_APPT_TX_DETAIL!! Stores a limited set of appointment transaction attributes focused on transaction dates, pay basis, effort/employment measures, schedule attributes, and ETL counters. Each row represents an appointment transaction segment for a person and position. |
N/A |
Human Resources, SAP |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores appointment transaction records for SU detail, including compensation measures, premiums, schedule attributes, and MAP indicator for transaction segments. Each row represents an appointment transaction segment for a person and position. |
N/A |
Human Resources, SAP |
RESTRICTED-PII |
Unavailable |
27-FEB-2026 |
|
Stores appointment type and subtype reference data used by HR appointment and personnel action tables, including indicators for current, future, paid, exempt, and supplemental appointments. Each row represents a distinct appointment type definition. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Stores eligibility rules for the Childcare Scholarship Program (CSP) - Eligibility Chart / Non Tenured PSAs Eligible by personnel subarea and effective date range, indicating eligibility for capped, uncapped, and MIT-specific benefits. Each row represents an eligibility rule over a defined date range. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores MIT tuition amounts for the academic year, used by the Childcare Scholarship Program (CSP), including academic year descriptors and effective date ranges. Each row represents a tuition rate applicable to a specific academic year and date range. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores detailed Childcare Scholarship Program (CSP) benefit records for employees, including eligibility indicators, application and approval workflow data, dependent student details, benefit amounts, academic year context, and award/payment status. Each row represents a CSP benefit record for an employee and associated dependent student. |
N/A |
SAP Financial |
RESTRICTED-PII |
Unavailable |
27-FEB-2026 |
|
Stores configuration settings for the HR Childcare Scholarship Program (CSP), including setting codes, descriptions, and values used by CSP processing and reporting. Each row represents a single CSP configuration setting. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores current payroll distribution (costing) allocations for HR acess, for personnel positions and appointment subtypes, including cost collector, suspense cost collector, GL account, org unit, distribution percent, and effective date range. Each row represents an active distribution line for a personnel/position. |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Reference table defining academic degree values used within HR systems. Each row represents a distinct degree code and description. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Reference table defining degree type classifications used by HR, such as degree level or category. Each row represents a distinct degree type. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores employee demographic, diversity, and employment attributes used for affirmative action, diversity, equity, and compliance reporting. Each row represents a snapshot of demographic and employment characteristics for an individual within an AAP plan year and organizational unit. |
N/A |
SAP Financial |
RESTRICTED-PII |
Unavailable |
27-FEB-2026 |
|
Stores hiring and personnel action records used for affirmative action, diversity, equity, and compliance reporting. Each row represents a hire or hire-related personnel action within an AAP plan year and organizational context. |
N/A |
SAP Financial |
RESTRICTED-PII |
Unavailable |
27-FEB-2026 |
|
Stores promotion and related personnel action records used for affirmative action, diversity, equity, and compliance reporting, including before/after organizational and job attributes for an individual. Each row represents a promotion event (or promotion-related action) within an AAP plan year. |
N/A |
SAP Financial |
RESTRICTED-PII |
Unavailable |
27-FEB-2026 |
|
Stores termination and separation personnel action records used for affirmative action, diversity, equity, and compliance reporting. Each row represents a termination-related action within an AAP plan year and organizational/job context for an individual. |
N/A |
SAP Financial |
RESTRICTED-PII |
Unavailable |
27-FEB-2026 |
|
Stores education history details for individuals, including degree, degree type, institution, CIP/program classification, specialization, and completion dates. Users with the HR_PERSON_EMPLOYEE_FULL and HR_PERSON_EMPLOYEE_LIMITED roles can seethis view - users with access to records that are charged to their cost objects (ie. the persons are not in the users Org Units) are only allowed to see the directory-based information, no education information.Each row represents an education record for a person. |
N/A |
Human Resources, SAP |
RESTRICTED-PII |
Unavailable |
27-FEB-2026 |
|
Reference table of educational institutions, including identifiers, name, and location attributes used to support HR education reporting and education-history fact tables. |
N/A |
Human Resources, SAP |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores detailed employee affiliation records, including organizational assignment, position context, and employment percentage over a defined time period. Used for HR reporting and workforce analytics. |
N/A |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Reference table defining employee affiliation types and related reporting indicators used to categorize and interpret employee affiliations in HR analytics. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores employee emergency contact and related communication details used for safety, emergency response, and administrative purposes. |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Stores employee Classification of Instructional Programs (CIP)?related education and employment details, including degree context and effective dates, used for HR reporting and compliance analytics. Users with the HR_PERSON_EMPLOYEE_FULL and HR_PERSON_EMPLOYEE_LIMITED roles can see this view - users with access to records that are charged to their cost objects (ie. the persons are not in the users Org Units) are only allowed to see the directory-based information, no employment cip information. |
N/A |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Reference table defining employment CIP types used to categorize employee CIP records for HR reporting and compliance purposes. Classification of Instructional Programs |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Reference table defining job classifications and attributes used across HR systems, including titles, families, levels, compensation ranges, benefits eligibility, and regulatory reporting categories - for the current fiscal period. |
N/A |
Human Resources, SAP |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Job hierarchy dimension defining multi-level job classification structures used to group jobs for reporting, analytics, and organizational analysis. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Historical job dimension capturing job classification, compensation ranges, and hiring attributes as they existed for each fiscal reporting period, used for longitudinal workforce, compensation, and compliance analysis. |
N/A |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores HR letter and notification information, including appointment letter details, processing status, personal identifiers, appointment attributes, compensation information, and eligibility indicators used for HR correspondence and downstream reporting. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores generic lookup and reference values used across HR systems to standardize codes and their descriptions. Each row represents a single lookup code within a defined lookup type. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Subset of HR_OBJECT_RELATIONSHIP containing relationship codes: (1) Z02 (2) ZLI (3) ZC1 (4) ZC2. Also includes MIT_ID and FULL_NAME and RELATIONSHIP_ACTIVE_FLG. Stores personnel-focused HR object relationships, enriched with individual identifiers and activity flags for reporting and analysis. Each row represents a relationship between HR objects associated with a specific individual. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores faculty sponsor relationships between HR objects, identifying sponsorship links and their effective dates. Each row represents a faculty sponsorship relationship between two HR objects. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores flattened and hierarchical Human Resources organizational unit reference data, including department identifiers, organizational levels, and reporting hierarchy attributes. Used to support HR reporting, access control, and organizational rollups. |
N/A |
Human Resources, SAP |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores current (non-snapshot) organizational hierarchy and department alignment attributes for HR organizational units. Each row represents an HR organizational unit, including descriptive fields and its placement within the organizational hierarchy used for reporting and analytics. |
N/A |
Human Resources, SAP |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores a flattened HR organizational hierarchy for each HR organizational unit, including search-friendly hierarchy name/code fields and level-based sort/name/abbreviation attributes used for navigation, reporting rollups, and filtering. |
N/A |
Human Resources, SAP |
MIT Only |
Daily |
27-FEB-2026 |
|
Master data table containing the new 8 digit department nuber, title, old department codes, and organization levels. |
Fact |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
SAP HR personnel actions data. |
Fact |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Table containing information about MIT employees as recorded and maintained in SAP HR. |
Dimension |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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-2025 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Master data table containing position information, such as position title, position area/subarea and employee group/subgroup. |
Dimension |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
This table contains the list of relevant position statuses and their descriptions. |
Dimension |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
HR Roles detail |
Fact |
Roles Authorization System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
HR Roles function |
Dimension |
Roles Authorization System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
HR Roles qualifier |
Dimension |
Roles Authorization System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
This table contains the different types of visas. |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Categories for IAP Non-Credit Activities |
Dimension |
MIT Student Information System |
MIT ONLY |
As Needed |
27-FEB-2026 |
|
IAP non-credit activities for the current/upcoming IAP period. Data items include the activity title, description, enrollment & attendance, prerequisites, fee, and pre registration deadline. There is one record per activity as it is offered during IAP. |
Fact |
MIT Student Information System |
MIT ONLY |
As Needed |
27-FEB-2026 |
|
This table contains information about the persons (Activity Leader, Contact Person, Session Leader, etc.) associated with the IAP non-credit subjects/activities. |
Dimension |
MIT Student Information System |
MIT ONLY |
As Needed |
27-FEB-2026 |
|
Individual session asscoiated with an IAP non-credit activity. |
Dimension |
MIT Student Information System |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Sponsor for an IAP non-credit activity. |
Dimension |
MIT Student Information System |
MIT ONLY |
As Needed |
27-FEB-2026 |
|
XXX |
N/A |
Institutional Research |
SENSITIVE |
Unavailable |
Unavailable |
|
This table contains directory information plus tenure date for active employees whose Employee Type are "Faculty". |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Internal Order Dimension. Contains Master data about all Internal Orders |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Contains the history of internal order data by fiscal period and fiscal year. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Awards |
Dimension |
Institutional Research |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Institutional Research |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Honors bestowed. |
Fact |
Institutional Research |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Recipients of awards and honors. |
Dimension |
Institutional Research |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Institutional Research |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Institutional Research |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Institutional Research |
SENSITIVE |
Yearly |
17-FEB-2026 |
|
This table contains kerberos name (kerberos principal) of all current students. |
Dimension |
Moira Accounts |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Contains a list of keys that have been allocated, and the name of the person the keys have been allocated to. |
Fact |
Facilities -- Physical Plant |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
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 |
Unavailable |
Unavailable |
|
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 |
|
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 |
22-DEC-2021 |
|
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 |
|
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 |
|
Includes the classification number and a calculated classification number. Use this table to limit the query by classification. |
Dimension |
Libraries |
MIT ONLY |
Daily |
22-DEC-2021 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
22-DEC-2021 |
|
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 |
22-DEC-2021 |
|
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 |
22-DEC-2021 |
|
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 |
22-DEC-2021 |
|
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 |
22-DEC-2021 |
|
XXX |
N/A |
Libraries |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Libraries |
SENSITIVE |
Unavailable |
Unavailable |
|
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 |
22-DEC-2021 |
|
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 |
|
Includes information from the General Invoice (Invoice Header) in Aleph (e.g., Invoice Number, Invoice Date, Vendor, Total Price) |
Fact |
Libraries |
MIT ONLY |
Daily |
22-DEC-2021 |
|
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 |
06-JAN-2022 |
|
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 |
22-DEC-2021 |
|
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 |
|
XXX |
N/A |
Libraries |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Libraries |
SENSITIVE |
Daily |
10-JAN-2022 |
|
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 |
22-DEC-2021 |
|
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 |
22-DEC-2021 |
|
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 |
|
XXX |
N/A |
Libraries |
SENSITIVE |
Daily |
22-DEC-2021 |
|
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 |
|
XXX |
N/A |
Libraries |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
|
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 |
22-DEC-2021 |
|
Master table containing all Personnel lookup data. |
Dimension |
Human Resources |
MIT ONLY |
Unavailable |
Unavailable |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
People taking classes via LSO, includes people external to MIT |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Buildings in LSO system (SAP) |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Courses offered through E-learning catalog |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
List of instructors in E-learning (LSO) module |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Table for reporting on sections instructors teach |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Session Locations as described in LSO module |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
MIT Org unit information (SAP HR) |
Dimension |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
List of LSO qualifications |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Fact table for reporting on LSO Attendee qualifications |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Fact table for reporting on registrations in E-learning module |
Fact |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
List of valid course registration statuses |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Fact table for reporting statistics on course sessions in E-learning module |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Fact table for reporting session schedules |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
List of LSO session statuses |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
MIT address view of the Employee table for use by Mail Services only. |
Fact |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Data Warehouse |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Data Warehouse |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Data Warehouse |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Balance Amounts and Project Authorized totals summarized at the master project level |
Fact |
SAP Financial |
SENSITIVE |
Monthly |
27-FEB-2026 |
|
Contains codes and descriptions of material groups used in categorizing items ordered through Purchase Orders. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
26-FEB-2026 |
|
Material Data used in Tech Review Sales Orders |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
26-FEB-2026 |
|
Medical invoices including check numbers. This is a subset of financial detail documents, combined with payment information. |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
26-FEB-2026 |
|
All people with an active (not obsolete) MIT ID in the MITID database |
Dimension |
MIT ID Database |
SENSITIVE |
Daily |
27-FEB-2026 |
|
All people with a MIT ID in the MITID database |
Dimension |
MIT ID Database |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
MIT Card Office |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
XXX |
N/A |
MIT Card Office |
SENSITIVE |
Unavailable |
Unavailable |
|
Contains MIT Card information |
N/A |
MIT Card Office |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
MIT Card Office |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
MIT Card Office |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
MIT Card Office |
SENSITIVE |
Unavailable |
Unavailable |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
MIT Card Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
MIT Card Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
Technology Licensing Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Technology Licensing Office |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Technology Licensing Office |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Technology Licensing Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Stores Moira list (mailing list/group) metadata, including name, description, list type indicators, activity status, and visibility flags. Each row represents a Moira list. |
N/A |
Moira Accounts |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores Moira list membership details linking lists to owners and members, including member identifiers, member names, update timestamps, and ETL counters. Each row represents a single membership entry for a Moira list. |
N/A |
Moira Accounts |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores Moira list owner records, including owner identifier and owner type. Each row represents an owner entity associated with one or more Moira lists. |
N/A |
Moira Accounts |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Budget, Finance and Treasury |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Budget, Finance and Treasury |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
OPA Disclosures |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
OPA Disclosure Activities |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
OPA Person Information |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
ORCID WEBSITE |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
ORCID WEBSITE |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
ORCID WEBSITE |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
24-APR-2011 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
17-MAY-2011 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Activity type for OSP Proposal |
Dimension |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Contains all project data for WBS Elements stored in COEUS. |
Dimension |
OSP - MIT Office of Sponsored Programs |
MIT ONLY |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
COEUS award cost sharing data |
Fact |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
OSP Award Special Review Details |
Fact |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
Dimension table contains the different types of OSP award terms and conditions. |
Dimension |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
OSP Award Cost Sharing Comments |
Fact |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
OSP Cost Sharing Type |
Dimension |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
Dimension |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
OSP Proposal Investigator information |
Dimension |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
OSP Proposals |
Dimension |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
Fact |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Status for OSP Proposals |
Dimension |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
Dimension |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Type of OSP Proposal |
Dimension |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
OSP Proposal Cost Sharing |
Fact |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
OSP Proposal Unit Investigator |
Dimension |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
24-JUN-2025 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
EB, Lab Allocation, and Overhead rates |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Daily |
20-SEP-2019 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Parking Office |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Payment data |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
05-OCT-2016 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
This table contains the appointment distribution data (no salary information) for employees and students beginning July 2006. |
Fact |
SAP HR Payroll |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
This table contains e-DACCA Certification information. |
Dimension |
SAP HR Payroll |
SENSITIVE |
Daily |
27-FEB-2026 |
|
This table contains e-DACCA Certification detail information. |
Fact |
SAP HR Payroll |
SENSITIVE |
Daily |
27-FEB-2026 |
|
This is a time dimension table for e-DACCA Certification which contains the fiscal year data. |
Dimension |
SAP HR Payroll |
SENSITIVE |
As Needed |
27-FEB-2026 |
|
This table contains information that describes the e-DACCA certification status. |
Dimension |
SAP HR Payroll |
SENSITIVE |
As Needed |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
Fact |
SAP HR Payroll |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
This fact table contains salary/appointment information for hourly paid students. |
Fact |
SAP HR Payroll |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Authorizations for payroll data access in the Roles Database. |
Fact |
Roles Authorization System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
All the functions for payroll authorizations in the Roles Database. |
Dimension |
Roles Authorization System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
All the qualifiers for payroll authorizations in the Roles Database. |
Dimension |
Roles Authorization System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
This table contains appointment/salary information for employees (exempts and non-exempts), graduate students, and hourly paid students. |
Fact |
SAP HR Payroll |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
This table contains the salary and account distribution (percent and amount) information for employees and students. |
Fact |
SAP HR Payroll |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Pension Actions data (Action Begin and End date,SAP Status, Last Update Date,etc) |
Fact |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Pension Benefits data |
Fact |
Human Resources, SAP |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Pension Benefits Eligibility |
Fact |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
SAP HR Pension Benefits Recipients |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
MIT Medical health plan enrollment records of Pension Annuitants |
Fact |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
This view includes pension annuitants personal data if they subscribe for MIT Medical health plans |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Pension annuitants who subscribe to MIT Medical health plan, and their dependents |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
SAP HR Pension Person data |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
The history of Personnel Actions in HR |
Fact |
SAP Financial |
SENSITIVE |
Daily |
08-MAR-2005 |
|
Types of Personnel Actions |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Data Warehouse |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Data Warehouse |
SENSITIVE |
Daily |
26-FEB-2026 |
|
View of the employee table for use by the IS Help system only. |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SENSITIVE |
Unavailable |
27-FEB-2026 |
||
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
History of Cost Collector Pool Units by fiscal period, beginning with June 1997. |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
History of Pool Unit Values by fiscal period, beginning with June 1997. |
Fact |
SAP Financial |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
Dimension |
SAP Financial |
SENSITIVE |
As Needed |
15-JUN-2004 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
26-FEB-2026 |
|
Contains a list of all SAP posting key codes and their descriptions. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
26-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Pricing elements codes and descriptions -- used by Tech Review |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Profit Center Dimension. Master data information on Profit Centers including name and id. |
Dimension |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Structure for creating reports of grouped Profit Centers taken from SAP. Multiple hierarchies are represented in the groups. |
Dimension |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Contains the history of project data by fiscal period and fiscal year. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
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 |
02-JUL-2024 |
|
Contains both Project information from SAP and additional information from COEUS |
Dimension |
OSP - MIT Office of Sponsored Programs |
MIT ONLY |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Contains information about the type of purchase order. |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
26-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Contains codes, descriptions and phone numbers for MIT's Purchasing Groups |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Contains codes and descriptions for all MIT's Purchasing Organizations |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Purchasing requisition information |
Fact |
Procurement |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Purchasing requisition type codes and descriptions |
Dimension |
Procurement |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
14-JUN-2002 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Stores assignments linking research cost collectors to fiscal years, assignment types, master projects, and organizational/research department context. Each row represents a cost-collector assignment used to attribute research financial activity to departments and organizations. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Stores research financial volume measures summarized by principal investigator (PI/supervisor) and fiscal year, including GL category, profit center, administrative flag, and year-to-date and cumulative amounts and budget. Each row represents a PI-level fiscal-year summary. |
N/A |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Mapping of org units to costs objects used by the Rewards and Recognition Office |
Fact |
Human Resources, SAP |
MIT ONLY |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Roles Authorization System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Roles Authorization System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Roles Authorization System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Roles Authorization System |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Roles Authorization System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Roles Authorization System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Roles Authorization System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Roles Authorization System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Roles Authorization System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Roles Authorization System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Contains the custom fields used in Request Tracker's tickets. |
Dimension |
Request Tracker |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Contains all custom field names and the values used in Request Tracker's tickets. |
Fact |
Request Tracker |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Contains information about the existing queues in Request Tracker. |
Dimension |
Request Tracker |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Contains detail information about each ticket in Request Tracker. |
Fact |
Request Tracker |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Contains the status of the tickets in Request Tracker. |
Dimension |
Request Tracker |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Contains Request Tracker ticket transactions data. |
Fact |
Request Tracker |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Contains all the type of transactions (eg. Create, Comment, Correspond, Take) added to the ticket in Request Tracker. |
Dimension |
Request Tracker |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Sales contract data |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Sales Order information -- currently contains Tech Review data only |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Sales Order Partners information-- currently contains Tech Review data only |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
SAP Financial roles and authorizations. |
Fact |
Roles Authorization System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
SAP Financial Functions, including "CAN SPEND OR COMMIT FUNDS", "INVOICE APPROVAL UNLIMITED", "TRAVEL DOCUMENTS APPROVAL". |
Dimension |
Roles Authorization System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Sponsor Billing |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Sponsor Billing |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Sponsor Billing |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
Unavailable |
|
Current Settlement Rules |
Fact |
SAP Financial |
SENSITIVE |
Daily |
26-FEB-2026 |
|
Settlement Rules History |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
This table contains information about academic departments and schools as recorded in MITSIS. |
Dimension |
MIT Student Information System |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Contains descriptions of codes used in MTSIS, the Student Information System. |
Dimension |
MIT Student Information System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Descriptions for student's minor programs |
Dimension |
MIT Student Information System |
MIT ONLY |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
10-SEP-2018 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Daily |
26-FEB-2026 |
|
Physical Plant data -- rooms. |
Fact |
Facilities -- Physical Plant |
PUBLIC |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
Unavailable |
|
Physical Plant data -- floors |
Dimension |
Facilities -- Physical Plant |
MIT ONLY |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Daily |
26-FEB-2026 |
|
Physical Plant data -- org units |
Dimension |
Facilities -- Physical Plant |
MIT ONLY |
Unavailable |
Unavailable |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
Unavailable |
|
Physical Plant data -- space usage |
Dimension |
Facilities -- Physical Plant |
SENSITIVE |
Daily |
26-FEB-2026 |
|
XXX |
N/A |
SPACE System - MDS |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
AWS Sponsored Account |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
AWS Sponsored Account |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
AWS Sponsored Account |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
AWS Sponsored Account |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
26-FEB-2026 |
|
Contains data about each sponsor. |
Dimension |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
Customer Information which joins with the Sponsor Billing Detail. This is a subset of the Customers from SAP. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Contains information about Sponsor Billing. |
Fact |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Sponsor Hierarchy maintained in COEUS. |
Dimension |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Historic data for sponsor hierarchy maintained in COEUS. |
Fact |
OSP - MIT Office of Sponsored Programs |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
This is a version of Subject Offered table built specifically for the Sloan School of Management. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
This version of the Subject Enrollment table is specifically built for the Sloan School of Management. |
Fact |
MIT Student Information System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
09-JUL-2020 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
This table contains the term GPA and other academic information, with one record per student per academic term. |
Fact |
MIT Student Information System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
This table contains students' home, term and office addresses |
Fact |
MIT Student Information System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
Unavailable |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
As Needed |
30-MAY-2002 |
|
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 |
Unavailable |
27-FEB-2026 |
|
Student's degree audit profile and summary data. One record per student per degree level (Undergraduate or Graduate). |
Fact |
MIT Student Information System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
This table contains MIT degree candidates and applicants for the upcoming degree-award term. |
Dimension |
MIT Student Information System |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
Student degree information including degree code, degree name, degree type, and effective academic terms. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Student Thesis |
Dimension |
MIT Student Information System |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
Contains student directory data for current students. |
Dimension |
MIT Student Information System |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Contains directory information for current students, including term address, year of degree, and department. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Student ethnicity summary data. |
N/A |
MIT Student Information System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Student ethnicity information. |
Dimension |
MIT Student Information System |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
Weekly |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Academic Term |
27-FEB-2026 |
|
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 |
Daily |
27-FEB-2026 |
|
This table contains graduate students' general exam credit dates. |
Fact |
MIT Student Information System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Daily |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
This table contains the tuition assessment for students by academic term. |
Dimension |
MIT Student Information System |
SENSITIVE |
Weekly |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Descriptions of attributes of subject in degree audit. |
Dimension |
MIT Student Information System |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Degree audit data. |
Fact |
MIT Student Information System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Subject enrollment data with specific subjects/classes, tailored for the EH&S Office. |
Fact |
MIT Student Information System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
Subject enrollment records (or class lists) with grades. |
Fact |
MIT Student Information System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
Subject registration status codes and descriptions |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
Contains Overhead, EB, and Lab Allocation rates as they would have been calculated by the SAP costing sheets yesterday. |
Fact |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Surcharge postings |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Contains a list and description of all tables in the warehouse that are available to users. |
Dimension |
PUBLIC |
As Needed |
Unavailable |
||
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
28-APR-2022 |
|
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 |
|
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 |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
01-SEP-2011 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
02-OCT-2010 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
02-OCT-2010 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
01-SEP-2011 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
03-OCT-2010 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
02-OCT-2010 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
02-OCT-2010 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
02-OCT-2010 |
|
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 |
Unavailable |
27-FEB-2026 |
|
Daily calendar information. For use in joining tables to include a time dimension to the report. |
Dimension |
PUBLIC |
As Needed |
27-FEB-2026 |
||
Stores time dimension data at the fiscal month level, including fiscal, calendar, academic, and financial aid attributes, as well as period indicators used for reporting and analysis. |
N/A |
MIT ONLY |
As Needed |
27-FEB-2026 |
||
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-FEB-2026 |
||
Inforamtion about Course Material (Author,Title,ISBN, Publisher, etc.) |
Dimension |
SENSITIVE |
Weekly |
27-FEB-2026 |
||
Course Material status (Ex. Required,Recommended, No Material, etc.) |
Dimension |
SENSITIVE |
Weekly |
27-FEB-2026 |
||
Subjects Offered offered for a particular academic Term |
Dimension |
SENSITIVE |
Weekly |
27-FEB-2026 |
||
XXX |
N/A |
Technology Licensing Office |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
Technology Licensing Office |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 Table |
Dimension |
Human Resources |
MIT ONLY |
Daily |
08-MAR-2006 |
|
XXX |
N/A |
Traincaster |
SENSITIVE |
Unavailable |
24-JUL-2012 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
Unavailable |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Contains departmental data from the personnel system. |
Dimension |
Human Resources |
MIT ONLY |
Daily |
08-MAR-2006 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
Stores legacy VAPS (Vendor Accounts Payable System) vendor master records, including vendor identifiers, contact information, payment terms, tax indicators, and classification attributes. Each row represents a vendor record maintained within the VAPS system. It was replaced by the Roles Database during fiscal year 1999, and legacy system signature cards were eliminated in early June 1999. |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
XXX |
N/A |
SENSITIVE |
Unavailable |
Unavailable |
||
Stores vendor master reference data used for procurement, financial accounting, and payment processing. Each row represents a vendor entity including identifying, contact, banking, withholding, and status attributes. Contains a distinct list of vendors by company_code (if a vendor belongs to the company_code CUR, it will not appear in the TECR list or SING, if itis in TECR it wll not appear in SING). Company codes - CUR = MIT, LCP1 = MIT Lincoln Laboratory, TECR = MIT Technology Review, RDBP = MIT Ret.Def.Benefit Plan, SING = MIT Singapore |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Stores vendor business classification attributes derived from Dun and Bradstreet and related enrichment sources. Includes industry codes, size indicators, ownership classifications, certification flags, and regulatory indicators. Each row represents classification data associated with a vendor. |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Stores Dun and Bradstreet enriched vendor reference data linked to VENDOR records. Includes DUNS identifiers, industry classifications, business ownership indicators, firmographic attributes, certification flags, and corporate hierarchy information. Each row represents Dun and Bradstreet profile data associated with a vendor. |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Stores vendor master reference data sourced from Singapore Financials (FS), including vendor identifiers, names, contact details, and industry classification. Each row represents a vendor record as maintained in the Singapore Financials system for financial and procurement reporting. |
N/A |
SAP Financial |
MIT ONLY |
Daily |
27-FEB-2026 |
|
Stores comprehensive vendor master data combining procurement, payment, tax, compliance, and related personnel linkage attributes. Each row represents a vendor entity with extended financial, tax, and status information for reporting and operational use. |
N/A |
SAP Financial |
SENSITIVE |
Daily |
27-FEB-2026 |
|
Stores vendor purchasing group assignments and related sales contact information. Each row represents a vendor-to-purchasing-group relationship used for procurement and sourcing processes. |
N/A |
SAP Financial |
MIT ONLY |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
26-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
SAP Financial |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Academic term information for the Who-is-Teaching-What data. |
Dimension |
MIT Student Information System |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
This table includes all instructors in the Who-is-Teaching-What data. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
This table contains all instructors in the OLD Who-is-Teaching-What data model. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
27-FEB-2026 |
|
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 |
Unavailable |
27-FEB-2026 |
|
XXX |
N/A |
Registrar - MITSIS |
SENSITIVE |
Unavailable |
27-FEB-2026 |
|
Zip codes in Canada |
Dimension |
Zip Code |
PUBLIC |
As Needed |
09-JUL-2015 |
|
Zip codes in the United States |
Dimension |
Zip Code |
PUBLIC |
As Needed |
09-JUL-2015 |