ITG_ACTIVITIES
This table stores the definitions for activities.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KNTA_USERS |
USER_ID |
CREATED_BY |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
ACTIVITY_ID |
NOT NULL |
NUMBER |
System-generated identifier |
VERSION |
NOT NULL |
NUMBER |
System-generated version for the entity. This column must not be updated manually |
ACTIVITY_NAME |
NOT NULL |
VARCHAR2(255) |
Defines the name given to this activity |
DESCRIPTION |
NULLABLE |
VARCHAR2(650) |
Describes the activity. |
ENABLED_FLAG |
NULLABLE |
VARCHAR2(1) |
Indicates whether the activity is enabled |
CATEGORY_CODE |
NULLABLE |
VARCHAR2(255) |
SOP 98-1 Category for the activity |
CAPEX_OPEX_ENABLED_FLAG |
NULLABLE |
VARCHAR2(1) |
Indicates whether the activity can be capitalized. Y indicates that the activity can be capitalized. |
IS_USED_FOR_REQUEST |
NULLABLE |
VARCHAR2(1) |
Indicates whether the activity can be used for requests |
IS_USED_FOR_ASSET |
NULLABLE |
VARCHAR2(1) |
Indicates whether the activity can be used for assets |
IS_USED_FOR_PACKAGE |
NULLABLE |
VARCHAR2(1) |
Indicates whether the activity can be used for packages |
IS_USED_FOR_PROJECT |
NULLABLE |
VARCHAR2(4) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
IS_USED_FOR_TASK |
NULLABLE |
VARCHAR2(4) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
IS_USED_FOR_MISC |
NULLABLE |
VARCHAR2(1) |
Indicates whether the activity can be used for miscellaneous items. |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
DEFINITION_LANGUAGE |
NOT NULL |
VARCHAR2(40) |
Default definition language |
IS_USED_FOR_ITG |
NOT NULL |
VARCHAR2(1) |
(Added in 9.22) Flag to show whether this activity can be used on External Data items in time sheet |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
SYS_C005200169 |
UNIQUE |
1 |
ACTIVITY_NAME |
SYS_C005201533 |
UNIQUE |
1 |
ACTIVITY_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
ITG_ACTIVITIES_S |
ACTIVITY_ID |