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

AWARD_ID, AWD_PROJECT_LNK_ID, REFERENCE_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 512 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