EOSF_SRCH_DTL_S(SQL Table) |
Index Back |
|---|---|
Search Configuration DetailsSearch Configuration Criteria/Resluts Details |
| # | 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 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | EOSF_FIELD_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria/Results Field Order |
| 7 | EOSF_SRCH_KEY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Search Key field flag |
| 8 | EOSF_INCL_IN_CRIT | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 9 | EOSF_CRIT_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria/Results Field Order |
| 10 | EOSF_DISP_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Field Display in Basic/Advance Search
A=Advanced Search B=Basic Search C=Basic and Advanced Search |
| 11 | EOSF_INCL_IN_RSLT | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Results
Y/N Table Edit Default Value: N |
| 12 | EOSF_RSLT_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria/Results Field Order |
| 13 | EOSF_PRMP_EDITTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Promopt Edit Type
0=No Prompt Edit 1=No Table Edit 2=Prompt Table 3=Translate Table 4=Yes/No Default Value: 0 |
| 14 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table: PSRECDEFN |
| 15 | EOSF_DROPDOWN_DESC | Character(18) | VARCHAR2(18) NOT NULL | Description Field |
| 16 | SETCNTRLFLD | Character(18) | VARCHAR2(18) NOT NULL |
Tree Structure Node User Key Field Name
Prompt Table: PSRECFIELDDB |