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.