RC_FAQ_LIB_VW

(SQL View)
 Index Back

FAQ's

FAQ libraries for Self-Service

SELECT L.SETID , L.LIBRARY_ID , L.LIBRARY_NAME FROM PS_RC_SOLN_LIB_TBL L WHERE EXISTS ( SELECT 'x' FROM PS_RC_SOLUTION S , PS_RC_SOLN_LIBRARI SL WHERE L.SETID = S.SETID AND S.SETID = SL.SETID AND S.SOLUTION_ID = SL.SOLUTION_ID AND L.LIBRARY_ID = SL.LIBRARY_ID AND SL.INTERNAL_FAQ = 'Y')

  • Related Language Record: RC_FAQ_LIB_L_VW

    • # 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 LIBRARY_ID Character(5) VARCHAR2(5) NOT NULL Solution Library ID or Troubleshooting Guide ID
    3 LIBRARY_NAME Character(30) VARCHAR2(30) NOT NULL Library Name