Share this page

# 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.

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: