PTS_SRCHDEF_VW

(SQL View)
 Index Back

Search Definition View

Record View to display current dated Search Definition

SELECT D.PORTAL_NAME ,D.PORTAL_OBJNAME ,D.PTS_SEARCH_ID ,D.PTS_SRCH_TYPE ,D.PTS_SRCH_RECNM ,D.PTS_SRCH_ESDEF ,D.PTS_RCNT_SRCH_MAX ,D.PTS_RCNT_SRCH_NM ,D.PTS_SAVE_SRCH_MAX ,D.PTS_SRCH_LKP_OPTN ,D.PTS_SRCH_LKP_DFLT ,D.PTS_ADV_SRCH_DISP ,D.PTS_ADD_IMAGE ,D.PTS_IMG_SRC_REC ,D.PTS_IMG_SRC_FLD FROM PS_PTS_SRCH_DEFN D WHERE %EffdtCheck(PTS_SRCH_DEFN D1, D, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
3 PTS_SEARCH_ID Character(65) VARCHAR2(65) NOT NULL Search ID
4 PTS_SRCH_TYPE Character(1) VARCHAR2(1) NOT NULL Search Type
E=Keyword Search
S=Standard Search
5 PTS_SRCH_RECNM Character(15) VARCHAR2(15) NOT NULL Search Record Name
6 PTS_SRCH_ESDEF Character(65) VARCHAR2(65) NOT NULL Elastic Search Definition Name
7 PTS_RCNT_SRCH_MAX Number(3,0) SMALLINT NOT NULL Recent Search Limit
8 PTS_RCNT_SRCH_NM Character(3) VARCHAR2(3) NOT NULL Recent Search Format
LBL=Label value
OPR=Label operator value
9 PTS_SAVE_SRCH_MAX Number(3,0) SMALLINT NOT NULL Maximum of Saved Searches to store
10 PTS_SRCH_LKP_OPTN Character(1) VARCHAR2(1) NOT NULL Search Lookup Type
A=Advanced
B=Basic
C=Basic and Advanced
11 PTS_SRCH_LKP_DFLT Character(1) VARCHAR2(1) NOT NULL Default Search/Lookup Type (Basic/Advanced)
A=Advanced
B=Basic
12 PTS_ADV_SRCH_DISP Character(1) VARCHAR2(1) NOT NULL Advance Search Display Pattern (Single/Two Column)
D=Double Column
S=Single Column
13 PTS_ADD_IMAGE Character(1) VARCHAR2(1) NOT NULL Include Image

Y/N Table Edit

Default Value: N

14 PTS_IMG_SRC_REC Character(15) VARCHAR2(15) NOT NULL Image Source Record

Prompt Table: PTS_IMG_REC_VW

15 PTS_IMG_SRC_FLD Character(18) VARCHAR2(18) NOT NULL Image Source Field

Prompt Table: PTS_IMG_FLD_VW