PS Query & SQL

I am trying to identify the record where Distribution Detail is stored. This is what you get when you are about to start a process, and on the Process Scheduler Request page press the Distribution link. I'm interested in the Email Subject, Message Text, Email Address List and Distribution ID. It looks like it should be a combination of PRCSRQSTDLG and PRCSDEFNDIST_VW, however when I asked for access to PRCSRQSTDLG I was told that it doesn't exist, while 

PRCSRQSTDLGLNG does exist, it doesn't contain any data.

Also, PRCSDEFNDIST_VW doesn't contain any data.

Does anyone know how to get to this data?

------------------------------
Kevin Shalla
Director of Technology
University of Chicago
------------------------------

Hi Kevin,

I think it might be PSPRCSRQSTTEXT you want.  

There could be multiple rows for a process instance, including the email address, subject and text.

Hope this helps!

Paz

------------------------------
Paz Centeno-Armstrong
Application Developer
Long Beach City College
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

Thanks, that does get what I'm looking for for individual instances, though I'd rather get the setup for instances that haven't yet been scheduled.

------------------------------
Kevin Shalla
Director of Technology
University of Chicago
------------------------------

Original Message:
Sent: 09-19-2025 11:19 AM
From: Paz Centeno-Armstrong
Subject: Distribution Detail Records

Hi Kevin,

I think it might be PSPRCSRQSTTEXT you want.  

There could be multiple rows for a process instance, including the email address, subject and text.

Hope this helps!

Paz

------------------------------
Paz Centeno-Armstrong
Application Developer
Long Beach City College
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

Hi Kevin,

A few more tables that you can look at related to run control ids;  that may have the information as it was saved based on the oprid, runcntlid, prcstype and prcsname   ;   some reverse engineering related to those numeric fields may be able to get you were you want to see information about the distributions and/or email addresses.

PRCSRUNCNTLDTL

PRCSRUNCNTLOUT

PRCSRUNCNTLDIST

PRCSRUNCNTLEOPT

Pam

------------------------------
Pamela Lantzy
Senior Systems Architect
University At Albany
------------------------------

Perfect, thanks Pam!

------------------------------
Kevin Shalla
Director of Technology
University of Chicago
------------------------------

Original Message:
Sent: 09-22-2025 10:17 AM
From: Pamela Lantzy
Subject: Distribution Detail Records

Hi Kevin,

A few more tables that you can look at related to run control ids;  that may have the information as it was saved based on the oprid, runcntlid, prcstype and prcsname   ;   some reverse engineering related to those numeric fields may be able to get you were you want to see information about the distributions and/or email addresses.

PRCSRUNCNTLDTL

PRCSRUNCNTLOUT

PRCSRUNCNTLDIST

PRCSRUNCNTLEOPT

Pam

------------------------------
Pamela Lantzy
Senior Systems Architect
University At Albany
------------------------------