This table requires activation of Grants Management functional area. This table stores Project Awards Details.
Module: Grants Management
AWARD_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| AWARD_ID | NUMBER | 38 | 0 | True | Primary Key, Unique identifier of award header | ||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. System genrated unique key. | ||||
| BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Business Unit Id | |||
| SPONSOR_ID | NUMBER | 38 | 0 | Sponsor Party Id (From GMS_SPONSORS table) | |||
| AWARD_OWNING_ORG_ID | NUMBER | 38 | 0 | Award Owning Organization | |||
| INSTITUTION_ID | NUMBER | 38 | 0 | Awarded Institution | |||
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal Entity Identifier of Award. | |||
| AWARD_PURPOSE_CODE | VARCHAR2 | 32 | Award Purpose | ||||
| AWARD_TYPE | VARCHAR2 | 32 | Award Type | ||||
| SPONSOR_AWARD_NUMBER | VARCHAR2 | 32 | Sponsor Award Number | ||||
| AWARD_NUMBER | VARCHAR2 | 128 | Contract number of contract. | ||||
| CURRENCY_CODE | VARCHAR2 | 16 | Contract's transaction currency. | ||||
| STATUS_CODE | VARCHAR2 | 32 | User status of the contract. | ||||
| AWARD_START_DATE | DATE | Start date of contract. | |||||
| AWARD_END_DATE | DATE | End date of contract. | |||||
| VALIDATE_STATUS | VARCHAR2 | 16 | Validation Status, N -- for Not validated, C -- Clean, E -- Error, W -- Warning, P -- Pending Calendar Update. | ||||
| EXPANDED_AUTH_FLAG | VARCHAR2 | 16 | Expanded authority flag | ||||
| IS_INTELL_PROP_REPORTED | VARCHAR2 | 16 | Intellectual Property Reported Flag | ||||
| CLOSE_DATE | DATE | Award Close Date | |||||
| PRE_AWARD_DATE | DATE | Pre-award spending date | |||||
| PRE_AWARD_SPENDING_ALLOWED | VARCHAR2 | 16 | Previous Award - Spending Allowed Flag | ||||
| PREV_AWARD_ID | NUMBER | 38 | 0 | Previous award ID | |||
| PREV_AWARD_RENEWAL_INPRG | VARCHAR2 | 16 | Previous award Renewal In Progress Flag | ||||
| PREV_AWARD_ABR | VARCHAR2 | 16 | Previous award - Accomplishment Based Renewal | ||||
| PREV_AWARD_BU | NUMBER | 38 | 0 | Previous award Business Unit | |||
| FLOW_THROUGH_FROM_DATE | DATE | Flow Through - From Date | |||||
| FLOW_THROUGH_PRIMARY_SPONSOR | NUMBER | 38 | 0 | Flow Through - Primary Sponsor | |||
| FLOW_THROUGH_IS_FEDERAL | VARCHAR2 | 16 | Flow Through - Is Federal Flag | ||||
| FLOW_THROUGH_TO_DATE | DATE | Flow Through - To Date | |||||
| FLOW_THROUGH_AMOUNT | NUMBER | Flow Through - Amount | |||||
| COI_INST_POLICY_COMPLIANT | VARCHAR2 | 16 | Conflict Of Interest Policy Compliance Flag | ||||
| COI_REVIEW_COMPLETED | VARCHAR2 | 16 | Conflict Of Interest Review Completion Status | ||||
| IDC_SCHEDULE_ID | NUMBER | 38 | 0 | Award default burden schedule | |||
| COST_IND_SCH_FIXED_DATE | DATE | Indirect Cost schedule fixed date | |||||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. |
Copyright © 2019, 2024, Oracle and/or its affiliates.