DW_AWARD_REFERENCE_D (Preview)

This table requires activation of Grants Management functional area. This is table to store the award reference base information

Details

Module: Grants Management

Key Columns

REFERENCE_ID, AWARD_ID, AWD_PROJECT_LNK_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
AWARD_ID NUMBER 38 0 True Foreign Key to Award Header    
AWD_PROJECT_LNK_ID NUMBER 38 0 True Award Project linkage id    
REFERENCE_ID NUMBER 38 0 True Award Reference type    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. System Generated    
REFERENCE_VALUE VARCHAR2 32     Value for the award reference type    
ORIGINAL_FLAG VARCHAR2 16     Original or Derived data flag.    
AWARD_LEVEL_FLAG VARCHAR2 16     Flag to identify if value is set at Award level    
PROJECT_LEVEL_FLAG VARCHAR2 16     Flag to identify if value is set at Project level    

Copyright © 2019, 2024, Oracle and/or its affiliates.