PTIACPTMPLTFQ1V |
index back |
|---|---|
Define Filter Query View |
| 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 | Field Type | Column Type | Description |
|---|---|---|---|
| PTIACPTMPLT | Character(50) | VARCHAR2(50) NOT NULL | Structure 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 |