RBT_FAQSOLDT_VW

(SQL View)
 Index Back

FAQ Details

This view shows details of a FAQ. View Changed as per ICE # 2030520000

SELECT A.SETID ,A.SOLUTION_ID ,A.SYMPTOM_DESCR ,A.SOLUTION_DESCR ,A.ROW_LASTMANT_DTTM FROM PS_RC_SOLUTION A , PS_RC_SOLN_LIBRARI B , PS_RC_SOLN_LIB_TBL C WHERE A.SETID=B.SETID AND A.SOLUTION_ID = B.SOLUTION_ID AND B.SETID = C.SETID AND B.LIBRARY_ID=C.LIBRARY_ID AND C.SEARCHABLE_IND='Y' AND A.EXPIRY_IND <> 'Y' AND A.SOLN_STATUS = 'ACTV' AND A.RC_SOLN_VISIBILITY='A'

  • Related Language Record: RC_FAQSOLND_LNG

    • # 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 SYMPTOM_DESCR Character(254) VARCHAR2(254) NOT NULL Symptom Description
    4 SOLUTION_DESCR Long Character CLOB Solution Description
    5 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.