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     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.    

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