I use PSOPRDEFN a lot. My main use is to identify OPRIDs I can use for testing, but I also use it for other queries. I recently used it to modify an existing query that we use to identify employees who have terminated or lost Self Service access so that we ensure that we print their W-2.
PSROLEUSER is also useful for whenever I need to look at security, or find users with specific roles for testing.
------------------------------
Audrey Liddy
IT Business Analyst
State of New Mexico
------------------------------
Message from the HEUG Marketplace:------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the
HEUG Marketplace.
------------------------------
Original Message:
Sent: 03-03-2025 07:28 PM
From: Ross Nolan
Subject: Metadata records
Based on parts of previous discussions with this group that have come up, what metadata records do you find helpful in your work? Here are a few I use often/have been mentioned.
- PSQRYDEFN - Query Definition
- The header data for a query has information creation, updated, and descriptions
- PSQRYRECORD - Query Record
- All the records used in a query
- helpful in finding and updating queries
- PMN_PRCSLIST - Process Monitor Process List
- Has the data on the Process Monitor
- useful in tracking how long processes take
- PSSQLTEXTDEFN - SQL Object Text
- Has the SQL for views
- Can help with debugging views or pulling helpful SQL
- PSPRSMDEFN - Portal Structure Defn Tbl
- Data on how and where different pages are located
- helpful for data on navigation collections, activity guides, etc.
------------------------------
Ross Nolan
Data and Reporting Analysis
University of California, Berkeley
rvnolan@berkeley.edu
------------------------------