RC_SOLSS_SRH_VW

(SQL View)
 Index Back

Self Service Solution Search

Self Service Solution Search View for self service solution search collection.

SELECT A.SETID , A.SOLUTION_ID , A.RC_SOLUTION_TYPE , A.SOLN_STATUS , A.RC_SOLN_VISIBILITY , A.RC_SUMMARY , A.SYMPTOM_DESCR , A.SOLUTION_DESCR , A.KEYWORDS , A.LAST_ACTION_DTTM , A.EXPIRY_IND , A.EXPIRY_DATE , A.EXPIRY_REASON , A.NEW_SOLUTION_ID , ' ' , A.USAGE_COUNT , A.LAST_USAGE_DTTM , A.USER_UPDATE_DTTM , A.RC_SOLVED_COUNT , B.PROD_DESCRLONG , %subrec(RB_AUDIT_SBR, A) FROM PS_RC_SOLUTION A ,PS_RC_SOL_PRODSRCH B WHERE A.SETID = B.SETID AND A.SOLUTION_ID = B.SOLUTION_ID AND A.EXPIRY_IND <> 'Y' AND A.SOLN_STATUS = 'ACTV' AND A.RC_SOLN_VISIBILITY = 'A' AND A.RC_SOLUTION_TYPE NOT IN ( 'ADHC','CAND','FILE','LINK') AND (A.EXPIRY_DATE > %CurrentDateIn OR A.EXPIRY_DATE IS NULL )

  • Related Language Record: RC_ASOLPRSH_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID

    Default Value: 999999999999999

    3 RC_SOLUTION_TYPE Character(4) VARCHAR2(4) NOT NULL Solution Type
    ADHC=Adhoc Solution
    CAND=Canned Solution
    FILE=File
    LINK=Link
    S=Standard Solution
    W=Workaround Solution
    4 SOLN_STATUS Character(4) VARCHAR2(4) NOT NULL Solution Status
    ACTV=4 - Active
    DNED=5 - Denied
    DRFT=1 - Draft
    EXPR=6 - Expired
    REVW=3 - In Review
    RWRK=8 - Rework
    SUBM=2 - Submitted for Review
    SUPR=7 - Superseded
    5 RC_SOLN_VISIBILITY Character(4) VARCHAR2(4) NOT NULL Solution Visibility
    A=All
    I=Internal

    Default Value: A

    6 SOLUTION_SUMMARY Character(80) VARCHAR2(80) NOT NULL Solution Summary
    7 SYMPTOM_DESCR Character(254) VARCHAR2(254) NOT NULL Symptom Description
    8 SOLUTION_DESCR Long Character CLOB Solution Description
    9 SOLN_KEYWORDS Character(100) VARCHAR2(100) NOT NULL Query Keywords
    10 LAST_ACTION_DTTM DateTime(26) TIMESTAMP LAST_ACTION_DTTM
    11 EXPIRY_IND Character(1) VARCHAR2(1) NOT NULL Expiry Indicator
    N=Not Expired
    Y=Expired

    Default Value: N

    12 EXPIRY_DATE Date(10) DATE Expiry Date
    13 EXPIRY_REASON Character(80) VARCHAR2(80) NOT NULL Expiry reason
    14 NEW_SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Superceding Solution ID

    Prompt Table: RC_SOLN_NEW2_VW

    15 LIBRARY_ID Character(5) VARCHAR2(5) NOT NULL Solution Library ID or Troubleshooting Guide ID

    Prompt Table: RC_SOLN_LIB_TBL

    16 USAGE_COUNT Number(8,0) INTEGER NOT NULL Counter of how often this row was selected in a Search Results page and marked as 'Used'. Usage Count is incremented by the USAGE_INCREMENT amount on the Search Setup Parameters page each time the row is 'Used'.

    Default Value: 0

    17 LAST_USAGE_DTTM DateTime(26) TIMESTAMP Used to identify last time the record was marked 'Used' in a Search result
    18 USER_UPDATE_DTTM DateTime(26) TIMESTAMP USER_UPDATE_DTTM
    19 RC_SOLVED_COUNT Number(6,0) INTEGER NOT NULL Solved Count Field in Solution

    Default Value: 0

    20 PROD_DESCRLONG Long Character CLOB Product list for searching
    21 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    22 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    23 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    24 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    25 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    26 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time