TM_PENDING_APPROVERS_EVALS

This table stores pending records that are waiting for the Evaluate TM Approvers Service that will update any change needed in the possible approvers for any time sheet.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KCRT_REQUESTS

REQUEST_ID

OVR_WORK_ITEM_ID

WP_TASKS

TASK_ID

OVR_WORK_ITEM_ID

KDLV_PACKAGES

PACKAGE_ID

OVR_WORK_ITEM_ID

PM_PROJECTS

PROJECT_ID

OVR_WORK_ITEM_SET_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

OVR_WORK_ITEM_SET_ID

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

OVR_WORK_ITEM_SET_ID

Column Descriptions

Column Name

Null?

Data Type

Description

ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually.

SOURCE_TYPE

NOT NULL

VARCHAR2(255)

Type of the source of the change. Can be either resource, override rules, or project settings.

SOURCE_ID

NULLABLE

VARCHAR2(255)

ID of the source of this change. Can be either resource id, override rule ID or project ID

TIME_APPROVER_TYPE

NULLABLE

VARCHAR2(1)

Y if the change is for time approvers, N if not.

BILLING_APPROVER_TYPE

NULLABLE

VARCHAR2(1)

Y if the change is for billing approvers, N if not.

OVR_WORK_ITEM_TYPE

NULLABLE

VARCHAR2(255)

Used only if the source if override rule, to specify the work item type of this override rule.

OVR_WORK_ITEM_SET_ID

NULLABLE

VARCHAR2(255)

Used only if the source if override rule, to specify the work item set ID of this override rule.

OVR_WORK_ITEM_ID

NULLABLE

VARCHAR2(255)

Used only if the source if override rule, to specify the work item ID of this override rule.

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date when the 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 when the record was last updated
IN_PROCESS NULLABLE VARCHAR2(1)  

Indexes

Index Name

Index Type

Sequence

Column Name

TM_PENDING_APPROVERS_EVALS_U1

NONUNIQUE

1

ID
TM_PENDING_APPROVERS_EVALS_N1 NONUNIQUE 1 SOURCE_TYPE
TM_PENDING_APPROVERS_EVALS_N1 NONUNIQUE 2 SOURCE_ID

Sequences

Sequence Name

Sequence Type

TM_PENDING_APPROVERS_EVALS_S

ID