Previous Topic: Timezone TableNext Topic: Transition_Types Table


Transition_Points Table

Lists the transitions of interest to the Notification System. E.g. Incident_report creation, or reassignment, TT creation TT closure and so on.

Field

Data Type

Reference

Remarks

del

INTEGER NOT_NULL

 

Deleted flag

0—Active

1—Inactive/marked as deleted

enum

INTEGER NOT_NULL

 

Enumerated value for this entry - specifies ordering in lists and relative values

id

INTEGER UNIQUE NOT_NULL KEY

 

Unique (to the table) Numeric ID

nx_desc

STRING 40

 

longer description of event

sym

STRING 30 UNIQUE NOT_NULL S_KEY

 

transition event symbol

tp_use_pri

INTEGER

 

flag indicating whether priority is meaningfull