RPT_DIM_FM_FCST_ACTUAL_MV

This is a materialized view on top of PPM's FM_FORECAST_ACTUALS table.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

FORECAST_ACTUAL_ID

NOT NULL

NUMBER

ID derived from FM_FORECAST_ACTUALS table.

CAPEX_OPEX_ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether the costs and actuals are tracked by capitalization as well. The setting is "Financial Summary tracks capitalized costs".

USER_DATA_1-20

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_1_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_2_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_3_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_4_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_5_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_6_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_7_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_8_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_9_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_10_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_11_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_12_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_13_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_14_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_15_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_16_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_17_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_18_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_19_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

USER_DATA_20_VISIBLE

NULLABLE

VARCHAR2(255)

User data segment

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_DIM_FM_FCST_ACTL_MV_PK

UNIQUE

1

FORECAST_ACTUAL_ID

Sequences

This table uses no sequences.