PTS_SAVEDSRCH_D

#	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_SAVESRCH_CD	Character(30)	VARCHAR2(30) NOT NULL	Saved Search Code
4	PTS_SRCH_FIELDNM1	Character(65)	VARCHAR2(65) NOT NULL	Field Name
5	PTS_SRCH_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Search Type E=Keyword Search S=Standard Search
6	PTS_PREVIEW_YN	Character(1)	VARCHAR2(1) NOT NULL	Search Filter - value yes no Y/N Table Edit Default Value: N
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
10	PTS_NDVAL	Character(254)	VARCHAR2(254) NOT NULL	Search filter- value
11	PTS_VALUE_PROMPT	Character(50)	VARCHAR2(50) NOT NULL	Search Filter - value prompt Prompt Table: %EDITTABLE2
12	PTS_NDVAL_PROMPT	Character(50)	VARCHAR2(50) NOT NULL	Search Filter - value prompt Prompt Table: %EDITTABLE2
13	PTS_VALUE_NEPRMT	Character(50)	VARCHAR2(50) NOT NULL	Search Filter - value prompt without Edit
14	PTS_NDVAL_NEPRMT	Character(50)	VARCHAR2(50) NOT NULL	Search Filter - value prompt without edit
15	PTS_VALUE_XLAT	Character(4)	VARCHAR2(4) NOT NULL	Search Filter - value xlat Prompt Table: PTS_XLATPR_VW
16	PTS_VALUE_YESNO	Character(1)	VARCHAR2(1) NOT NULL	Search Filter - value yes no N=No Y=Yes Default Value: Y
17	PTS_VALUE_DATE	Date(10)	DATE	Search Filter - value date
18	PTS_NDVAL_DATE	Date(10)	DATE	Search Filter - value date
19	PTS_VALUE_TIME	Time(15)	TIMESTAMP	Search Filter - value time
20	PTS_NDVAL_TIME	Time(15)	TIMESTAMP	Search Filter - value time