How to Make a Private PeopleSoft Query to Public using Update SQL:

The difference between a public PeopleSoft query and a private PeopleSoft query is the population of the OPRID field on the following tables:

PSQRYDEFN
PSQRYSELECT
PSQRYRECORD
PSQRYFIELD

Update Statements Below:

UPDATE PSQRYDEFN
SET OPRID = ''
WHERE QRYNAME = 'QUERY_NAME';

UPDATE PSQRYSELECT
SET OPRID = ''
WHERE QRYNAME = ' QUERY_NAME';

UPDATE PSQRYRECORD
SET OPRID = ''
WHERE QRYNAME = ' QUERY_NAME';

UPDATE PSQRYFIELD
SET OPRID = ''
WHERE QRYNAME = ' QUERY_NAME';