INDEXNAMEINDEXFIELDSAC_IDX_FLD_FVW(SQL View) |
Index Back |
|---|---|
"Field" type index fields |
| SELECT INDEXNAME , INDEXFIELD FROM PS_SAC_IDX_FIELDS WHERE INDEX_FIELDTYPE = 'A' OR INDEX_FIELDTYPE = 'F' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INDEXNAME |
Character(30) | VARCHAR2(30) NOT NULL | Search Index Name |
| 2 | INDEXFIELD |
Character(18) | VARCHAR2(18) NOT NULL | Index Field Name |