Data Warehouse

IS&T Home >   Data Warehouse

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

FINAID_PAYROLL_CWSP_STATUS

A dimension table for the CWSP (College Work Study Program) account status for each of the student payroll distribution record.

Dimension

MIT Student Information System

MIT ONLY

Daily

08-JAN-2020

FINAID_WORK_STUDENT

This table contains records of students who have worked on campus. Fields of records include MIT ID, full name, and some enrollment information.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

FINAID_AID_APPLICANT

(Access to this table is restricted to the staff of Student Financial Services. Other authorized users are given access to the FINAID APPLICANT table.) This table contains the yearly status and summary information of all prospective financial aid applicants, including incoming freshmen and applicants, at MIT since financial aid year 1994. Information includes biographical data, financial aid data, enrollment profile data, admissions data, and summary of award data. There is one record per aid applicant per financial aid year.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

TIME_DAY

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

Dimension

PUBLIC

As Needed

14-JUN-2003

FINAID_PAY_DIST_TYPE

A dimensional table for the Financial Aid Campus Work Star Schema. It contains the following data items: Payroll System (for either undergraduate or graduate students), Distribution Type (Undergraduate Timesheet, Graduate Appointment, Undergraduate Voucher, Adjustments, etc.), Personnel Rank (RA, TA, Instructor, etc.). Personnel Rank is not applicable to the undergraduate payroll system.

Dimension

MIT Student Information System

MIT ONLY

Daily

08-JAN-2020

FINAID_PAYROLL_DIST_DETAIL

Financial Aid Student Payroll Distribution Detail ("Student Employment") Table. It contains detailed distribution transactions of all student payroll data. Each record represents a single payroll distribution.

Fact

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

GL_ACCOUNT

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

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

COST_COLLECTOR

Contains Master data information about all three types of cost collectors (Cost Centers, Internal Orders, & Projects/WBS Elements). It only contains the fields common to all three. Cost Collector is a term synonymous with Cost Object.

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020