DISP_TMPL_FAM_CDLIBRARY_NAMERC_FAQ_DESCR_VW(SQL View) |
Index Back |
|---|---|
FAQ questions and answersThis view returns a list of Solutions along with the question and topic they belong. It used on the FAQ Details page for Service self service. |
| SELECT A.DISP_TMPL_FAM_CD , A.LIBRARY_NAME , A.SOLUTION_ID , A.RC_SUMMARY , B.SOLUTION_DESCR , A.SETID , A.LIBRARY_ID FROM PS_RC_FAQ_SUM_VW A , PS_RC_SOLUTION B WHERE A.SOLUTION_ID = B.SOLUTION_ID AND A.RC_SUMMARY = B.RC_SUMMARY |
| # | 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_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Library Name |
| 3 | SOLUTION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |
| 4 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
| 5 | SOLUTION_DESCR | Long Character | CLOB | Solution Description |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 7 | LIBRARY_ID | Character(5) | VARCHAR2(5) NOT NULL | Solution Library ID or Troubleshooting Guide ID |