Share this page

# TM_TIME_SHEET_LINES

This table stores the list of items added to each time sheet.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | ACTUAL_APPROVER_USER_ID
ITG_TRUSTEE | TRUSTEE_ID | BASE_TRUSTEE_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_SECURITY_GROUPS_NLS | SECURITY_GROUP_ID | SECURITY_GROUP_ID
TM_TIME_SHEETS | TIME_SHEET_ID | TIME_SHEET_ID
WP_TASKS | TASK_ID | WORK_ITEM_ID
KCRT_REQUESTS | REQUEST_ID | WORK_ITEM_ID
KDLV_PACKAGES | PACKAGE_ID | WORK_ITEM_ID
KWFL_WORKFLOWS_NLS | WORKFLOW_ID | WORK_ITEM_SET_ID
PM_PROJECTS | PROJECT_ID | WORK_ITEM_SET_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | WORK_ITEM_SET_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TIME_SHEET_LINE_ID | NOT NULL | NUMBER | System-generated identifier
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually
TIME_SHEET_ID | NOT NULL | NUMBER | Identifies the time sheet that this item belongs to.
WORK_ITEM_ID | NULLABLE | VARCHAR2(255) | Identifies the item that this line represents. Valid values represent Request IDs, Package IDs, Task IDs, and Miscellaneous Items.
WORK_ITEM_SET_ID | NULLABLE | VARCHAR2(255) | Identifies the parent type of the item. Valid values represent Request Types, Workflows, Projects, and Miscellaneous Items.
WORK_ITEM_TYPE | NULLABLE | VARCHAR2(255) | Indicates the type of item. Valid values are REQUEST, PACKAGE, TASK, PROJECT, and MISC.
BASE_TRUSTEE_ID | NULLABLE | NUMBER | Identifies the time approver of the time sheet item if it is configured to be a participant group.
SECURITY_GROUP_ID | NULLABLE | NUMBER | Identifies the time approver of the time sheet item if it is configured to be a Security Group.
STATE | NULLABLE | NUMBER | Defines the current state of the time sheet item.
EDIT_ACTIVITY_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether Activities are editable for this particular item.
CHARGE_CODES_UPDATEABLE_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether charge codes are updateable for this particular item.
CHARGE_CODES_REQUIRED_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether charge codes are required to be configured on this item.
EFFORT_ON_WORK_ITEM_ENTITY | NULLABLE | VARCHAR2(1) | A flag to determine if actuals should be synchronized to the PM tasks (pushed or removed) or not, if they are already in synchronization.
CREATION_SOURCE_CODE | NULLABLE | VARCHAR2(255) | Contains the creation source of this line item.
ACTUAL_APPROVER_USER_ID | NULLABLE | NUMBER | References the USER_ID in KNTA_USERS of the user who approved the line item.
TM_WORK_UNIT_ID | NULLABLE | NUMBER | ID of the corresponding work unit from TM_WORK_UNITS
USER_DATA1-20 | NULLABLE | VARCHAR2(255) | User data segment
VISIBLE_USER_DATA1-20 | NULLABLE | VARCHAR2(255) | User data segment
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_DATE | NOT NULL | DATE | Date 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 record was last updated
TIME_SHEET_LINE_SEQ | NULLABLE | NUMBER | Contains the internal sequence of lines for a time sheet.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FK3F7A26B35BD31FCB_I | NONUNIQUE | 1 | BASE_TRUSTEE_ID
FK3F7A26B3FCB0930C_I | NONUNIQUE | 1 | TIME_SHEET_ID
FK3F7A26B3FE01C679_I | NONUNIQUE | 1 | SECURITY_GROUP_ID
FK3F7A26B3FE17B54F_I | NONUNIQUE | 1 | TM_WORK_UNIT_ID
FK3F7A26B3FF595611_I | NONUNIQUE | 1 | ACTUAL_APPROVER_USER_ID
SYS_C00109356191 | UNIQUE | 1 | TIME_SHEET_LINE_ID
TM_TIME_SHEET_LINES_N1 | NONUNIQUE | 1 | WORK_ITEM_ID
TM_TIME_SHEET_LINES_N1 | NONUNIQUE | 2 | WORK_ITEM_TYPE
TM_TIME_SHEET_LINES_N2 | NONUNIQUE | 1 | WORK_ITEM_SET_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
TM_TIME_SHEET_LINES_S | TIME_SHEET_LINE_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: