Populate Country Code in sys_user table via script using location.

[Savleen2]

User data is getting populated via workday in our system. Country Code field remains blank due to mismatch in the format sent via workday.

If I want to populate country code on change of location in sys_user, how should I do that? 

Please note that country_code contains choice list where the values dont exactly match from the ones set in cmn_location or core_country table.

(I was trying to use onchange client script, and get the value via script include but setting it on choice field is not working)

Please suggest a way out to fix this.

Thanks!

[DrewW]

You could look at t a onBefore business rule but it would be better to look at how the data is coming over from Workday and add the code there if possible.

For us when we get extra data from Workday its in a supplemental file so we would just update our transform map scripts to handle this.  So its going to depend on how yours is setup.