PTIASPSEARCHNAMEPTIASPSRCHCATSEQA=All Unapplied Updates
C=Other Criteria
L=Language
N=New Feautres
O=Specific Objects
P=Prod/Severity/Image
R=Translations Only
S=Subsearch
T=True Requisites
U=Specific Updates
V=Application Upgrade
X=Tax Updates
PTIASPSRCHCAT(SQL Table) |
Index Back |
|---|---|
Search CategoryThis table stores search category information |
| # | 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 | PTIASPSRCHCATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Search Category
A=All Unapplied Updates C=Other Criteria L=Language N=New Feautres O=Specific Objects P=Prod/Severity/Image R=Translations Only S=Subsearch T=True Requisites U=Specific Updates V=Application Upgrade X=Tax Updates |
| 4 | PTIA_DTTM_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 5 | PTIASPSUBSEARCH | Character(30) | VARCHAR2(30) NOT NULL | Sub-search Name |