PTIACPTMPLTPTIACPCHPTRIDPTIACPTASKIDPTIACPSTEPIDPTIACPSTEPRANKPTIACPFLTRQRYIDPTIASPTMPLTVERSPTIACPTMPLTFQUS(SQL Table) |
Index Back |
|---|---|
Filter Query UsageThis table stores metadata about filter queries are referenced by CA template steps |
| # | 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 | PTIACPFLTRQRYREF | Character(6) | VARCHAR2(6) NOT NULL | Flag to specify if this is the definition or reference to a filter query |
| 8 | PTIACPTMPLSTEPTYPE | Number(3,0) | SMALLINT NOT NULL | Template Step Type |
| 9 | PTIASPTMPLTVERS |
Number(5,0) | INTEGER NOT NULL | Template Version |