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.
