RC_SRCH_LANG_VW (SQL View)	Index Back
Pre-defined search view Pre Defined search view to contain only pre-defined searches that are enabled.

RC_SRCH_LANG_VW

(SQL View)

Pre-defined search view

Pre Defined search view to contain only pre-defined searches that are enabled.

SELECT A.RC_PREDEFN_ID , A.ROLE_TYPE_ID_CUST , A.RC_DEFINED_SRCH , B.LANGUAGE_CD , B.DESCR50 FROM PS_RC_DEFINED_SRCH A , PS_RC_DEFINED_LNG B WHERE A.RC_PREDEFN_ID = B.RC_PREDEFN_ID AND A.ROLE_TYPE_ID_CUST = B.ROLE_TYPE_ID_CUST AND A.RC_DEFINED_SRCH = B.RC_DEFINED_SRCH AND A.ENABLE_FLG = 'Y'

Related Language Record for RC_DEFN_SRCH_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RC_PREDEFN_ID Character(10) VARCHAR2(10) NOT NULL Pre-defined search definition to be used for the configurable component. (applicable for call center self-service case components)

2 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
Prompt Table: BO_ROLE_TYPE

3 RC_DEFINED_SRCH Character(5) VARCHAR2(5) NOT NULL Predefined Search - Used in the Self-Service Search for Help Desk and Support. This is system data.

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RC_PREDEFN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pre-defined search definition to be used for the configurable component. (applicable for call center self-service case components)
2	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer Prompt Table: BO_ROLE_TYPE
3	RC_DEFINED_SRCH	Character(5)	VARCHAR2(5) NOT NULL	Predefined Search - Used in the Self-Service Search for Help Desk and Support. This is system data.
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50