Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINAID YEAR Table


Contains information about financial aid years


Field Name

Description

Data Type

Length

AID_YEAR

Financial aid year.

VARCHAR2

4

AID_YEAR_DESC

Description of the financial aid year.

VARCHAR2

30

AID_YEAR_END_DATE

The end date of the financial aid year.

DATE

8

AID_YEAR_START_DATE

The begin date of the financial aid year.

DATE

8

FINAID_YEAR_KEY

Key identifying an entry in the FINAID YEAR Table. This field should only be used for linking tables together, not for reporting.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8