{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Employee_Onboard","Revision detail"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,19],[21,3,21,9]]}
[]
[null,"Welcome to the Employee Data Loadsheets"]
[]
[null,"These loadsheets enable a client to upload employee data into the Alesco HRIS with a minimum of effort. All the relevant data checking and validation is done within the upload"]
[null,"process."]
[]
[null,"These loadsheets work as follows:"]
[null,"1) The employee data is placed into the relevant sheet"]
[null,"2) Each loadsheet is saved as its own CSV file"]
[null,"3) Those CSV files then need to be placed/FTP'd into the Interface Directory of your Alesco environment"]
[null,"4) Then the first process to run is the RA100 load which takes the CSV data into temporary tables in Alesco (data checking exists) and exception files are produced back into the Interface Directory"]
[null,"5) When all exceptions are cleared, the RA101 load can occur which takes the data in the temporary tables into the core Alesco tables (extensive data validation applied)"]
[null,"6) Again, exception files are created out of the RA101 process which should be run in NON-UPDATE until all errors are cleared"]
[null,"7) Once loaded, all data should be \"spot checked\" within the Alesco HRIS for accuracy"]
[]
[null,"Note to User:"]
[null,"a) The User should double-check their data sheets for format and cleanliness prior to creating the CSV for uploading into Alesco. Some hints are:"]
[null,"- turn on the filters for each column and scan down the filtered lists looking for inconsistencies in the data (dates, numbers etc)"]
[null,"- do a record count on the employee table and check against the record counts in the job and substantive table (accounting for multiple jobs) you should have a record in each sheet for all employees"]
[]
[null,"Output Files"]
[null,null,"Target Folder  ","C:\\temp"]

{"sheet":"Employee_Onboard","index":1,"n_rows":3,"n_cols":114,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["EmployeeID","Surname","First_Name","Second_Name","Third_Name","Preferred_Name","Title","Previous_Surname","Date_Of_Birth (DD/MM/YYYY)","Gender","First_Commencement_Date (DD/MM/YYYY)","Aboriginal_Descent","Citizenship","Country_Of_Origin","Cultural_Background","Disability","Disability_Type","Disability_Work_Modifications","Disability_Assistance","Ethnicity","IWI","Language_Background","Language_First","Language_Home","Marital_Status","Residency_Status","Tax_Organisation_ID","Reference_Emp","Address_1","Address_2","Town_Suburb","Country","state_code","Post_Code","Address_1_Post","Address_2_Post","Town_Suburb_Post","Country_Post","state_code_post","Post_Code_Post","home_phone","work_phone","mobile_phone","work_mobile_phone","other_phone","Email_Address_Personal","Email_Address_Work","Passport_ID","Expiry_Date (DD/MM/YYYY)","Passport_Issued_Location","Passport_Country","Passport_Sighted","Visa_ID","Visa_From_Date (DD/MM/YYYY)","Visa_To_Date (DD/MM/YYYY)","Visa_Type","Pay_Method","Branch_BSB_ID","Account_Name","Account_Number","Reference_Bank","Currency","Surname_Emer","First_Name_Emer","Title_Emer","Relationship_Emer","Address_Emer","phone_home_Emer","phone_work_Emer","phone_mobile_Emer","Email_Emer","Tax_Code","Tax_Scale","Start_Date (DD/MM/YYYY)","End_Date (DD/MM/YYYY)","Reference_Tax","TFN_Entry_Date (DD/MM/YYYY)","No_TFN","TFN_Exempt_Under_18","TFN_Exempt_Pensioner","Basis_Of_Payment","Surname_Changed","Australian_Resident","Tax_Free_Threshold","Family_Tax_Benefit","Help_Debt","Financial_Supplement_Debt","Super_Pension_Rebate","Trade_Support_Loan","Payee_Signature_Present","Payee_Signature_Date (DD/MM/YYYY)","Position_ID","Commence_Date (DD/MM/YYYY)","Position_Title","Super_Code","Employer_Amount","Employer_Percent","Employee_Amount","Employee_Percent","Reference_Super","Policy_Number","SGC_Scheme","Aust_Fund_ID","SMSF_Fund_Name","SMSF_Address_1","SMSF_Address_2","SMSF_Town_Suburb","SMSF_State_Code","SMSF_Post_Code","SMSF_Phone_Number","SMSF_Service_Address","SMSF_Branch_BSB_ID","SMSF_Account_Number","SMSF_Account_Name"]
["Insert Employee Onboard records below. Please read the Instruction on First Tab  before use."]
["ONBOARD","Loki06","Joanne","Reddy","Bavanasi","Lokeswara Bhavanasi","Mr","TestPSNM","1996-06-29","M","2015-05-23","N","AUST","ENG","Y",6,3,"N","SS",1,"A","ESB",1,"ENG","MAR","Y",123456789,"Test emp reference","21 Main St","Street Addrs2","Newtown","Australia","NSW",2121,"21 Main St","Post St Adddrs2","Newtown","Australia","NSW",2122,5234533,231232331,400111222,35345252323,"1212123","lok.asdf@lokipersona.com","lok.sdf@lokiwork.com","M342874","2023-09-27","Australia","AU","Y","AUPR32453","2020-02-02","2023-08-27","EMP","B","016000","YRGHWIUE34RHIU",456545,"Ref Bank","AUD","BEmr","FNameEmr","Mr","Cousion","Emer Addrs",456767445,987767653,9876765432,"tsstst@emremilsad.com","TAX","2B","2022-12-12","2023-12-11","Tax Ref","2022-12-12","Y","Y","Y","F","Y","Y","Y","N","N","N","Y","Y","Y","2020-08-22","SAL001","2020-08-22","HR Manager","CHOIP",350,50,250,50,"Super Ref",321321321,"A","PTC0133AU","A","A","A","A","A","A",123,"AA","AA",123,"AA"]

{"sheet":"Revision detail","index":2,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Revision","Date","Author","WO#","Details"]
["1.0","2020-12-18","Gokul","Express 1.8","Initial Version"]