RC_DEFINED_VW (SQL View)	Index Back
HelpDesk Predefined Searches Predefined Help Desk Searches for the Self-Service Manage Cases Case Search.

RC_DEFINED_VW

(SQL View)

HelpDesk Predefined Searches

Predefined Help Desk Searches for the Self-Service Manage Cases Case Search.

SELECT RC_PREDEFN_ID , RC_DEFINED_SRCH , DESCR50 FROM PS_RC_DEFINED_SRCH WHERE ROLE_TYPE_ID_CUST = 4

Related Language Record: RC_DEFND_LNG_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 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.

3 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	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.
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50