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