Recycled Pump Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
CM_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
CM_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
CM_BFRQ_CD |
Billing Freq |
nnn |
Billing Freq: |
Integer |
CM_BFRQ_TY |
Billing Freq. Text |
25x |
Billing Freq Text: |
Text |
CM_BOOK |
Book Value |
nnnnnnnn.nn |
Book Value |
Double |
CM_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
CM_BR_TY |
Default WO Cat Text |
60x |
Default Category Text |
Text |
CM_CAPCITY |
Pump Capacity |
nnnnnnnnn |
Pump Capacity |
Long Integer |
CM_CFRQ_CD |
Contract Freq. |
nnn |
Contract Freq |
Integer |
CM_CFRQ_TY |
Contract Freq. Text |
25x |
Contract Freq Text |
Text |
CM_CLSS_CD |
Classification |
nnn |
Pump Classification |
Integer |
CM_CLSS_TY |
Classification Text |
25x |
Pump Class Text |
Text |
CM_CNDM_CD |
Motor Condition |
nnn |
Motor Condition |
Integer |
CM_CNDM_TY |
Motor Condition Text |
25x |
Motor Condition Text |
Text |
CM_CNDP_CD |
Pump Condition |
nnn |
Pump Condition |
Integer |
CM_CNDP_TY |
Pump Condition Text |
25x |
Pump Condition Text |
Text |
CM_CNDS_CD |
Seal Condition |
nnn |
Seal Condition |
Integer |
CM_CNDS_TY |
Seal Condition Text |
25x |
Seal Condition Text |
Text |
CM_CNTL_CD |
Pump Controller |
nnn |
Pump Controller |
Integer |
CM_CNTL_TY |
Pump Controller Text |
25x |
Pump Controller Text |
Text |
CM_COF |
Consequence of Failure |
nnnn.nn |
Consequence of Failure |
Double |
CM_CON_CST |
Contract Cost |
nnnnnnnn.nn |
Contract Cost: |
Double |
CM_CRT_BY |
Created By |
25x |
Created By |
Text |
CM_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CM_CS_ID |
Pump Station Rec # |
nnnnnnnn |
Long Integer |
|
CM_CS_NAME |
Station Name |
30x |
Pump Station Name |
Text |
CM_CS_NUMB |
Station Number |
30x |
Pump Station ID: |
Text |
CM_CUR_DT |
Current Date |
mm/dd/yyyy |
Current Date |
Date/Time |
CM_CURHR |
Current Hourmeter |
nnnnnnnn.n |
Current Hourmeter |
Double |
CM_CUROTH |
Current Other Meter |
nnnnnnnn.n |
Current Other Meter |
Double |
CM_DEP_AMT |
Dep. Amount |
nnnnnnnn.nn |
Depreciation Amount |
Double |
CM_DEP_DT |
Dep. Date |
mm/dd/yyyy |
Depreciation Date |
Date/Time |
CM_DOC_FLG |
Document Available |
|
Doc Available |
Boolean |
CM_DSC_DIA |
DS End Dia(in) |
nnnn.nn |
DS End Diameter (in) |
Double |
CM_DSCH_CD |
DS End Type |
nnn |
DS End Type |
Integer |
CM_DSCH_TY |
DS End Type Text |
25x |
DS End Type Text |
Text |
CM_DSCL_EL |
DS CL Elev (ft) |
-nnnnn.nn |
DS CL Elevation (ft) |
Double |
CM_DYNM_HD |
TDH (ft) |
nnnnn.nn |
TDH (ft) |
Double |
CM_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
CM_H1_HIGH |
High H 1 (ft) |
nnnnn.nn |
High H 1 (ft) |
Double |
CM_H1_LOW |
Low H 1 (ft) |
nnnnn.nn |
Low H 1 (ft) |
Double |
CM_H2_HIGH |
High H 2 (ft) |
nnnnn.nn |
High H 2 (ft) |
Double |
CM_H2_LOW |
Low H 2 (ft) |
nnnnn.nn |
Low H 2 (ft) |
Double |
CM_H3_HIGH |
High H 3 (ft) |
nnnnn.nn |
High H 3 (ft) |
Double |
CM_H3_LOW |
Low H 3 (ft) |
nnnnn.nn |
Low H 3 (ft) |
Double |
CM_H4_HIGH |
High H 4 (ft) |
nnnnn.nn |
High H 4 (ft) |
Double |
CM_H4_LOW |
Low H 4 (ft) |
nnnnn.nn |
Low H 4 (ft) |
Double |
CM_H5_HIGH |
High H 5 (ft) |
nnnnn.nn |
High H 5 (ft) |
Double |
CM_H5_LOW |
Low H 5 (ft) |
nnnnn.nn |
Low H 5 (ft) |
Double |
CM_H6_HIGH |
High H 6 (ft) |
nnnnn.nn |
High H 6 (ft) |
Double |
CM_H6_LOW |
Low H 6 (ft) |
nnnnn.nn |
Low H 6 (ft) |
Double |
CM_HIGH_SP |
High Speed (rpm) |
nnnnn |
High Speed (rpm) |
Integer |
CM_HORSPWR |
Horsepower |
nnnnn.nn |
Motor Horsepower |
Double |
CM_ID |
Pump Rec # |
nnnnnnnn |
Raw Water Pump Record Number |
Long Integer |
CM_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Integer |
CM_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Integer |
CM_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
String |
CM_IMP_DIA |
Impeller Dia (in) |
nnnn.nn |
Impeller Dia (in) |
Double |
CM_IMP_MOD |
Impeller Model No |
25x |
Impeller Model Number |
Text |
CM_INS_EXP |
Ins. Expires |
mm/dd/yyyy |
Expires |
Date/Time |
CM_INSCOCD |
Insurance Co. |
nnn |
Insurance Co. |
Integer |
CM_INSCOTY |
Insurance Co. Text |
25x |
Insurance Co. Text |
Text |
CM_INSP_DT |
Date Inspected |
mm/dd/yyyy |
Date Inspected |
Date/Time |
CM_INST_BY |
Installed By |
30x |
Installed By |
Text |
CM_INST_DT |
Date Installed |
mm/dd/yyyy |
Date Installed |
Date/Time |
CM_LC_ID |
Slot Rec # |
nnnnnnnn |
Long Integer |
|
CM_LC_NO |
Slot Number |
10x |
Slot Number |
Text |
CM_LOK_RTR |
Lock Rotor Amps |
nnnn.nn |
Lock Rotor Amps |
Double |
CM_LOW_SP |
Low Speed (rpm) |
nnnnn |
Low Speed (rpm) |
Integer |
CM_LUB_CD |
Lubrication Type |
nnn |
Lubrication Type |
Integer |
CM_LUB_TY |
Lubrication Type Txt |
25x |
Lubrication Type Txt |
Text |
CM_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
CM_MAX_DT |
Service Life |
nnnn.nnn |
Maximum Years |
Double |
CM_MFRAME |
Motor Frame |
30x |
Motor Frame |
Text |
CM_MINS_DT |
Motor Installed |
mm/dd/yyyy |
Date Motor Installed |
Date/Time |
CM_MITIGAT |
Mitigation |
nnnnnnnn.nn |
Mitigation |
Double |
CM_MLOC_CD |
Motor Installation |
nnn |
Motor Installation |
Integer |
CM_MLOC_TY |
Motor Inst Text |
25x |
Motor Inst Text |
Text |
CM_MMDL_NO |
Motor Model No |
25x |
Motor Model Num Text |
Text |
CM_MMFG_CD |
Motor Manuf |
nnn |
Motor Manufacturer |
Integer |
CM_MMFG_TY |
Motor Mfg Text |
25x |
Motor Mfg Text |
Text |
CM_MNMT_DT |
Next Motor Insp |
mm/dd/yyyy |
Next Motor Insp |
Date/Time |
CM_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
CM_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
CM_MOD_TM |
Last Modified Time |
hh:mm am |
Last Modified Time |
Date/Time |
CM_MTR_EFF |
Motor Efficiency |
nnn.nn |
Motor Efficiency |
Double |
CM_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
CM_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
CM_NMNT_DT |
Next Inspection Date |
mm/dd/yyyy hh:mm am |
Next Inspection Date |
DateTime |
CM_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
CM_NUMBER |
Pump Number |
30x |
Pump Number |
Text |
CM_PHAS_CD |
Electrical Phase |
nnn |
Electrical Phase |
Integer |
CM_PHAS_TY |
Electrical Phase Txt |
25x |
Electrical Phase Txt |
Text |
CM_PLATE1 |
Plate 1 |
30x |
Plate 1 |
Text |
CM_PLATE10 |
Plate 10 |
30x |
Plate 10 |
Text |
CM_PLATE11 |
Plate 11 |
30x |
Plate 11 |
Text |
CM_PLATE12 |
Plate 12 |
30x |
Plate 12 |
Text |
CM_PLATE13 |
Plate 13 |
30x |
Plate 13 |
Text |
CM_PLATE14 |
Plate 14 |
30x |
Plate 14 |
Text |
CM_PLATE15 |
Plate 15 |
30x |
Plate 15 |
Text |
CM_PLATE16 |
Plate 16 |
30x |
Plate 16 |
Text |
CM_PLATE17 |
Plate 17 |
30x |
Plate 17 |
Text |
CM_PLATE18 |
Plate 18 |
30x |
Plate 18 |
Text |
CM_PLATE19 |
Plate 19 |
30x |
Plate 19 |
Text |
CM_PLATE2 |
Plate 2 |
30x |
Plate 2 |
Text |
CM_PLATE20 |
Plate 20 |
30x |
Plate 20 |
Text |
CM_PLATE3 |
Plate 3 |
30x |
Plate 3 |
Text |
CM_PLATE4 |
Plate 4 |
30x |
Plate 4 |
Text |
CM_PLATE5 |
Plate 5 |
30x |
Plate 5 |
Text |
CM_PLATE6 |
Plate 6 |
30x |
Plate 6 |
Text |
CM_PLATE7 |
Plate 7 |
30x |
Plate 7 |
Text |
CM_PLATE8 |
Plate 8 |
30x |
Plate 8 |
Text |
CM_PLATE9 |
Plate 9 |
30x |
Plate 9 |
Text |
CM_PMDL_NO |
Pump Model No |
25x |
Pump Model Numb Text |
Text |
CM_PMFG_CD |
Pump Manufacturer |
nnn |
Pump Manufacturer |
Integer |
CM_PMFG_TY |
Pump Mfg Text |
25x |
Pump Mfg Text |
Text |
CM_PMP_SZ |
Pump Size |
25x |
Pump Size |
Text |
CM_PNMT_DT |
Next Pump Insp |
mm/dd/yyyy |
Next Pump Insp |
Date/Time |
CM_PO |
Purchase Order |
30x |
Purchase Order |
Text |
CM_POF |
Probability of Failure |
nnn.nn |
Probability of Failure |
Double |
CM_PRIM_CD |
Priming Type |
nnn |
Priming Type |
Integer |
CM_PRIM_TY |
Priming Type Text |
25x |
Priming Type Text |
Text |
CM_PRJ_NO |
Project Number |
25x |
Project Number |
Text |
CM_PUR_DT |
Purchase Date |
mm/dd/yyyy |
Purchase Date: |
Date/Time |
CM_PURCOST |
Purchase Amount |
nnnnnnnn.nn |
Purchase Cost: |
Double |
CM_PVALUE |
Present Value |
nnnnnnnnn.nn |
Present Value |
Double |
CM_Q1_HIGH |
High Q 1 (gpm) |
nnnnn.nn |
High Q 1 (gpm) |
Double |
CM_Q1_LOW |
Low Q 1 (gpm) |
nnnnn.nn |
Low Q 1 (gpm) |
Double |
CM_Q2_HIGH |
High Q 2 (gpm) |
nnnnn.nn |
High Q 2 (gpm) |
Double |
CM_Q2_LOW |
Low Q 2 (gpm) |
nnnnn.nn |
Low Q 2 (gpm) |
Double |
CM_Q3_HIGH |
High Q 3 (gpm) |
nnnnn.nn |
High Q 3 (gpm) |
Double |
CM_Q3_LOW |
Low Q 3 (gpm) |
nnnnn.nn |
Low Q 3 (gpm) |
Double |
CM_Q4_HIGH |
High Q 4 (gpm) |
nnnnn.nn |
High Q 4 (gpm) |
Double |
CM_Q4_LOW |
Low Q 4 (gpm) |
nnnnn.nn |
Low Q 4 (gpm) |
Double |
CM_Q5_HIGH |
High Q 5 (gpm) |
nnnnn.nn |
High Q 5 (gpm) |
Double |
CM_Q5_LOW |
Low Q 5 (gpm) |
nnnnn.nn |
Low Q 5 (gpm) |
Double |
CM_Q6_HIGH |
High Q 6 (gpm) |
nnnnn.nn |
High Q 6 (gpm) |
Double |
CM_Q6_LOW |
Low Q 6 (gpm) |
nnnnn.nn |
Low Q 6 (gpm) |
Double |
CM_RCOST |
Replacement Cost |
nnnnn.nn |
Replacement Cost |
Double |
CM_RECEIVE |
Received Date |
mm/dd/yyyy |
Received Date: |
Date/Time |
CM_RENTED |
Rented? |
|
Rented? |
Boolean |
CM_REP_CST |
Replace Cost |
nnnnnnnn.nn |
Replacement Cost |
Double |
CM_REP_DT |
Replace Date |
mm/dd/yyyy |
Replacement Date |
Date/Time |
CM_REPL_DT |
Replacement Date |
mm/dd/yyyy |
Replacement Date |
Date/Time |
CM_RFX_CST |
Fixed Rate |
nnnnnnnn.nn |
Fixed Rental Rate |
Double |
CM_RHR_CST |
Hourly Rate |
nnnnnnnn.nn |
Hourly Rental Rate |
Double |
CM_RISK |
Risk |
nnnn.nn |
Risk = COF * POF * Mitigation |
Double |
CM_RLIFE |
Remaining Life |
nnnn.nn |
Remaining Life |
Double |
CM_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CM_RPM_MTR |
Motor RPM |
nnnnn |
Motor RPM |
Long Integer |
CM_RVALUE |
Replacement Value |
nnnnnnnnn.nn |
Replacement Value |
Double |
CM_SALVAGE |
Salvage Value |
nnnnnnnn.nn |
Salvage Value |
Double |
CM_SBY_CD |
Standby Power |
nnn |
Standby Power |
Integer |
CM_SBY_TY |
Standby Power Text |
25x |
Standby Power Text |
Text |
CM_SEAL_DT |
Seal Installed |
mm/dd/yyyy |
Date Seal Installed |
Date/Time |
CM_SHT_OFH |
Shutoff Head H (ft) |
nnnnn.nn |
Shutoff Head H (ft) |
Double |
CM_SHT_OFL |
Shutoff Head L (ft) |
nnnnn.nn |
Shutoff Head L (ft) |
Double |
CM_SMDL_NO |
Seal Model No |
25x |
Seal Model Num Text |
Text |
CM_SMFG_CD |
Seal Manuf |
nnn |
Seal Manufacturer |
Integer |
CM_SMFG_TY |
Seal Manuf Text |
25x |
Seal Mfg Text |
Text |
CM_SNMT_DT |
Next Seal Insp |
mm/dd/yyyy |
Next Seal Insp |
Date/Time |
CM_SRL_MTR |
Motor Serial No |
25x |
Motor Serial Number |
Text |
CM_SRL_PMP |
Pump Serial No |
25x |
Pump Serial Number |
Text |
CM_SRL_SEL |
Seal Serial No |
25x |
Seal Serial Number |
Text |
CM_STAGES |
Number of Stages |
nnn |
Number of Stages |
Integer |
CM_STAT_CD |
Status |
nnn |
Status |
Integer |
CM_STAT_TY |
Status Text |
25x |
Status Text |
Text |
CM_STRT_CD |
Starter Type |
nnn |
Starter Type |
Integer |
CM_STRT_TY |
Starter Type Text |
25x |
Starter Type Text |
Text |
CM_SUC_DIA |
SS End Dia (in) |
nnnn.nn |
SS End Diameter (in) |
Double |
CM_SUCD_CD |
SS End Type |
nnn |
SS End Type |
Integer |
CM_SUCD_TY |
SS End Type Text |
25x |
SS End Type Text |
Text |
CM_SUCL_EL |
SS CL Elev (ft) |
-nnnnn.nn |
SS CL Elevation (ft) |
Double |
CM_TSEL_CD |
Seal Type |
nnn |
Seal Type |
Integer |
CM_TSEL_TY |
Seal Type Text |
25x |
Seal Type Text |
Text |
CM_TYPE_CD |
Pump Type |
nnn |
Pump Type |
Integer |
CM_TYPE_TY |
Pump Type Text |
25x |
Pump Type Text |
Text |
CM_USEHRS |
Usable Hrs/Yr |
nnnn |
Usable Hrs/Yr |
Integer |
CM_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
CM_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
CM_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
CM_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
CM_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
CM_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
CM_USER4 |
User 4 |
30x |
User 4 |
Text |
CM_USER5 |
User 5 |
30x |
User 5 |
Text |
CM_USER6 |
User 6 |
30x |
User 6 |
Text |
CM_USER7 |
User 7 |
-nnnnnnnnn.nn |
User 7 |
Double |
CM_USER8 |
User 8 |
-nnnnnnnnn.nn |
User 8 |
Double |
CM_USER9 |
User 9 |
-nnnnnnnnn.nn |
User 9 |
Double |
CM_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
CM_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
CM_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
CM_USER13 |
User 13 |
|
User 13 |
Boolean |
CM_USER14 |
User 14 |
|
User 14 |
Boolean |
CM_USER15 |
User 15 |
|
User 15 |
Boolean |
CM_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
CM_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
CM_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
CM_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
CM_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
CM_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
CM_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
CM_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
CM_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
CM_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
CM_USER21 |
User 21 |
50x |
User 21 |
String |
CM_USER22 |
User 22 |
50x |
User 22 |
String |
CM_USER23 |
User 23 |
50x |
User 23 |
String |
CM_USER24 |
User 24 |
50x |
User 24 |
String |
CM_USER25 |
User 25 |
50x |
User 25 |
String |
CM_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
CM_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
CM_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
CM_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
CM_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
CM_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
CM_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
CM_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
CM_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
CM_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
CM_USER36 |
User 36 |
|
User 36 |
Boolean |
CM_USER37 |
User 37 |
|
User 37 |
Boolean |
CM_USER38 |
User 38 |
|
User 38 |
Boolean |
CM_USER39 |
User 39 |
|
User 39 |
Boolean |
CM_USER40 |
User 40 |
|
User 40 |
Boolean |
CM_VAR_CD |
Variable Speed |
nnn |
Variable Speed |
Integer |
CM_VAR_TY |
Variable Speed Text |
25x |
Variable Speed Text |
Text |
CM_VENDOR |
Vendor |
30x |
Vendor |
Text |
CM_VLT_MTR |
Volts |
nnnn.nn |
Volts |
Double |
CM_WO_COMM |
WO Comment |
255x |
Short WO Comment |
Text |