PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 06/01/2018 8:36 AM by  GinaSL
Use for Work in EMPLOYEECONTACT
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Kidd Kasper
System Analyst/Admin
Private
Basic Member
(19 points)
Basic Member
Posts:9


Send Message:

--
05/17/2018 1:22 PM

    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

    Tags: LANDMARK EMPLOYEECONTACT WORK EMAIL
    GinaSL
    Director HRIS
    Private
    Basic Member
    (25 points)
    Basic Member
    Posts:9


    Send Message:

    --
    06/01/2018 8:36 AM
    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.
    You are not authorized to post a reply.