RC_RSLN_DET_LVW

(SQL View)
 Index Back

Case Resolution Language View

This is the record for the view that will fetch the Solution Summary and Solution Description for the Solution associated with the Case

SELECT A.CASE_ID , A.BUSINESS_UNIT , A.RSLN_SEQ_NBR , L.LANGUAGE_CD , L.RC_SUMMARY , L.SOLUTION_DESCR FROM PS_RC_RESOLUTION A , PS_RC_SOLUTION_LNG L WHERE A.SOLUTION_ID = L.SOLUTION_ID AND L.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE= A.BUSINESS_UNIT AND C.RECNAME = 'RC_SOLUTION')

  • Related Language Record for RC_RSLN_DET_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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.

    Default Value: RC_CASE.CASE_ID

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: RC_CASE.BUSINESS_UNIT

    3 RSLN_SEQ_NBR Number(8,0) INTEGER NOT NULL Resolution Sequence Number

    Default Value: 1

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
    6 SOLUTION_DESCR Long Character CLOB Solution Description