Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FA AWARD STATUS Table


XXX


Field Name

Description

Data Type

Length

AWARD_IS_ACCEPTED

Whether the status of the award indicates that the award is accepted by the student. Y=Yes, N=No.

VARCHAR2

1

AWARD_IS_CANCELLED

Whether the status of the award indicates that the offer of the award has been cancelled. Y=Yes, N=No.

VARCHAR2

1

AWARD_IS_DECLINED

Whether the status of the award indicates that the award offfered has been declined. Y=Yes, N=No

VARCHAR2

1

AWARD_IS_OFFERED

Whether the status of the award indicates that the award is offered to the student. Y=Yes, N=No.

VARCHAR2

1

AWARD_STATUS_CODE

XXX

VARCHAR2

4

AWARD_STATUS_DESC

Description of the status code of the financial aid award. Examples: "Actual" for ACTL; "Cancelled" for CANC; "Paid Directly to Student" for KEPT.

VARCHAR2

30

FA_AWARD_STATUS_KEY

XXX

VARCHAR2

4

WAREHOUSE_LOAD_DATE

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

DATE