FO_SRCH_SVD_FF(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SRCH_TYPE_CD |
Character(5) | VARCHAR2(5) NOT NULL | Search Type |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | SAVED_NAME |
Character(15) | VARCHAR2(15) NOT NULL | Saved Search Name |
| 4 | ORDERNO |
Number(5,0) | INTEGER NOT NULL | Sort Order |
| 5 | SRCH_CATEGORY |
Character(15) | VARCHAR2(15) NOT NULL | Category |
| 6 | MTCH_COL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Column |
| 7 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 8 | FO_SRCH_FLD_VAL | Character(254) | VARCHAR2(254) NOT NULL | Criteria |
| 9 | PROMPTED_SELECT | Character(30) | VARCHAR2(30) NOT NULL | Select Value |
| 10 | SELECT_DT | Date(10) | DATE | Date |
| 11 | SRCH_PREF_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Required Or Desired
N=No Y=Yes |
| 12 | COMP_OPERATOR | Character(2) | VARCHAR2(2) NOT NULL |
Represents SQL field comparison syntax when the user is creating node specific data selection criteria
<=< <==<= <>=<> === >=> >==>= B=Begins With C=Contains E=Ends With NB=Doesn't Begins With NC=Doesn't Contains NE=Doesn't Ends With Prompt Table: FO_COMP_OPRTR |
| 13 | COMBINED_SRCH_REF | Character(15) | VARCHAR2(15) NOT NULL | Combination Search Reference |
| 14 | COMBINED_SRCH_FLD | Character(15) | VARCHAR2(15) NOT NULL | Combination Search Field |
| 15 | SRCH_RESUME | Character(1) | VARCHAR2(1) NOT NULL |
Search in resume.
N=Inactive Y=Active |