Share this page

# 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

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: