How to Import Employees

How to use the import tool to import employees via CSV file

1. Click Import in the Left Nav to expand the options and select Employees

2. Click in the software to download the sample file.

3. Open the sample file from the browser or from the Downloads folder. Spreadsheet software such as Excel or Libre Office Calc is required to complete the following steps.

4. Enter employee data into the fields. The Required Fields must be filled to continue.

* Drop-down options may vary based on what's been added to your account

Required Fields

Field	Description
Employee ID	Unique ID assigned to employees * Can be numeric or alphanumeric
First Name	Employee's First Name
Last Name	Employee's Last Name
Location	Select a Location previously added to your EWS account
Employee Status	Select one: Active Pending Inactive Terminated
Hire Date	Hire Date of the employee
Employee Type	Select one: Regular Intern Seasonal Temporary Contractor On Call VendorEmployee
FT/PT Status	Select one: Part Time Full Time
Pay Type	Select one: Salary Commas must be removed in the formatting Hourly
FLSA Code	Select one: Exempt Non Exempt
Pay Schedule	Select one: Weekly Bi-Weekly Monthly Semi-Monthly
Pay Rate	Select one: Part Time Full Time
Pay Rate Schedule	Select one: Hourly Daily Weekly BiWeekly FourWeek SemiMonthly Monthly Annual
Pay Change Reason	Select one: Promotion Demotion Annual Review Performance Review Cost of Living Adj. Other None New Hire
Expected Hours Behavior	Select one: None Fixed Fluctuating FluctuatingWithFixedRate * Required: Must be None when PayType is Hourly or PayType is Salary and FLSAType is Exempt, must be know for any other case