All Stars / Table Groups
This page lists all of the stars or table groups in the Data Warehouse.
Follow the links in the Tables in Group column to see a list of all the tables used in the star/group, together with information on how to combine the tables in a query.
Follow the links in the Data Model Diagram column (if available) to see a pictorial representation of the star.
Star/Table Group |
Description |
Tables in Group |
Data Model Diagram |
|---|---|---|---|
Academic Chairs |
This area contains academic chair information which includes the chair holders of the academic chairs in different periods of time, and the various cost objects associated with each of the chair. |
||
Alumni Addresses |
MIT Alumni addresses information, including home and business addresses. |
||
Alumni Degrees |
MIT Alumni degrees, including degrees awarded by MIT and other institutions |
||
Alumni Information - All |
MIT Alumni information, including biographic, address, degree, and employment data, all in one table. |
||
Alumni Occupation Data |
MIT Alumni Occupation data. |
||
Alumni SIC Data |
MIT Alumni SIC (Standard Industrial Code) data. |
||
Balance Sheet Balances |
This contains summary financial information relating to MIT's assets, liabilities, and net assets (also called "net worth" or "fund balance". Data on MIT's revenues, expenses, and operations is available though Balances or Balances_by_fiscal_period. |
|
|
Balances |
This is good for looking at summary financial information as of yesterday. Balances, budgets, and commitments are included. This is also good for year to year comparisons. |
|
|
Balances by Fiscal Period |
This gives summary point in time financial information. It includes Balances & Budgets. If asking for more than one Fiscal Period, you must be careful using the fields FYTD_AMOUNT & CUM_AMOUNT. This star can also be used to view financial information using an alternative Fiscal Year. |
|
|
Benefits Adjustments |
Data about Reasons for Employee Benefits Adjustments such as Employee Divorce,Dependent Birth or Adoption, Spouse Death, etc |
||
Benefits Detail |
Information about Employee Benefits such as Benefit Plans, Recipients, Benefits Adjustment Reasons etc. |
||
Benefits Eligibility |
Data about Employee Benefits Eligibility |
||
Commitment History |
This allows for the reporting of commitments as they were at a particular point in time. The history starts with July of 1998. |
|
|
Credit Card |
PROTOTYPE: Details about MIT Credit Card transactions. |
|
|
Current Commitments |
This shows current open commitments, and allows for distinguishing between LDS, Manual Reservations, Blanket Orders, Requisition Commitments, and PO Commitments. |
|
|
Degrees |
Student Degree Information |
|
|
EHS Contact people |
Data About EHS Contact people by their room sets |
|
|
EHS Room Set |
EHS data containing information about room sets, rooms, hazards, functions and people in different roles |
|
|
EHS Training |
Data about EHS training certifications, triggers,trainees, units, PIs, DLCs, and training detail |
|
|
Employee CIP Details |
Information about MIT Employees' CIP (Classification of Instructional Programs) records |
|
|
Employee Education |
Information about Education Level, Subjects and Degrees |
||
External Test Credit Results |
This area contains the credit results (both generated and applied credits) associated with the external test scores (submitted by freshmen and transfer students) that are maintained by the Registrar's Office. Such tests and test scores include: AP (Advanced Placement), GCE (GCE A-Level Exams), International Baccalaureate Exams, Transfer Credit, Advanced Standing, and Freshman Essay Evaluation. Students whose undergraduate entrance term is in Summer 2003 (2003SU) or later are included in the tables. |
||
External Test Scores |
This area contains the external test score information for freshmen and transfer students. The test scores contain all tests and test scores maintained by the Registrar's Office for: Advanced Placement, International Baccalaureate Exams, GCE A-Level Exams, Transfer Credit, Advanced Standing, and Freshman Essay Evaluation. Students whose undergraduate entrance term is in Summer 2003 (2003SU) or later are included in the tables. |
||
Financial Aid Awards |
This area contains student financial aid award information. You may find in this area the complete financial aid packages of student financial aid applicants for the financial aid year. Data items included in this area are: the offer amount, offer date, status, and the type and category of each award in the aid package; promissory loan note information; award disbursement information; as well as the biographical and enrollment information of the students for the financial aid year. |
||
Financial Aid Campus Work |
This area contains detailed distribution transactions of all student payroll data. The information may be used (1) for Financial Aid College Work Study Program (CWSP) classification and assignment, (2) in payroll verification (ie. so and so did work here from this date to that date), (3) as a record for actual payment to graduate students, and (4) as statistical analysis of student work at MIT. |
||
Financial Aid Grant Packages |
This area contains information about MIT grant assignments (including the specific grant and the awarded amount) for students who are eligible to receive MIT grant. Also included in this area is the Student Financial Aid MIT grant management data. |
||
Financial Aid Work Summary |
Financial Aid Student Campus Work Earnings summary data. The total amount of earnings for each student who works on campus in the financial aid year. |
||
Financial Detail |
This area encompasses all the detailed financial transactions for the institute. Actual and committed dollar amounts can be reported and grouped by various categories such as GL Account, Cost Object, Fiscal Period etc. You will automatically be limited to viewing only those accounts you are authorized to see. |
|
|
Funds Reporting |
This is specific to all funds reporting, by FY only |
|
|
Grad Adm Application |
Graduate admissions application data, including applicant biographic information, graduate admissions programs, admissions decisions from the departments, and replies from the applicants. Data are by entry terms. |
||
Grad Adm Schools Attended |
This area contains graduate admissions applciation data with focus on the schools previously attended (with degrees received) by the applicants. |
||
Grad Adm Test Score |
Graduate admissions test and test score data. |
||
Grad Adm Test and Application |
Graduate admissions applications with test score information. |
||
Graduate Awards |
This area contains graduate award/appointment (ie. RA, TA and Fellowship) information for graduate students. The dollar amounts for tuition and stipends awarded to the students in each academic term are shown along with account and department information. Student enrollment information is also included. |
||
HR Absences |
Data with to-date absences by absence type (vacation, sick leave, jury duty, bereavement, etc.). Balances are included for those absence types with balance quotas. |
||
HR Appointment Transactions |
HR Data - containing information about employee's appointment transactions |
||
HR Appointments |
HR Data - containing information about employee's appointments |
||
HR Positions |
Data about filled, open, and closed positions at the Institute. |
||
HR Vacation Balances |
Data with to-date balances and details (number of hours/days deducted, dates, etc.) for Vacation and Fifth-week Vacation. |
||
IAP Non-Credit Activities |
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. |
||
IR Awards and Honors |
Information of Awards and Honors bestowed to current and former MIT faculty and staff members, and alumni; maintained by the Office of Institutional Research. |
||
Library Fund |
This contains Library financial data |
||
Library Item Detail |
This area contains data from the MIT Libraries Aleph database |
||
Moira Lists |
Information about visible Moira Lists, including list names, list owners, list members, and last update date. |
||
OSP Award Costshare |
Information about OSP Award Cost Sharing |
||
OSP Award Indirect Cost |
Information about OSP Award Indirect Costs |
||
OSP Award Special Review |
Information about Osp Award Special Review |
||
OSP Award Terms and Conditions |
Information about OSP Award Terms and Conditions |
||
OSP Proposal Cost Sharing |
Information about OSP Proposal Cost Sharing |
||
OSP Proposal IDC Rate |
Information about OSP Proposal Inderect Cost Rate |
||
OSP Proposal Investigator |
Information about OSP Proposal Investigator |
||
OSP Proposals |
Information about OSP Proposals |
||
OSP Proposals to Award MAP |
Information about connection between Proposals and Awards |
||
Overhead Rates |
PROTOTYPE: Overhead, EB and Lab Allocation rates, as they would have been calculated using the Sap costing sheets. |
|
|
Payroll Deductions |
This area contains information about payroll deductions. This information enables each central area making payroll deductions, such as Credit Union, Parking, to report on the deductions by person made by that area. |
||
Payroll Distributions |
This area contains FYTD payroll (e-DACCA) distribution information that shows the percent distribution of salaries to Cost Object. |
||
Payroll e-DACCA Certifications |
This area contains the Quarterly Dacca Certification information. Data include cost collectors by supervisor and cost object, with name of certifier and date certified. The date certified field is blank if the cost object has not yet been certified. |
||
Pension Action Detail |
Information about Pension Actions (Pension Termination, Initial Pension Set up, etc.) and Pension People |
||
Pension Benefits Detail |
Information about Pension Benefits, Pension People, Recipients, Benefits Plans and Adjustment Reasons |
||
Pension Benefits Eligibility |
Pension Benefits Eligibilty data |
||
Personnel |
This contains information about employees and appointments in the CYBORG system. |
|
|
Pre Registration |
This area contains pre-registration information of students for the upcoming academic term. |
||
Purchasing Detail |
This area provides a detailed view of purchase order data down to the account distribution level. In addition, summarized invoiced dollar amounts are included. Information can be limited and grouped by such categories as GL Account, Cost Object, Fiscal Period, Purchase Order Type. You will automatically be limited to viewing only those accounts you are authorized to see. |
|
|
RT Custom Field |
Information about Request Tracker ticket's custom fields. |
||
RT Ticket |
Information about Request Tracker tickets, their status, queue assigned to, user's questions and problems notes, and IS&T staff members solution. |
||
RT Transaction |
Information about Transactions associated with a Request Tracker ticket. Some of the data included are Transaction Subject and Description, Start Date, Due Date, Resolved Date, Transfer to another Queue Date, and Days on Hold. |
||
Space |
This area contains information about MIT Buildings and Rooms. |
|
|
Student Minors |
This area contains the proposed and completed minors of the students. |
||
Subject Enrollment |
This area contains student subject enrollment/registration information. |
||
Subject Enrollment with Grades |
Subject enrollment/registration records ("Class Lists") with grades |
||
Subject Grades |
This area contains student grade data, by academic terms and subjects |
|
|
Summary Statement Detail |
This shows monthly statement information for a point in time. It includes Authorized Totals, Balances, Budgets and Commitments. |
|
|
Telephone Detail |
This area contains information about all telephone charges. |
|
|
UROP Project |
Information about UROP (Undergraduate Research Opportunities Program) projects. |
||
Who's Teaching What |
This area contains department-wide teaching data as entered in the current version of the Who?s Teaching What application beginning in Spring 2008. Teaching data are organized by academic terms, subjects, and sections, with instructors in the following roles: Lecturer, Recitation Instructor, Lab Instructor, Teaching Assistant, Writing Instructor, etc. |
||
Who's Teaching What - Old WTW |
This area contains department-wide teaching data as entered in the old version of the Who?s Teaching What application used in conjunction with paper-based subject evaluations from Fall 1999 through Spring 2010. |
