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.