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.

Employee Location Identifier

No

30

The Location Identifier is used for Form 300 incident record numbering. As an example, if your location name is Chicago, you might use CHI for the location identifier.

Employee Location Address 1

Yes

100

Individual street number and name for Employee's work location.

Employee Location City

Yes

50

City for Employee's work location.

Employee Location Country

Yes

50

Country for Employee's work location.

Employee Location State/Province

Yes

50

State/Province for Employee's work location. Can be two letter abbreviation or full name of state/province.

Employee Location ZIP/Postal Code

Yes

15

ZIP/Postal Code for Employee's work location.

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 State/Province

No

50

Use the drop-down to select State/Province where Employee was hired.

Employment Type

No

50

Use the drop-down to select Employment Type of Full Time or Terminated or Seasonal or Temporary or Part Time.

Contract Worker

No

3

Use the drop-down to select Contract Worker Yes or No.

Insurance Provided

No

3

Use the drop-down to select whether Insurance is Provided 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

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

Use the drop-down to select Gender of 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 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.

 

 

  • Was this article helpful?