INDEXNAMEPrompt Table: PSSIDXDEFN
FLD=Each field in own zone
ONE=All data in one zone
Default Value: ONE
RECNAMEPrompt Table: PSRECDEFNPVW
Prompt Table: PSRECDEFN
PSRGWIDX(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INDEXNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Name of Index for Collection
Prompt Table: PSSIDXDEFN |
| 2 | 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 Value: ONE |
| 3 | RGWIDX_SQL | Character(200) | VARCHAR2(200) NOT NULL | WHERE clause to append |
| 4 | VEGGIEKEY | Long Character | CLOB | Key returned in search results |
| 5 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFNPVW |
| 6 | INCVWNAME | Character(15) | VARCHAR2(15) NOT NULL |
Update View Name
Prompt Table: PSRECDEFN |