Previous Topic: usp_acctyp_role TableNext Topic: usp_caextwf_instances Table


usp_auto_close Table

The auto close object controls the automatic closure of a ticket (request, incident, problem, change order, issue). The usp_auto_close table lists the automatic closure settings. For each ticket type, you can define the number of business hours before the closure takes place. By definition, zero hours means that automatic closure is not implemented for the ticket type.

In an untenanted system only one active row is allowed in this table.

In a tenanted system, each tenant can have its own row and only one row is permitted. In addition, one active Public row is permitted for tenants that do not have a tenanted row. If a tenant does not have its own row of auto-close settings, and there is not an active Public row, the automatic closure feature is disabled for that tenant.

Label

Field

Description

id

INTEGER

Unique key

sym

STRING 80

 

cr_ach

INTEGER

 

in_ach

INTEGER

 

pr_ach

INTEGER

 

chg_ach

INTEGER

 

iss_ach

INTEGER

 

description

STRING 255

 

last_mod_dt

LOCAL_TIME

 

last_mod_by

UUID REF

ca_tenant

del

INTEGER

nn

tenant

UUID REF

ca_tenant