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 use to determine whether the target was met.

condition_outcome

INTEGER

Boolean_Table

Specifies the required outcome of the evaluation of the condition.

object_type

STRING 30

NOT_NULL. Identifies the valid ticket type for this template.

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.

cost

STRING 255

Indicates the text information to appear on the ticket.

work_shift

STRING 30

Bop_Workshift

Indicates the workshift used for time calculations.