PTIASPPKGTPFQ1V

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
2 PTIASPPKGNAME Character(30) VARCHAR2(30) NOT NULL Package Name
3 PTIACPCHPTRID Character(10) VARCHAR2(10) NOT NULL Chapter ID
4 PTIACPTASKID Character(10) VARCHAR2(10) NOT NULL Task ID
5 PTIACPSTEPID Character(10) VARCHAR2(10) NOT NULL Step ID
6 PTIACPSTEPRANK Number(5,0) INTEGER NOT NULL Step Version
7 PTIACPFLTRQRYID Character(50) VARCHAR2(50) NOT NULL ID for filter query
8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
9 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
10 PTIACPFLTRQRYSQL Character(254) VARCHAR2(254) NOT NULL filter query operation
11 PTIACPFLTRQRYVL Character(100) VARCHAR2(100) NOT NULL value result for filter query
12 PTIACPFLTRQRYOT Character(30) VARCHAR2(30) NOT NULL result type of filter query
13 PTIACPFLTRQRYOP Character(254) VARCHAR2(254) NOT NULL filter query operation