Share this page

# KCRT_FG_WORK_ITEMS_INT

The KCRT_FG_WORK_ITEMS_INT interface table stores validation information, for each request, that are related to the Work Item Fields field group.

Table A-16. KCRT_FG_WORK_ITEMS_INT interface table
Column | Usage | Data Type | Description
--- | --- | --- | ---
WORK_ITEM_INTERFACE_ID | Obsolete | NUMBER | No longer used.
GROUP_ID | I | NUMBER | Groups all the records that should be processed at the same time. Use only one GROUP_ID for each batch of imported users when running the User Open Interface report. Derived from the KNTA_INTERFACE_GROUPS_S sequence. This value should be the same as the parent's GROUP_ID in KCRT_REQUEST_INT.
TRANSACTION_ID | I | NUMBER | Uniquely identifies each transaction.
PARENT_TRANSACTION_ID | I | NUMBER | Provides the transaction ID (from KCRT_REQUESTS_INT) of the parent table being imported.
PROCESS_PHASE | Obsolete | NUMBER | No longer used.
PROCESS_STATUS | Obsolete | NUMBER | No longer used.
REQUEST_ID | I/O | NUMBER | Identifies the request. This is normally left blank and is derived from the KCRT_REQUESTS_S sequence.
REQUEST_TYPE_ID | I/O | NUMBER | Identifies the request type. This is normally left blank and is derived from REQUEST_TYPE_NAME.
WORKLOAD_FLAG | I | VARCHAR2 | Indicates whether or not this request should count as workload against resource capacity. Valid values are: Y N The default value is Y.
WORKLOAD_FLAG_MEANING | I | VARCHAR2 | Indicates whether or not there is a description associated with WORKLOAD_FLAG. Valid values are: Yes No The default value is Yes.
WORKLOAD_CATEGORY_CODE | O | VARCHAR2 | Specifies the code for the category if the workload represented by this request falls under a category.
WORKLOAD_CATEGORY_MEANING | I | VARCHAR2 | Specifies the description for the category if the workload represented by this request falls under a category.
ALLOW_EXTERNAL_UPDATE_FLAG | I | VARCHAR2 | Indicates whether or not the actuals can be updated by an external system (such as Time Management time sheets). Valid values are: Y N The default value is N.
USR_SCHEDULED_START_DATE | I | DATE | Specifies the date when the work item is scheduled to start. This is the same day as SCHEDULED_START_DATE, but the time may not be at 8:00 a.m.
USR_SCHEDULED_FINISH_DATE | I | DATE | Specifies the date when the work item is scheduled to finish. This is the same day as SCHEDULED_FINISH_DATE, but the time may not be the end of the work day.
SCHEDULED_START_DATE | I | DATE | Specifies the date that the work item is scheduled to start. The starting time is at 8:00 a.m. on that day.
SCHEDULED_FINISH_DATE | I | DATE | Specifies the date when the work item is scheduled to finish. The ending time is at the end of the working day.
SCHEDULED_EFFORT | I | NUMBER | Specifies the effort (in hours). Usually equal to (duration) x (hours/day).
SCHEDULED_DURATION | I | NUMBER | Specifies the number of working days between USR_SCHEDULED_START_DATE and USR_SCHEDULED_FINISH_DATE.
SCHED_EFF_OVER_DUR | I | NUMBER | Provides a helper column to be used when calculation actuals (no units).
USR_ACTUAL_START_DATE | I | DATE | Indicates the date when the work item is scheduled to start. This is the same day as ACTUAL_START_DATE, but the time may not be 8:00 a.m.
USR_ACTUAL_FINISH_DATE | I | DATE | Indicates the date when the work item is scheduled to finish. This is the same day as ACTUAL_FINISH_DATE, but the time may not be the end of the work day.
ACTUAL_START_DATE | I | DATE | Indicates the date that the work item actually starts. The starting time is at 8:00 a.m. on that day.
ACTUAL_FINISH_DATE | I | DATE | Indicates the date that the work item actually finishes. This occurs at the end of that day.
ACTUAL_EFFORT | I | NUMBER | Specifies the effort (in hours). Usually equal to (duration) x (hours/day).
ACTUAL_DURATION | I | NUMBER | Indicates the number of working days between USR_ACTUAL_START_DATE and USR_ACTUAL_FINISH_DATE.
ACTUAL_EFF_OVER_DUR | I | NUMBER | Provides a helper column used when calculation actuals (no units).
BOOKED_SKILL_ID | I | NUMBER | Provides the ID of the booked skill. This must match a SKILL_ID in KRSC_SKILLS.
BOOKED_SKILL_NAME | I | VARCHAR2 | Provides the skill name booked on this request. This must match a SKILL_NAME in KRSC_SKILLS.

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: