SRCH_TYPE_CDSRCH_CATEGORYMTCH_COL_IDDEFAULT_DESCR<=<
<==<=
<>=<>
===
>=>
>==>=
B=Begins With
C=Contains
E=Ends With
NB=Doesn't Begins With
NC=Doesn't Contains
NE=Doesn't Ends With
FO_SRCH_PROMPT(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 | SRCH_CATEGORY |
Character(15) | VARCHAR2(15) NOT NULL | Category |
| 3 | MTCH_COL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Column |
| 4 | DEFAULT_DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Default Asset Description |
| 5 | PROMPT_TABLE | Character(15) | VARCHAR2(15) NOT NULL | Record Name |
| 6 | RS1_REC | Character(15) | VARCHAR2(15) NOT NULL | RowSet 1 Record |
| 7 | RS2_REC | Character(15) | VARCHAR2(15) NOT NULL | Rowset 2 Record |
| 8 | RS3_REC | Character(15) | VARCHAR2(15) NOT NULL | |
| 9 | ROW_REC | Character(15) | VARCHAR2(15) NOT NULL | |
| 10 | ROW_REC_FIELD | Character(30) | VARCHAR2(30) NOT NULL | |
| 11 | 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 |
| 12 | SQL_STMT_254 | Character(254) | VARCHAR2(254) NOT NULL | An internal work field that contains SQL text that is to be utilized in treasury application p |