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