Importing Employees

Import may be used to add employees from external human resource or payroll processing sources.

Restrictions The form at of the file to be imported should be as follows. The first line should contain the field names to be imported in quotes followed by commas but no spaces. The example below will import the employee’s FirstName, LastName, Nickname, City and State.

 

• FirstName - The employee’s First Name.
• LastName -  The employee’s Last Name.
• Nickname - The employee’s Nickname.
• ID1 - The employee’s ID1.
• ID2 - The employee’s ID2.
• Address - The employee’sAddress.
• City - The employee’s City.
• State -The employee’s 2 digit State abbreviation.
• Zip - The employee’s Zip code.
• PhoneNumber1 - The employee’s Phone Number1.
• PhoneNumber2 - The employee’s Phone Number2.
• EmergencyPhoneNumber - The employee’s Emergency Phone Number.
• EmergencyContact - The employee’s Emergency Contact.
• BirthDate - The employee’s Birth Date. Specified as mm/dd/yyyy.
• HireDate - The employee’s Hire Date. Specified as mm/dd/yyyy.
• LastRaiseDate - The employee’s Last Raise Date. Specified as mm/dd/yyyy.
• TerminationDate - The employee’s Termination Date. Specified as mm/dd/yyyy.
• TerminationReason - Specify the name of the Termination Reason.
• Employment Status - “Y” signifies the employee is terminated. “I” signifies the employee is inactive.
• Job Code1-  The name of the employee’s first Job.
• Job Code2 - The name of the employee’s second Job.
• Job Code3 - The name of the employee’s third Job.
• Job Code4 - The name of the employee’s forth Job.
• Job Code5 - The name of the employee’s fifth Job.
• Job Code6 - The name of the employee’s sixth Job.
• Pay Rate1 - Job1 Pay Rate.
• Pay Rate2 - Job2 Pay Rate.
• Pay Rate3 - Job3 Pay Rate.
• Pay Rate4 - Job4 Pay Rate.
• Pay Rate5 - Job5 Pay Rate.
• Pay Rate6 - Job6 Pay Rate.
• Access Code - The4digitAccessCodefortheemployee.
• External Job1 - This field is compared with the “ADPExternalID” defined for each Job to determine the Job for the employee.
• External Job2 - This field is compared with the “ADPExternalID” defined for each Job to determine the Job for the employee.
• External Job3 - This field is compared with the “ADPExternalID” defined for each Job to determine the Job for the employee.
• External Job4 - This field is compared with the “ADPExternalID” defined for each Job to determine the Job for the employee.
• External Job5 - This field is compared with the “ADPExternalID” defined for each Job to determine the Job for the employee.
• External Job6 - This field is compared with the “ADPExternalID” defined for each Job to determine the Job for the employee.
• Require Card - Specify “Y” or “N”.
• Extend Rights - Specify “Y”or“N”.
• Clock In Out Only - Specify “Y”or“N”.
• Enforce Scheduling - Specify “Y”or“N”.
• Fingerprint At ClockIn - Specify “Y”or“N”.
• Fingerprint Required - Specify “Y”or“N”.

Procedure for Importing Employees 

• Access the Setup>Employees>Employees Window
• Click Tools and then click Import.
• Select the file containing the import information and click OK. The imported employee records will now appear in the Employee List.

For any questions regarding Importing Employees, please contact our support staff at [e-mail].