INDEXNAMERECNAMEDefault Value: PSRGWIDX.RECNAME
Y/N Table Edit
Default Value: N
FIELDNAMEY/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: Y
PSRGWFLDOPT(SQL Table) |
Index Back |
|---|---|
Record Gateway Field Options |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INDEXNAME |
Character(30) | VARCHAR2(30) NOT NULL | Name of Index for Collection |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Default Value: PSRGWIDX.RECNAME |
| 3 | ISBLOBATTACH | Character(1) | VARCHAR2(1) NOT NULL |
Field has attachment data
Y/N Table Edit Default Value: N |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | ISVFIELD | Character(1) | VARCHAR2(1) NOT NULL |
Use field for comparisons
Y/N Table Edit Default Value: N |
| 6 | ISWORDIDX | Character(1) | VARCHAR2(1) NOT NULL |
Field values into word index
Y/N Table Edit Default Value: Y |