Hi DSawyer - You just have to join EmployeeContact to Employee. The Employee.UseForWorkEmail is the EmployeeContact.EmployeeContact for the work email address. Here's a sample query (we use DB2 database, so you may have to adapt a little if you're on MSSQL):

Select
emp.HROrganization
,emp.employee
,emp.useforworkemail
,ec.cdemailaddress as work_email
from
{schema}.employee as emp
inner join {schema}.employeecontact as ec
on ec.hrorganization = emp.hrorganization
and ec.employee = emp.employee
and ec.employeecontact = emp.useforworkemail
and ec.active = 1
and hex(ec.deleteflag) = repeat('0',32)
where
emp.hrorganization = {whatever}

Good Luck!

By the way, this is the same way you can get the work phone (Employee.UseForWorkPhone and join to EmployeeContact) and mailing address (Employee.UseForMailing and Employee.UseForPayroll and join to EmployeeAddress).

@DSawyer - curious what mechanism you going to use once you have the data?? ProcessFlow, manually build "loaduser.xml", etc??

Thanks Woozy.  I'll give that a try.  I can't believe I glanced over those fields quite a few times and didn't see that field.  Nice to have this place to bounce these questions off of.

@Time - I'm just providing adhoc queries with T-SQL/PL-SQL and transferring information between MSSQL and our Oracle system.

 

Thanks for the assistance

Dwayne