get_table_indexes
Retrieve index keys for any PeopleSoft table to write efficient queries by using indexed fields in WHERE clauses and understanding the logical key structure.
Instructions
Get the index keys for a PeopleSoft table to help write efficient queries.
Understanding indexes helps you:
- Write WHERE clauses that use indexed fields for better performance
- Understand the logical key structure of a table
- Know which fields uniquely identify a row
Common PeopleSoft key patterns:
- Simple: EMPLID (employee ID only)
- Effective-dated: EMPLID, EMPL_RCD, EFFDT, EFFSEQ
- SetID-based: SETID, DEPTID, EFFDT
:param table_name: The PeopleSoft record name (e.g., 'JOB', 'PERSONAL_DATA')
:return: List of indexes with their key fields
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | Yes |