PTIASPSEARCHNAMEPTIASPSRCHCATSEQPTIASPSRCHCRITSEQA=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
PTIASPSRCHDEFN(SQL Table) |
Index Back |
|---|---|
Search Criteria TableThis table stores detailed search criteria |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIASPSEARCHNAME |
Character(30) | VARCHAR2(30) NOT NULL | Search Name |
| 2 | PTIASPSRCHCATSEQ |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence |
| 3 | PTIASPSRCHCRITSEQ |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence |
| 4 | 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 |
| 5 | PTIASPSRCHVALUE1 | Character(254) | VARCHAR2(254) NOT NULL | Value1 |
| 6 | PTIASPSRCHVALUE2 | Character(254) | VARCHAR2(254) NOT NULL | Value2 |
| 7 | PTIASPSRCHVALUE3 | Character(254) | VARCHAR2(254) NOT NULL | Value3 |
| 8 | PTIASPSRCHVALUE4 | Character(254) | VARCHAR2(254) NOT NULL | Value4 |
| 9 | PTIASPSRCHVALUE5 | Character(254) | VARCHAR2(254) NOT NULL | Value5 |
| 10 | PTIASPSRCHVALUE6 | Character(254) | VARCHAR2(254) NOT NULL | Value6 |
| 11 | PTIASPSRCHVALUE7 | Character(254) | VARCHAR2(254) NOT NULL | Value7 |
| 12 | PTIASPSRCHVALUE8 | Character(254) | VARCHAR2(254) NOT NULL | Value8 |