PTIACPTMPLTFQ1V

(SQL View)
 Index Back

Define Filter Query View

This view selects information about filter queries defined for a given template

SELECT PTIACPTMPLT ,PTIACPCHPTRID ,PTIACPTASKID ,PTIACPSTEPID ,PTIACPSTEPRANK ,PTIACPFLTRQRYID ,DESCR254 ,OPERATION ,PTIACPFLTRQRYSQL ,PTIACPFLTRQRYVL ,PTIACPFLTRQRYOT ,PTIACPFLTRQRYOP FROM ( SELECT FQU.PTIACPTMPLT ,FQU.PTIACPCHPTRID ,FQU.PTIACPTASKID ,FQU.PTIACPSTEPID ,FQU.PTIACPSTEPRANK ,FQU.PTIACPFLTRQRYID ,FQU.PTIACPTMPLSTEPTYPE AS TMPLTYPE ,FQU.PTIASPTMPLTVERS AS TMPLVER ,FQD.DESCR254 ,FQD.OPERATION ,FQD.PTIACPFLTRQRYSQL ,FQD.PTIACPFLTRQRYVL ,FQD.PTIACPFLTRQRYOT ,FQD.PTIACPFLTRQRYOP ,SRC.PTIASPIMAGETYPE AS IMGTYPE ,SRC.PTIASPTMPLTVERS AS IMGVER FROM PS_PTIACPTMPLTFQUS FQU ,PS_PTIACPTMPLTFQDF FQD ,PS_PTIASPSRCINFO SRC WHERE 1=1 AND FQU.PTIACPFLTRQRYREF = 'FQDEFN' AND FQU.PTIACPFLTRQRYID = FQD.PTIACPFLTRQRYID) WHERE TMPLVER = IMGVER AND ((IMGTYPE = 'E' AND BITAND(1, TMPLTYPE) = 1) OR (IMGTYPE = 'I' AND BITAND(2, TMPLTYPE) = 2) OR (IMGTYPE = 'P' AND BITAND(4, TMPLTYPE) = 4) OR(IMGTYPE = 'M' AND BITAND(8, TMPLTYPE) = 8))

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