I am facing issue in updating the user . Once the identity is created in saviynt , if there is any udate in the data of that identity in the authorative system , updated data is not refelecting in saviynt after running the job
xml
<dataMapping>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="username">
<![CDATA[SELECT STAFF_NUMBER as username,FIRST_NAME as firstname,LAST_NAME as lastname,MIDDLE_NAME as middlename,PRIMARY_MANAGER as manager,
PRIMARY_WORK_PHONE as phonenumber, PREFERRED_SURNAME as surname,ADDRESS_SUBURB as city,ADDRESS_POSTCODE as regioncode,
PREFERRED_FIRST as preferedFirstName,MAX_OCCUP_TERM_DATE as termdate,MIN_COMMENCE_DATE as startdate,PERSONAL_EMAIL as secondaryEmail,
PRIMARY_BU as departmentNumber,PRIMARY_BU_DESC as departmentname,PRIMARY_CLEVEL7_DESC as orgunitid,PRIMARY_CLEVEL8 as employeeclass,
PRIMARY_FACULTY_DESC as companyname,PRIMARY_MBDP as location,PRIMARY_MBDP_DESC as locationdesc,PRIMARY_PERSON_TYPE as employeeType,
PRIMARY_ROLE_DESC as jobDescription,WORK_MOBILE_PHONE as secondaryPhone,TITLE as title,STAFF_NUMBER as employeeid,STAFF_NUMBER as systemUsername,
ALL_EMP_JOB_BUS as AllEmpJobBus,NAME_SEARCH_PERMIT as NameSearchPermit,PRIMARY_MANAGER_POSITION# as PrimaryManagerPosition,
ALL_EMP_AWARDS as AllEmpAwards,
ALL_EMP_CLEVEL8 as AllEmpClevel8,
ALL_EMP_CLEVELS as AllEmpClevels,
ALL_EMP_JOB_BUS as AllEmpJobBus,
ALL_EMP_STATUS as AllEmpStatus,
DATE_OF_BIRTH as DOB,
PRIMARY_START_REASON as PrimaryStartReason,
PRIMARY_START_REASON_DESC as PrimaryStartReasonDesc,
ALL_START_REASON as AllStartReason,
(CASE WHEN PREFERRED_FIRST IS NOT NULL AND PREFERRED_SURNAME IS NOT NULL THEN (PREFERRED_FIRST||' '||PREFERRED_SURNAME)
WHEN PREFERRED_FIRST IS NULL AND PREFERRED_SURNAME IS NOT NULL THEN (FIRST_NAME||' '||PREFERRED_SURNAME)
WHEN PREFERRED_FIRST IS NOT NULL AND PREFERRED_SURNAME IS NULL THEN (PREFERRED_FIRST||' '||LAST_NAME)
ELSE (FIRST_NAME||' '||LAST_NAME) END) as displayname,
(STAFF_NUMBER ||'@'||'xxx.xxx.xx') as email,
(CASE WHEN MIN_COMMENCE_DATE > CURRENT_DATE THEN '0' ELSE '1' END) as status,PRIMARY_MANAGER_TITLE as PrimaryManagerTitle,
PRIMARY_POSITION# as jobCode ,PRIMARY_STATUS as PrimaryStatus FROM concept.UWA_SAVIYNT_STAFF_VW where STAFF_NUMBER=00112558]]>
</sql-query>
<importsettings>
<zeroDayProvisioning>false</zeroDayProvisioning>
<generateEmail>true</generateEmail>
<userNotInFileAction>NOACTION</userNotInFileAction>
<checkRules>false</checkRules>
<buildUserMap>false</buildUserMap>
<generateSystemUsername>false</generateSystemUsername>
<userOperationsAllowed>CREATE OR UPDATE</userOperationsAllowed>
<userReconcillationField>username</userReconcillationField>
</importsettings>
<mapper description="This is the mapping field for Saviynt Field name">
<mapfield saviyntproperty="username" sourceproperty="username" type="character"></mapfield>
<mapfield saviyntproperty="firstname" sourceproperty="firstname" type="character"></mapfield>
<mapfield saviyntproperty="lastname" sourceproperty="lastname" type="character"></mapfield>
<mapfield saviyntproperty="statuskey" sourceproperty="status" type="character"></mapfield>
<mapfield saviyntproperty="middlename" sourceproperty="middlename" type="character"></mapfield>
<mapfield saviyntproperty="manager" sourceproperty="manager" type="character"></mapfield>
<mapfield saviyntproperty="phonenumber" sourceproperty="phonenumber" type="character"></mapfield>
<mapfield saviyntproperty="customproperty1" sourceproperty="surname" type="character"></mapfield>
<mapfield saviyntproperty="city" sourceproperty="city" type="character"></mapfield>
<mapfield saviyntproperty="regioncode" sourceproperty="regioncode" type="character"></mapfield>
<mapfield saviyntproperty="preferedFirstName" sourceproperty="preferedFirstName" type="character"></mapfield>
<mapfield saviyntproperty="termdate" sourceproperty="termdate" type="character"></mapfield>
<mapfield saviyntproperty="startdate" sourceproperty="startdate" type="character"></mapfield>
<mapfield saviyntproperty="secondaryEmail" sourceproperty="secondaryEmail" type="character"></mapfield>
<mapfield saviyntproperty="departmentNumber" sourceproperty="departmentNumber" type="character"></mapfield>
<mapfield saviyntproperty="departmentname" sourceproperty="departmentname" type="character"></mapfield>
<mapfield saviyntproperty="orgunitid" sourceproperty="orgunitid" type="character"></mapfield>
<mapfield saviyntproperty="employeeclass" sourceproperty="employeeclass" type="character"></mapfield>
<mapfield saviyntproperty="companyname" sourceproperty="companyname" type="character"></mapfield>
<mapfield saviyntproperty="location" sourceproperty="location" type="character"></mapfield>
<mapfield saviyntproperty="locationdesc" sourceproperty="locationdesc" type="character"></mapfield>
<mapfield saviyntproperty="employeeType" sourceproperty="employeeType" type="character"></mapfield>
<mapfield saviyntproperty="jobDescription" sourceproperty="jobDescription" type="character"></mapfield>
<mapfield saviyntproperty="title" sourceproperty="title" type="character"></mapfield>
<mapfield saviyntproperty="secondaryPhone" sourceproperty="secondaryPhone" type="character"></mapfield>
<mapfield saviyntproperty="employeeid" sourceproperty="employeeid" type="character"></mapfield>
<mapfield saviyntproperty="systemUsername" sourceproperty="systemUsername" type="character"></mapfield>
<mapfield saviyntproperty="customproperty10" sourceproperty="AllEmpJobBus" type="character"></mapfield>
<mapfield saviyntproperty="customproperty15" sourceproperty="NameSearchPermit" type="character"></mapfield>
<mapfield saviyntproperty="customproperty7" sourceproperty="PrimaryManagerPosition" type="character"></mapfield>
<mapfield saviyntproperty="customproperty11" sourceproperty="AllEmpAwards" type="character" ></mapfield>
<mapfield saviyntproperty="customproperty12" sourceproperty="AllEmpClevel8" type="character"></mapfield>
<mapfield saviyntproperty="customproperty13" sourceproperty="AllEmpClevels" type="character"></mapfield>
<mapfield saviyntproperty="customproperty10" sourceproperty="AllEmpJobBus" type="character"></mapfield>
<mapfield saviyntproperty="customproperty9" sourceproperty="AllEmpStatus" type="character"></mapfield>
<mapfield saviyntproperty="customproperty14" sourceproperty="DOB" type="character"></mapfield>
<mapfield saviyntproperty="customproperty3" sourceproperty="PrimaryStartReason" type="character"></mapfield>
<mapfield saviyntproperty="customproperty4" sourceproperty="PrimaryStartReasonDesc" type="character"></mapfield>
<mapfield saviyntproperty="customproperty5" sourceproperty="AllStartReason" type="character"></mapfield>
<mapfield saviyntproperty="displayname" sourceproperty="displayname" type="character"></mapfield>
<mapfield saviyntproperty="email" sourceproperty="email" type="character"></mapfield>
<mapfield saviyntproperty="customproperty8" sourceproperty="PrimaryManagerTitle" type="character"></mapfield>
<mapfield saviyntproperty="jobCode" sourceproperty="jobCode" type="character"></mapfield>
<mapfield saviyntproperty="customproperty16" sourceproperty="PrimaryStatus" type="character"></mapfield>
</mapper>
</dataMapping>
[Post has been edited by moderator to mask domain/email]
.png){kind=link}
