DW_AWARD_FUNDING_SOURCE_D (Preview)

This table requires activation of Grants Management functional area. This table stores Funding Source Details.

Details

Module: Grants Management

Key Columns

FUNDING_SOURCE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FUNDING_SOURCE_ID NUMBER 38 0 True FUNDING_SOURCE_ID - Primary key    
SOURCE_RECORD_ID VARCHAR2 256     System    
FUNDING_SOURCE_NUMBER VARCHAR2 64     Unique Funding Source Number for each funding source    
FUNDING_SOURCE_TYPE VARCHAR2 16     TYPE specifies whether it is an external('S') or internal organisation('O') or internal named funding source ('N').    
SOURCE_ID NUMBER 38 0   SOURCE_ID specifies the PARTY_ID of external sponsor or the ORGANISATION_ID of internal Organisation    
FUNDING_SOURCE_STATUS VARCHAR2 32     Fundling source status    
START_DATE_ACTIVE DATE       Specifies the date from which Named Funding Source is active    
END_DATE_ACTIVE DATE       Specifies the date until the Named Funding Source is active    
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.