KCRT_FG_WORK_ITEMS_INT

This is a child table of KCRT_REQUESTS_INT. This table is used to import data into the KCRT_FG_WORK_ITEMS table. This table is processed through the java report that calls a PL/SQL package that can be run either from the command line or through the report job scheduler. This allows the user to immediately run the interface while also allowing for scheduled processing. The PL/SQL package queries this table, validates against appropriate tables and imports into the production tables. It can also release the request, depending on its status, by calling the Workflow APIs.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

RSC_ROLES_NLS

ROLE_ID

ROLE_ID

KWFL_TRANSACTIONS_INT

TRANSACTION_ID

PARENT_TRANSACTION_ID

Column Descriptions

Column Name

Null?

Data Type

Description

WORK_ITEM_INTERFACE_ID

NULLABLE

NUMBER

System-generated ID

GROUP_ID

NULLABLE

NUMBER

Value used to tie records in the interface tables together. Most of the database processing is done based on this value. The value must be the same as the parent's group_ID in the KCRT_REQUESTS_INT table.

TRANSACTION_ID

NULLABLE

NUMBER

System-generated record identifier

PARENT_TRANSACTION_ID

NULLABLE

NUMBER

Links this table to TRANSACTION_ID in the KCRT_REQUESTS_INT table

PROCESS_PHASE

NULLABLE

NUMBER

Determines where the record is in the interface process: 1 -- Pending, 2 -- Validating, 3 -- Importing

PROCESS_STATUS

NULLABLE

NUMBER

Determines the current status of the interface record: 1 -- Pending, 2 -- In-Process, 3 -- Errored, 4 -- Completed.

REQUEST_ID

NULLABLE

NUMBER

Refers to the request_id in KCRT_REQUESTS table

REQUEST_TYPE_ID

NULLABLE

NUMBER

Request type ID used by this request

WORKLOAD_FLAG

NULLABLE

VARCHAR2(1)

Determines whether this request should be considered workload in visualizations (Y/N)

WORKLOAD_FLAG_MEANING

NULLABLE

VARCHAR2(200)

Meaning of the workload_flag

WORKLOAD_CATEGORY_CODE

NULLABLE

VARCHAR2(30)

Lookup code for 'RSC - Workload Category Code'

WORKLOAD_CATEGORY_MEANING

NULLABLE

VARCHAR2(200)

Lookup meaning of 'RSC - Workload Category Code'

ALLOW_EXTERNAL_UPDATE_FLAG

NULLABLE

VARCHAR2(1)

Determines whether this request can be updated by Time Management (Y/N)

USR_SCHEDULED_START_DATE

NULLABLE

DATE

Scheduled Start Date formatted for viewing

USR_SCHEDULED_FINISH_DATE

NULLABLE

DATE

Scheduled Finish Date formatted for viewing

SCHEDULED_START_DATE

NULLABLE

DATE

Date on which work on the request is scheduled to start

SCHEDULED_FINISH_DATE

NULLABLE

DATE

Date on which work on the request is scheduled to end

SCHEDULED_EFFORT

NULLABLE

NUMBER

Estimated number of hours to be worked on the request

SCHEDULED_DURATION

NULLABLE

NUMBER

Number of days over which work on this request will take place, not including non-working days

SCHED_EFF_OVER_DUR

NULLABLE

NUMBER

Ratio of Scheduled Effort to Duration. Used for defaulting logic.

USR_ACTUAL_START_DATE

NULLABLE

DATE

Actual Start Date formatted for viewing

USR_ACTUAL_FINISH_DATE

NULLABLE

DATE

Actual Finish Date formatted for viewing

ACTUAL_START_DATE

NULLABLE

DATE

Date on which work on the request started

ACTUAL_FINISH_DATE

NULLABLE

DATE

Date on which work on the request ended

ACTUAL_EFFORT

NULLABLE

NUMBER

Number of hours worked on the request

ACTUAL_DURATION

NULLABLE

NUMBER

Number of days over which work on this request took place, not including non-working days

ACTUAL_EFF_OVER_DUR

NULLABLE

NUMBER

Ratio of Actual Effort to Duration. Used for defaulting logic.

ROLE_ID

NULLABLE

NUMBER

Role of the resource that is assigned to the item

ROLE_NAME

NULLABLE

VARCHAR2(200)

Name of the role represented by ROLE_ID

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_WORK_ITEMS_INT_N1

NONUNIQUE

1

GROUP_ID

KCRT_FG_WORK_ITEMS_INT_N1

NONUNIQUE

2

TRANSACTION_ID

KCRT_FG_WORK_ITEMS_INT_N2

NONUNIQUE

1

REQUEST_ID

Sequences

This table uses no sequences.