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.