|
| |
Related Links: |
|---|---|
| |
All Stars / Table Groups
This page lists all of the stars or table groups in the 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 |
|---|---|---|---|
ASA Early Return Requests |
Requests of early return resources by the ASA (Association of Student Activities) recognized student groups |
||
ASA Midway Requests |
Requests of midway sapce by the ASA (Association of Student Activities) recognized student groups. |
||
ASA Resource Allocations |
Resource allocations of the ASA (Association of Student Activities) recognized student groups |
||
ASA Resource Requests |
Requests of resource allocations (Locker, bulletin board, office, and mailbox) by the ASA (Association of Student Activities) recognized student groups. |
||
ASA Student Group Officers |
Recognized student groups and their officers in the Association of Student Activities. |
||
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. |
|
|
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 |
|
|
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 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, allowing graduate administrators to report on those students who are enrolled in courses in their department. |
||
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. |
||
Instructor Roles (WTW) |
This area contains the "Who is Teaching What" (WTW) data -- information about the roles (Eg.: Lecturer, Tutor, Grader, Administrator) of instructors in different sections of subjects/courses, by academic terms, as recorded on MITSIS. |
||
Library Fund |
This contains Library financial data |
||
Library Item Detail |
This area contains data from the MIT Libraries Aleph database |
||
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 Detail |
Information about Request Tracker ticket's custom fields. |
||
RT Ticket Detail |
Information about Request Tracker tickets, their status, queue assigned to, user's questions and problems notes, and IS&T staff members solution. |
||
RT Transaction Detail |
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. |
|
|
Subject Enrollment |
This area contains student subject enrollment/registration information. |
||
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. |
||
Web Hits by Locker |
This area contains statistics about web hits on web sites at MIT. Selection of criteria: Athena locker name and calendar period. |
||
Web Hits by URL |
This area contains statistics about web hits on web sites at MIT. Results (web hits) are retrieved by specifying a full or partial URL of the web site. |
