DW_AWARD_SPONSOR_ACCOUNT_D (Preview)

This table requires activation of Grants Management functional area. This table stores the Letter of Credit information for each account of the sponsor.

Details

Module: Grants Management

Key Columns

SPONSOR_ACCOUNT_DETAIL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SPONSOR_ACCOUNT_DETAIL_ID NUMBER 38 0 True The unique identifier for the sponsor account.
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System generated Unique identifier.
SPONSOR_ID NUMBER 38 0 The identifier of the sponsor.
SPONSOR_ACCT_ID NUMBER 38 0 The identifier of the sponsor account.
LOC_NUMBER VARCHAR2 256 Letter of credit number.
LOC_FLAG VARCHAR2 16 Indicates the sponsor account is letter of credit sponsor account.
PRIMARY_FLAG VARCHAR2 16 Indicates if the sponsor account is the primary account.
RELATED_SPONSOR_ID NUMBER 38 0 The identifier of the related sponsor.
RELATED_SPONSOR_ACCT_ID NUMBER 38 0 The identifier of the related sponsor account.
RELATED_LOC_NUMBER VARCHAR2 256 Letter of credit number.
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.