DISP_TMPL_FAM_CDSETIDLIBRARY_IDSOLUTION_IDLANGUAGE_CDRC_FAQ_SUMV_LNG(SQL View) |
Index Back |
|---|---|
RC_FAQ_SUM_VWThis view returns a list of questions along with the topic they belong to and is used at the top of the FAQ page to display the FAQs. Sep 19, 2014: Bug #17828189 Added criteria - Solution Status = Active |
| SELECT DISTINCT A.DISP_TMPL_FAM_CD , A.SETID , B.LIBRARY_ID , D.SOLUTION_ID , E.LANGUAGE_CD , E.RC_SUMMARY FROM PS_RC_FAQ_SETID_VW A , PS_RC_SOLN_LIBRARI B , PS_RC_SOLN_LIB_TBL C , PS_RC_SOLUTION D LEFT OUTER JOIN PS_RC_SOLUTION_LNG E ON D.SETID=E.SETID AND D.SOLUTION_ID=E.SOLUTION_ID WHERE A.SETID = B.SETID AND A.SETID = C.SETID AND A.SETID = D.SETID AND B.SETID = C.SETID AND B.SETID = D.SETID AND C.SETID = D.SETID AND B.LIBRARY_ID = C.LIBRARY_ID AND B.SOLUTION_ID = D.SOLUTION_ID AND B.EXTERNAL_FAQ='Y' AND C.SEARCHABLE_IND = 'Y' AND D.SOLN_STATUS = 'ACTV' |
| # | 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 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 3 | LIBRARY_ID |
Character(5) | VARCHAR2(5) NOT NULL | Solution Library ID or Troubleshooting Guide ID |
| 4 | SOLUTION_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |