PTS_SEARCH_IDEFFDTPTS_SRCH_TYPEE=Keyword Search
S=Standard Search
PTS_SRCATTR_NAMEY/N Table Edit
Default Value: N
A=Advanced Search
B=Basic Search
C=Both Basic & Advanced
Default Value: A
Y/N Table Edit
Default Value: N
PTS_SRCDTL_VW(SQL View) |
Index Back |
|---|---|
Search Configuration DetailsSearch Configuration Details including both Standard and Elastic search records |
| SELECT PTS_SEARCH_ID ,EFFDT ,'S' , FIELDNAME ,PTS_FIELD_ORDER ,PTS_SRCH_KEY_FLG ,PTS_INCL_IN_CRIT ,PTS_CRIT_ORDER ,PTS_DISP_OPTN ,PTS_INCL_IN_RSLT ,PTS_RSLT_ORDER FROM PS_PTS_SRCH_DTL_S UNION SELECT PTS_SEARCH_ID ,EFFDT ,'E' ,PTS_SRCATTR_NAME ,PTS_FIELD_ORDER ,PTS_SRCH_KEY_FLG ,PTS_INCL_IN_CRIT ,PTS_CRIT_ORDER ,PTS_DISP_OPTN ,PTS_INCL_IN_RSLT ,PTS_RSLT_ORDER FROM PS_PTS_SRCH_DTL_E |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTS_SEARCH_ID |
Character(65) | VARCHAR2(65) NOT NULL | Search ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | PTS_SRCH_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Search Type
E=Keyword Search S=Standard Search |
| 4 | PTS_SRCATTR_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Search Attribute name |
| 5 | PTS_FIELD_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria/Results Field Order |
| 6 | PTS_SRCH_KEY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Search Key field flag |
| 7 | PTS_INCL_IN_CRIT | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 8 | PTS_CRIT_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria Field Order |
| 9 | PTS_DISP_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Field Display in Basic/Advance Search
A=Advanced Search B=Basic Search C=Both Basic & Advanced Default Value: A |
| 10 | PTS_INCL_IN_RSLT | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Results
Y/N Table Edit Default Value: N |
| 11 | PTS_RSLT_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria/Results Field Order |