RPT_FCT_FM_FA_APPROVED_MV
This is a fact table in reporting Star schema that contains the approved budget, forecast and actual information of financial summary of lifecycle entities, programs, portfolios, and org units. This information is stored at year granularity.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
FINANCIAL_SUMMARY_ID |
NULLABLE |
NUMBER |
ID of a financial summary derived from RPT_FCT_FM_APPROVED_BUDGETS table. |
FORECAST_ACTUAL_ID |
NULLABLE |
NUMBER |
Forecast Actual ID for a financial summary. |
DIRECT_PARENT_ID |
NULLABLE |
NUMBER |
ID of the financial entity that this financial summary belongs to (Project / Proposal / Asset / Program). |
DIRECT_PARENT_TYPE |
NULLABLE |
VARCHAR2(20) |
Proposal, Project, Asset, Program |
DIRECT_PARENT_NAME |
NULLABLE |
VARCHAR2(500) |
Name of the financial entity (project, proposal, asset, or program) to which this financial summary belongs. |
REGION_ID |
NULLABLE |
NUMBER |
ID of the region with which the cost is associated |
PERIOD_ID |
NULLABLE |
NUMBER |
ID of the Proposal/Project/Asset/Program/org units to which this Financial Summary belongs |
APPROVED_BASE |
NULLABLE |
NUMBER |
Approved cost aggregated for a given year, displayed in base currency |
APPROVED_LOCAL |
NULLABLE |
NUMBER |
Approved cost aggregated for a given year, displayed in local currency |
FORECAST_BASE |
NULLABLE |
NUMBER |
Forecast cost aggregated for a given year, displayed in base currency |
FORECAST_LOCAL |
NULLABLE |
NUMBER |
Forecast cost aggregated for a given year, displayed in local currency |
ACTUAL_BASE |
NULLABLE |
NUMBER |
Actual cost aggregated for a given year, displayed in base currency |
ACTUAL_LOCAL |
NULLABLE |
NUMBER |
Actual cost aggregated for a given year, displayed in local currency |
CAPEX_APPROVED_BASE |
NULLABLE |
NUMBER |
Approved capital cost aggregated for a given year, displayed in base currency |
CAPEX_APPROVED_LOCAL |
NULLABLE |
NUMBER |
Approved capital cost aggregated for a given year, displayed in local currency |
OPEX_APPROVED_BASE |
NULLABLE |
NUMBER |
Approved operating cost aggregated for a given year, displayed in local currency |
OPEX_APPROVED_LOCAL |
NULLABLE |
NUMBER |
Approved operating cost aggregated for a given year, displayed in base currency |
Indexes
This table uses no indexes.
Sequences
This table uses no sequences.