Skip to main content
J. J. Keller Support Center

Employee Import Instructions Document

 

 

DATA FIELD

REQUIRED?

MAX CHARACTERS

INSTRUCTIONS

Employee Status

Yes

n/a

Enter Active or Inactive.

Employee ID

Yes

50

This field represents the unique identifier for each employee in the system and must be different for each employee. If no employee identification number is currently in use at your company, a combination of first initial (last name) and last 4 or 5 digits of the Social Security number works well as an Employee Code.

First Name

Yes

50

Enter first name with no additional punctuation.

Middle Name

No

10

Enter middle initial with no additional punctuation.

Last Name

Yes

50

Enter last name with no additional punctuation. Also enter additional descriptive abbreviations without punctuation, such as Jr or Sr

Job Title

Yes

255

Enter a value that matches an existing Job Title, or create new.

Employee Location Name

Yes

100

Enter a value that matches an existing Location Name, or create new.

Hire Date
(MM/DD/YYYY)

No

10

Date of hire for Employee. Format must include forward slashes - examples: 1/20/2004, 11/9/2009

Hire Country No 50 Enter the Country where Employee was hired.

Hire State/Province

No

50

Enter the State/Province where Employee was hired.

Employment Type

No

50

Enter an Employment Type of Full Time or Terminated or Seasonal or Temporary or Part Time.

Contract Worker

No

3

Enter Yes or No

Insurance Provided

No

3

Enter Yes or No

Shift

No

100

Enter a value that matches an existing Shift, or create new.

Work Area

No

100

Enter a value that matches an existing Work Area, or create new.

Cost Center

No

50

Enter a value that matches an existing Cost Center, or create new.

Hours per week

No

9

Enter a value between 0 - 168. Decimals can be used.

Hours per day

No

9

Enter a value between 0 - 24. Decimals can be used.

Office Phone

No

20

Enter phone number.

Cell Phone

No

20

Enter phone number.

Fax Number

No

20

Enter fax number.

Work Email

No

(But highly recommended)

241

Enter email address.

Termination Date
(MM/DD/YYYY)

No

10

Date of termination for Employee. Format must include forward slashes - examples: 1/20/2004, 11/9/2009

Date of Birth
(MM/DD/YYYY)

No

10

Date of Birth for Employee. Format must include forward slashes - examples: 1/20/2004, 11/9/2009

Gender

No

50

Enter Female or Male or Other or Unknown.

Home Address 1

No

100

Individual street number and name for Employee's home address.

Home Address 2

No

100

Additional line for Employee's home address, to be used for apartment number, suite number, etc.

Home City

No

50

City for Employee's home address.

Home Country No 50 Country Employee resides in

Home State/Province
(use drop-down)

No

50

State/Province for Employee's home address. Can be two letter abbreviation for full name of state/province.

Home ZIP/Postal Code

No

15

ZIP/Postal Code for Employee's home address.

Home Phone

No

20

Enter phone number.

Job Function No   Enter a value that matches an existing Job Function, or create new.
Supervisor No   Enter the applicable Supervisor's Employee ID

 

 

  • Was this article helpful?