INDEXNAMEPrompt Table: PSSIDXDEFN
FLD=Each field in own zone
ONE=All data in one zone
Default: ONE
RECNAMEPrompt Table: PSRECDEFNPVW
Prompt Table: PSRECDEFN
PSRGWIDX |
index back |
|---|
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| INDEXNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Name of Index for Collection
Prompt Table: PSSIDXDEFN |
| ZONEOPT | Character(3) | VARCHAR2(3) NOT NULL |
How to zone the index
FLD=Each field in own zone ONE=All data in one zone Default: ONE |
| RGWIDX_SQL | Character(200) | VARCHAR2(200) NOT NULL | WHERE clause to append |
| VEGGIEKEY | Long Character | CLOB | Key returned in search results |
| RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFNPVW |
| INCVWNAME | Character(15) | VARCHAR2(15) NOT NULL |
Update View Name
Prompt Table: PSRECDEFN |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |