MCFUQEVENTLOG(SQL Table) |
Index Back |
---|---|
MCF Universal Queue Event LogThis 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 |