DISP_TMPL_FAM_CDLIBRARY_IDRC_FAQ_TOPIC_V2(SQL View) |
Index Back |
|---|---|
Solution Library NamesA view returning the Library Name for Solution Libraries. |
| SELECT DISTINCT A.DISP_TMPL_FAM_CD , C.LIBRARY_ID , C.LIBRARY_NAME FROM PS_RC_FAQ_SETID_VW A , PS_RC_SOLN_LIBRARI B , PS_RC_SOLN_LIB_TBL C WHERE A.SETID = B.SETID AND A.SETID = C.SETID AND B.LIBRARY_ID = C.LIBRARY_ID AND B.SOLUTION_ID = B.SOLUTION_ID AND B.EXTERNAL_FAQ='Y' AND C.SEARCHABLE_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DISP_TMPL_FAM_CD |
Character(30) | VARCHAR2(30) NOT NULL | Display Template Family Code |
| 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 |