CONTEXT_IDSETIDRC_CXT_TPSOL_VW(SQL View) |
Index Back |
|---|---|
Fetch Top SolutionsRecord to fetch Top Solutions and display it in Find Help Page |
| SELECT A.CONTEXT_ID , A.SETID , A.LIBRARY_ID , B.SOLUTION_ID ,'N' , C.RC_SUMMARY ,C.SOLUTION_DESCR ,C.USAGE_COUNT ,C.SS_USAGE_COUNT ,C.RC_SS_SOLVED_COUNT +C.RC_SOLVED_COUNT ,C.LAST_USAGE_DTTM ,C.USER_UPDATE_DTTM ,C.ROW_ADDED_DTTM FROM PS_RC_CNTXT_SOLLIB A , PS_RC_SS_SOLUTION B ,PS_RC_SOLUTION C WHERE A.SETID=B.SETID AND A.LIBRARY_ID=B.LIBRARY_ID AND A.SETID=C.SETID AND A.LIBRARY_ID=B.LIBRARY_ID AND B.SOLUTION_ID =C.SOLUTION_ID AND C.RC_SOLN_VISIBILITY = 'A' AND C.SOLN_STATUS = 'ACTV' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTEXT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Context Map 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 | EXTERNAL_FAQ | Character(1) | VARCHAR2(1) NOT NULL | External (self-service) frequently-asked-question |
| 6 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
| 7 | SOLUTION_DESCR | Long Character | CLOB | Solution Description |
| 8 | USAGE_COUNT | Number(8,0) | INTEGER NOT NULL | Counter of how often this row was selected in a Search Results page and marked as 'Used'. Usage Count is incremented by the USAGE_INCREMENT amount on the Search Setup Parameters page each time the row is 'Used'. |
| 9 | SS_USAGE_COUNT | Number(8,0) | INTEGER NOT NULL | Counter of how often this row was selected in a Search Results page and marked as 'Used'. Usage Count is incremented by the USAGE_INCREMENT amount on the Search Setup Parameters page each time the row is 'Used'. |
| 10 | RC_SS_SOLVED_COUNT | Number(6,0) | INTEGER NOT NULL | Solved Count Field in Solution |
| 11 | LAST_USAGE_DTTM | DateTime(26) | TIMESTAMP | Used to identify last time the record was marked 'Used' in a Search result |
| 12 | USER_UPDATE_DTTM | DateTime(26) | TIMESTAMP | USER_UPDATE_DTTM |
| 13 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |