Imports - Employee Import Information
- Kim Dyer
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) |