MCFUQWORKSET(SQL Table) |
Index Back |
|---|---|
MCFUQWORKSETCurrent working set of active longterm tasks for the Universal Queue. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |