PTS_RCTSRC_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	PTS_SEARCH_ID	Character(65)	VARCHAR2(65) NOT NULL	Search ID
3	PTS_RCNT_SRCH_CD	Number(3,0)	SMALLINT NOT NULL	Recent Search Code
4	PTS_SRCH_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Search Type E=Keyword Search S=Standard Search
5	PTS_PREVIEW_YN	Character(1)	VARCHAR2(1) NOT NULL	Search Filter - value yes no Y/N Table Edit Default Value: N
6	PTS_SRCH_FIELDNM1	Character(65)	VARCHAR2(65) NOT NULL	Field Name
7	PTS_CRITERIA_ID	Number(2,0)	SMALLINT NOT NULL	Criteria ID
8	PTS_SEARCH_OPER	Character(4)	VARCHAR2(4) NOT NULL	Search Filter operator BET=between BGN=begins with CT=contains EG== GE=>= GT=> LE=<= LT=< NE=not = PH=having phrase
9	PTS_VALUE	Long Character	CLOB	Search Filter - value