/
Imports - Employee Import Information

Imports - Employee Import Information

Field

Value

Type/Size

Required for create new

Required for Update

Update Allowed

Field

Value

Type/Size

Required for create new

Required for Update

Update Allowed

Connected User

Needs to match an existing username from their system

 

Facility

Must have an existing facility

int(5)

Employee Number

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)

Abbreviation

 

char(10)

Name

 

char(35)

Department

 

char(10)

Type

Y = Mechanic

D = Driver

M = Manager

A = Asst. Manager 

C = Clerical

I = Inactive

N = Other

char(1)

Labor Rate 1

 

decimal(4,2)

Rate Description 1

 

char(10)

 

 

 

Labor Rate 2

 

decimal(4,2)

Rate Description 2

 

char(10)

 

 

 

Labor Rate 3

 

decimal(4,2)

Rate Description 3

 

char(10)

 

 

 

Labor Rate 4

 

decimal(4,2)

Rate Description 4

 

char(10)

 

 

 

Labor Rate 5

 

decimal(4,2)

Rate Description 5

 

char(10)

 

 

 

PO Approval Maximum

 

int(9)

 License Number

 

char(15)

 License State

 

char(5)

 License Expires

 

 date

License Class

 

char(10)

Related content

Imports - Contacts Import Information
Imports - Contacts Import Information
More like this
Imports - Department Import Information
Imports - Department Import Information
More like this
Imports - Customers Import Information
Imports - Customers Import Information
More like this
Employee Import and Export
Employee Import and Export
More like this
Imports - Vehicle Contact Import Information
Imports - Vehicle Contact Import Information
More like this