RPT_DIM_TM_ACTIVITIES_MV

This table stores the definition of each PPM Activity.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

ACTIVITY_ID

NOT NULL

NUMBER

ID derived from the PPM ITG_ACTIVITIES table

ACTIVITY_NAME

NOT NULL

VARCHAR2(255)

Name of the activity

DESCRIPTION

NULLABLE

VARCHAR2(650)

Description of the activity

ENABLED_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether the activity is enabled

CAPEX_OPEX_ENABLED_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether the Activity can be capitalized. Y indicates that the Activity can be capitalized.

CATEGORY

NULLABLE

VARCHAR2(150)

Indicates the SOP 98-1 Category for the activity.

Indexes

This table uses no indexes.

Sequences

This table uses no sequences.