Field

Data Type

Reference

Remarks

id

INTEGER

UNIQUE NOT_NULL KEY Unique (to the table) Numeric ID.

del

INTEGER

NOT_NULL Deleted flag:

0—Active

1—Inactive/marked as deleted

sym

STRING 60

NOT_NULL Identifies the symbolic value for this target.

last_mod_dt

LOCAL_TIME

Indicates the timestamp when this record was last modified.

last_mod_by

UUID

ca_contact

UUID of the contact who last modified this record.

tenant

UUID

ca_tenant

UUID REF to the ca_tenant table.

target_duration

DURATION

NOT_NULL.

The amount of time in which this target is reached.

condition

STRING 30

Macro

Identifies the condition to be detected in determining that this target has been reached.

condition_outcome

INTEGER

Boolean_Table

Specifies the required outcome of the evaluation of the condition.

service_type

STRING 30

Service_Desc

NOT_NULL. The Service Type to which this target belongs.

object_type

STRING 30

NOT_NULL Ticket type that this target is attached.

object_id

INTEGER

S_KEY

NOT_NULL id of the ticket that this target is attached.

set_actual

INTEGER

Boolean_Table

A flag that determines whether the Set Actual Service Target Action is available on the ticket.

reset_actual

INTEGER

Boolean_Table

A flag that determines whether the Reset Actual Service Target Action is available on the ticket.

lock_target

INTEGER

Boolean_Table

Prevents Service Target recalculations for tickets that transition to and from the Hold status.

cost

STRING 255

Text information to appear on the ticket.

target_time

LOCAL_TIME

Deadline for the Service Target.

actual_time

LOCAL_TIME

The time that the target completed.

time_left

DURATION

Number of remaining minutes.

_mapped_cr

STRING 30

Call_Req

Pointer to the Request, Incident, or Problem that uses this Service Target.

_mapped_chg

INTEGER

Change_ Request

Pointer to the Change Order that uses this Service Target.

_mapped_iss

STRING 30

Issue

Pointer to the Incident that uses this Service Target.

target_tpl

INTEGER

target_tpl

Identifies the target template for this target.

work_shift

STRING 30

Bop_Workshift

Identifies the workshift to use for calculating the target.