Automating PeopleSoft Edit Prompts on PSQUERY

[Christine Bauder]

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

[Christine Bauder]

PSQUERY -

Record Name - QUERY_RUN_PARM

Field Name - BNDVALUE

Key Name - BNDNUM

Key Value - 1

[Christine Bauder]

Helpful links I found online:

 

Index of Documented PeopleTools Tables 

 

PS Utility plugin - PS Utilities - Chrome Web Store 

[Bobby Tamayo]

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

[Christine Bauder]

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

[Bobby Tamayo]

ChristineBauder603411 , Thank you! Please keep us updated.  

[Christine Bauder]

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/>

 

 

[Christine Bauder]

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 [e-mail].

 

Thanks

Christine

[Christine Bauder]

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_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

[Christine Bauder]

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

[Christine Bauder]

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: