RC_SS_FAQSCH_VW (SQL View)	Index Back
FAQ Search Configurable search view for the self service setup FAQ Search.

RC_SS_FAQSCH_VW

(SQL View)

FAQ Search

Configurable search view for the self service setup FAQ Search.

SELECT B.SETID , B.LIBRARY_ID , B.SOLUTION_ID , A.LIBRARY_NAME , B.ROW_ADDED_DTTM , B.ROW_LASTMANT_DTTM FROM PS_RC_SOLN_LIB_TBL A , PS_RC_SOLN_LIBRARI B , PS_RC_SOLUTION C WHERE A.SETID = B.SETID AND A.SETID = C.SETID AND A.LIBRARY_ID =B.LIBRARY_ID AND B.SOLUTION_ID = C.SOLUTION_ID AND A.SEARCHABLE_IND = 'Y' AND B.EXTERNAL_FAQ='Y' AND C.RC_SOLN_VISIBILITY = 'A'

# 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: SP_SETID_NONVW

2 LIBRARY_ID Character(5) VARCHAR2(5) NOT NULL Solution Library ID or Troubleshooting Guide ID
Prompt Table: RC_LIBNAME_VW

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

4 LIBRARY_NAME Character(30) VARCHAR2(30) NOT NULL Library Name
Prompt Table: RC_LIBNAME_VW

5 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

6 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

#	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: SP_SETID_NONVW
2	LIBRARY_ID	Character(5)	VARCHAR2(5) NOT NULL	Solution Library ID or Troubleshooting Guide ID Prompt Table: RC_LIBNAME_VW
3	SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Solution ID
4	LIBRARY_NAME	Character(30)	VARCHAR2(30) NOT NULL	Library Name Prompt Table: RC_LIBNAME_VW
5	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
6	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.