RC_BAKPGSTAT_VW

(SQL View)
Index Back

PG Backlog by Status

A view showing provider group case backlog by status.

SELECT A.BUSINESS_UNIT , A.RC_MANAGER , A.RC_STATUS , A.PROVIDER_GRP_ID , COUNT(DISTINCT A.CASE_ID) , B.RC_SHORT_DESCR , ' ' ,A.DISP_TMPL_FAM_CD FROM PS_RC_PGMGRCASE_VW A , PS_RC_STATUS_TBL B WHERE B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'RC_STATUS_TBL') AND A.RC_STATUS = B.RC_STATUS GROUP BY A.BUSINESS_UNIT , A.RC_MANAGER , A.PROVIDER_GRP_ID , A.RC_STATUS , DISP_TMPL_FAM_CD, B.RC_SHORT_DESCR

  • Related Language Record: RC_BAKPGSTAT_VL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 RC_MANAGER Character(15) VARCHAR2(15) NOT NULL Call Center Manager. Used in call center business unit setup.
    3 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status
    4 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
    5 RC_CASE_COUNT Number(7,0) INTEGER NOT NULL Case Count
    6 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables
    7 DATAHINTS Character(100) VARCHAR2(100) NOT NULL Chart Data Hints
    8 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code