ADM GRAD FUNDING OFFER CHR Table
View exposing graduate funding offer characteristic reference data including offer period, length, type, source, value, and status attributes used for graduate admissions funding reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADM_GRAD_FUNDING_OFFER_CHR_KEY |
Surrogate key identifying the adm grad funding offer chr. |
VARCHAR2 |
58 |
IS_INITIAL_OFFER |
Indicator identifying whether initial offer (Y/N). |
VARCHAR2 |
1 |
IS_LATEST_OFFER |
Indicator identifying whether latest offer (Y/N). |
VARCHAR2 |
1 |
OFFER_LENGTH |
Offer length as provided by the source. |
VARCHAR2 |
30 |
OFFER_LENGTH_CODE |
Code identifying offer length. |
VARCHAR2 |
10 |
OFFER_PERIOD |
Offer period as provided by the source. |
VARCHAR2 |
30 |
OFFER_PERIOD_CODE |
Code identifying offer period. |
VARCHAR2 |
10 |
OFFER_SOURCE |
Offer source as provided by the source. |
VARCHAR2 |
10 |
OFFER_STATUS |
Offer status as provided by the source. |
VARCHAR2 |
30 |
OFFER_STATUS_CODE |
Code identifying offer status. |
VARCHAR2 |
10 |
OFFER_TYPE |
Offer type as provided by the source. |
VARCHAR2 |
50 |
OFFER_TYPE_CODE |
Code identifying offer type. |
VARCHAR2 |
10 |
OFFER_VALUE |
Offer value as provided by the source. |
VARCHAR2 |
30 |
OFFER_VALUE_CODE |
Code identifying offer value. |
VARCHAR2 |
10 |
OFFER_VALUE_PERCENT |
Offer value percent as provided by the source. |
NUMBER |
10,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |