Share this page

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

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: