Purpose

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

 

Restrictions

The format 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 First Name, Last Name, Nickname, City and State.

 

Figure 2.10 Sample Import File

“First Name”,”Last Name”,”Nickname”,”City”,”State” “Matt”,”Kovo”,”Matt K”,”Spring”,”TX” “Becky”,”Baker”,”Becky B”,”The Woodlands”,”TX”

 

Figure 2.11 Employee Import Fields

Field	Description
First Name	The employee’s First Name.
Last Name	The employee’s Last Name.
Nickname	The employee’s Nickname.
ID1	The employee’s ID1.
ID2	The employee’s ID2.
Address	The employee’s Address.
City	The employee’s City.
State	The employee’s 2 digit State abbreviation.
Zip	The employee’s Zip.
PhoneNumber1	The employee’s Phone Number 1.
PhoneNumber2	The employee’s Phone Number 2.
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.
EmploymentStatus	“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	The 4 digit Access Code for the employee.
External lJob1	This field is compared with the “ADP External ID” defined for each Job to determine the Job for the employee.
External Job2	This field is compared with the “ADP External ID” defined for each Job to determine the Job for the employee.
External Job3	This field is compared with the “ADP External ID” defined for each Job to determine the Job for the employee.
External Job4	This field is compared with the “ADP External ID” defined for each Job to determine the Job for the employee.
External Job5	This field is compared with the “ADP External ID” defined for each Job to determine the Job for the employee.
External Job6	This field is compared with the “ADP External ID” 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 Clock In	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.

 

Figure 2.12 Import Window 

 

·          Select the file containing the import information and click OK. The imported employee records will now appear in the Employee List.

 

Related Topics

Job Right ‘Employees - Edit Employees’

Job Right ‘Employees - Add Employees’