Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Financial Aid Work Summary


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_YEAR

Contains information about financial aid years

Dimension

MIT Student Information System

MIT ONLY

Academic Term

01-SEP-2019

FINAID_WORK_EARNINGS_DETAIL

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

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