List of PSQuery Tables | PeopleSoft Tutorial

PSQuery Tables

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.

PSQRYACCLSTRECS
PSQRYBIND – Query Prompt
PSQRYBINDLANG – Query Prompt Alternate Lang.
PSQRYCRITERIA – Query Criteria
PSQRYDEFN – Query Definition
PSQRYDEFNLANG – Query Definition Alt. Language
PSQRYDEL
PSQRYEXECLOG – Query RunTime Log
PSQRYEXPR – Query Expression
PSQRYFAVORITES – Query Manager Favorites Table
PSQRYFIELD – Query Field
PSQRYFIELDDEP
PSQRYFIELDLANG – Query Field Alternate Language
PSQRYFLAGS – Query Global Flags Table
PSQRYLINK
PSQRYPREFS
PSQRYRECORD – Query Record
PSQRYSELECT – Query Select
PSQRYSTATS – Query RunTime Statistics
PSQRYTRANS
PSQRYXFORM

If you need to restore queries from another environment, the tables that are most likely to have data specific to your query include:

PSQRYBIND
PSQRYCRITERIA
PSQRYDEFN
PSQRYEXPR
PSQRYFAVORITES
PSQRYFIELD
PSQRYRECORD
PSQRYSELECT
PSQRYSTATS

Following tables are less likely to have data related to a query:

PSQRYBINDLANG
PSQRYDEFNLANG
PSQRYDEL
PSQRYEXECLOG
PSQRYFIELDDEP
PSQRYFIELDLANG
PSQRYLINK
PSQRYTRANS
PSQRYXFORM

Apurva Tripathi
 

Apurva is a PeopleSoft consultant and a big advocate of everything PeopleSoft. He is also a technology enthusiast and loves learning and implementing newer and open source technologies. He spends his spare time updating this blog and likes to read books on self help and productivity.

>