RC_SSHD_LANG_VW(SQL View) |
Index Back |
---|---|
Self Service Support CasesThis 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') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. | |
2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
3 | 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 | Character(30) | VARCHAR2(30) NOT NULL | Display Template Family Code | |
5 | 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 |