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.