RPT_DIM_BUSINESS_OBJ_MV

This is a materialized view representing the Business Objective dimension in the Star schema.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

BUSINESS_OBJECTIVE_ID

NULLABLE

NUMBER

Represents the unique identifier of Business Objective and is derived from PPM KPMO_BUSINESS_OBJECTIVES_NLS table

BUSINESS_OBJECTIVE_NAME

NULLABLE

VARCHAR2(80)

Name of the business objective

ENTITY_ID

NULLABLE

NUMBER

Represents the ID of the Program or Request that is associated with the business objective

ENTITY_TYPE

NULLABLE

VARCHAR2(8)

Indicates whether the business objective is associated with a Program, Project, Proposal, Asset.

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_DIM_BUSINESS_OBJ_MV_N15

NONUNIQUE

1

ENTITY_ID

RPT_DIM_BUSINESS_OBJ_MV_N16

NONUNIQUE

1

ENTITY_TYPE

Sequences

This table uses no sequences.