PTS_SRCDEFN_VW(SQL View) |
Index Back |
|---|---|
Search config. view |
| 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_SRCH_PG_LBL ,D.PTS_SRCH_PG_INSTR ,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 ,D.ADDSRCHRECNAME ,D.PTS_ADD_PG_LBL ,D.PTS_ADD_PG_INSTR ,D.PTS_PKGROOT_A ,D.PTS_CLSPATH_A ,D.PTS_CLSNAME_A ,D.PTS_CLSMETHOD_A ,D.PTS_DFLT_VIEW ,D.PTS_SHOW_RA ,D.PTS_EXEC_AUTOSRCH ,D.PTS_CLPS_SRCH_CRTA ,D.PTS_MAX_SRCH_RSLTS ,D.PTS_SAVD_SRCH_NM 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_SRCH_PG_LBL | Character(100) | VARCHAR2(100) NOT NULL | Search Page Heading |
| 8 | PTS_SRCH_PG_INSTR | Long Character | CLOB | Page Instructions |
| 9 | PTS_RCNT_SRCH_MAX | Number(3,0) | SMALLINT NOT NULL | Recent Search Limit |
| 10 | PTS_RCNT_SRCH_NM | Character(3) | VARCHAR2(3) NOT NULL |
Recent Search Format
LBL=Label value OPR=Label operator value |
| 11 | PTS_SAVE_SRCH_MAX | Number(3,0) | SMALLINT NOT NULL | Maximum of Saved Searches to store |
| 12 | PTS_SRCH_LKP_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Search Lookup Type
A=Advanced B=Basic C=Basic and Advanced |
| 13 | PTS_SRCH_LKP_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
Default Search/Lookup Type (Basic/Advanced)
A=Advanced B=Basic |
| 14 | PTS_ADV_SRCH_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Advance Search Display Pattern (Single/Two Column)
D=Double Column S=Single Column |
| 15 | PTS_ADD_IMAGE | Character(1) | VARCHAR2(1) NOT NULL |
Include Image
Y/N Table Edit Default Value: N |
| 16 | PTS_IMG_SRC_REC | Character(15) | VARCHAR2(15) NOT NULL |
Image Source Record
Prompt Table: PTS_IMG_REC_VW |
| 17 | PTS_IMG_SRC_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Image Source Field
Prompt Table: PTS_IMG_FLD_VW |
| 18 | ADDSRCHRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Additional Search Record Name |
| 19 | PTS_ADD_PG_LBL | Character(100) | VARCHAR2(100) NOT NULL | Add Page Heading |
| 20 | PTS_ADD_PG_INSTR | Long Character | CLOB | Add Page Instructions |
| 21 | PTS_PKGROOT_A | Character(30) | VARCHAR2(30) NOT NULL | Package Name |
| 22 | PTS_CLSPATH_A | Character(127) | VARCHAR2(127) NOT NULL | Qualfd Pkg/Class Path |
| 23 | PTS_CLSNAME_A | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID |
| 24 | PTS_CLSMETHOD_A | Character(100) | VARCHAR2(100) NOT NULL | Method Name |
| 25 | PTS_DFLT_VIEW | Character(1) | VARCHAR2(1) NOT NULL | Include Image |
| 26 | PTS_SHOW_RA | Character(1) | VARCHAR2(1) NOT NULL | Include Image |
| 27 | PTS_EXEC_AUTOSRCH | Character(1) | VARCHAR2(1) NOT NULL | Include Image |
| 28 | PTS_CLPS_SRCH_CRTA | Character(1) | VARCHAR2(1) NOT NULL | Include Image |
| 29 | PTS_MAX_SRCH_RSLTS | Number(9,0) | DECIMAL(9) NOT NULL | Maximum of Saved Searches to store |
| 30 | PTS_SAVD_SRCH_NM | Character(3) | VARCHAR2(3) NOT NULL |
Saved Search Format
LBL=Label value OPR=Label operator value |