USER_NOT_IN_FILE_ACTION=NOACTION
#FILENAME=schemauser
DELIMITER=,
SKIP_NUMBER_OF_LINES=1
ZERODAYPROVISIONING=TRUE
userReconcillationField=systemUserName
GENERATESYSTEMUSERNAME=TRUE
GENERATEEMAIL=TRUE
EMAILTEMPLATE="Email Template Name"
CHECKRULES=TRUE
MODIFYUSERDATAJSON={"ADDITIONALTABLES":{"USERS":"SELECT USERNAME, ORGUNITID FROM USERS","CUSTOMERS":"SELECT c.customerkey, C.DESCRIPTION, c.CUSTOMERNAME from CUSTOMER c","ACTIVEIDENTITIES":"SELECT DISTINCT USERNAME FROM USERS WHERE (U.COUNTRY = 'SWITZERLAND') AND (U.ENDDATE > NOW() OR U.ENDDATE IS NULL)"},"COMPUTEDCOLUMNS":["CUSTOMPROPERTY7","STATUSKEY","CUSTOMER"],"PREPROCESSQUERIES":["UPDATE NEWUSERDATA N1 LEFT JOIN CURRENTCUSTOMERS C on N1.ORGUNITID = C.CUSTOMERNAME SET N1.CUSTOMPROPERTY7 = CASE WHEN C.CUSTOMERNAME IS NULL THEN 'Organization not managed' ELSE C.DESCRIPTION END,N1.CUSTOMER = CASE WHEN C.CUSTOMERNAME IS NULL THEN 'Organization not managed' ELSE C.CUSTOMERNAME END;","UPDATE NEWUSERDATA N1 LEFT JOIN CURRENTACTIVEIDENTITIES AI ON N1.USERNAME = AI.USERNAME SET N1.STATUSKEY = CASE WHEN AI.USERNAME IS NOT NULL THEN '1' ELSE '0' END;"]}
EMPLOYEEID,FIRSTNAME,LASTNAME,COMPANYNAME,LOCATION,DEPARTMENTNAME,customproperty3,DISPLAYNAME,TITLE,USERNAME,COUNTRY