MCFUQWORKSET

(SQL Table)
Index Back

MCFUQWORKSET

Current working set of active longterm tasks 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 MCFUQTASKTYPE Character(4) VARCHAR2(4) NOT NULL Type of Universal Queue task
CH=Chat
EM=Email
GN=Generic
VO=Voice
3 MCFUQQUEUEID Character(32) VARCHAR2(32) NOT NULL Queue ID
4 MCFUQQUEUETIME DateTime(26) TIMESTAMP NOT NULL MCF Universal Queue date time field indicating the time when this task/event was enqueued
5 MCFUQSTATUS Character(4) VARCHAR2(4) NOT NULL Universal Queue task status
ACPT=Accepted
ASGN=Assigned
DONE=Done
ENQ=Enqueued

Default Value: ENQ

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
7 MCFUQAGENTID Character(30) VARCHAR2(30) NOT NULL Agent Id
8 MCFUQTIEDAGENT Character(30) VARCHAR2(30) NOT NULL Universal Queue field to indicate the identifier of the Agent to which this task is tied.
9 MCFUQCOST Number(3,0) SMALLINT NOT NULL Cost of task used in the Universal Queue to determine task to Agent routing.
10 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.
11 MCFUQSKILLLEVEL Number(3,0) SMALLINT NOT NULL Skill Level
12 MCFUQORIGQTIME DateTime(26) TIMESTAMP First Time in the MCF System
13 MCFUQATIMEOUT DateTime(26) TIMESTAMP Universal Queue timer value to measure task's system timeout.
14 MCFUQCTIMEOUT DateTime(26) TIMESTAMP Timer value used in Universal Queue to keep track of the contracted maximum time for this task's completion.
15 MCFUQAPPDATA Long Character CLOB Application data attached to the Universal Queue task.