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

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