# DW_AWARD_FUND_ALLOCATION_CF (Preview)

This table requires activation of Grants Management functional area. Table to store the award funding amounts allocated to Award Projects.

## Details

Module: Grants Management

## Key Columns

AWARD_FUND_ALLOCATION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
AWARD_FUND_ALLOCATION_ID | NUMBER | 38 | 0 | True | Primary Key, Unique Identifier of Funding Allocation. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System generated unique identifier |  |
AWARD_FUNDING_ID | NUMBER | 38 | 0 |  | Idenitifier of Award Funding. | DW_AWARD_FUNDING_CF | AWARD_FUNDING_ID
AWARD_ID | NUMBER | 38 | 0 |  | Award id for the funding allocation | 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 |  | Award 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_PARTY_D | PARTY_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 |  |
PROJECT_ID | NUMBER | 38 | 0 |  | ID of the award project association. | DW_PROJECT_D | PROJECT_ID
PROJECT_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Identifier of the business unit associated to the project. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PROJECT_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity assigned to the project. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
PROJECT_CARRYING_OUT_ORG_ID | NUMBER | 38 | 0 |  | The identifier of the organization that is responsible for the project work | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PROJECT_UNIT_ID | NUMBER | 38 | 0 |  | Project unit assigned to the project. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
DOCUMENT_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Award's transaction currency. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
PROJECT_FUNDING_AMOUNT | NUMBER |  |  |  | Funding Amount. |  |
ISSUE_NUMBER | VARCHAR2 | 256 |  |  | Issue Number |  |
ISSUE_TYPE | VARCHAR2 | 32 |  |  | Issue Type (Ex, Base or Supplemental). |  |
ISSUE_DATE | DATE |  |  |  | Issue Date |  |
FUND_ALLOCATION_CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row. |  |
FUND_ALLOCATION_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
FUND_ALLOCATION_UPDATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who last updated the row. |  |
FUND_ALLOCATION_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.