WO Line Mechanic Import Field Definitions

Only new WO line mechanics are imported. Updates to existing mechanics are not allowed.



Field

Value

Type/Size

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)