Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FA AWARD STATUS Table


View exposing reference values describing financial aid award status used in financial aid processing and reporting.


Field Name

Description

Data Type

Length

AWARD_IS_ACCEPTED

Award is accepted associated with the record.

VARCHAR2

1

AWARD_IS_CANCELLED

Award is cancelled associated with the record.

VARCHAR2

1

AWARD_IS_DECLINED

Award is declined associated with the record.

VARCHAR2

1

AWARD_IS_OFFERED

Award is offered associated with the record.

VARCHAR2

1

AWARD_STATUS_CODE

Code identifying award status.

VARCHAR2

4

AWARD_STATUS_DESC

Description of award status.

VARCHAR2

30

FA_AWARD_STATUS_KEY

Surrogate key identifying the fa award status.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE