Re: Getting PeopleSoft Panel Name

[Brian Nice <bnice@CCCI.ORG>]

This is probably not the best way, but you could make a derived work record with a field on it 
that could hold the panel name. 

   record_der.panel_name

Add that field to all the panels that can run the SQR and
initialize it to the panel name upon entering the panel with peoplecode.  Then on the SQR
parameters line in the process definition, pass it as a parameter

 :record_der.panel_name

Then use an input statement in the SQR to get the command line parameter (in this case the
panel name) and parse it from there.

I'm sure there is a better way, and this may be hard to maintain, but it could be an option.
HTH


/********************
* Brian Nice
* Senior Programmer/Analyst
* Campus Crusade for Christ
* bnice@ccci.org
*********************************/

>>> Guy Simonian <SIMOGUY@PSNC.COM> 01/06 2:34 PM >>>
Is there a way to find out which Peoplesoft panel invoked the SQR process.

I have several panels that call 1 SQR and want to find out which one it was that started the job.

I can get the RUN_CNTL_ID and OPER_ID, of course, but am looking for a way to get the panel name.

Guy