RC_BACKLOG_S_LV

(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 ,E.LANGUAGE_CD ,E.RC_SHORT_DESCR FROM PS_RC_CASE A , PS_RC_STATUS_TBL B , PS_SET_CNTRL_TBL C , PS_RC_STATUS_LNG E 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' AND B.SETID=E.SETID AND B.RC_STATUS = E.RC_STATUS

  • Related Language Record for RC_BACKLOG_S_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_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status
    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