MCFUQLOG(SQL Table) |
Index Back |
---|---|
Universal Queue LogLog 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. |