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 This column is for Oracle Internal use only. 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.