FO_SRC_PLSRC_WS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SO_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 3 | SO_LINE |
Number(3,0) | SMALLINT NOT NULL | Line Number |
| 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
Prompt Table: %EDITTABLE |
| 9 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 10 | VERITY_FIELD | Character(1) | VARCHAR2(1) NOT NULL |
Field - Comparable
Y/N Table Edit |
| 11 | SRCH_RESUME | Character(1) | VARCHAR2(1) NOT NULL |
Search in resume.
N=Inactive Y=Active Default Value: N |
| 12 | PROMPTED_SELECT | Character(30) | VARCHAR2(30) NOT NULL |
Select Value
Prompt Table: %EDITTABLE |
| 13 | SELECT_DT | Date(10) | DATE | Date |
| 14 | SRCH_PREF_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Required Or Desired
N=No Y=Yes Default Value: Y |
| 15 | 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 Default Value: = Prompt Table: FO_COMP_OPRTR |
| 16 | COMBINED_SRCH_REF | Character(15) | VARCHAR2(15) NOT NULL |
Combination Search Reference
Prompt Table: %EDITTABLE |
| 17 | COMBINED_SRCH_FLD | Character(15) | VARCHAR2(15) NOT NULL |
Combination Search Field
Prompt Table: FO_TEST_SRC_DTL |