PTS_SRCH_DTL_E(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 | PTS_SEARCH_ID |
Character(65) | VARCHAR2(65) NOT NULL | Search ID |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | PTS_SRCATTR_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Search Attribute name |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | PTS_DEF_LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL | LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG. |
| 8 | PTS_FIELD_LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
| 9 | PTS_MODIFY_LBL | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 10 | PTS_FIELD_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria/Results Field Order |
| 11 | PTS_SRCH_KEY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Search Key field flag |
| 12 | PTS_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 13 | PTS_HIDE | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 14 | PTS_DISPLAYONLY | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 15 | PTS_DEF_VALUE | Character(18) | VARCHAR2(18) NOT NULL | Default Field Name |
| 16 | PTS_INCL_IN_CRIT | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 17 | PTS_CRIT_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria Field Order |
| 18 | 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 |
| 19 | PTS_INCL_IN_RSLT | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Results
Y/N Table Edit Default Value: N |
| 20 | PTS_INCL_IN_SFF | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Results
Y/N Table Edit |
| 21 | PTS_RSLT_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria/Results Field Order |