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)