Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINAID OUTSIDE SCHOL Table


View exposing outside scholarship records associated with student financial aid awards.


Field Name

Description

Data Type

Length

IS_RENEWABLE

Indicator identifying whether renewable (Y/N).

VARCHAR2

1

LAST_ACTIVITY_DATE

Date associated with last activity.

DATE

OUTSIDE_SCHOL_CODE

Code identifying outside schol.

VARCHAR2

6

OUTSIDE_SCHOL_KEY

Surrogate key identifying the outside schol.

VARCHAR2

6

OUTSIDE_SCHOL_NAME

Outside schol name associated with the record.

VARCHAR2

29

OUTSIDE_SCHOL_TYPE

Outside schol type associated with the record.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE