DW_AWARD_SPONSOR_D (Preview)

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

Details

Module: Grants Management

Key Columns

SPONSOR_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SPONSOR_ID NUMBER 38 0 True Sponsor Unique Identifier    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. System Generated Unique identifier.    
PARTY_ID NUMBER 38 0   Unique identifier for Party.    
SPONSOR_NUMBER VARCHAR2 32     Sponsor Party Number    
SPONSOR_NAME VARCHAR2 512     Sponsor Party Name    
FEDERAL_FLAG VARCHAR2 16     Flag identifying a Federal sponsor    
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, 2024, Oracle and/or its affiliates.