Applied Concepts HR/Payroll

Home Search Tags Glossary

Welcome Guest ( Login | Register )

Home » articles » HR/Payroll (emPath) » Technical » Customs » Update emPath login_string during newhire process - ESS Active...

Update emPath login_string during newhire process - ESS Active Directory

Update emPath login_string during newhire process - ESS Active Directory

Request: An emPath user recently asked for suggestions on how to update, during the new hire process, the emPath security table such that Active Directory authentication can be used. The emPath users request was:

"Our company is changing the authentication of ESS to use Active Directory. I used a SQL script to update the login_string field in the Susr table to the employees’ Active Directory user name for existing employees; however I am having an issue populating this field for new hires."

" I don’t think I can use the Network_account since it is not in the EMF table. I was thinking of using em_employee_id as the ESSLoginString. Then run a job every evening that will execute a SQL script updating the login_string field to AD user name, but I am no sure this is the best approach. Any ideas are greatly appreciated."

Suggestion: I suggested the emPath wizard and PDX (page description XML) features be used to address this issue. Following are wizard screens which show the newhire process with the addition of a step allowing the entry of domain and network id into the login_string field on the SUSR table. Effectively allowing Active Directory authentication.

Note that emPath provides user detail in their help document on how to use active directory authenticaton for employee self service (ESS). This example focuses on how to add the network id to the emPath security table, during the new hire process.

Note that Field Level Security can also be used to edit the values entered on the above step.

Note that this approach requires some setup, configuration, and a small custom. Contact Denton Harryman at (888) 731-3026 x-1 or DentonHarryman@att.net if you are interested in obtaining this custom.

Tags: