Imports - PM Import Information

Asset Facility

Must be an existing facility

 int(5)

Asset Number

Must Match and existing asset in that facility

char(8)

PM Code

A0 thru Z9

char(1)Int(1)

Include PM Code

A0 thru Z9

char(1)Int(1)

Major VMRS

Must match an existing code

int(3)

 Intermediate VMRS

Must match an existing code

int(3) 

 Minor VMRS

Must match an existing code

 int(3)

 Description

 char(50)

 Template WO Facility

 int(5)

 Template WO Number

 char(7)

 Part Kit Facility

 int(5)

 Part Kit Number

 char(25)

 PM Enabled

Y = PM Enabled (Default)

N = PM Not Enabled

 char(1)

 One Time PM

 Y = One Time Use PM

N = Recurring PM (Default)

 char(1)

 Inspection

 char(15)

 Primary Meter

D = Days (Default)
M = Miles
G = Gallons
1 = Alt Meter 1
2 = Alt Meter 2
3 = Alt Meter 3
4 = Alt Meter 4

 char(1)

 Lock Days/Months

 P = interval is Months                                    (uses CCYYMM from date posted)

M = locked interval is Months                        (ignores date posted)

D = locked interval is Days

Space = Days meter is NOT locked                        (Default)

 char(1)

 Interval Days

int(6)

 Last Done Date

 date

 Last Done Lock Date

 date

 Lock Meter

Y =  Meter interval locked

N = Meter interval is NOT locked

If not set, set to N

 char(1)

 Interval Meter

 int(6)

 Last Done Work Meter

 decimal(8, 1)

 Last Done Life Meter

  int(8)

 Last Done Lock Meter

  int(8)

 Interval Gallons

 int(6)

 Last Done Gallons

int(8) 

 Interval Alt Meter 1

Only valid if the alternate meter is in use

int(6) 

  Last Done Alt Meter 1

Only valid if the alternate meter is in use

  int(6) 

  Interval Alt Meter 2

Only valid if the alternate meter is in use 

int(6)

 Last Done Alt Meter 2

Only valid if the alternate meter is in use  

int(6) 

  Interval Alt Meter 3

Only valid if the alternate meter is in use  

int(6) 

 Last Done Alt Meter 3

Only valid if the alternate meter is in use  

int(6) 

  Interval Alt Meter 4

Only valid if the alternate meter is in use  

int(6) 

 Last Done Alt Meter 4

Only valid if the alternate meter is in use  

int(6) 

 Current WO Facility

Must match existing facility

int(5) 

 Current WO Number

Must Match existing WO. If filled out, then we should mark PM as scheduled

 char(7)

 Current WO Line

Must match an existing line on the WO

 int(2)

 Last WO Facility

 int(5)

 Last WO Number

 char(7) 

 Last WO Line

 int2)

 Previous WO Facility

 int(5)

 Previous WO Number

  char(7)

 Previous WO Line

 int(2)

 Sleep Mode Enabled

Y = Sleep enabled

N = Sleep disabled

 char(1)

 Sleep Date

 date

 Days Sleep

 int(4)

 PM is Warranty

Y = PM is Warranty

N = PM Not Warranty (Default)

 char(1)

 Warranty Major VMRS

  int(3)

Warranty Intermediate   VMRS

  int(3) 

 Warranty Minor VMRS

   int(3)