RC_SS_TOPIC_VW

(SQL View)
Index Back

Solution Topics

Solution topics (libraries) that are available for Self Service SEPT 19 2014 : Bug 18989479 Created and added related language record view RC_SS_TOPIC_LVW.

SELECT A.SETID ,A.LIBRARY_ID ,A.LIBRARY_NAME FROM PS_RC_SOLN_LIB_TBL A WHERE A.SEARCHABLE_IND='Y'

  • Related Language Record: RC_SS_TOPIC_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.

    Prompt Table: SP_SETID_NONVW
    Set Control Field: BUSINESS_UNIT

    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