MCFUQTIMEOUT

index back

MCFUQTIMEOUT

Escalation and overflow timeout table for the Universal Queue

PeopleSoft Field NameField TypeColumn TypeDescription
MCFUQTASKNUMCharacter(30)VARCHAR2(30) NOT NULLUnique identifier for a task in the Universal Queue.
MCFUQINSERTTIMEDateTime(26)TIMESTAMPTime Inserted
MCFUQTASKTYPECharacter(4)VARCHAR2(4) NOT NULLType of Universal Queue task
CH=Chat
EM=Email
GN=Generic
VO=Voice
MCFUQQUEUEIDCharacter(32)VARCHAR2(32) NOT NULLQueue ID
MCFUQQUEUETIMEDateTime(26)TIMESTAMP NOT NULLMCF Universal Queue date time field indicating the time when this task/event was enqueued
MCFUQAGENTIDCharacter(30)VARCHAR2(30) NOT NULLAgent Id
LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
MCFUQCOSTNumber(3,0)SMALLINT NOT NULLCost of task used in the Universal Queue to determine task to Agent routing.
MCFUQPRIORITYNumber(2,0)SMALLINT NOT NULLPriority of task in Universal Queue. Tasks are serviced in order by highest value to low on their associated queue.
MCFUQSKILLLEVELNumber(3,0)SMALLINT NOT NULLSkill Level
MCFUQORIGQTIMEDateTime(26)TIMESTAMPFirst Time in the MCF System
MCFUQATIMEOUTDateTime(26)TIMESTAMPUniversal Queue timer value to measure task's system timeout.
MCFUQCTIMEOUTDateTime(26)TIMESTAMPTimer value used in Universal Queue to keep track of the contracted maximum time for this task's completion.
MCFUQREASONCharacter(1)VARCHAR2(1) NOT NULLReason for Universal Queue timeout. This can either be due to "overflow" or "escalation".
E=escalation
O=overflow
MCFTASKISCLOSEDCharacter(3)VARCHAR2(3) NOT NULLIs Closed

Y/N Table Edit

MCFCOMMENTSCharacter(254)VARCHAR2(254) NOT NULLComments
MCFUQAPPDATALong CharacterCLOBApplication data attached to the Universal Queue task.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19