MCFUQLOG

(SQL Table)
Index Back

Universal Queue Log

Log table of events that occur in the Universal Queue

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MCFUQEVENT Character(4) VARCHAR2(4) NOT NULL Type of event that occurred in the Universal Queue system.
ACPT=Accept
ASGN=Assign
DONE=Done/Dequeue
LGIN=Login
LGOT=Logout
NWST=New state
RSRT=Restart
TOUT=Timeout
USGN=Unassign
2 MCFUQTASKNUM Character(30) VARCHAR2(30) NOT NULL Unique identifier for a task in the Universal Queue.
3 MCFUQTIME DateTime(26) TIMESTAMP NOT NULL Time at which the event occured in the Universal Queue.
4 MCFUQAGENTID Character(30) VARCHAR2(30) NOT NULL Agent Id
5 MCFUQQUEUEID Character(32) VARCHAR2(32) NOT NULL Queue ID
6 MCFUQINFO Character(254) VARCHAR2(254) NOT NULL Field that contains additional information on the Universal Queue event that occured.
7 MCFUQTASKTYPE Character(4) VARCHAR2(4) NOT NULL Type of Universal Queue task
CH=Chat
EM=Email
GN=Generic
VO=Voice
8 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.
9 MCFUQCOST Number(3,0) SMALLINT NOT NULL Cost of task used in the Universal Queue to determine task to Agent routing.