PSQuery tables are all PeopleTools tables.
Here is the complete list of PeopleTools meta tables that store all the possible information about PSQueries. The below list of PSQuery tables is correct for PeopleTools 8.57 release. It could vary slightly in earlier and later versions.
This list is super helpful in situations when you might need to query PSQuery tables such as restoring a query.
PSQRYBIND – Query Prompt
PSQRYBINDLANG – Query Prompt Alternate Lang.
PSQRYCRITERIA – Query Criteria
PSQRYDEFN – Query Definition
PSQRYDEFNLANG – Query Definition Alt. Language
PSQRYEXECLOG – Query RunTime Log
PSQRYEXPR – Query Expression
PSQRYFAVORITES – Query Manager Favorites Table
PSQRYFIELD – Query Field
PSQRYFIELDLANG – Query Field Alternate Language
PSQRYFLAGS – Query Global Flags Table
PSQRYRECORD – Query Record
PSQRYSELECT – Query Select
PSQRYSTATS – Query RunTime Statistics
If you need to restore queries from another environment, the tables that are most likely to have data specific to your query include:
Following tables are less likely to have data related to a query: