CONTEXT_IDSETIDRC_CXT_FETSOLVW(SQL View) |
Index Back |
|---|---|
Fetch Featured SolutionRecord to fetch Featured Solution |
| SELECT A.CONTEXT_ID , A.SETID ,B.LIBRARY_ID , B.SOLUTION_ID , 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_CNXT_SELSLTN A LEFT OUTER JOIN PS_RC_SOLN_LIBRARI B ON (A.SETID=B.SETID AND A.SOLUTION_ID=B.SOLUTION_ID) LEFT OUTER JOIN PS_RC_SOLUTION C ON(A.SETID=C.SETID AND A.SOLUTION_ID=C.SOLUTION_ID ) |
| # | 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 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
| 6 | SOLUTION_DESCR | Long Character | CLOB | Solution Description |
| 7 | 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'. |
| 8 | 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'. |
| 9 | RC_SS_SOLVED_COUNT | Number(6,0) | INTEGER NOT NULL | Solved Count Field in Solution |
| 10 | LAST_USAGE_DTTM | DateTime(26) | TIMESTAMP | Used to identify last time the record was marked 'Used' in a Search result |
| 11 | USER_UPDATE_DTTM | DateTime(26) | TIMESTAMP | USER_UPDATE_DTTM |
| 12 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |