DISP_TMPL_FAM_CDSETIDPrompt Table: SP_SETID_NONVW
LIBRARY_IDSOLUTION_IDRC_SS_FAQ_VW(SQL View) |
Index Back |
|---|---|
FAQsView on the setup table for storing FAQ's selected by the admin to be displayed on the self service home page Top FAQs pagelet. The view is used in the pagelet and contains only FAQ's marked with Include_link = 'Y'. Sep 19, 2014: Bug #17828189 Added criteria - Solution Status = Active Sep 06, 2015: Bug #21517112 Added criteria - External FAQ = Yes |
| SELECT A.DISP_TMPL_FAM_CD , A.SETID , A.LIBRARY_ID , A.SOLUTION_ID , A.SEQNUM FROM PS_RC_SS_FAQ A , PS_RC_SOLN_LIB_TBL B , PS_RC_SOLUTION C , PS_RC_SOLN_LIBRARI D WHERE B.SEARCHABLE_IND = 'Y' AND A.SETID = B.SETID AND A.LIBRARY_ID = B.LIBRARY_ID AND C.SETID = A.SETID AND C.SOLUTION_ID = A.SOLUTION_ID AND C.SOLN_STATUS = 'ACTV' AND D.SETID = A.SETID AND D.SOLUTION_ID = A.SOLUTION_ID AND D.LIBRARY_ID = A.LIBRARY_ID AND D.EXTERNAL_FAQ = '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 | 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 |
| 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 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |