Previous Topic: pr_trans TableNext Topic: Prob_Category Table

Data Element Dictionary › Priority Table

Priority Table

List of Priority entries. The priority reflects the time-frame in which a ticket must be resolved. For the ticket, it represents the highest priority of any problem attached to the ticket. Problem priorities are derived from the scope (impact) and severity of the problem.

Field

Data Type

Reference

Remarks

del

INTEGER

Active_Boolean_
Table::enum

Deleted flag that indicates the following:
0—Active

1—Inactive/marked as deleted

enum

INTEGER

 

Primary key of this table.

id

INTEGER

 

Specifies the unique (to the table) numeric ID.

last_mod_by

byte(16)

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

 

Indicates the timestamp of when this record was last modified.

nx_desc

nvarchar(40)

 

Describes the priority.

service_type

nvarchar(30)

Service_Desc:: code

Classic Service Type. Foreign key to the code field of the srv_desc table.

sym

nvarchar(12)

 

Indicates the symbolic name for this priority.