Share this page
KCRT_FG_WORK_ITEMS
If the Work Items field group is linked to a request's request header type, a row will exist in this table for the request. Defines columns so that a request can be scheduled and can be viewed in Workload visualizations..
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
RSC_ROLES_NLS |
ROLE_ID |
ROLE_ID |
|
KCRT_REQUEST_TYPES_NLS |
REQUEST_TYPE_ID |
REQUEST_TYPE_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
REQUEST_ID |
NOT NULL |
NUMBER |
Request identifier |
|
REQUEST_TYPE_ID |
NOT NULL |
NUMBER |
Request type used by the request |
|
WORKLOAD_FLAG |
NULLABLE |
VARCHAR2(1) |
Determines whether this request is to be considered workload in visualizations (Y/N). |
|
WORKLOAD_FLAG_MEANING |
NULLABLE |
VARCHAR2(200) |
Meaning of workload_flag |
|
WORKLOAD_CATEGORY_CODE |
NULLABLE |
VARCHAR2(30) |
Lookup code of '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 |
Number of hours estimated 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/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_N1 |
NONUNIQUE |
1 |
ROLE_ID |
|
KCRT_FG_WORK_ITEMS_N2 |
NONUNIQUE |
1 |
WORKLOAD_FLAG |
|
KCRT_FG_WORK_ITEMS_N2 |
NONUNIQUE |
2 |
WORKLOAD_CATEGORY_CODE |
|
KCRT_FG_WORK_ITEMS_U1 |
UNIQUE |
1 |
REQUEST_ID |
Sequences
This table uses no sequences.
