Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR CSP MIT TUITION Table


Stores MIT tuition amounts for the academic year, used by the Childcare Scholarship Program (CSP), including academic year descriptors and effective date ranges. Each row represents a tuition rate applicable to a specific academic year and date range.


Field Name

Description

Data Type

Length

ACADEMIC_YEAR

Academic year associated with the tuition amount.

VARCHAR2

4

ACADEMIC_YEAR_DESC

Descriptive label for the academic year.

VARCHAR2

20

END_DATE

End date on which the tuition amount expires.

DATE

MIT_SEMESTER_TUITION_AMOUNT

MIT semester tuition amount used in CSP award calculations.

NUMBER

13,2

START_DATE

Start date on which the tuition amount becomes effective.

DATE

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE