DISP_TMPL_FAM_CDLIBRARY_IDLANGUAGE_CDRC_FAQTOPV2_LNG(SQL View) |
Index Back |
|---|---|
Solution Library NamesA view returning the Library Name for Solution Libraries. |
| SELECT DISTINCT A.DISP_TMPL_FAM_CD , D.LIBRARY_ID , D.LANGUAGE_CD , D.LIBRARY_NAME FROM PS_RC_FAQ_SETID_VW A , PS_RC_SOLN_LIBRARI B , PS_RC_SOLN_LIB_TBL C LEFT OUTER JOIN PS_RC_SOLN_LIB_LNG D ON C.SETID=D.setid AND c.library_id=d.library_id 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | LIBRARY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Library Name |