RC_RSLN_DET_VW

(SQL View)
 Index Back

Case Resolution 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 , A.SOLUTION_ID , A.RSLN_STATE , B.RC_SUMMARY , B.SOLUTION_DESCR FROM PS_RC_RESOLUTION A , PS_RC_SOLUTION B WHERE A.SOLUTION_ID = B.SOLUTION_ID AND B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE= A.BUSINESS_UNIT AND C.RECNAME = 'RC_SOLUTION')

  • Related Language Record: RC_RSLN_DET_LVW

    • # 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 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID
    5 RSLN_STATE Character(1) VARCHAR2(1) NOT NULL Resolution Status for Call Center application.
    0=Viewed
    1=Successful Resolution
    2=Waiting on Customer
    3=In Consideration
    4=Failed Resolution
    5=Withdrawn

    Default Value: 3

    6 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
    7 SOLUTION_DESCR Long Character CLOB Solution Description