Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINAID YEAR Table


View exposing financial aid year reference data used in aid eligibility, packaging, and reporting.


Field Name

Description

Data Type

Length

AID_YEAR

Aid year associated with the record.

VARCHAR2

4

AID_YEAR_DESC

Description of aid year.

VARCHAR2

30

AID_YEAR_END_DATE

Date associated with aid year end.

DATE

AID_YEAR_START_DATE

Date associated with aid year start.

DATE

FINAID_YEAR_KEY

Surrogate key identifying the finaid year.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE