PTIASPRPTTAGNAMEPrompt Table: PTIASPTAGLISTVW
PTIASPRPTTAGVALUEPrompt Table: PTIASPAVDCATVW
Default Value: N
PTIASPAVDCATVW(SQL View) |
Index Back |
|---|---|
Advanced Search Criteria List |
| SELECT DISTINCT PTIASPRPTTAGNAME , PTIASPRPTTAGVALUE , 'N' FROM PS_PTIASPRPTTAGS WHERE PTIASPRPTTAGNAME <> 'Standard' AND PTIASPRPTTAGNAME <> 'Translations Only' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIASPRPTTAGNAME |
Character(30) | VARCHAR2(30) NOT NULL |
TAG Name
Prompt Table: PTIASPTAGLISTVW |
| 2 | PTIASPRPTTAGVALUE |
Character(254) | VARCHAR2(254) NOT NULL |
TAG Value
Prompt Table: PTIASPAVDCATVW |
| 3 | PTIASPSELECTAVDCAT | Character(1) | VARCHAR2(1) NOT NULL |
Advanced Search Criteria flag
Default Value: N |