PeopleSoft Indexs

Application Designer Index naming convention

The indexes generated by the Application Designer have the following naming convention:

INDEX_NAME = 'PS '||{index_id}||{peoplesoft record name}

Index ID : Description

_ : PeopleSoft key index. Implied from the record definition.

1–9 : Alternate search key indexes. Implied from the record definition.

# : List index. Implied from the record definition. Only applicable in PeopleTools 7.5 and earlier; not used in PeopleTools 8.

A–Z : User-specified index.