RG_DEFINED_SRCH (SQL Table)	Index Back
Predefined Case Search Critera Used in Self-Service Help Desk and Support. This is system data.

RG_DEFINED_SRCH

(SQL Table)

Predefined Case Search Critera

Used in Self-Service Help Desk and Support. This is system data.

Related Language Record: RG_DEFINED_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RG_PREDEFN_ID Character(10) VARCHAR2(10) NOT NULL Pre-defined search definition to be used for the configurable component. (applicable for change request self-service 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 RG_DEFINED_SRCH Character(5) VARCHAR2(5) NOT NULL Predefined Search - Used in the Self-Service Search for Help Desk Change Requestc. This is system data.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RG_PREDEFN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pre-defined search definition to be used for the configurable component. (applicable for change request self-service 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	RG_DEFINED_SRCH	Character(5)	VARCHAR2(5) NOT NULL	Predefined Search - Used in the Self-Service Search for Help Desk Change Requestc. This is system data.
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50