Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ADM GRAD FUNDING OFFER DETAIL Table


View exposing graduate funding offer detail by application and offer identifier including amount, date, notes, and update attributes used for graduate admissions funding reporting.


Field Name

Description

Data Type

Length

ADM_GRAD_APPLICATION_KEY

Surrogate key identifying the adm grad application.

VARCHAR2

10

ADM_GRAD_FUNDING_OFFER_CHR_KEY

Surrogate key identifying the adm grad funding offer chr.

VARCHAR2

58

LAST_ACTIVITY_DATE

Date associated with last activity.

DATE

LAST_UPDATE_USER

Last update user as provided by the source.

VARCHAR2

20

OFFER_AMOUNT

Offer amount as provided by the source.

VARCHAR2

10

OFFER_DATE

Date associated with offer.

DATE

OFFER_ID

Business identifier for the offer.

NUMBER

10

OFFER_NOTES

Offer notes as provided by the source.

VARCHAR2

254

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE