RC_BACKLOG_A_VL

(SQL View)
 Index Back

Agent Backlog by Priority

A view of the case backlog by agent and Priority.

SELECT A.BUSINESS_UNIT , A.ASSIGNED_TO , A.RC_PRIORITY ,E.LANGUAGE_CD , E.RC_SHORT_DESCR FROM PS_RC_CASE A , PS_RC_PRIORITY_TBL B , PS_RC_STATUS_TBL D , PS_RC_PRIORITY_LNG E WHERE A.RC_PRIORITY <> ' ' AND B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'RC_PRIORITY_TBL') AND A.RC_PRIORITY = B.RC_PRIORITY AND B.RC_PRIORITY =E.RC_PRIORITY AND B.SETID= E.SETID AND D.STATUS_CATEGORY = 'O' AND A.RC_STATUS=D.RC_STATUS AND D.SETID=( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'RC_STATUS_TBL')

  • Related Language Record for RC_BACKLOG_A_V RC_BACKLOG_A_VN RC_BACKLOG_A_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.
    3 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables