Record Name - QUERY_RUN_PARM
Field Name - BNDVALUE
Key Name - BNDNUM
Key Value - 1
Helpful links I found online:
Index of Documented PeopleTools Tables
PS Utility plugin - PS Utilities - Chrome Web Store
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!
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. ☺
ChristineBauder603411 , Thank you! Please keep us updated.
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.
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
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
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 firstname.lastname@example.org.
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:
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
Edit Prompt Boxes for processes using a pop select query
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)
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:
Retrieving data ...