DW_AWARD_D (Preview)

This table requires activation of Grants Management functional area. This table stores Project Awards Details.

Details

Module: Grants Management

Key Columns

AWARD_ID

Columns

Columns
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.