Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: