Use for Work in EMPLOYEECONTACT

 1 Replies
 1 Subscribed to this topic
 45 Subscribed to this forum
Sort:
Author
Messages
Kidd Kasper
Basic Member
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
    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.