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.