Share this page

# FM_FORECAST_ACTUALS

The table stores the data for the forecast actuals linked to a financial summary.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
FM_USER_DATA | USER_DATA_ID | USER_DATA_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
FORECAST_ACTUAL_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.
SHOW_ACTUALS_FLAG | NOT NULL | VARCHAR2(1) | Used for UI to show actuals when the screen loads. In PPM Center 8.00, used for the default state. After first load, settings are stored elsewhere. This is ported over from PPM Center 7.5
VIEW_BY_PERIOD_TYPE_ID | NOT NULL | NUMBER | Used for UI to show the data by period type (month, quarter) when the screen loads up. In PPM Center 8.00, used for the default state. After first load, settings are stored elsewhere. This is ported over from PPM Center 7.5. YEAR(6, 1, "Y"), HALF_YEAR(7, 2, "HY"), QUARTER(5, 3, "Q"), MONTH(4, 4, "M"), WEEK(8, 5, "W"); in FiscalPeriodType.
ACTUAL_ROLL_UP_CODE | NOT NULL | VARCHAR2(30) | Indicates whether the actuals for the entity are entered manually by the user or are rolled up and so cannot be modified directly by the user.
CAPEX_OPEX_ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Indicates whether the costs and actuals are tracked by capitalization. The setting is "Financial Summary tracks capitalized costs".
USER_DATA_ID | NULLABLE | NUMBER | References any user data at the Forecast Actual level, if any. Referenced by FM_USER_DATA

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FM_FORECAST_ACTUALS_PK | UNIQUE | 1 | FORECAST_ACTUAL_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
FM_FORECAST_ACTUALS_S | FORECAST_ACTUAL_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: