Automic Workload Automation

Expand all | Collapse all

Automating PeopleSoft Edit Prompts on PSQUERY

  • 1.  Automating PeopleSoft Edit Prompts on PSQUERY

    Posted 08-04-2017 01:09 PM
    Is anyone out there automatically updating edit prompt fields (edit boxes) in PeopleSoft through Automic Workload Automation? 
    beuaeaeevbcu.pnghttps://us.v-cdn.net/5019921/uploads/editor/im/beuaeaeevbcu.png" width="1600">



  • 2.  Re: Automating PeopleSoft Edit Prompts on PSQUERY

    Posted 05-29-2018 11:31 AM

    PSQUERY -

    Record Name - QUERY_RUN_PARM

    Field Name - BNDVALUE

    Key Name - BNDNUM

    Key Value - 1



  • 3.  Re: Automating PeopleSoft Edit Prompts on PSQUERY

    Posted 06-07-2018 10:41 AM

    Helpful links I found online:

     

    Index of Documented PeopleTools Tables 

     

    PS Utility plugin - PS Utilities - Chrome Web Store 



  • 4.  Re: Automating PeopleSoft Edit Prompts on PSQUERY

    Broadcom Employee
    Posted 06-28-2018 11:25 AM

    Hi ChristineBauder603411

     

    Thank you for the post. 

     

    I have the same question regarding the Edit Prompts  -> Query Prompts as shown below. We would like to change the value of the parameters "Institution", Career, Fall Term, Summer term etc...

     

     

    I have checked the link with tables but I did not see the fieldnames.  May I know how to get the fieldnames for  Institution", Career, Fall Term, Summer term etc... Also, once we found the fieldnames, we just need to define them in "Additional Keys for Scroll Level' section in CA Automic PS job as shown below, correct ?

     

     

     

     

    Thank you in advance!

    Bobby



  • 5.  Re: Automating PeopleSoft Edit Prompts on PSQUERY

    Posted 07-02-2018 12:23 PM

    Good Morning,

         I apologize for the delayed response.

     

    In regards to the edit prompt boxes, I have been working on this too as we want these automated also. The edit prompt boxes do not follow the same rules as the other processes. The record and field name are buried. I think I have narrowed it down to a record named DERIVED and module specific records like DERIVED_FA - the fieldname would be different for each box. I get an OPRID error though which I am hoping they can help me with today. I will keep you posted if I can figure these ones out. I found the information I’ve been testing with through App Designer, viewing the actual sql of the query being called, and google is my friend sometimes. ☺

     

    Thanks

    Christine



  • 6.  Re: Automating PeopleSoft Edit Prompts on PSQUERY

    Broadcom Employee
    Posted 07-03-2018 04:16 PM

    ChristineBauder603411 , Thank you! Please keep us updated.  



  • 7.  Re: Automating PeopleSoft Edit Prompts on PSQUERY

    Posted 07-03-2018 04:27 PM
      |   view attached

    I will keep you posted. They are looking at our permissions to update that DERIVED* table. We don’t have access currently, and it might just be a simple fix.

     

    Christine Bauder

    Assistant Director of Production Services, University Information Services

    University of Colorado

    1800 Grant Street, Suite 200

    Denver, CO  80203

    t  303 860 4334

    c 303 263 3288

    www.cu.edu<http://www.cu.edu/>

     

     



  • 8.  Re: Automating PeopleSoft Edit Prompts on PSQUERY

    Posted 08-14-2018 12:10 PM

    Good Morning,

         Quick question - are using Campus Solutions? The process you gave as an example looks like an SCC_POP_UPD found under Setup SACR > System Administration > Utilities > Population Update > Population Update Process. If that is correct, and you are using CS, I have found way to update these through Automic. 

    Record Name: SCCPS_RUN_PARM

    Field Name: BNDVALUE

    Keys:

    SCCPS_CNTXT_ID - (this value will be specific to the record being updated)

    BNDNUM - (this value will also change depending on the order of the parameters in the prompt box)

     

    I cannot tell you what your specific values will be for the SCCPS_CNTXT_ID, but I am going to see if I can put together something that can be used universally to get those values. If you have time and resources, see if someone in your shop has access to and is willing to help you find the SCCPS_CNTXT_ID. 

     

    To test, you could just enter the record and field name and leave the keys blank, remove the page that runs the process and just run the modified run control page in Automic. You should get an error that says more keys are required. Try that and let me know. My direct email is christine.bauder@cu.edu.

     

    Thanks

    Christine



  • 9.  Re: Automating PeopleSoft Edit Prompts on PSQUERY

    Posted 08-14-2018 02:44 PM

    The values for the SCCPS_CNTXT_ID depend on the how it is mapped. I cannot say for sure from your screenshots what record you are calling in the run control. Here is a list of the SCCPS_CNTXT_ID and their values:

     

    SCCPS_MAP_VALUESCCPS_CNTXT_ID
    ADM_APPL_DATA427
    ADM_APPL_RCR_CA403
    ADM_PRSPCT_CAR410
    INAS_CALC_RECS412
    INAS_FED_EXT417
    INAS_PROF_EXT418
    ISIR_CONTROL411
    ITEM_TYPE_FISCL432
    ITEM_TYPE_FNOTE433
    LOAN_DISBMNT422
    LOAN_ORIG_DTL419
    LOAN_ORIGNATN421
    PELL_DISBMNT423
    PELL_ORIG_DTL413
    PELL_ORIGINATN415
    PERS_INST_REL402
    RESIDENCY_OFF431
    SAA_NOTE_ACCESS436
    SCC_PERSON_AUS435
    SFA_ASG_ORG_DTL414
    SFA_EASTAGE_DTL420
    SFA_LN_CNSL_TBL429
    SFA_SAP_STDNT2426
    SFA_SAP_STDNT3424
    SFA_SAP_STDNT4425
    SFA_SLC_STUDENT409
    SSR_STDNT_DATA434
    STDNT_AGGR_LIFE428
    STDNT_AID_ATRBT401
    STDNT_AWARDS416
    STDNT_AWD_PER430
    STDNT_AWRD_ACTV1048
    STDNT_CAR_TERM404
    STDNT_CAREER408
    STDNT_EQUTN_VAR405
    STDNT_FA_TERM407
    STDNT_PKG_VAR406


  • 10.  Re: Automating PeopleSoft Edit Prompts on PSQUERY

    Posted 08-14-2018 02:49 PM

    SQl that was used to find the ID values above

     

    select sccps_map_value, sccps_cntxt_id from ps_sccps_cntxt_bnd a where sccps_cntxt_hdr_id = 400



  • 11.  Re: Automating PeopleSoft Edit Prompts on PSQUERY

    Posted 08-14-2018 03:45 PM

    Edit Prompt Boxes for processes using a pop select query

    Record Name: SCCPS_RUN_PARM

    Field Name: BNDVALUE

    Value: (assigned value or variable)

    Scroll Level 1

    Key Name:  SCCPS_CNTXT_ID

    Key Value: Mapping ID number dependent on record being called in run control (see below)

    Scroll Level 2

                    Key Name: BNDNUM

                    Key Value:  Will vary depending on how many prompt boxes and the order of the boxes

     

    SCCPS_CNTXT_ID - this value is dependent on the value of the mapping ID of the record being called. The record being called is found on the run control page under “Select Record Fields for update”. In the example, the record being called is STDNT_FA_TERM.

    Find the record STDNT_FA_TERM in the table below and use that corresponding value as the Key Value in the Automic modified run control page.

      

    Mapping IDs (these values may differ between organizations, but here is sql that can be tweaked accordingly)

    (SQL code used to gather the map -  (select sccps_map_value, sccps_cntxt_id from ps_sccps_cntxt_bnd a where sccps_cntxt_hdr_id = 400)

    SCCPS_MAP_VALUE

    SCCPS_CNTXT_ID

    ADM_APPL_DATA

    427

    ADM_APPL_RCR_CA

    403

    ADM_PRSPCT_CAR

    410

    INAS_CALC_RECS

    412

    INAS_FED_EXT

    417

    INAS_PROF_EXT

    418

    ISIR_CONTROL

    411

    ITEM_TYPE_FISCL

    432

    ITEM_TYPE_FNOTE

    433

    LOAN_DISBMNT

    422

    LOAN_ORIG_DTL

    419

    LOAN_ORIGNATN

    421

    PELL_DISBMNT

    423

    PELL_ORIG_DTL

    413

    PELL_ORIGINATN

    415

    PERS_INST_REL

    402

    RESIDENCY_OFF

    431

    SAA_NOTE_ACCESS

    436

    SCC_PERSON_AUS

    435

    SFA_ASG_ORG_DTL

    414

    SFA_EASTAGE_DTL

    420

    SFA_LN_CNSL_TBL

    429

    SFA_SAP_STDNT2

    426

    SFA_SAP_STDNT3

    424

    SFA_SAP_STDNT4

    425

    SFA_SLC_STUDENT

    409

    SSR_STDNT_DATA

    434

    STDNT_AGGR_LIFE

    428

    STDNT_AID_ATRBT

    401

    STDNT_AWARDS

    416

    STDNT_AWD_PER

    430

    STDNT_AWRD_ACTV

    1048

    STDNT_CAR_TERM

    404

    STDNT_CAREER

    408

    STDNT_EQUTN_VAR

    405

    STDNT_FA_TERM

    407

    STDNT_PKG_VAR

    406

     

     

      

    The BNDNUM value is the order of the boxes in the edit prompt box:

     

    In the example, the prompts that change with the terms are the prompts we want to modify. In this case, field 1 and field 3. BNDNUM values are then 1 and 3: