PTIACPTMPLTFQ2V

index back

Define Filter Query View

This view selects information about filter queries defined for each template
SELECT A.PTIACPTMPLT ,A.PTIACPCHPTRID ,A.PTIACPTASKID ,A.PTIACPSTEPID ,A.PTIACPSTEPRANK ,A.PTIACPFLTRQRYID ,B.DESCR254 ,B.OPERATION ,B.PTIACPFLTRQRYVL ,B.PTIACPFLTRQRYOT ,B.PTIACPFLTRQRYOP ,B.PTIACPSTEPID FROM PS_PTIACPTMPLTFQUS A ,PS_PTIACPTMPLTFQDF B WHERE 1=1 AND A.PTIACPFLTRQRYREF = 'FQREFN' AND A.PTIACPFLTRQRYID = B.PTIACPFLTRQRYID

PeopleSoft Field Name Field Type Column Type Description
PTIACPTMPLT Character(50) VARCHAR2(50) NOT NULL Structure Name
PTIACPCHPTRID Character(10) VARCHAR2(10) NOT NULL Chapter ID
PTIACPTASKID Character(10) VARCHAR2(10) NOT NULL Task ID
PTIACPSTEPID Character(10) VARCHAR2(10) NOT NULL Step ID
PTIACPSTEPRANK Number(5,0) INTEGER NOT NULL Step Version
PTIACPFLTRQRYID Character(50) VARCHAR2(50) NOT NULL ID for filter query
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
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
PTIACPSTEP Character(50) VARCHAR2(50) NOT NULL Step
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19