IR AWARD Table
View exposing institutional research award reference records including award identifiers, agency, name, type, level, data source, and review date.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AWARD_AGENCY |
Award agency associated with the record. |
VARCHAR2 |
150 |
AWARD_DATA_SOURCE |
Award data source associated with the record. |
VARCHAR2 |
200 |
AWARD_ID |
Business identifier for the award. |
VARCHAR2 |
30 |
AWARD_LEVEL |
Award level associated with the record. |
VARCHAR2 |
60 |
AWARD_NAME |
Award name associated with the record. |
VARCHAR2 |
100 |
AWARD_NAME_DETAIL |
Award name detail associated with the record. |
VARCHAR2 |
4000 |
AWARD_TYPE |
Award type associated with the record. |
VARCHAR2 |
60 |
GENERAL_TYPE_OF_AWARD |
General type of award associated with the record. |
VARCHAR2 |
100 |
IR_AWARD_KEY |
Surrogate key identifying the ir award. |
VARCHAR2 |
30 |
LAST_DATE_LIST_REVIEWED |
Last date list reviewed associated with the record. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |