EOSF_SRCDEFN_VW(SQL View) |
Index Back |
|---|---|
Search config. view |
| 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_SRCH_PG_LBL ,D.EOSF_SRCH_PG_INSTR ,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 ,D.ADDSRCHRECNAME ,D.EOSF_ADD_PG_LBL ,D.EOSF_ADD_PG_INSTR ,D.EOSF_PKGROOT_S ,D.EOSF_CLSPATH_S ,D.EOSF_CLSNAME_S ,D.EOSF_CLSMETHOD_S ,D.EOSF_PKGROOT_A ,D.EOSF_CLSPATH_A ,D.EOSF_CLSNAME_A ,D.EOSF_CLSMETHOD_A 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_SRCH_PG_LBL | Character(100) | VARCHAR2(100) NOT NULL | Page Title |
| 8 | EOSF_SRCH_PG_INSTR | Long Character | CLOB | Page Instructions |
| 9 | EOSF_RCNT_SRCH_MAX | Number(3,0) | SMALLINT NOT NULL | Recent Search Limit |
| 10 | EOSF_RCNT_SRCH_NM | Character(3) | VARCHAR2(3) NOT NULL |
Recent Search Name Display Format
LBL=Field Label: Value VAL=Field Value |
| 11 | EOSF_SAVE_SRCH_MAX | Number(3,0) | SMALLINT NOT NULL | Maximum of Saved Searches to store |
| 12 | EOSF_SRCH_LKP_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Search Lookup Type
A=Advanced B=Basic C=Basic and Advanced |
| 13 | EOSF_SRCH_LKP_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
Default Search/Lookup Type (Basic/Advanced)
A=Advanced B=Basic |
| 14 | EOSF_ADV_SRCH_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Advance Search Display Pattern (Single/Two Column)
D=Double Column S=Single Column |
| 15 | EOSF_ADD_IMAGE | Character(1) | VARCHAR2(1) NOT NULL |
Include Image
Y/N Table Edit Default Value: N |
| 16 | EOSF_IMG_SRC_REC | Character(15) | VARCHAR2(15) NOT NULL |
Image Source Record
Prompt Table: EOSF_IMG_REC_VW |
| 17 | EOSF_IMG_SRC_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Image Source Field
Prompt Table: EOSF_IMG_FLD_VW |
| 18 | ADDSRCHRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Additional Search Record Name |
| 19 | EOSF_ADD_PG_LBL | Character(100) | VARCHAR2(100) NOT NULL | Page Title |
| 20 | EOSF_ADD_PG_INSTR | Long Character | CLOB | Page Instructions |
| 21 | EOSF_PKGROOT_S | Character(30) | VARCHAR2(30) NOT NULL | Package Name |
| 22 | EOSF_CLSPATH_S | Character(127) | VARCHAR2(127) NOT NULL | Qualified Package/Class Path |
| 23 | EOSF_CLSNAME_S | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID |
| 24 | EOSF_CLSMETHOD_S | Character(100) | VARCHAR2(100) NOT NULL | Method Name |
| 25 | EOSF_PKGROOT_A | Character(30) | VARCHAR2(30) NOT NULL | Package Name |
| 26 | EOSF_CLSPATH_A | Character(127) | VARCHAR2(127) NOT NULL | Qualified Package/Class Path |
| 27 | EOSF_CLSNAME_A | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID |
| 28 | EOSF_CLSMETHOD_A | Character(100) | VARCHAR2(100) NOT NULL | Method Name |