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