PTIACPTMPLTFQ2V(SQL View) |
Index Back |
|---|---|
Define Filter Query ViewThis view selects information about filter queries defined for each template |
| SELECT PTIACPTMPLT ,PTIACPCHPTRID ,PTIACPTASKID ,PTIACPSTEPID ,PTIACPSTEPRANK ,PTIACPFLTRQRYID ,DESCR254 ,OPERATION ,PTIACPFLTRQRYVL ,PTIACPFLTRQRYOT ,PTIACPFLTRQRYOP ,T.PTIACPSTEP 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.PTIACPFLTRQRYVL ,FQD.PTIACPFLTRQRYOT ,FQD.PTIACPFLTRQRYOP ,FQD.PTIACPSTEPID AS PTIACPSTEP ,SRC.PTIASPIMAGETYPE AS IMGTYPE ,SRC.PTIASPTMPLTVERS AS IMGVER FROM PS_PTIACPTMPLTFQUS FQU ,PS_PTIACPTMPLTFQDF FQD ,PS_PTIASPSRCINFO SRC WHERE 1=1 AND FQU.PTIACPFLTRQRYREF = 'FQREFN' AND FQU.PTIACPFLTRQRYID = FQD.PTIACPFLTRQRYID) T 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 | PTIACPFLTRQRYVL | Character(100) | VARCHAR2(100) NOT NULL | value result for filter query |
| 10 | PTIACPFLTRQRYOT | Character(30) | VARCHAR2(30) NOT NULL | result type of filter query |
| 11 | PTIACPFLTRQRYOP | Character(254) | VARCHAR2(254) NOT NULL | filter query operation |
| 12 | PTIACPSTEP | Character(50) | VARCHAR2(50) NOT NULL | Step |