PPM_RESOURCE_SETTINGS

This table stores the settings for the resources section of a request type, this is set up in the resources tab of a request type.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

RESOURCE_SETTING_ID

NULLABLE

NUMBER

System-generated identifier

ENTITY_ID

NULLABLE

NUMBER

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

ENTITY_PRIMARY_KEY

NULLABLE

NUMBER

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

TRACK_ASSIGNMENTS

NULLABLE

VARCHAR2(10)

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

TRACK_SE

NULLABLE

VARCHAR2(10)

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

TRACK_AE

NULLABLE

VARCHAR2(10)

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

TRACK_AS_AF

NULLABLE

VARCHAR2(10)

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

USE_TM

NULLABLE

VARCHAR2(10)

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

TM_SETTING_ASSGN_TO

NULLABLE

VARCHAR2(10)

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

TM_SETTING_ALL_RES_ON_REQ

NULLABLE

VARCHAR2(10)

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

TM_SETTING_ASSGN_GROUP

NULLABLE

VARCHAR2(10)

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

TM_SETTING_ALL_PARTSPNTS

NULLABLE

VARCHAR2(10)

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

TM_SETTING_STAFF_PROF

NULLABLE

VARCHAR2(10)

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

ASSIGN_TO_VAL_ID

NULLABLE

NUMBER

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

ASSIGN_TO_VAL_NAME

NULLABLE

VARCHAR2(1000)

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

TM_SEC_ALL_USERS

NULLABLE

VARCHAR2(10)

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

TM_SETTING

NULLABLE

VARCHAR2(10)

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

TM_SETTING_ACT_REQD

NULLABLE

VARCHAR2(10)

For the activity restriction feature for request types. Indicates whether an activity is required for a request work-items of this request type.

TM_SETTING_ALL_ACT

NULLABLE

VARCHAR2(10)

For the activity restriction feature for request types. Indicates whether all activities are valid or only a subset. (If subset see KCRT_REQ_TYPE_ACTIVITY_LIST)

TM_SETTING_DEFAULT_ACT

NULLABLE

NUMBER

For the activity restriction feature for request types.Contains activity ID of the default activity (if set).

TM_SETTING_DEFAULT_ACT_NAME

NULLABLE

VARCHAR2(255)

No longer used

Indexes

Index Name

Index Type

Sequence

Column Name

PPM_RESOURCE_SETTINGS_N1

NONUNIQUE

1

ENTITY_ID

PPM_RESOURCE_SETTINGS_N1

NONUNIQUE

2

ENTITY_PRIMARY_KEY

Sequences

Sequence Name

Sequence Type

PPM_RESOURCE_SETTINGS_S

RESOURCE_SETTING_ID