RB_MCF_AGT_QUE

(SQL View)
Index Back

Agent queue view

MultiChannel Agent Queue View for Unitfied Agent Desktop

SELECT MCFUQAGENTID ,MCFREN_LOG_RTENT ,MCFREN_LOG_RTENT ,MCFREN_PHYS_RTENT ,MCFUQSKILLLEVEL ,MCFUQMAXWKLD FROM PSMCFUQAGENTQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 MCFUQQUEUEID Character(32) VARCHAR2(32) NOT NULL Queue ID
3 MCFREN_LOG_RTENT Character(30) VARCHAR2(30) NOT NULL Queue Id

Prompt Table: PSMCFLOGENT_VW

4 MCFREN_PHYS_RTENT Character(32) VARCHAR2(32) NOT NULL Physical Queue Id

Prompt Table: PSMCFRENMAP

5 MCFUQSKILLLEVEL Number(3,0) SMALLINT NOT NULL Skill Level
6 MCFUQMAXWKLD Number(3,0) SMALLINT NOT NULL Maximum Workload