IR AWARD Table
Awards
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AWARD_AGENCY |
The agency which confers the award. Eg. American Physical Society, American Academy of Arts and Letters, CIES (Council for International Exchange of Scholars), Department of Energy, Association for Computing Machinery, David and Lucile Packard Foundation, etc. |
VARCHAR2 |
100 |
AWARD_DATA_SOURCE |
Data source of this award record. |
VARCHAR2 |
200 |
AWARD_ID |
XXX |
VARCHAR2 |
30 |
AWARD_LEVEL |
Level of the award. |
VARCHAR2 |
60 |
AWARD_NAME |
Name of award |
VARCHAR2 |
100 |
AWARD_NAME_DETAIL |
Name of award -- more descriptive than AWARD_NAME. |
VARCHAR2 |
200 |
AWARD_TYPE |
Type of award (Example: Fellowship, Gift, Grant, Contract, Consortium Membership, Cooperative Agreement, etc.) |
VARCHAR2 |
100 |
GENERAL_TYPE_OF_AWARD |
XXX |
VARCHAR2 |
100 |
IR_AWARD_KEY |
Use this field to join together the IR_AWARD and IR_AWARD_HONOR_DETAIL tables. |
VARCHAR2 |
30 |
LAST_DATE_LIST_REVIEWED |
XXX |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |