Re: Getting PeopleSoft Panel Name

[Tony DeLia <tdelia@EROLS.COM>]

Guy,
  This is probably the easiest way to obtain the Panel name from within
the SQR process... very slight modifications required...

A - Add the field PNLNAME to your Run Control Record (hopefully you're
using a custom Run Control instead of delivered)...

B - Under PNLNAME.RowInit (for the Run Control Record) add this line of
PeopleCode:

    PNLNAME = %Panel;

C - In your SQR add the field PNLNAME to the Run Control Select list:

    begin-select
    rc.pnlname
       let $PNL_name = &rc.pnlname
     from ps_run_control_xxx
    where ...
    end-select

D - BINGO!!! display $PNL_name

This should suit your needs without adding any complexity... If this is
critical there should be no objection to adding a column to the
delivered Run Control table(s)... This simple change allows the Panel to
be obtained by ALL SQR processes using this Run Control record... If the
"derived field" method were used it would have to be added to "every"
Run Control Panel AND "every" Process Definition that needed the Panel
name via SQR...

                                     -Tony DeLia

Guy Simonian wrote:
>
> 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

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com