Imports - Contacts Import Information

First Name

Create New - First/last name combo can’t already exist

Update- Must find existing first/last name

Last Name

Create New - First/last name combo can’t already exist

Update- Must find existing first/last name

Prefix

Email

Create New- must be an employee number that doesn’t exist in the facility selecting

Update - must find existing employee number in that facility

int(10)

Phone Number

char(10)

Job Title

char(35)

Department

Must be an existing department

char(10)

Division

Y = Mechanic

D = Driver

M = Manager

A = Asst. Manager 

C = Clerical

I = Inactive

N = Other

char(1)

Language

decimal(4,2)