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