Useful PeoplTools Tables

Tools 8.42 / 8.45 / 8.49 / 8.50

SELECT * FROM PSRECFIELDDB

All the fields in a given record created in application designer, including the fields in subrecords

This also stores all the record field properties like prompt tables, key, alternate keys,etc.


SELECT * FROM PSPNLFIELD

All the fields present on a page created in application designer. This also has page field properties, co-ordinates, etc.


SELECT * FROM PSAUTHBUSCOMP

Authorized component interfaces (CI) in a a given permission list with the authorized actions on a given CI.


SELECT * FROM PSAUTHWEBLIBVW WHERE CLASSID='ALLPAGES'

Authorized web libraries in a given permission list.


SELECT * FROM PSAUTHITEM_VW2 WHERE MENUNAME LIKE 'WEBLIB%'

All the properties related to web libraries with authorized actions through menu


SELECT * FROM PSAUTHWS
In 8.48 tools onwards, this table stores the authorized webservices

To find out the details about the portal tables:When you are not sure about the navigation for some components this table will help you find the folder. This is a sure-shot back-end approach.
SELECT * FROM PSPRSMDEFN

This table will help you find out the access to portal registry content:
SELECT * FROM PSPRSMPERM




Finding the SQL text for a view:
SELECT SUBSTRING(SQLTEXT,1,10000) FROM PSSQLTEXTDEFN WHERE SQLID='XREF_PSRECDEFN'