RC_SA_CASE_VW

(SQL View)
 Index Back

Solution Advisor Case View

Solution Advisor Case View. Solution Advisor Case View

SELECT K.OPRID , K.SEQ_NBR_4 , K.KEY_CASE_ID , K.KEY_BUSINESS_UNIT , K.RECNAME , K.RC_SCORE , K.RC_TEXT_SCORE , K.BUSINESS_UNIT , K.CASE_ID , C.RC_SUMMARY , C.RC_STATUS , C.RC_VERTICAL , C.CASE_TYPE , C.RC_DESCRLONG FROM PS_RC_SA_RSLT_KEYS K , PS_RC_CASE C WHERE K.RECNAME = 'RC_CASE' AND K.BUSINESS_UNIT = C.BUSINESS_UNIT AND K.CASE_ID = C.CASE_ID

  • Parent record: RC_SA_RSLT_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 SEQ_NBR_4 Number(4,0) SMALLINT NOT NULL Sequence Nbr 4
    3 KEY_CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID
    4 KEY_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    6 RC_SCORE Number(6,2) DECIMAL(5,2) NOT NULL Survey Score
    7 RC_TEXT_SCORE Character(4) VARCHAR2(4) NOT NULL Field to display search score as text (in percentage)
    8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    9 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.
    10 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
    11 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status

    Prompt Table: RC_STATUS_TBL

    12 RC_VERTICAL Character(4) VARCHAR2(4) NOT NULL Specifies the CallCenter type. See translates for valid values.
    HD=HelpDesk
    SW=Support
    13 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type

    Prompt Table: RC_CASETYPE_TBL

    14 RC_DESCRLONG Long Character CLOB Long description used in CallCenter for Problem, Solution...