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 | 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 | ||||
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 | ||||
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, 2023, Oracle and/or its affiliates.