PTIACPTMPLTFQUS

index back

Filter Query Usage

This table stores metadata about filter queries are referenced by CA template steps

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
PTIACPFLTRQRYREF Character(6) VARCHAR2(6) NOT NULL Flag to specify if this is the definition or reference to a filter query
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19