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 NameField TypeColumn TypeDescription
PTIACPTMPLTCharacter(50)VARCHAR2(50) NOT NULLStructure Name
PTIACPCHPTRIDCharacter(10)VARCHAR2(10) NOT NULLChapter ID
PTIACPTASKIDCharacter(10)VARCHAR2(10) NOT NULLTask ID
PTIACPSTEPIDCharacter(10)VARCHAR2(10) NOT NULLStep ID
PTIACPSTEPRANKNumber(5,0)INTEGER NOT NULLStep Version
PTIACPFLTRQRYIDCharacter(50)VARCHAR2(50) NOT NULLID for filter query
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
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
PTIACPSTEPCharacter(50)VARCHAR2(50) NOT NULLStep
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19