TM_TIME_SHEET_LINES

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

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.

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

TM_TIME_SHEET_LINES_S

TIME_SHEET_LINE_ID