Equipment Inspections
Field Name |
Caption |
Mask |
Description |
Field Type |
EI_BRG_TMP |
TM Bearing (F) |
nnn |
TM Bearing (F) : Temperature Monitoring on Bearing in Degrees Fahrenheit |
Integer |
EI_CND1_CD |
Condition 1 |
nnn |
Condition 1 |
Integer |
EI_CND1_TY |
Condition 1 Text |
25x |
Condition 1 Text |
Text |
EI_CND10CD |
Condition 10 |
nnn |
Condition 10 |
Integer |
EI_CND10TY |
Condition 10 Text |
25x |
Condition 10 Text |
Text |
EI_CND11CD |
Condition 11 |
nnn |
Condition 11 |
Integer |
EI_CND11TY |
Condition 11 Text |
25x |
Condition 11 Text |
Text |
EI_CND12CD |
Condition 12 |
nnn |
Condition 12 |
Integer |
EI_CND12TY |
Condition 12 Text |
25x |
Condition 12 Text |
Text |
EI_CND13CD |
Condition 13 |
nnn |
Condition 13 |
Integer |
EI_CND13TY |
Condition 13 Text |
25x |
Condition 13 Text |
Text |
EI_CND14CD |
Condition 14 |
nnn |
Condition 14 |
Integer |
EI_CND14TY |
Condition 14 Text |
25x |
Condition 14 Text |
Text |
EI_CND15CD |
Condition 15 |
nnn |
Condition 15 |
Integer |
EI_CND15TY |
Condition 15 Text |
25x |
Condition 15 Text |
Text |
EI_CND16CD |
Condition 16 |
nnn |
Condition 16 |
Integer |
EI_CND16TY |
Condition 16 Text |
25x |
Condition 16 Text |
Text |
EI_CND17CD |
Condition 17 |
nnn |
Condition 17 |
Integer |
EI_CND17TY |
Condition 17 Text |
25x |
Condition 17 Text |
Text |
EI_CND18CD |
Condition 18 |
nnn |
Condition 18 |
Integer |
EI_CND18TY |
Condition 18 Text |
25x |
Condition 18 Text |
Text |
EI_CND19CD |
Condition 19 |
nnn |
Condition 19 |
Integer |
EI_CND19TY |
Condition 19 Text |
25x |
Condition 19 Text |
Text |
EI_CND2_CD |
Condition 2 |
nnn |
Condition 2 |
Integer |
EI_CND2_TY |
Condition 2 Text |
25x |
Condition 2 Text |
Text |
EI_CND20CD |
Condition 20 |
nnn |
Condition 20 |
Integer |
EI_CND20TY |
Condition 20 Text |
25x |
Condition 20 Text |
Text |
EI_CND3_CD |
Condition 3 |
nnn |
Condition 3 |
Integer |
EI_CND3_TY |
Condition 3 Text |
25x |
Condition 3 Text |
Text |
EI_CND4_CD |
Condition 4 |
nnn |
Condition 4 |
Integer |
EI_CND4_TY |
Condition 4 Text |
25x |
Condition 4 Text |
Text |
EI_CND5_CD |
Condition 5 |
nnn |
Condition 5 |
Integer |
EI_CND5_TY |
Condition 5 Text |
25x |
Condition 5 Text |
Text |
EI_CND6_CD |
Condition 6 |
nnn |
Condition 6 |
Integer |
EI_CND6_TY |
Condition 6 Text |
25x |
Condition 6 Text |
Text |
EI_CND7_CD |
Condition 7 |
nnn |
Condition 7 |
Integer |
EI_CND7_TY |
Condition 7 Text |
25x |
Condition 7 Text |
Text |
EI_CND8_CD |
Condition 8 |
nnn |
Condition 8 |
Integer |
EI_CND8_TY |
Condition 8 Text |
25x |
Condition 8 Text |
Text |
EI_CND9_CD |
Condition 9 |
nnn |
Condition 9 |
Integer |
EI_CND9_TY |
Condition 9 Text |
25x |
Condition 9 Text |
Text |
EI_CNDM_CD |
Motor Condition |
nnn |
Motor Condition |
Integer |
EI_CNDM_TY |
Motor Condition Text |
25x |
Motor Condition Text |
Text |
EI_CNDP_CD |
Pump Condition |
nnn |
Pump Condition |
Integer |
EI_CNDP_TY |
Pump Condition Text |
25x |
Pump Condition Text |
Text |
EI_CNDS_CD |
Seal Condition |
nnn |
Seal Condition |
Integer |
EI_CNDS_TY |
Seal Condition Text |
25x |
Seal Condition Text |
Text |
EI_COMMENT1 |
Long Note |
|
Long Note |
Memo |
EI_COND21 |
Condition 21 |
-nnnnn.nn |
Condition 21 |
Double |
EI_COND22 |
Condition 22 |
-nnnnn.nn |
Condition 22 |
Double |
EI_COND23 |
Condition 23 |
-nnnnn.nn |
Condition 23 |
Double |
EI_COND24 |
Condition 24 |
-nnnnn.nn |
Condition 24 |
Double |
EI_COND25 |
Condition 25 |
-nnnnn.nn |
Condition 25 |
Double |
EI_COND26 |
Condition 26 |
-nnnnn.nn |
Condition 26 |
Double |
EI_COND27 |
Condition 27 |
-nnnnn.nn |
Condition 27 |
Double |
EI_COND28 |
Condition 28 |
-nnnnn.nn |
Condition 28 |
Double |
EI_COND29 |
Condition 29 |
-nnnnn.nn |
Condition 29 |
Double |
EI_COND30 |
Condition 30 |
-nnnnn.nn |
Condition 30 |
Double |
EI_CRT_BY |
Created By |
25x |
Created By |
Text |
EI_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
EI_CURHR |
Current Hourmeter Reading |
nnnnnnnn.nn |
Current Hourmeter Reading |
Double |
EI_CUROTH |
Current Meter Reading |
nnnnnnnn.nn |
Current Meter Reading |
Double |
EI_DOC_FLG |
Document Available |
|
Doc Available |
Boolean |
EI_EQP_CD |
Equipment Code |
20x |
Equipment Code |
Text |
EI_EQP_TY |
Equipment Name |
50x |
Equipment Description |
Text |
EI_FRM_VM |
VM Frame (ips) |
n.nnnn |
VM Frame (ips) : Vibration Monitoring on Frame in Inches per Second |
Double |
EI_GE_ID |
Equipment Rec # |
-nnnnnnnn |
Long Integer |
|
EI_H1_H |
High H 1 (ft) |
nnnnn.nn |
High Head 1 (ft.) : 1st Pump Head in Feet High Speed |
Double |
EI_H1_L |
Low H 1 (ft) |
nnnnn.nn |
Low Head 1 (ft.) : 1st Pump Head in Feet Low Speed |
Double |
EI_H2_H |
High H 2 (ft) |
nnnnn.nn |
High Head 2 (ft.) : 2nd Pump Head in Feet High Speed |
Double |
EI_H2_L |
Low H 2 (ft) |
nnnnn.nn |
Low Head 2 (ft.) : 2nd Pump Head in Feet Low Speed |
Double |
EI_H3_H |
High H 3 (ft) |
nnnnn.nn |
High Head 3 (ft.) : 3rd Pump Head in Feet High Speed |
Double |
EI_H3_L |
Low H 3 (ft) |
nnnnn.nn |
Low Head 3 (ft.) : 3rd Pump Head in Feet Low Speed |
Double |
EI_H4_H |
High H 4 (ft) |
nnnnn.nn |
High Head 4 (ft.) : 4th Pump Head in Feet High Speed |
Double |
EI_H4_L |
Low H 4 (ft) |
nnnnn.nn |
Low Head 4 (ft.) : 4th Pump Head in Feet Low Speed |
Double |
EI_H5_H |
High H 5 (ft) |
nnnnn.nn |
High Head 5 (ft.) : 5th Pump Head in Feet High Speed |
Double |
EI_H5_L |
Low H 5 (ft) |
nnnnn.nn |
Low Head 5 (ft.) : 5th Pump Head in Feet Low Speed |
Double |
EI_H6_H |
High H 6 (ft) |
nnnnn.nn |
High Head 6 (ft.) : 6th Pump Head in Feet High Speed |
Double |
EI_H6_L |
Low H 6 (ft) |
nnnnn.nn |
Low Head 6 (ft.) : 6th Pump Head in Feet Low Speed |
Double |
EI_ID |
Inspection Rec # |
-nnnnnnnn |
Inspection Record No |
Long Integer |
EI_IMG_FLG |
|
|
Image Available |
Boolean |
EI_INSP_BY |
Inspected By |
20x |
Inspected By |
Text |
EI_INSP_DT |
Date Inspected |
mm/dd/yyyy |
Date Inspected |
Date/Time |
EI_INSP_TM |
Time Inspected |
hh:mm am |
Time Inspected |
Date/Time |
EI_LATEST |
Most Recent Inspect |
|
Most Recent Inspection |
Boolean |
EI_LG1_VLT |
Voltage Leg1 |
nnnn |
Voltage Leg1 |
Integer |
EI_LG2_VLT |
Voltage Leg2 |
nnnn |
Voltage Leg2 |
Integer |
EI_LG3_VLT |
Voltage Leg3 |
nnnn |
Voltage Leg3 |
Integer |
EI_LGT_TMP |
TM Lighting (F) |
nnn |
TM Lighting (F) : Temperature Monitoring on Lighting in Degrees Fahrenheit |
Integer |
EI_LR_AMP1 |
Lock rotor amps Leg1 |
nnnn.nn |
Lock rotor amps Leg1 |
Double |
EI_LR_AMP2 |
Lock rotor amps Leg2 |
nnnn.nn |
Lock rotor amps Leg2 |
Double |
EI_LR_AMP3 |
Lock rotor amps Leg3 |
nnnn.nn |
Lock rotor amps Leg3 |
Double |
EI_MAINTREQ |
Maint Requested |
|
Maintenance Requested |
Boolean |
EI_MCC_TMP |
TM MCC (F) |
nnn |
TM MCC (F) : Temperature Monitoring on Motor Controller in Degrees Fahrenheit |
Integer |
EI_MNMT_DT |
Next Motor Insp. |
mm/dd/yyyy |
Next Motor Insp. |
Date/Time |
EI_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
EI_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
EI_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
EI_MOV_FLG |
|
|
Movie Available |
Boolean |
EI_MTR_TMP |
TM Motor (F) |
nnn |
TM Motor (F) : Temperature Monitoring on Motor in Degrees Fahrenheit |
Integer |
EI_MTR_VM |
VM Motor (ips) |
n.nnnn |
VM Motor (ips) : Vibration Monitoring on Motor in Inches per Second |
Double |
EI_NEEDREP |
Needs Repair |
|
Needs Repair |
Boolean |
EI_NEXT_DT |
Next Inspection Date |
mm/dd/yyyy |
Next Inspection Date |
DateTime |
EI_PNMT_DT |
Next Pump Insp. |
mm/dd/yyyy |
Next Pump Insp. |
Date/Time |
EI_PUMP_VM |
VM Pump (ips) |
n.nnnn |
VM Pump (ips) : Vibration Monitoring on Pump in Inches per Second |
Double |
EI_PURP_CD |
Purpose |
nnn |
Purpose |
Integer |
EI_PURP_TY |
Purpose Text |
25x |
Purpose Text |
Text |
EI_Q1_H |
High Q 1 (gpm) |
nnnnn.nn |
High Discharge 1 (gpm) : 1st Pump Discharge in Gallons per Minute High Speed |
Double |
EI_Q1_L |
Low Q 1 (gpm) |
nnnnn.nn |
Low Discharge 1 (gpm) : 1st Pump Discharge in Gallons per Minute Low Speed |
Double |
EI_Q2_H |
High Q 2 (gpm) |
nnnnn.nn |
High Discharge 2 (gpm) : 2nd Pump Discharge in Gallons per Minute High Speed |
Double |
EI_Q2_L |
Low Q 2 (gpm) |
nnnnn.nn |
Low Discharge 2 (gpm) : 2nd Pump Discharge in Gallons per Minute Low Speed |
Double |
EI_Q3_H |
High Q 3 (gpm) |
nnnnn.nn |
High Discharge 3 (gpm) : 3rd Pump Discharge in Gallons per Minute High Speed |
Double |
EI_Q3_L |
Low Q 3 (gpm) |
nnnnn.nn |
Low Discharge 3 (gpm) : 3rd Pump Discharge in Gallons per Minute Low Speed |
Double |
EI_Q4_H |
High Q 4 (gpm) |
nnnnn.nn |
High Discharge 4 (gpm) : 4th Pump Discharge in Gallons per Minute High Speed |
Double |
EI_Q4_L |
Low Q 4 (gpm) |
nnnnn.nn |
Low Discharge 4 (gpm) : 4th Pump Discharge in Gallons per Minute Low Speed |
Double |
EI_Q5_H |
High Q 5 (gpm) |
nnnnn.nn |
High Discharge 5 (gpm) : 5th Pump Discharge in Gallons per Minute High Speed |
Double |
EI_Q5_L |
Low Q 5 (gpm) |
nnnnn.nn |
Low Discharge 5 (gpm) : 5th Pump Discharge in Gallons per Minute Low Speed |
Double |
EI_Q6_H |
High Q 6 (gpm) |
nnnnn.nn |
High Discharge 6 (gpm) : 6th Pump Discharge in Gallons per Minute High Speed |
Double |
EI_Q6_L |
Low Q 6 (gpm) |
nnnnn.nn |
Low Discharge 6 (gpm) : 6th Pump Discharge in Gallons per Minute Low Speed |
Double |
EI_RDCR_VM |
VM Reducer (ips) |
n.nnnn |
VM Reducer (ips) : Vibration Monitoring on Reducer in Inches per Second |
Double |
EI_REQNUMB |
Request # |
25x |
Request # |
String |
EI_RN_AMP1 |
Running amps Leg1 |
nnnn.nn |
Running amps Leg1 |
Double |
EI_RN_AMP2 |
Running amps Leg2 |
nnnn.nn |
Running amps Leg2 |
Double |
EI_RN_AMP3 |
Running amps Leg3 |
nnnn.nn |
Running amps Leg3 |
Double |
EI_ROTSPD1 |
1st Speed (rpm) |
nnnn |
1st Speed (rpm) : Motor revolutions per minute |
Integer |
EI_ROTSPD2 |
2nd Speed (rpm) |
nnnn |
2nd Speed (rpm) : Motor revolutions per minute for second speed (if available) |
Integer |
EI_ROWVER |
|
|
Rowversion for the Equipment Inspections table |
Date/Time |
EI_RQ_ID |
Link to Request |
nnnnnnnn |
Long Integer |
|
EI_SHFT_VM |
VM Shaft (ips) |
n.nnnn |
VM Shaft (ips) : Vibration Monitoring on Shaft in Inches per Second |
Double |
EI_SHT_OFH |
Shut Off Head H(ft) |
nnnnn.nn |
Shut Off Head H(ft) : High Speed Pump Shut Off Head in Feet |
Double |
EI_SHT_OFL |
Shut Off Head L(ft) |
nnnnn.nn |
Shut Off Head L(ft) : Low Speed Pump Shut Off Head in Feet |
Double |
EI_SNMT_DT |
Next Seal Insp. |
mm/dd/yyyy |
Next Seal Insp. |
Date/Time |
EL_THRES |
Outside Threshold |
|
At least one inspection value was outside of the threshold limit set |
Boolean |
EI_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
EI_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
EI_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
EI_USER13 |
User 13 |
|
User 13 |
Boolean |
EI_USER14 |
User 14 |
|
User 14 |
Boolean |
EI_USER15 |
User 15 |
|
User 15 |
Boolean |
EI_USER16CD |
User 16 |
nnn |
User 16 |
Small Integer |
EI_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
EI_USER17CD |
User 17 |
nnn |
User 17 |
Small Integer |
EI_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
EI_USER18CD |
User 18 |
nnn |
User 18 |
Small Integer |
EI_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
EI_USER19CD |
User 19 |
nnn |
User 19 |
Small Integer |
EI_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
EI_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
EI_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
EI_USER20CD |
User 20 |
nnn |
User 20 |
Small Integer |
EI_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
EI_USER21 |
User 21 |
50x |
User 21 |
String |
EI_USER22 |
User 22 |
50x |
User 22 |
String |
EI_USER23 |
User 23 |
50x |
User 23 |
String |
EI_USER24 |
User 24 |
50x |
User 24 |
String |
EI_USER25 |
User 25 |
50x |
User 25 |
String |
EI_USER26 |
User 26 |
-nnnnnnnn.nn |
User 26 |
Double |
EI_USER27 |
User 27 |
-nnnnnnnn.nn |
User 27 |
Double |
EI_USER28 |
User 28 |
-nnnnnnnn.nn |
User 28 |
Double |
EI_USER29 |
User 29 |
-nnnnnnnn.nn |
User 29 |
Double |
EI_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
EI_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
EI_USER30 |
User 30 |
-nnnnnnnn.nn |
User 30 |
Double |
EI_USER31 |
User 31 |
mm/dd/yyyy |
User 31 |
DateTime |
EI_USER32 |
User 32 |
mm/dd/yyyy |
User 32 |
DateTime |
EI_USER33 |
User 33 |
mm/dd/yyyy |
User 33 |
DateTime |
EI_USER34 |
User 34 |
mm/dd/yyyy |
User 34 |
DateTime |
EI_USER35 |
User 35 |
mm/dd/yyyy |
User 35 |
DateTime |
EI_USER36 |
User 36 |
|
User 36 |
Boolean |
EI_USER37 |
User 37 |
|
User 37 |
Boolean |
EI_USER38 |
User 38 |
|
User 38 |
Boolean |
EI_USER39 |
User 39 |
|
User 39 |
Boolean |
EI_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
EI_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
EI_USER40 |
User 40 |
|
User 40 |
Boolean |
EI_USER4 |
User 4 |
30x |
User 4 |
Text |
EI_USER5 |
User 5 |
30x |
User 5 |
Text |
EI_USER6 |
User 6 |
30x |
User 6 |
Text |
EI_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
EI_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
EI_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
EI_WINS_CD |
Work Inspector |
20x |
Work Inspector |
String |
EI_WINS_TY |
Work Inspector Text |
40x |
Work Inspector Text |
String |
EI_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |
|
EI_WONUMB |
Work Order # |
25x |
Work Order # |
String |