EOSF_SRCHDEF_VW(SQL View) |
Index Back |
|---|---|
Search Definition ViewRecord View to display current dated Search Definition |
| SELECT D.PORTAL_NAME ,D.PORTAL_OBJNAME ,D.EOSF_SEARCH_ID ,D.EOSF_SRCH_TYPE ,D.EOSF_SRCH_RECNM ,D.EOSF_SRCH_ESDEF ,D.EOSF_RCNT_SRCH_MAX ,D.EOSF_RCNT_SRCH_NM ,D.EOSF_SAVE_SRCH_MAX ,D.EOSF_SRCH_LKP_OPTN ,D.EOSF_SRCH_LKP_DFLT ,D.EOSF_ADV_SRCH_DISP ,D.EOSF_ADD_IMAGE ,D.EOSF_IMG_SRC_REC ,D.EOSF_IMG_SRC_FLD FROM PS_EOSF_SRCH_DEFN D WHERE %EffdtCheck(EOSF_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 | EOSF_SEARCH_ID |
Character(65) | VARCHAR2(65) NOT NULL | Search ID |
| 4 | EOSF_SRCH_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Search Type
E=Search S=Standard Search |
| 5 | EOSF_SRCH_RECNM | Character(15) | VARCHAR2(15) NOT NULL | Search Record Name |
| 6 | EOSF_SRCH_ESDEF | Character(65) | VARCHAR2(65) NOT NULL | Search Definition Name |
| 7 | EOSF_RCNT_SRCH_MAX | Number(3,0) | SMALLINT NOT NULL | Recent Search Limit |
| 8 | EOSF_RCNT_SRCH_NM | Character(3) | VARCHAR2(3) NOT NULL |
Recent Search Name Display Format
LBL=Field Label: Value VAL=Field Value |
| 9 | EOSF_SAVE_SRCH_MAX | Number(3,0) | SMALLINT NOT NULL | Maximum of Saved Searches to store |
| 10 | EOSF_SRCH_LKP_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Search Lookup Type
A=Advanced B=Basic C=Basic and Advanced |
| 11 | EOSF_SRCH_LKP_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
Default Search/Lookup Type (Basic/Advanced)
A=Advanced B=Basic |
| 12 | EOSF_ADV_SRCH_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Advance Search Display Pattern (Single/Two Column)
D=Double Column S=Single Column |
| 13 | EOSF_ADD_IMAGE | Character(1) | VARCHAR2(1) NOT NULL |
Include Image
Y/N Table Edit Default Value: N |
| 14 | EOSF_IMG_SRC_REC | Character(15) | VARCHAR2(15) NOT NULL |
Image Source Record
Prompt Table: EOSF_IMG_REC_VW |
| 15 | EOSF_IMG_SRC_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Image Source Field
Prompt Table: EOSF_IMG_FLD_VW |