SDB_WFGRP_AG_VW

(SQL View)
Index Back

Agent Worklist View

Agent Worklist View used in Contact Center Dashboard.

SELECT A.RB_WF_GRP_NAME , A.USERID , B.BO_NAME_DISPLAY , A.GROUP_OWNER_FLG FROM PS_RB_WF_GRP_PLIST A , PS_RB_OPR_PR_NM_VW B WHERE A.USERID = B.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RB_WF_GRP_NAME Character(30) VARCHAR2(30) NOT NULL Group Worklist Nameg
2 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

Prompt Table: OPRID_VW2

3 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
4 GROUP_OWNER_FLG Character(1) VARCHAR2(1) NOT NULL Group Owner

Y/N Table Edit

Default Value: N