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

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.

tgt_time_tpl

INTEGER

target_time_tpl

NOT_NULL. The Service Target Template that is linked to a Service Type.

sdsc

STRING 30

Service_Desc

NOT_NULL.The Service Type to which the template is linked.

target_ duration

DURATION

NOT_NULL. The amount of time in which this target is reached.

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

Text information to appear on the ticket.

work_shift

STRING 30

Bop_Workshift

The workshift used in time calculations.