Updated: PeopleTools Tables

Here is just a quick post to let you know that I have added a few more tables to the PeopleTools Tables page:


These tables are related to HTML definitions.  I was using them to check to make sure that I have all of the HTML definitions that I have created in my project.

Here is a link to the page:


One Response to “Updated: PeopleTools Tables”

  1. Ashok Says:

    PeopleSoft Query Tables
    PSQRYDEFN: Stores query related info.

    PSQRYFIELD: Stores all fields used in a query (both the fields in the Select and Where clause).

    PSQRYCRITERIA: Stores criteria query fields. You can get the name of the fields by joining the PSQRYFIELD table.

    PSQRYEXPR: Stores query expressions.

    PSQRYBIND: Stores query bind variables.

    PSQRYRECORD: Stores all records used in all aspects of query creation

    PSQRYSELECT: Stores all SELECT requirements by select type. Example would be sub select, join, ect.

    PSQRYLINK: Stores the relationships to child queries.

    PSQRYEXECLOG: Query run time log table that stores (only 8.4x and higher)

    PSQRYSTATS: Query run time statistics table such as count of query execution, and date time of last execution (only in 8.4x and higher).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: