Share this page

# FM_FORECAST_ACTUAL_PERIOD_SUM

This table stores the sum by monthly period, projected totals and breakdowns by category for each forecast actual. The sums are calculated both synchronously on forecast actual save and by the cost rollup service. In addition, recalculation may be triggered by web services.

The user always edits forecast actual values in financial summary local currency and the conversions with exchange rate applications are done on the fly. All values are stored here for faster retrieval. Values are used by other modules such as cost-based portlets. If the financial summary does not track capitalized costs, all values are considered operational by default. The period of -1 for a forecast actual is used to indicate the grand totals of all the other values. That is also the final projected total for the entity.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
FM_FORECAST_ACTUALS | FORECAST_ACTUAL_ID | FORECAST_ACTUAL_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
PPM_FISCAL_PERIODS_NLS | FISCAL_PERIOD_ID | PERIOD_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
FORECAST_ACTUAL_PERIOD_SUM_ID | NOT NULL | NUMBER | System-generated identifier
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_DATE | NOT NULL | DATE | Date record was created
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually.
ACTUAL_CAPEX_TOTAL_BSE | NULLABLE | NUMBER | Total for the capitalized actuals in system base currency for the monthly period referenced by this row. This is across all labor and non-labor types.
ACTUAL_CAPEX_TOTAL_LCL | NULLABLE | NUMBER | Total for the capitalized actuals in financial summary local currency for the monthly period referenced by this row. This is across all labor and non-labor types.
ACTUAL_LABOR_TOTAL_BSE | NULLABLE | NUMBER | Total for the labor actuals in system base currency for the monthly period referenced by this row. This is across all expense types like capitalized or operational.
ACTUAL_LABOR_TOTAL_LCL | NULLABLE | NUMBER | Total for the labor actuals in financial summary local currency for the monthly period referenced by this row. This is across all expense types like capitalized or operational.
ACTUAL_NONLABOR_TOTAL_BSE | NULLABLE | NUMBER | Total for the non-labor actuals in system base currency for the monthly period referenced by this row. This is across all expense types like capitalized or operational.
ACTUAL_NONLABOR_TOTAL_LCL | NULLABLE | NUMBER | Total for the non-labor actuals in financial summary local currency for the monthly period referenced by this row. This is across all expense types like capitalized or operational.
ACTUAL_OPEX_TOTAL_BSE | NULLABLE | NUMBER | Total for the operational actuals in system base currency for the monthly period referenced by this row. This is across all labor and non-labor types.
ACTUAL_OPEX_TOTAL_LCL | NULLABLE | NUMBER | Total for the operational actuals in financial summary local currency for the monthly period referenced by this row. This is across all labor and non-labor types.
ACTUAL_TOTAL_BSE | NULLABLE | NUMBER | Total of all actual values in system base currency (versus forecast values) for the monthly period referenced by this row.
ACTUAL_TOTAL_LCL | NULLABLE | NUMBER | Total of all actual values in financial summary local currency (versus forecast values) for the monthly period referenced by this row.
CAPEX_PROJECTED_TOTAL | NULLABLE | NUMBER | Projected total for the capitalized costs (actuals and forecasted) in system base currency for the monthly period referenced by this row.
FORECAST_ACTUAL_ID | NOT NULL | NUMBER | Forecast actual that this period sum is for. Referenced by the FM_FORECAST_ACTUALS table.
OPEX_PROJECTED_TOTAL | NULLABLE | NUMBER | Projected total for the operational costs (actuals and forecasted) in system base currency for the monthly period referenced by this row.
FISCAL_PERIOD_ID | NOT NULL | NUMBER | Period that this row refers to. Referenced by PPM_FISCAL_PERIODS
PLAN_CAPEX_TOTAL_BSE | NULLABLE | NUMBER | Total for the capitalized planned values in system base currency for the monthly period referenced by this row. This is across all labor and non-labor types.
PLAN_CAPEX_TOTAL_LCL | NULLABLE | NUMBER | Total for the capitalized planned values in financial summary local currency for the monthly period referenced by this row. This is across all labor and non-labor types.
PLAN_LABOR_TOTAL_BSE | NULLABLE | NUMBER | Total for the labor planned values in system base currency for the monthly period referenced by this row. This is across all expense types like capitalized or operational.
PLAN_LABOR_TOTAL_LCL | NULLABLE | NUMBER | Total for the labor planned values in financial summary local currency for the monthly period referenced by this row. This is across all expense types like capitalized or operational.
PLAN_NONLABOR_TOTAL_BSE | NULLABLE | NUMBER | Total for the non-labor planned values in system base currency for the monthly period referenced by this row. This is across all expense types like capitalized or operational.
PLAN_NONLABOR_TOTAL_LCL | NULLABLE | NUMBER | Total for the non-labor planned values in financial summary local currency for the monthly period referenced by this row. This is across all expense types like capitalized or operational.
PLAN_OPEX_TOTAL_BSE | NULLABLE | NUMBER | Total for the operational planned values in system base currency for the monthly period referenced by this row. This is across all labor and non-labor types.
PLAN_OPEX_TOTAL_LCL | NULLABLE | NUMBER | Total for the operational planned values in financial summary local currency for the monthly period referenced by this row. This is across all labor and non-labor types.
PLAN_TOTAL_BSE | NULLABLE | NUMBER | Total of all planned values in system base currency (versus forecast values) for the monthly period referenced by this row.
PLAN_TOTAL_LCL | NULLABLE | NUMBER | Total of all planned values in financial summary local currency (versus forecast values) for the monthly period referenced by this row.
PROJECTED_TOTAL | NULLABLE | NUMBER | Overall projected total in system base currency for the monthly period. If the period ID is -1, then this is the projected total for the entire Financial Summary.
SEQ | NOT NULL | NUMBER | Period sequence, tied to the sequence in PPM_FISCAL_PERIODS.
PLAN_CAPEX_LABOR_LCL | NULLABLE | NUMBER | Total for the capitalized labor planned values in financial summary local currency for the monthly period.
PLAN_CAPEX_LABOR_BSE | NULLABLE | NUMBER | Total for the capitalized labor planned values in system base currency for the monthly period.
PLAN_OPEX_LABOR_LCL | NULLABLE | NUMBER | Total for the operational labor planned values in financial summary local currency for the monthly period.
PLAN_OPEX_LABOR_BSE | NULLABLE | NUMBER | Total for the operational labor planned values in system base currency for the monthly period.
PLAN_CAPEX_NONLABOR_LCL | NULLABLE | NUMBER | Total for the capitalized non-labor planned values in financial summary local currency for the monthly period.
PLAN_CAPEX_NONLABOR_BSE | NULLABLE | NUMBER | Total for the capitalized non-labor planned values in system base currency for the monthly period.
PLAN_OPEX_NONLABOR_LCL | NULLABLE | NUMBER | Total for the operational non-labor planned values in financial summary local currency for the monthly period.
PLAN_OPEX_NONLABOR_BSE | NULLABLE | NUMBER | Total for the operational non-labor planned values in system base currency for the monthly period.
ACTUAL_CAPEX_LABOR_LCL | NULLABLE | NUMBER | Total for the capitalized labor actuals in financial summary local currency for the monthly period.
ACTUAL_CAPEX_LABOR_BSE | NULLABLE | NUMBER | Total for the capitalized labor actuals in system base currency for the monthly period.
ACTUAL_OPEX_LABOR_LCL | NULLABLE | NUMBER | Total for the operational labor actuals in financial summary local currency for the monthly period.
ACTUAL_OPEX_LABOR_BSE | NULLABLE | NUMBER | Total for the operational labor actuals in system base currency for the monthly period.
ACTUAL_CAPEX_NONLABOR_LCL | NULLABLE | NUMBER | Total for the capitalized non-labor actuals in financial summary local currency for the monthly period.
ACTUAL_CAPEX_NONLABOR_BSE | NULLABLE | NUMBER | Total for the capitalized non-labor actuals in system base currency for the monthly period.
ACTUAL_OPEX_NONLABOR_LCL | NULLABLE | NUMBER | Total for the operational non-labor actuals in financial summary local currency for the monthly period.
ACTUAL_OPEX_NONLABOR_BSE | NULLABLE | NUMBER | Total for the operational non-labor actuals in system base currency for the monthly period.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FK_FM_FAPS_FORECAST_ACTUAL_I | NONUNIQUE | 1 | FORECAST_ACTUAL_ID
FK_FM_FAPS_PERIOD_I | NONUNIQUE | 1 | FISCAL_PERIOD_ID
FK_FM_FAPS_SEQ_I | NONUNIQUE | 1 | SEQ
SYS_C005201528 | UNIQUE | 1 | FORECAST_ACTUAL_PERIOD_SUM_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
FM_FA_PERIOD_SUM_S | FORECAST_ACTUAL_PERIOD_SUM_ID

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: