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 |
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 |
No |
10 |
Date of termination for Employee. Format must include forward slashes - examples: 1/20/2004, 11/9/2009 |
Date of Birth |
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 |
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 |