Share this page

# 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: