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.