Share this page

# RPT_FCT_FM_FCST_ACTUAL_CELL

This is a fact table in reporting Star schema that contains the forecast and actual information of financial summary of lifecycle entities, programs, and portfolios. This information is stored at month granularity.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
FACT_ID | NOT NULL | NUMBER | ID derived from the FM_FINANCIAL_LINE_CELLS table
FORECAST_ACTUAL_LINE_ID | NOT NULL | NUMBER | ID of each forecast actual line in a financial summary derived from FM_FORECAST_ACTUAL_LINES table
FORECAST_ACTUAL_ID | NOT NULL | NUMBER | Forecast Actual ID for a specific financial summary derived from FM_FORECAST_ACTUAL_LINES table
FINANCIAL_SUMMARY_ID | NOT NULL | NUMBER | ID for a financial summary the cost are associated with derived from FM_FINANCIAL_SUMMARY
DIRECT_PARENT_ID | NOT NULL | NUMBER | ID for the proposal, project, asset, program, org unit with which this financial summary is associated with. This ID is derived from PFM_LIFECYCLE_PARENT_ENTITY table for current active entity.
DIRECT_PARENT_TYPE | NOT NULL | VARCHAR2(20) | Type of parent entity (project, proposal, asset, program, org unit)
DIRECT_PARENT_NAME | NOT NULL | VARCHAR2(500) | Name of a proposal, project, asset, program, or org unit associated with the financial summary
REGION_ID | NULLABLE | NUMBER | ID of the region with which the cost is associated
PERIOD_ID | NOT NULL | NUMBER | ID of the region with which the cost is associated derived from FM_FINANCIAL_LINE_CELLS table
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 base currency
PLANNED_BASE | NULLABLE | NUMBER | Forecast cost aggregated for a given year, displayed in base currency
PLANNED_LOCAL | NULLABLE | NUMBER | Forecast cost aggregated for a given year, displayed in local currency

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RPT_FCT_FM_FCST_ACTL_CLL_N1 | NONUNIQUE | 1 | PERIOD_ID
RPT_FCT_FM_FCST_ACTL_CLL_N2 | NONUNIQUE | 1 | DIRECT_PARENT_ID
RPT_FCT_FM_FCST_ACTL_CLL_N3 | NONUNIQUE | 1 | FORECAST_ACTUAL_LINE_ID
RPT_FCT_FM_FCST_ACTL_CLL_N4 | NONUNIQUE | 1 | FINANCIAL_SUMMARY_ID
RPT_FCT_FM_FCST_ACTL_CLL_N5 | NONUNIQUE | 1 | REGION_ID
RPT_FCT_FM_FCST_ACTL_CLL_N6 | NONUNIQUE | 1 | DIRECT_PARENT_TYPE

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