Use for Work in EMPLOYEECONTACT

 1 Replies
 1 Subscribed to this topic
 45 Subscribed to this forum
Sort:
Author
Messages
Kidd Kasper
Basic Member Send Private Message
Posts: 13
Basic Member

Hello all,

I'm basically trying to automate adding a work email address to employee records (for new hires). I can add an email address record for the employee using IPA and a Landmark Transaction node. I'm able to update other elements as needed. However, I can't seem to change the value for "Use for Work". I understand that the value for specifying which email is used for work lives in the EMPLOYEE table under the USEFORWORKEMAIL field. But I'm really hoping to be able to do this in one node versus many (primarily to avoid a messy design and the notorious issue of process flows taking way too long to complete). VisibleMakeWorkEmail, UsedForWorkEmail, IsWorkEmail, IsWorkEmailDer, IsWorkEmailorPhoneDer are all fields in the EmployeeContact object that seem like they might be viable candidates for this sort of thing. But they don't seem to allow their state to be changed as evidence from testing (below).

STRING: _dataArea="ghrtest" & _module="hr" & _objectName="EmployeeContact" & _actionName="AddEmailAddress" & _actionOperator="NONE" & _actionType="SingleRecordQuery" & _runAsUser="" & _authenticatedUser="" & _pageSize="30" & _relationName="" & _setName="" & _asOfDate="" & _effectiveDate="" & HROrganization="1" & Employee="12345" & ContactDetail.EmailAddress="user@domain.com" & EmployeeContact_effective_date="20180517" & Active="TRUE" & VisibleMakeWorkEmail="TRUE" & UsedForWorkEmail="YES" & IsWorkEmail="TRUE" & IsWorkEmailDer="TRUE" & IsWorkEmailorPhoneDer="TRUE" & ContactMethod="6" RESULT: complete: true response message: Employee Contact created record count: 1 has next: false has previous: false Results header string: HROrganization,Employee,ContactDetail.EmailAddress,EmployeeContact_effective_date,Active,VisibleMakeWorkEmail,UsedForWorkEmail,IsWorkEmail,IsWorkEmailDer,IsWorkEmailorPhoneDer,ContactMethod Results string: 1,12345,user@domain.com,00000000,true,true,No,false,false,false,6 Communications trace null

 

 

Any suggestions would be appreciated.

 

Thanks

GinaSL
Basic Member Send Private Message
Posts: 9
Basic Member
Hi, I am not an IPA person, but I know this works with spreadsheet upload. Are you sure it is looking for a true/false, verses the actual stored value of 0/1? I also noticed your results string has "true" not "TRUE" so not sure if that makes a difference.