TM_RESOURCE_QUICKLIST_ITEMS

This table stores the "My Items" list for each resource to allow quick addition of items to a Time Sheet.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KDLV_PACKAGES

PACKAGE_ID

WORK_ITEM_ID

PM_PROJECTS

PROJECT_ID

WORK_ITEM_SET_ID

RSC_RESOURCES

RESOURCE_ID

RESOURCE_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

WORK_ITEM_SET_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

WORK_ITEM_SET_ID

KCRT_REQUESTS

REQUEST_ID

WORK_ITEM_ID

WP_TASKS

TASK_ID

WORK_ITEM_ID

Column Descriptions

Column Name

Null?

Data Type

Description

RESOURCE_QUICKLIST_ITEM_ID

NOT NULL

NUMBER

System-generated identifier

RESOURCE_ID

NOT NULL

NUMBER

Identifies the Resource that this item belongs to.

WORK_ITEM_ID

NOT NULL

VARCHAR2(255)

Identifies the item contained in a Resource's "My Items" list. Valid IDs are Request IDs, Package IDs, Task IDs, or Miscellaneous Items.

WORK_ITEM_SET_ID

NOT NULL

VARCHAR2(255)

Identifies the parent set for the item. Valid IDs are Request Types, Workflows, Projects or Miscellaneous items.

WORK_ITEM_TYPE

NOT NULL

VARCHAR2(255)

Indicates the type of item. Valid values are REQUEST, PACKAGE, PROJECT, TASK, and MISC.

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

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005200521

UNIQUE

1

RESOURCE_ID

SYS_C005200521

UNIQUE

2

WORK_ITEM_ID

SYS_C005200521

UNIQUE

3

WORK_ITEM_TYPE

SYS_C005201596

UNIQUE

1

RESOURCE_QUICKLIST_ITEM_ID

Sequences

Sequence Name

Sequence Type

TM_RESOURCE_QL_ITEMS_HIB_S

RESOURCE_QUICKLIST_ITEM_ID