RC_SSHD_LANG_VW

(SQL View)
 Index Back

Self Service Support Cases

This view is a related language record used to pull all the Cases that are currently open for a customer by using the CUST_ID.

SELECT C.BO_ID_CUST , C.BUSINESS_UNIT , C.CASE_ID , C.DISP_TMPL_FAM_CD , L.LANGUAGE_CD , L.RC_DESCR_SS FROM PS_RC_CASE C , PS_RC_STATUS_TBL S , PS_RC_STATUS_LNG L WHERE C.RC_VERTICAL = 'HD' AND S.RC_STATUS = C.RC_STATUS AND S.RC_STATUS = L.RC_STATUS AND S.STATUS_CATEGORY = 'O' AND S.SETID = L.SETID AND S.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = C.BUSINESS_UNIT AND RECNAME = 'RC_STATUS_TBL')

  • Related Language Record for RC_SS_HD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 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.
    4 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 RC_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Description to be shown on Self-Service Pages