The URGENCY table stores information about urgency codes that are used to prioritize tickets in Infor CRM. Urgency codes indicate the priority of the ticket and how immediately to respond to the ticket. The information includes a numeric urgency code, description, turnaround time in minutes, and settings to enable the urgency code and allow Web Ticket user access.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
URGENCYID (PK) |
STANDARDID(12) |
NOT NULL |
URGENCY_URGENCYID (AK) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
URGENCYCODE |
STANDARDID(12) |
NOT NULL |
URGENCY_URGENCYCODE (CA) |
|
|
|
DESCRIPTION |
varchar(80) |
NULLS |
URGENCY_DESCRIPTION (IE) |
|
|
|
MINUTES |
int(4) |
NULLS |
|
|
|
|
ENABLED |
BOOLEAN(1) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
ISDEFAULT |
char(1) |
NULLS |
|
|
|
|
ALLOWWEBTICKET |
char(1) |
NULLS |
|
|
|