#USER_NOT_IN_FILE_ACTION=NOACTION
#FILENAME=users
#DELIMITER=,
#SKIP_NUMBER_OF_LINES=1
#ZERODAYPROVISIONING=TRUE
#userReconcillationField=UserName
#GENERATESYSTEMUSERNAME=TRUE
#GENERATEEMAIL=TRUE
#EMAILTEMPLATE="Email Template Name"
#CHECKRULES=TRUE
#MODIFYUSERDATAJSON={"ADDITIONALTABLES":{"USERS":"SELECT USERNAME, ORGUNITID FROM USERS","ACTIVEIDENTITIES":"SELECT DISTINCT USERNAME FROM USERS WHERE COUNTRY = 'SWITZERLAND'"},"COMPUTEDCOLUMNS":["CUSTOMPROPERTY7","STATUSKEY"],"PREPROCESSQUERIES":["UPDATE NEWUSERDATA set CUSTOMPROPERTY7 = '1'","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"]}
USERNAME,FIRSTNAME,LASTNAME