Share this page

# KTMG_OVERRIDE_RULES

This table stores override rules for Time Management.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
WP_TASKS | TASK_ID | WORK_ITEM_ID
KNTA_REGIONS_NLS | REGION_ID | REGION_ID
KDLV_PACKAGES | PACKAGE_ID | WORK_ITEM_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
PM_PROJECTS | PROJECT_ID | WORK_ITEM_SET_ID
KCRT_REQUESTS | REQUEST_ID | WORK_ITEM_ID
KNTA_USERS | USER_ID | BILLING_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | WORK_ITEM_SET_ID
KNTA_SECURITY_GROUPS_NLS | SECURITY_GROUP_ID | BILLING_ID
KWFL_WORKFLOWS_NLS | WORKFLOW_ID | WORK_ITEM_SET_ID
KNTA_SECURITY_GROUPS_NLS | SECURITY_GROUP_ID | APPROVAL_ID
KNTA_USERS | USER_ID | APPROVAL_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
OVERRIDE_RULE_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
ENTITY_LAST_UPDATE_DATE | NOT NULL | DATE | Date a record in the entity was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
OVERRIDE_RULE_NAME | NOT NULL | VARCHAR2(80) | Name of the override rule
DESCRIPTION | NULLABLE | VARCHAR2(240) | Description of the override rule
WORK_ITEM_TYPE_CODE | NULLABLE | VARCHAR2(30) | Type identifier of the work item to which this rule belongs to
WORK_ITEM_SET_ID | NULLABLE | NUMBER | Set identifier of the work set to which the work item belongs to
WORK_ITEM_ID | NULLABLE | NUMBER | Work item identifier that identifies the work item to which the override rule belongs to
DEPARTMENT_CODE | NULLABLE | VARCHAR2(30) | Department identifier that identifies which department the override rule applies to
RESOURCE_TITLE_CODE | NULLABLE | VARCHAR2(30) | Title of the resource to which this override rule belongs to
RATE_UNIT_CODE | NULLABLE | VARCHAR2(30) | Identifier that identifies the rate unit
RATE | NULLABLE | NUMBER | Rate for the override rule
APPROVAL_TYPE_CODE | NULLABLE | VARCHAR2(30) | Identifier that identifies the type of approval for the override rule
APPROVAL_ID | NULLABLE | NUMBER | Identifier for the approval for the override rule
BILLING_TYPE_CODE | NULLABLE | VARCHAR2(30) | Identifier that identifies the type of billing for the override rule
BILLING_ID | NULLABLE | NUMBER | Identifier for the billing of the override rule
OVERRIDE_RESOURCE_CC_FLAG | NULLABLE | VARCHAR2(1) | Flag that determines whether the resource charge code is overridden
OVERRIDE_WORK_ALLOC_CC_FLAG | NULLABLE | VARCHAR2(1) | Flag that determines whether the work allocation charge code is overridden
CHARGE_CODES_UPDATEABLE_FLAG | NULLABLE | VARCHAR2(1) | Flag that determines whether the charge code for the override rule is updateable
CHARGE_CODES_REQUIRED_FLAG | NULLABLE | VARCHAR2(1) | Flag that determines whether a charge code is required for the override rule
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Flag that determines whether the current override rule is enabled
REGION_ID | NULLABLE | NUMBER | Foreign key to region_id on knta_regions table. Used to reference the currency for the rate.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KTMG_OVERRIDE_RULES_N1 | NONUNIQUE | 1 | WORK_ITEM_TYPE_CODE
KTMG_OVERRIDE_RULES_N2 | NONUNIQUE | 1 | WORK_ITEM_SET_ID
KTMG_OVERRIDE_RULES_N3 | NONUNIQUE | 1 | WORK_ITEM_ID
KTMG_OVERRIDE_RULES_N4 | NONUNIQUE | 1 | RESOURCE_TITLE_CODE
KTMG_OVERRIDE_RULES_N5 | NONUNIQUE | 1 | DEPARTMENT_CODE
KTMG_OVERRIDE_RULES_U1 | UNIQUE | 1 | OVERRIDE_RULE_ID
KTMG_OVERRIDE_RULES_U2 | UNIQUE | 1 | OVERRIDE_RULE_NAME

## Sequences

Sequence Name | Sequence Type
--- | ---
KTMG_OVERRIDE_RULES_S | OVERRIDE_RULE_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: