RC_BACKLOG_S_VW

(SQL View)
 Index Back

Backlog by Status

A view of the case backlog by agent and status.

SELECT A.BUSINESS_UNIT , A.ASSIGNED_TO , A.RC_STATUS ,B.RC_SHORT_DESCR , COUNT(DISTINCT A.CASE_ID) ,' ' , A.DISP_TMPL_FAM_CD FROM PS_RC_CASE A , PS_RC_STATUS_TBL B , PS_SET_CNTRL_TBL C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.RC_STATUS = A.RC_STATUS AND B.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'RC_STATUS_TBL') AND B.STATUS_CATEGORY = 'O' GROUP BY A.BUSINESS_UNIT, A.ASSIGNED_TO, A.RC_STATUS, B.RC_SHORT_DESCR, A.DISP_TMPL_FAM_CD

  • Related Language Record: RC_BACKLOG_S_LV

    • # 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_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status
    4 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables
    5 RC_CASE_COUNT Number(7,0) INTEGER NOT NULL Case Count
    6 DATAHINTS Character(100) VARCHAR2(100) NOT NULL Chart Data Hints
    7 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code