RC_SS_SOLSCH_VW (SQL View)	Index Back
Solution search record Search record for top solution config search

RC_SS_SOLSCH_VW

(SQL View)

Solution search record

Search record for top solution config search

SELECT SETID , SOLUTION_ID , LIBRARY_ID ,' ' , RC_SUMMARY , ' ' , USAGE_COUNT , RC_SOLVED_COUNT , SS_USAGE_COUNT , RC_SS_SOLVED_COUNT , RC_SS_UNSOLVED_CNT , LAST_USAGE_DTTM FROM PS_RC_SOLUTION WHERE RC_SOLUTION_TYPE='S' AND SOLN_STATUS='ACTV' AND RC_SOLN_VISIBILITY='A' AND EXPIRY_IND='N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Prompt Table: RC_SSTMPL_SETID

2 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID

3 LIBRARY_ID Character(5) VARCHAR2(5) NOT NULL Solution Library ID or Troubleshooting Guide ID

4 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code

5 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.

6 CHECKBOX Character(1) VARCHAR2(1) NOT NULL Found
N=No
Y=Yes

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 RC_SOLVED_COUNT Number(6,0) INTEGER NOT NULL Solved Count Field in Solution

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 RC_SS_UNSOLVED_CNT Number(6,0) INTEGER NOT NULL Solved Count Field in Solution

12 LAST_USAGE_DTTM DateTime(26) TIMESTAMP Used to identify last time the record was marked 'Used' in a Search result

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Prompt Table: RC_SSTMPL_SETID
2	SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Solution ID
3	LIBRARY_ID	Character(5)	VARCHAR2(5) NOT NULL	Solution Library ID or Troubleshooting Guide ID
4	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code
5	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
6	CHECKBOX	Character(1)	VARCHAR2(1) NOT NULL	Found N=No Y=Yes
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	RC_SOLVED_COUNT	Number(6,0)	INTEGER NOT NULL	Solved Count Field in Solution
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	RC_SS_UNSOLVED_CNT	Number(6,0)	INTEGER NOT NULL	Solved Count Field in Solution
12	LAST_USAGE_DTTM	DateTime(26)	TIMESTAMP	Used to identify last time the record was marked 'Used' in a Search result