PTIACPFLTRQRYID<=Less Than
<==Less Than or Equal To
<>=Not Equal To
==Equal To
>=Greater Than
>==Greater Than or Equal To
PTIACPTMPLTFQDF(SQL Table) |
Index Back |
|---|---|
Filter Query Step DefinitionThis table stores metadata about which filter queries are used by CA template steps |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIACPFLTRQRYID |
Character(50) | VARCHAR2(50) NOT NULL | ID for filter query |
| 2 | PTIACPSTEPID | Character(10) | VARCHAR2(10) NOT NULL | Step ID |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | OPERATION | Character(3) | VARCHAR2(3) NOT NULL |
Arithmetic Operation
<=Less Than <==Less Than or Equal To <>=Not Equal To ==Equal To >=Greater Than >==Greater Than or Equal To |
| 5 | PTIACPFLTRQRYSQL | Character(254) | VARCHAR2(254) NOT NULL | filter query operation |
| 6 | PTIACPFLTRQRYVL | Character(100) | VARCHAR2(100) NOT NULL | value result for filter query |
| 7 | PTIACPFLTRQRYOT | Character(30) | VARCHAR2(30) NOT NULL | result type of filter query |
| 8 | PTIACPFLTRQRYOP | Character(254) | VARCHAR2(254) NOT NULL | filter query operation |