PTIASPPKGTPFQ1V

index back

Define Filter Query View

This view selects information about filter queries defined for a generated package
SELECT DISTINCT PKG.PTIASPPKGGUID ,PKG.PTIASPPKGNAME ,FQU.PTIACPCHPTRID ,FQU.PTIACPTASKID ,FQU.PTIACPSTEPID ,FQU.PTIACPSTEPRANK ,FQU.PTIACPFLTRQRYID ,REPLACE (FQD.DESCR254 , '[PackageName]' , PKG.PTIASPPKGNAME) AS DESCR254 ,FQD.OPERATION ,REPLACE (FQD.PTIACPFLTRQRYSQL , '[PackageName]' , PKG.PTIASPPKGNAME) AS PTIACPFLTRQRYSQL ,FQD.PTIACPFLTRQRYVL ,FQD.PTIACPFLTRQRYOT ,FQD.PTIACPFLTRQRYOP FROM PS_PTIACPTMPLTFQUS FQU ,PS_PTIACPTMPLTFQDF FQD , PS_PTIASPPKGSTRH PKG , PS_PTIASPSRCINFO SRC WHERE FQU.PTIASPTMPLTVERS = SRC.PTIASPTMPLTVERS AND FQU.PTIACPCHPTRID = PKG.PTIACPCHPTRID AND FQU.PTIACPTASKID = PKG.PTIACPTASKID AND FQU.PTIACPSTEPID = PKG.PTIACPSTEPID AND FQU.PTIACPSTEPRANK = PKG.PTIACPSTEPRANK AND FQU.PTIACPFLTRQRYID = FQD.PTIACPFLTRQRYID AND FQU.PTIACPFLTRQRYREF = 'FQDEFN' AND ((SRC.PTIASPIMAGETYPE = 'E' AND BITAND(1, FQU.PTIACPTMPLSTEPTYPE) = 1) OR (SRC.PTIASPIMAGETYPE = 'I' AND BITAND(2, FQU.PTIACPTMPLSTEPTYPE) = 2) OR (SRC.PTIASPIMAGETYPE = 'P' AND BITAND(4, FQU.PTIACPTMPLSTEPTYPE) = 4) OR(SRC.PTIASPIMAGETYPE = 'M' AND BITAND(8, FQU.PTIACPTMPLSTEPTYPE) = 8))

PeopleSoft Field Name Field Type Column Type Description
PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
PTIASPPKGNAME Character(30) VARCHAR2(30) NOT NULL Package 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
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 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20