I have a list of sales reps.  Each has a sales rep number.  The rep number it tied to a Sqlserver database that contain all customer information.  At the moment I use a bridge table to connect the Outsystems userid to the rep number.  Management wants me to use a first initial last name username.  All this information needs to be updated every time a rep changes position or leaves.  It is also a big time waster when deploying  to a new environment.

My request is simple,  how do I go about inserting the external rep number into the external_Id field of the system users table.

Is there a simple way or do I need to build an app?

Thank you