vTicketField

Each ticket will have a set of fields associated with it.  Three of these fields are standard fields, status, priority, and category.  Also, a series of user fields can be added that will also be seen in this view.  Each field has a datatype.  All lists are stored as integer values.  The view vTicketField has the associated text for each list value.

Column Name

Type

Purpose

TicketID

int

unique trouble ticket ID number

TicketLabel

varchar

The label of the field

IntegerValue

int

The value of a integer field

NumberValue

numeric

The value of a number field

StringValue

varchar

The value of a string field

ListValue

varchar

The value of a list field