EOSF_SRCDTL_VW(SQL View) |
Index Back |
|---|---|
Search Configuration DetailsSearch Configuration Details including both Standard and Search records |
| SELECT EOSF_SEARCH_ID ,EFFDT ,'S' , FIELDNAME ,EOSF_FIELD_ORDER ,EOSF_SRCH_KEY_FLG ,EOSF_INCL_IN_CRIT ,EOSF_CRIT_ORDER ,EOSF_DISP_OPTN ,EOSF_INCL_IN_RSLT ,EOSF_RSLT_ORDER ,EOSF_PRMP_EDITTYPE ,EDITTABLE ,EOSF_DROPDOWN_DESC ,SETCNTRLFLD FROM PS_EOSF_SRCH_DTL_S UNION SELECT EOSF_SEARCH_ID ,EFFDT ,'E' ,EOSF_SRCATTR_NAME ,EOSF_FIELD_ORDER ,EOSF_SRCH_KEY_FLG ,EOSF_INCL_IN_CRIT ,EOSF_CRIT_ORDER ,EOSF_DISP_OPTN ,EOSF_INCL_IN_RSLT ,EOSF_RSLT_ORDER ,EOSF_PRMP_EDITTYPE ,EDITTABLE ,EOSF_DROPDOWN_DESC ,SETCNTRLFLD FROM PS_EOSF_SRCH_DTL_E |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOSF_SEARCH_ID |
Character(65) | VARCHAR2(65) NOT NULL | Search ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | EOSF_SRCH_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Search Type
E=Search S=Standard Search |
| 4 | EOSF_SRCATTR_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Search Attribute name |
| 5 | EOSF_FIELD_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria/Results Field Order |
| 6 | EOSF_SRCH_KEY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Search Key field flag |
| 7 | EOSF_INCL_IN_CRIT | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 8 | EOSF_CRIT_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria/Results Field Order |
| 9 | 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 Default Value: A |
| 10 | EOSF_INCL_IN_RSLT | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Results
Y/N Table Edit Default Value: N |
| 11 | EOSF_RSLT_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria/Results Field Order |
| 12 | 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 |
| 13 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table: PSRECDEFN |
| 14 | EOSF_DROPDOWN_DESC | Character(18) | VARCHAR2(18) NOT NULL | Description Field |
| 15 | SETCNTRLFLD | Character(18) | VARCHAR2(18) NOT NULL |
Tree Structure Node User Key Field Name
Prompt Table: PSRECFIELDDB |