EOSF_ADDDTL_VW(SQL View) |
Index Back |
|---|---|
Search Configuration DetailsSearch Configuration Details including both Standard and Search records |
| SELECT EOSF_SEARCH_ID ,EFFDT , FIELDNAME ,EOSF_FIELD_ORDER ,EOSF_SRCH_KEY_FLG ,EOSF_USE_IN_ADD ,EOSF_ADD_ORDER ,EOSF_PRMP_EDITTYPE ,EDITTABLE ,EOSF_DROPDOWN_DESC ,DEFAULT_FLAG ,EOSF_DEF_VALUE ,SETCNTRLFLD ,EOSF_ADD_FLD_VISIB ,EOSF_ADD_FLD_GREY FROM PS_EOSF_ADD_DTL |
| # | 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_SRCATTR_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Search Attribute name |
| 4 | EOSF_FIELD_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria/Results Field Order |
| 5 | EOSF_SRCH_KEY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Search Key field flag |
| 6 | EOSF_USE_IN_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 7 | EOSF_ADD_ORDER | Number(1,0) | SMALLINT NOT NULL | Criteria/Results Field Order |
| 8 | 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 |
| 9 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table: PSRECDEFN |
| 10 | EOSF_DROPDOWN_DESC | Character(18) | VARCHAR2(18) NOT NULL | Description Field |
| 11 | DEFAULT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Set As Default
N=No Y=Yes |
| 12 | EOSF_DEF_VALUE | Character(18) | VARCHAR2(18) NOT NULL | Default Field Name |
| 13 | SETCNTRLFLD | Character(18) | VARCHAR2(18) NOT NULL |
Tree Structure Node User Key Field Name
Prompt Table: PSRECFIELDDB |
| 14 | EOSF_ADD_FLD_VISIB | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 15 | EOSF_ADD_FLD_GREY | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |