PTIASPSRCHDEFN

index back

Search Criteria Table

This table stores detailed search criteria

PeopleSoft Field Name Field Type Column Type Description
PTIASPSEARCHNAME Character(30) VARCHAR2(30) NOT NULL Search Name
PTIASPSRCHCATSEQ Number(10,0) DECIMAL(10) NOT NULL Sequence
PTIASPSRCHCRITSEQ Number(10,0) DECIMAL(10) NOT NULL Sequence
PTIASPSRCHCRITERIA Character(1) VARCHAR2(1) NOT NULL Search Criteria
A=All Suitable Values
F=Product Family
G=Family with Relation
I=Image Number
L=Installed Language
P=Installed Product
Q=Product with Relation
S=Severity
T=Tracking Group
U=Specific Updates
PTIASPSRCHVALUE1 Character(254) VARCHAR2(254) NOT NULL Value1
PTIASPSRCHVALUE2 Character(254) VARCHAR2(254) NOT NULL Value2
PTIASPSRCHVALUE3 Character(254) VARCHAR2(254) NOT NULL Value3
PTIASPSRCHVALUE4 Character(254) VARCHAR2(254) NOT NULL Value4
PTIASPSRCHVALUE5 Character(254) VARCHAR2(254) NOT NULL Value5
PTIASPSRCHVALUE6 Character(254) VARCHAR2(254) NOT NULL Value6
PTIASPSRCHVALUE7 Character(254) VARCHAR2(254) NOT NULL Value7
PTIASPSRCHVALUE8 Character(254) VARCHAR2(254) NOT NULL Value8
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20