PTIACPTMPLTFQDF

index back

Filter Query Step Definition

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

PeopleSoft Field NameField TypeColumn TypeDescription
PTIACPFLTRQRYIDCharacter(50)VARCHAR2(50) NOT NULLID for filter query
PTIACPSTEPIDCharacter(10)VARCHAR2(10) NOT NULLStep ID
DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
OPERATIONCharacter(3)VARCHAR2(3) NOT NULLArithmetic Operation
<=Less Than
<==Less Than or Equal To
<>=Not Equal To
==Equal To
>=Greater Than
>==Greater Than or Equal To
PTIACPFLTRQRYSQLCharacter(254)VARCHAR2(254) NOT NULLfilter query operation
PTIACPFLTRQRYVLCharacter(100)VARCHAR2(100) NOT NULLvalue result for filter query
PTIACPFLTRQRYOTCharacter(30)VARCHAR2(30) NOT NULLresult type of filter query
PTIACPFLTRQRYOPCharacter(254)VARCHAR2(254) NOT NULLfilter query operation
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19