Financial Aid Campus Work
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 |
|---|---|---|---|---|---|---|
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 |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
(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 |
01-JAN-2025 |
|
Daily calendar information. For use in joining tables to include a time dimension to the report. |
Dimension |
PUBLIC |
As Needed |
01-JAN-2025 |
||
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 |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
Contains Master data information about all three types of cost collectors (Cost Centers, Internal Orders, & Projects/WBS Elements). It only contains the fields common to all three. Cost Collector is a term synonymous with Cost Object. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |