Previous Topic: Person_Contacting TableNext Topic: Priority Table


pr_trans Table

A transition object controls the current and next ticket status. The pr_trans table lists the status, new status, and actions that need to occur for a default transition.

Label

Field

Description

id

INTEGER

Unique key.

status

SYMBOL

Specifies the current ticket status.

new_status

SYMBOL

Specifies the new ticket status

must_comment

INTEGER

Comment required when using a transition.

On new default: 0

is_default

INTEGER

Default transition that appears when the Status field is empty.

On new default: 0

condition

BOP_REF_STR_REF Macro

Site condition macro to approve transition.

condition error

STRING 255

Error message for site condition.

description

STRING 255

Description of this transition.

last_mod_dt

LOCAL_TIME

Timestamp of last update to this record.

last_mod_by

UUID REF ca_contact

User who last updated this.

del

INTEGER nn

Logical database delete status.

tenant

UUID REF ca_tenant

Reference to Tenant information.