RC_MYCASE_VLN

(SQL View)
 Index Back

Agent Case Details

Chart drill to details for open cases assigned to an agent.

SELECT A.BUSINESS_UNIT , A.CASE_ID , A.RC_STATUS , A.RC_PRIORITY ,F.LANGUAGE_CD , F.RC_SHORT_DESCR , E.RC_SHORT_DESCR FROM PS_RC_STATUS_TBL C , PS_RC_STATUS_LNG F , PS_RC_CASE A LEFT JOIN PS_RC_CASEWPRIO_LN E ON E.CASE_ID=A.CASE_ID WHERE C.RC_STATUS = A.RC_STATUS AND C.RC_STATUS = F.RC_STATUS AND C.SETID=F.SETID AND E.LANGUAGE_CD=F.LANGUAGE_CD AND C.STATUS_CATEGORY = 'O' AND C.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'RC_STATUS_TBL')

  • Related Language Record for RC_MYCASE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
    3 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status

    Prompt Table: RC_STATUS_TBL

    4 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority

    Prompt Table: RC_PRIORITY_TBL

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables
    7 RC_SHORT_DESCR1 Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables