Share this page

# RPT_DIM_FM_FCST_ACTUAL_LINE_MV

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

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
FORECAST_ACTUAL_LINE_ID | NOT NULL | NUMBER | Forecast actual ID for a financial summary derived from FM_FORECAST_ACTUAL_LINES table.
EXPENSE_TYPE_CODE | NULLABLE | VARCHAR2(30) | Indicates the expense type (capital or operating)
LABOR_TYPE_CODE | NOT NULL | VARCHAR2(30) | Labor type (labor or non-labor)
CATEGORY_CODE | NOT NULL | VARCHAR2(30) | Indicates the cost category
SYNC_SOURCE_FLAG | NULLABLE | VARCHAR2(10) | Identifies rolled up lines and lines that are not rolled up. 'N' indicates that the line is not rolled up. 'SP' indicates that the line is rolled up from the staffing profile. 'FS' indicates that the line is rolled up from financial summaries belong to
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_LIN_MV_PK | UNIQUE | 1 | FORECAST_ACTUAL_LINE_ID
RPT_DIM_FM_FCST_ACTL_LIN_MV_X1 | NONUNIQUE | 1 | EXPENSE_TYPE_CODE
RPT_DIM_FM_FCST_ACTL_LIN_MV_X2 | NONUNIQUE | 1 | CATEGORY_CODE
RPT_DIM_FM_FCST_ACTL_LIN_MV_X3 | NONUNIQUE | 1 | LABOR_TYPE_CODE

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