Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINAID OUTSIDE INTEREST Table


View exposing student outside scholarship or funding interest records associated with financial aid processing.


Field Name

Description

Data Type

Length

AID_YEAR

Aid year associated with the record.

VARCHAR2

4

FINAID_OUTSIDE_INTEREST_KEY

Surrogate key identifying the finaid outside interest.

VARCHAR2

8

OUTSIDE_INTEREST_CODE

Code identifying outside interest.

VARCHAR2

4

OUTSIDE_INTEREST_DESC

Description of outside interest.

VARCHAR2

30

OUTSIDE_INTEREST_STATUS

Outside interest status associated with the record.

VARCHAR2

8

OUTSIDE_INTEREST_STATUS_CODE

Code identifying outside interest status.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE