MCFUQTIMEOUT

(SQL Table)
Index Back

MCFUQTIMEOUT

Escalation and overflow timeout table for the Universal Queue

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MCFUQTASKNUM Character(30) VARCHAR2(30) NOT NULL Unique identifier for a task in the Universal Queue.
2 MCFUQINSERTTIME DateTime(26) TIMESTAMP Time Inserted
3 MCFUQTASKTYPE Character(4) VARCHAR2(4) NOT NULL Type of Universal Queue task
CH=Chat
EM=Email
GN=Generic
VO=Voice
4 MCFUQQUEUEID Character(32) VARCHAR2(32) NOT NULL Queue ID
5 MCFUQQUEUETIME DateTime(26) TIMESTAMP NOT NULL MCF Universal Queue date time field indicating the time when this task/event was enqueued
6 MCFUQAGENTID Character(30) VARCHAR2(30) NOT NULL Agent Id
7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
8 MCFUQCOST Number(3,0) SMALLINT NOT NULL Cost of task used in the Universal Queue to determine task to Agent routing.
9 MCFUQPRIORITY Number(2,0) SMALLINT NOT NULL Priority of task in Universal Queue. Tasks are serviced in order by highest value to low on their associated queue.
10 MCFUQSKILLLEVEL Number(3,0) SMALLINT NOT NULL Skill Level
11 MCFUQORIGQTIME DateTime(26) TIMESTAMP First Time in the MCF System
12 MCFUQATIMEOUT DateTime(26) TIMESTAMP Universal Queue timer value to measure task's system timeout.
13 MCFUQCTIMEOUT DateTime(26) TIMESTAMP Timer value used in Universal Queue to keep track of the contracted maximum time for this task's completion.
14 MCFUQREASON Character(1) VARCHAR2(1) NOT NULL Reason for Universal Queue timeout. This can either be due to "overflow" or "escalation".
E=escalation
O=overflow
15 MCFTASKISCLOSED Character(3) VARCHAR2(3) NOT NULL Is Closed

Y/N Table Edit

16 MCFCOMMENTS Character(254) VARCHAR2(254) NOT NULL Comments
17 MCFUQAPPDATA Long Character CLOB Application data attached to the Universal Queue task.