DW_AWARD_D

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