Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINAID AWARD STATUS Table


View exposing reference values describing financial aid award status used in 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

Award status associated with the record.

VARCHAR2

4

AWARD_STATUS_DESC

Description of award status.

VARCHAR2

30

AWARD_STATUS_KEY

Surrogate key identifying the award status.

VARCHAR2

15

FED_LOAN_PERIOD

Fed loan period associated with the record.

VARCHAR2

6

FED_LOAN_PERIOD_DESC

Description of fed loan period.

VARCHAR2

19

NOTE_IS_ACTIVE

Note is active associated with the record.

VARCHAR2

1

NOTE_IS_CANCELLED

Note is cancelled associated with the record.

VARCHAR2

1

NOTE_IS_ON_HOLD

Note is on hold associated with the record.

VARCHAR2

1

NOTE_IS_SIGNED

Note is signed associated with the record.

VARCHAR2

1

NOTE_STATUS

Note status associated with the record.

VARCHAR2

4

NOTE_STATUS_DESC

Description of note status.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE