This table requires activation of Grants Management functional area. This table stores Funding Source Details.
Module: Grants Management
FUNDING_SOURCE_ID
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. |
Copyright © 2019, 2024, Oracle and/or its affiliates.