PTIACPTMPLTFQDF

index back

Filter Query Step Definition

This table stores metadata about which filter queries are used by CA template steps

PeopleSoft Field Name Field Type Column Type Description
PTIACPFLTRQRYID Character(50) VARCHAR2(50) NOT NULL ID for filter query
PTIACPSTEPID Character(10) VARCHAR2(10) NOT NULL Step ID
DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
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
PTIACPFLTRQRYSQL Character(254) VARCHAR2(254) NOT NULL filter query operation
PTIACPFLTRQRYVL Character(100) VARCHAR2(100) NOT NULL value result for filter query
PTIACPFLTRQRYOT Character(30) VARCHAR2(30) NOT NULL result type of filter query
PTIACPFLTRQRYOP Character(254) VARCHAR2(254) NOT NULL filter query operation
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19