MCFUQTIMEOUT

index back

MCFUQTIMEOUT

Escalation and overflow timeout table for the Universal Queue

PeopleSoft Field Name Field Type Column Type Description
MCFUQTASKNUM Character(30) VARCHAR2(30) NOT NULL Unique identifier for a task in the Universal Queue.
MCFUQINSERTTIME DateTime(26) TIMESTAMP Time Inserted
MCFUQTASKTYPE Character(4) VARCHAR2(4) NOT NULL Type of Universal Queue task
CH=Chat
EM=Email
GN=Generic
VO=Voice
MCFUQQUEUEID Character(32) VARCHAR2(32) NOT NULL Queue ID
MCFUQQUEUETIME DateTime(26) TIMESTAMP NOT NULL MCF Universal Queue date time field indicating the time when this task/event was enqueued
MCFUQAGENTID Character(30) VARCHAR2(30) NOT NULL Agent Id
LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
MCFUQCOST Number(3,0) SMALLINT NOT NULL Cost of task used in the Universal Queue to determine task to Agent routing.
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.
MCFUQSKILLLEVEL Number(3,0) SMALLINT NOT NULL Skill Level
MCFUQORIGQTIME DateTime(26) TIMESTAMP First Time in the MCF System
MCFUQATIMEOUT DateTime(26) TIMESTAMP Universal Queue timer value to measure task's system timeout.
MCFUQCTIMEOUT DateTime(26) TIMESTAMP Timer value used in Universal Queue to keep track of the contracted maximum time for this task's completion.
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
MCFTASKISCLOSED Character(3) VARCHAR2(3) NOT NULL Is Closed

Y/N Table Edit

MCFCOMMENTS Character(254) VARCHAR2(254) NOT NULL Comments
MCFUQAPPDATA Long Character CLOB Application data attached to the Universal Queue task.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19