RC_SS_TOPIC_VW(SQL View) |
Index Back |
---|---|
Solution TopicsSolution 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' |
# | 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
|
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 |