RPT_DIM_FM_KNTA_LOOKUPS_MV
This is a materialized view on top of PPM's KNTA_LOOKUPS table with additional logic for BUDGET_LABOR_CATEGORY, BUDGET_TYPE,BUDGET_EXPENSE_TYPE lookup types.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
CATEGORY_CODE |
NULLABLE |
VARCHAR2(40) |
Labor category code or expense type category code |
CATEGORY_NAME |
NULLABLE |
VARCHAR2(150) |
Labor category name or expense type category name |
EXPENSE_TYPE_CODE |
NULLABLE |
VARCHAR2(40) |
Expense type code of the forecast actual line |
EXPENSE_TYPE_NAME |
NULLABLE |
VARCHAR2(150) |
Expense type name of the forecast actual line |
LABOR_TYPE_CODE |
NULLABLE |
VARCHAR2(40) |
Labor type code of the forecast actual line |
LABOR_TYPE_NAME |
NULLABLE |
VARCHAR2(150) |
Labor type name of the forecast actual line |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
RPT_DIM_FM_KNTA_LKUPS_MV_X1 |
NONUNIQUE |
1 |
EXPENSE_TYPE_CODE |
RPT_DIM_FM_KNTA_LKUPS_MV_X2 |
NONUNIQUE |
1 |
CATEGORY_CODE |
RPT_DIM_FM_KNTA_LKUPS_MV_X3 |
NONUNIQUE |
1 |
LABOR_TYPE_CODE |
Sequences
This table uses no sequences.