This table requires activation of Grants Management functional area. Table to store Award Funding Summary Information
Module: Grants Management
AWARD_FUNDING_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| AWARD_FUNDING_ID | NUMBER | 38 | 0 | True | Primary Key, Unique Identifier of Funding. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. System generated unique identifier | ||||
| AWARD_ID | NUMBER | 38 | 0 | Award Id for which the funding is made. | DW_AWARD_D | AWARD_ID | |
| BUDGET_PERIOD_ID | NUMBER | 38 | 0 | Budget Period for which the funding is made. | DW_AWARD_BUDGET_PERIOD_D | BUDGET_PERIOD_ID | |
| GMS_AWARD_FUNDING_SRC_ID | NUMBER | 38 | 0 | Award Funding Source Id | DW_GMS_AWARD_FUNDING_SRC_D | GMS_AWARD_FUNDING_SRC_ID | |
| FUNDING_SOURCE_ID | NUMBER | 38 | 0 | FUNDING_SOURCE_ID | DW_AWARD_FUNDING_SOURCE_D | FUNDING_SOURCE_ID | |
| AWARD_BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Business Unit Id | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| AWARD_LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal Entity Identifier of Award. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
| AWARD_LEDGER_ID | NUMBER | 38 | 0 | Award ledger identifier. | DW_LEDGER_D | LEDGER_ID | |
| AWARD_OWNING_ORG_ID | NUMBER | 38 | 0 | Award Owning Organization | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| INSTITUTION_ID | NUMBER | 38 | 0 | Awarded Institution | DW_AWARD_INSTITUTION_D | INSTITUTION_ID | |
| SPONSOR_ID | NUMBER | 38 | 0 | Sponsor Unique identifier | DW_AWARD_SPONSOR_D | SPONSOR_ID | |
| SPONSOR_PARTY_ID | NUMBER | 38 | 0 | Sponsor Party Identifier. | DW_AWARD_SPONSOR_D | SPONSOR_ID | |
| FISCAL_PERIOD_TYPE | VARCHAR2 | 32 | GL Period Name for the award ledger. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | The GL period type in which the transaction is posted. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
| FISCAL_PERIOD_NAME | VARCHAR2 | 16 | GL Calendar Name for the award ledger. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
| BUDGET_PERIOD_START_DATE | DATE | Start Date of the Budget Period | |||||
| DOCUMENT_CURRENCY_CODE | VARCHAR2 | 16 | Award's transaction currency. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| DIRECT_FUNDING_AMOUNT | NUMBER | Direct Funding Amount | |||||
| INDIRECT_FUNDING_AMOUNT | NUMBER | Indirect Funding Amount | |||||
| ISSUE_NUMBER | VARCHAR2 | 256 | Issue Number | ||||
| ISSUE_TYPE | VARCHAR2 | 32 | Issue Type (Ex, Base or Supplemental). | ||||
| ISSUE_DATE | DATE | Issue Date | |||||
| AWARD_FUNDING_CREATED_BY | VARCHAR2 | 128 | Who column: indicates the user who created the row. | ||||
| AWARD_FUNDING_CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| AWARD_FUNDING_UPDATED_BY | VARCHAR2 | 128 | Who column: indicates the user who last updated the row. | ||||
| AWARD_FUNDING_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.