PTIASPPKGTPFQ2V |
index back |
|---|---|
Define Filter Query View |
| 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 ,FQD.PTIACPFLTRQRYVL ,FQD.PTIACPFLTRQRYOT ,FQD.PTIACPFLTRQRYOP ,FQD.PTIACPSTEPID 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 = 'FQREFN' 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 |
| 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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |