MCFUQEVENTLOG

(SQL Table)
Index Back

MCF Universal Queue Event Log

This log contains RENSRV events that occur during the course of operating the MCF Universal Queue.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MCFDOMAIN Character(50) VARCHAR2(50) NOT NULL Domain
2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 MCFUQQUEUETIME DateTime(26) TIMESTAMP NOT NULL MCF Universal Queue date time field indicating the time when this task/event was enqueued
4 MCFRENTOPIC Character(254) VARCHAR2(254) NOT NULL Published topic for this RENSRV event.
5 MCFLOGGEDEVENT Character(4) VARCHAR2(4) NOT NULL Type of event that occurred in the Universal Queue system.
6 MCFUQTASKTYPE Character(4) VARCHAR2(4) NOT NULL Type of Universal Queue task
CH=Chat
EM=Email
GN=Generic
VO=Voice
7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
8 MCFUQTASKNUM Character(30) VARCHAR2(30) NOT NULL Unique identifier for a task in the Universal Queue.
9 MCFUQQUEUEID Character(32) VARCHAR2(32) NOT NULL Queue ID
10 MCFUQAGENTID Character(30) VARCHAR2(30) NOT NULL Agent Id
11 MCFUQCOST Number(3,0) SMALLINT NOT NULL Cost of task used in the Universal Queue to determine task to Agent routing.
12 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.
13 MCFUQSKILLLEVEL Number(3,0) SMALLINT NOT NULL Skill Level
14 DESCRLONG Long Character CLOB Long Description