WO Line Mechanic Import Field Definitions
Only new WO line mechanics are imported. Updates to existing mechanics are not allowed.
Field | Value | Type/Size |
|---|---|---|
| Primary | Y = Is Primary N = Not Primary (default) | char(1) |
| WO Facility | Required | int(5) |
| WO Number | Required | char(7) |
| WO Line Number | Required | int(2) |
| Mechanic Facility | Required | int(5) |
| Mechanic Number | Required | int(10) |
| Wage | decimal(4, 2) | |
| Scheduled Hours | decimal(3, 2) | |
| Status | O = Open (Default) P = Partial C = Closed | char(1) |