RF_RSLN_DET_VW

(SQL View)
Index Back

Service Order Resolution View

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

SELECT A.BUSINESS_UNIT , A.SO_ID , A.RSLN_SEQ_NBR , A.SOLUTION_ID , A.RSLN_STATE , B.RC_SUMMARY , B.SOLUTION_DESCR FROM PS_RF_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: RF_RSLN_DET_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: RF_SO_HDR.BUSINESS_UNIT

    2 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID
    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