Import Inactive and Terminated Date into Employee Master

How do I import Terminated Date/Reason into Employee Master? 

Can blank fields be used in the import file to remove inactive/terminated dates?

• Payroll
• Employee Master
• Employee Dates
• Employee Import

If importing to Update the Terminated or Inactive Dates: 

1. Build .CSV file (for 11.3) or .CSV or Excel file (2019.1 and higher) with the following columns
   1. Employee Number
   2. Terminated/Inactive Date
   3. Terminated/Inactive Reason (if applicable) 
      1. If Terminated and Inactive date/reason fields are both needed, they will need their own columns.
   4. Action Flag (U for Update)
2. Access Payroll > Employee Maintenance > Employee Import
3. Click Define
   1. Select Import Type of Employee Information Import
   2. Select Form Definition (11.3) or  Template (2019.1 and higher)
      1. Import Documentation in Additional Information below which contains information on creating the Form Definitions/Templates as well as processing the imports.
   3. Select the .CSV or Excel File
4. Click Accept

There is no option to import blank fields to remove field values in Employee Master in versions 11.3 and 2019.1. This functionality does not exist until 2021.1

 Using Blank or Null Records In Import File To Clear Fields Using The Employee Import

• 2017.1 and up - Utilizing Flexible Imports and Exports
• 11.3 and below - Employee Import
• Please reach out to Payroll Support with any follow up questions