IR AWARD HONOR DETAIL Table
View exposing institutional research award and honor detail records by person and award including discipline references, award year, joint award indicators, institutional affiliation at time of award, and related attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AWARD_2ND_DISCIPLINE_ID |
Business identifier for the award 2nd discipline. |
VARCHAR2 |
30 |
AWARD_3RD_DISCIPLINE_ID |
Business identifier for the award 3rd discipline. |
VARCHAR2 |
30 |
AWARD_HONOR_COUNT |
Award honor count associated with the record. |
NUMBER |
|
AWARD_HONOR_DATA_SOURCE |
Award honor data source associated with the record. |
VARCHAR2 |
200 |
AWARD_WEBPAGE_URL |
Award webpage url associated with the record. |
VARCHAR2 |
200 |
DATE_UPDATED |
Date updated associated with the record. |
DATE |
|
DEPARTMENT_TIME_OF_AWARD |
Department time of award associated with the record. |
VARCHAR2 |
120 |
INSTITUTION_TIME_OF_AWARD |
Institution time of award associated with the record. |
VARCHAR2 |
120 |
IR_AWARD_DISCIPLINE_KEY |
Surrogate key identifying the ir award discipline. |
VARCHAR2 |
30 |
IR_AWARD_KEY |
Surrogate key identifying the ir award. |
VARCHAR2 |
30 |
IR_AWARD_PERSON_KEY |
Surrogate key identifying the ir award person. |
VARCHAR2 |
20 |
JOINT_AWARD_INFO |
Joint award info associated with the record. |
VARCHAR2 |
200 |
POSITION_STATUS_TIME_OF_AWARD |
Position status time of award associated with the record. |
VARCHAR2 |
120 |
RECORD_CREATED_DATE |
The date when the record was created. |
DATE |
|
RECORD_MODIFIED_DATE |
The date when the record was last modified. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
YEAR_AWARDED |
Year awarded associated with the record. |
VARCHAR2 |
10 |