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, 2024, Oracle and/or its affiliates.