Raw Pump Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
RX_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
RX_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
RX_BFRQ_CD |
Billing Freq |
nnn |
Billing Freq: |
Integer |
RX_BFRQ_TY |
Billing Freq. Text |
25x |
Billing Freq Text: |
Text |
RX_BOOK |
Book Value |
nnnnnnnn.nn |
Book Value |
Double |
RX_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
RX_BR_TY |
Default WO Cat Text |
60x |
Default Category Text |
Text |
RX_CAPCITY |
Pump Capacity |
nnnnnnnnn |
Pump Capacity |
Long Integer |
RX_CFRQ_CD |
Contract Freq. |
nnn |
Contract Freq |
Integer |
RX_CFRQ_TY |
Contract Freq. Text |
25x |
Contract Freq Text |
Text |
RX_CLSS_CD |
Pump Classification |
nnn |
Pump Classification |
Integer |
RX_CLSS_TY |
Pump Class Text |
25x |
Pump Class Text |
Text |
RX_CNDM_CD |
Motor Condition |
nnn |
Motor Condition |
Integer |
RX_CNDM_TY |
Motor Condition Text |
25x |
Motor Condition Text |
Text |
RX_CNDP_CD |
Pump Condition |
nnn |
Pump Condition |
Integer |
RX_CNDP_TY |
Pump Condition Text |
25x |
Pump Condition Text |
Text |
RX_CNDS_CD |
Seal Condition |
nnn |
Seal Condition |
Integer |
RX_CNDS_TY |
Seal Condition Text |
25x |
Seal Condition Text |
Text |
RX_CNTL_CD |
Pump Controller |
nnn |
Pump Controller |
Integer |
RX_CNTL_TY |
Pump Controller Text |
25x |
Pump Controller Text |
Text |
RX_COF |
Consequence of Failure |
nnnn.nn |
Consequence of Failure |
Double |
RX_CON_CST |
Contract Cost |
nnnnnnnn.nn |
Contract Cost: |
Double |
RX_CRT_BY |
Created By |
25x |
Created By |
Text |
RX_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
RX_CUR_DT |
Current Date |
mm/dd/yyyy |
Current Date |
Date/Time |
RX_CURHR |
Current Hourmeter |
nnnnnnnn.n |
Current Hourmeter |
Double |
RX_CUROTH |
Current Other Meter |
nnnnnnnn.n |
Current Other Meter |
Double |
RX_DEP_AMT |
Dep. Amount |
nnnnnnnn.nn |
Depreciation Amount |
Double |
RX_DEP_DT |
Dep. Date |
mm/dd/yyyy |
Depreciation Date |
Date/Time |
RX_DOC_FLG |
Document Available |
|
Doc Available |
Boolean |
RX_DSC_DIA |
DS End Dia (in) |
nnnn.nn |
DS End Diameter (in) |
Double |
RX_DSCH_CD |
DS End Type |
nnn |
DS End Type |
Integer |
RX_DSCH_TY |
DS End Type Text |
25x |
DS End Type Text |
Text |
RX_DSCL_EL |
DS CL Elevation (ft) |
-nnnnn.nn |
DS CL Elevation (ft) |
Double |
RX_DYNM_HD |
TDH (ft) |
nnnnn.nn |
TDH (ft) |
Double |
RX_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
RX_H1_HIGH |
High H 1 (ft) |
nnnnn.nn |
High H 1 (ft) |
Double |
RX_H1_LOW |
Low H 1 (ft) |
nnnnn.nn |
Low H 1 (ft) |
Double |
RX_H2_HIGH |
High H 2 (ft) |
nnnnn.nn |
High H 2 (ft) |
Double |
RX_H2_LOW |
Low H 2 (ft) |
nnnnn.nn |
Low H 2 (ft) |
Double |
RX_H3_HIGH |
High H 3 (ft) |
nnnnn.nn |
High H 3 (ft) |
Double |
RX_H3_LOW |
Low H 3 (ft) |
nnnnn.nn |
Low H 3 (ft) |
Double |
RX_H4_HIGH |
High H 4 (ft) |
nnnnn.nn |
High H 4 (ft) |
Double |
RX_H4_LOW |
Low H 4 (ft) |
nnnnn.nn |
Low H 4 (ft) |
Double |
RX_H5_HIGH |
High H 5 (ft) |
nnnnn.nn |
High H 5 (ft) |
Double |
RX_H5_LOW |
Low H 5 (ft) |
nnnnn.nn |
Low H 5 (ft) |
Double |
RX_H6_HIGH |
High H 6 (ft) |
nnnnn.nn |
High H 6 (ft) |
Double |
RX_H6_LOW |
Low H 6 (ft) |
nnnnn.nn |
Low H 6 (ft) |
Double |
RX_HIGH_SP |
High Speed (rpm) |
nnnnn |
High Speed (rpm) |
Integer |
RX_HORSPWR |
Motor Horsepower |
nnnnn.nn |
Motor Horsepower |
Double |
RX_ID |
Pump Rec # |
nnnnnnnn |
Raw Water Pump Record Number |
Long Integer |
RX_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Integer |
RX_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Integer |
RX_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
String |
RX_IMP_DIA |
Impeller Dia (in) |
nnnn.nn |
Impeller Dia (in) |
Double |
RX_IMP_MOD |
Impeller Model No |
25x |
Impeller Model Number |
Text |
RX_INS_EXP |
Ins. Expires |
mm/dd/yyyy |
Expires |
Date/Time |
RX_INSCOCD |
Insurance Co. |
nnn |
Insurance Co. |
Integer |
RX_INSCOTY |
Insurance Co. Text |
25x |
Insurance Co. Text |
Text |
RX_INSP_DT |
Date Inspected |
mm/dd/yyyy |
Date Inspected |
Date/Time |
RX_INST_BY |
Installed By |
30x |
Installed By |
Text |
RX_INST_DT |
Pump Installed |
mm/dd/yyyy |
Date Installed |
Date/Time |
RX_LOCATE |
General Location |
100x |
Location |
Text |
RX_LOK_RTR |
Lock Rotor Amps |
nnnn.nn |
Lock Rotor Amps |
Double |
RX_LOW_SP |
Low Speed (rpm) |
nnnnn |
Low Speed (rpm) |
Integer |
RX_LR_ID |
Pump Slot Rec # |
nnnnnnnn |
Long Integer |
|
RX_LR_NO |
Slot Number |
10x |
Slot Number |
Text |
RX_LUB_CD |
Lubrication Type |
nnn |
Lubrication Type |
Integer |
RX_LUB_TY |
Lubrication Type Txt |
25x |
Lubrication Type Txt |
Text |
RX_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
RX_MAX_DT |
Service Life |
nnnn.nnn |
Maximum Years |
Double |
RX_MFRAME |
Motor Frame |
30x |
Motor Frame |
Text |
RX_MINS_DT |
Motor Installed |
mm/dd/yyyy |
Date Motor Installed |
Date/Time |
RX_MITIGAT |
Mitigation |
nnnnnnnn.nn |
Mitigation |
Double |
RX_MLOC_CD |
Motor Installation |
nnn |
Motor Installation |
Integer |
RX_MLOC_TY |
Motor Inst Text |
25x |
Motor Inst Text |
Text |
RX_MMDL_NO |
Motor Model No |
25x |
Motor Model Num Text |
Text |
RX_MMFG_CD |
Motor Manuf |
nnn |
Motor Manufacturer |
Integer |
RX_MMFG_TY |
Motor Mfg Text |
25x |
Motor Mfg Text |
Text |
RX_MNMT_DT |
Next Motor Insp |
mm/dd/yyyy |
Next Motor Insp |
Date/Time |
RX_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
RX_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
RX_MOD_TM |
Last Modified Time |
hh:mm am |
Last Modified Time |
Date/Time |
RX_MTR_EFF |
Motor Efficiency |
nnn.nn |
Motor Efficiency |
Double |
RX_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
RX_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
RX_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
RX_NUMBER |
Pump Number |
30x |
Pump Number |
Text |
RX_PHAS_CD |
Electrical Phase |
nnn |
Electrical Phase |
Integer |
RX_PHAS_TY |
Electrical Phase Txt |
25x |
Electrical Phase Txt |
Text |
RX_PLATE1 |
Plate 1 |
30x |
Plate 1 |
Text |
RX_PLATE10 |
Plate 10 |
30x |
Plate 10 |
Text |
RX_PLATE11 |
Plate 11 |
30x |
Plate 11 |
Text |
RX_PLATE12 |
Plate 12 |
30x |
Plate 12 |
Text |
RX_PLATE13 |
Plate 13 |
30x |
Plate 13 |
Text |
RX_PLATE14 |
Plate 14 |
30x |
Plate 14 |
Text |
RX_PLATE15 |
Plate 15 |
30x |
Plate 15 |
Text |
RX_PLATE16 |
Plate 16 |
30x |
Plate 16 |
Text |
RX_PLATE17 |
Plate 17 |
30x |
Plate 17 |
Text |
RX_PLATE18 |
Plate 18 |
30x |
Plate 18 |
Text |
RX_PLATE19 |
Plate 19 |
30x |
Plate 19 |
Text |
RX_PLATE2 |
Plate 2 |
30x |
Plate 2 |
Text |
RX_PLATE20 |
Plate 20 |
30x |
Plate 20 |
Text |
RX_PLATE3 |
Plate 3 |
30x |
Plate 3 |
Text |
RX_PLATE4 |
Plate 4 |
30x |
Plate 4 |
Text |
RX_PLATE5 |
Plate 5 |
30x |
Plate 5 |
Text |
RX_PLATE6 |
Plate 6 |
30x |
Plate 6 |
Text |
RX_PLATE7 |
Plate 7 |
30x |
Plate 7 |
Text |
RX_PLATE8 |
Plate 8 |
30x |
Plate 8 |
Text |
RX_PLATE9 |
Plate 9 |
30x |
Plate 9 |
Text |
RX_PMDL_NO |
Pump Model No |
25x |
Pump Model Numb Text |
Text |
RX_PMFG_CD |
Pump Manufacturer |
nnn |
Pump Manufacturer |
Integer |
RX_PMFG_TY |
Pump Mfg Text |
25x |
Pump Mfg Text |
Text |
RX_PMP_SZ |
Pump Size |
25x |
Pump Size |
Text |
RX_PNMT_DT |
Next Pump Insp |
mm/dd/yyyy |
Next Pump Insp |
Date/Time |
RX_PO |
Purchase Order |
30x |
Purchase Order |
Text |
RX_POF |
Probability of Failure |
nnn.nn |
Probability of Failure |
Double |
RX_PRIM_CD |
Priming Type |
nnn |
Priming Type |
Integer |
RX_PRIM_TY |
Priming Type Text |
25x |
Priming Type Text |
Text |
RX_PRJ_NO |
Project Number |
25x |
Project Number |
Text |
RX_PUR_DT |
Purchase Date |
mm/dd/yyyy |
Purchase Date: |
Date/Time |
RX_PURCOST |
Purchase Amount |
nnnnnnnn.nn |
Purchase Cost: |
Double |
RX_PVALUE |
Present Value |
nnnnnnnnn.nn |
Present Value |
Double |
RX_Q1_HIGH |
High Q 1 (gpm) |
nnnnn.nn |
High Q 1 (gpm) |
Double |
RX_Q1_LOW |
Low Q 1 (gpm) |
nnnnn.nn |
Low Q 1 (gpm) |
Double |
RX_Q2_HIGH |
High Q 2 (gpm) |
nnnnn.nn |
High Q 2 (gpm) |
Double |
RX_Q2_LOW |
Low Q 2 (gpm) |
nnnnn.nn |
Low Q 2 (gpm) |
Double |
RX_Q3_HIGH |
High Q 3 (gpm) |
nnnnn.nn |
High Q 3 (gpm) |
Double |
RX_Q3_LOW |
Low Q 3 (gpm) |
nnnnn.nn |
Low Q 3 (gpm) |
Double |
RX_Q4_HIGH |
High Q 4 (gpm) |
nnnnn.nn |
High Q 4 (gpm) |
Double |
RX_Q4_LOW |
Low Q 4 (gpm) |
nnnnn.nn |
Low Q 4 (gpm) |
Double |
RX_Q5_HIGH |
High Q 5 (gpm) |
nnnnn.nn |
High Q 5 (gpm) |
Double |
RX_Q5_LOW |
Low Q 5 (gpm) |
nnnnn.nn |
Low Q 5 (gpm) |
Double |
RX_Q6_HIGH |
High Q 6 (gpm) |
nnnnn.nn |
High Q 6 (gpm) |
Double |
RX_Q6_LOW |
Low Q 6 (gpm) |
nnnnn.nn |
Low Q 6 (gpm) |
Double |
RX_RCOST |
Replacement Cost |
nnnnn.nn |
Replacement Cost |
Double |
RX_RECEIVE |
Received Date |
mm/dd/yyyy |
Received Date: |
Date/Time |
RX_RENTED |
Rented? |
|
Rented? |
Boolean |
RX_REP_CST |
Replace Cost |
nnnnnnnn.nn |
Replacement Cost |
Double |
RX_REP_DT |
Replace Date |
mm/dd/yyyy |
Replacement Date |
Date/Time |
RX_REPL_DT |
Replacement Date |
mm/dd/yyyy |
Replacement Date |
Date/Time |
RX_RFX_CST |
Fixed Rate |
nnnnnnnn.nn |
Fixed Rental Rate |
Double |
RX_RHR_CST |
Hourly Rate |
nnnnnnnn.nn |
Hourly Rental Rate |
Double |
RX_RISK |
Risk |
nnnn.nn |
Risk - COF * POF |
Double |
RX_RLIFE |
Remaining Life |
nnnn.nn |
Remaining Life |
Double |
RX_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
RX_RPM_MTR |
Motor RPM |
nnnnn |
Motor RPM |
Long Integer |
RX_RS_ID |
Pump Station Rec # |
nnnnnnnn |
Long Integer |
|
RX_RS_NAME |
Station Name |
30x |
Pump Station Name |
Text |
RX_RS_NUMB |
Station Number |
30x |
Pump Station ID: |
Text |
RX_RVALUE |
Replacement Value |
nnnnnnnnn.nn |
Replacement Value |
Double |
RX_SALVAGE |
Salvage Value |
nnnnnnnn.nn |
Salvage Value |
Double |
RX_SBY_CD |
Standby Power |
nnn |
Standby Power |
Integer |
RX_SBY_TY |
Standby Power Text |
25x |
Standby Power Text |
Text |
RX_SEAL_DT |
Seal Installed |
mm/dd/yyyy |
Date Seal Installed |
Date/Time |
RX_SHT_OFH |
Shutoff Head H (ft) |
nnnnn.nn |
Shutoff Head H (ft) |
Double |
RX_SHT_OFL |
Shutoff Head L (ft) |
nnnnn.nn |
Shutoff Head L (ft) |
Double |
RX_SMDL_NO |
Seal Model No |
25x |
Seal Model Num Text |
Text |
RX_SMFG_CD |
Seal Manufacturer |
nnn |
Seal Manufacturer |
Integer |
RX_SMFG_TY |
Seal Mfg Text |
25x |
Seal Mfg Text |
Text |
RX_SNMT_DT |
Next Seal Insp |
mm/dd/yyyy |
Next Seal Insp |
Date/Time |
RX_SRL_MTR |
Motor Serial No |
25x |
Motor Serial Number |
Text |
RX_SRL_PMP |
Pump Serial No |
25x |
Pump Serial Number |
Text |
RX_SRL_SEL |
Seal Serial No |
25x |
Seal Serial Number |
Text |
RX_STAGES |
Number of Stages |
nnn |
Number of Stages |
Integer |
RX_STAT_CD |
Status |
nnn |
Status |
Integer |
RX_STAT_TY |
Status Text |
25x |
Status Text |
Text |
RX_STRT_CD |
Starter Type |
nnn |
Starter Type |
Integer |
RX_STRT_TY |
Starter Type Text |
25x |
Starter Type Text |
Text |
RX_SUC_DIA |
SS End Dia (in) |
nnnn.nn |
SS End Diameter (in) |
Double |
RX_SUCD_CD |
SS End Type |
nnn |
SS End Type |
Integer |
RX_SUCD_TY |
SS End Type Text |
25x |
SS End Type Text |
Text |
RX_SUCL_EL |
SS CL Elevation (ft) |
-nnnnn.nn |
SS CL Elevation (ft) |
Double |
RX_TSEL_CD |
Seal Type |
nnn |
Seal Type |
Integer |
RX_TSEL_TY |
Seal Type Text |
25x |
Seal Type Text |
Text |
RX_TYPE_CD |
Pump Type |
nnn |
Pump Type |
Integer |
RX_TYPE_TY |
Pump Type Text |
25x |
Pump Type Text |
Text |
RX_USEHRS |
Usable Hrs/Yr |
nnnn |
Usable Hrs/Yr |
Integer |
RX_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
RX_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
RX_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
RX_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
RX_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
RX_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
RX_USER4 |
User 4 |
30x |
User 4 |
Text |
RX_USER5 |
User 5 |
30x |
User 5 |
Text |
RX_USER6 |
User 6 |
30x |
User 6 |
Text |
RX_USER7 |
User 7 |
-nnnnnnnnn.nn |
User 7 |
Double |
RX_USER8 |
User 8 |
-nnnnnnnnn.nn |
User 8 |
Double |
RX_USER9 |
User 9 |
-nnnnnnnnn.nn |
User 9 |
Double |
RX_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
RX_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
RX_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
RX_USER13 |
User 13 |
|
User 13 |
Boolean |
RX_USER14 |
User 14 |
|
User 14 |
Boolean |
RX_USER15 |
User 15 |
|
User 15 |
Boolean |
RX_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
RX_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
RX_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
RX_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
RX_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
RX_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
RX_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
RX_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
RX_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
RX_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
RX_USER21 |
User 21 |
50x |
User 21 |
String |
RX_USER22 |
User 22 |
50x |
User 22 |
String |
RX_USER23 |
User 23 |
50x |
User 23 |
String |
RX_USER24 |
User 24 |
50x |
User 24 |
String |
RX_USER25 |
User 25 |
50x |
User 25 |
String |
RX_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
RX_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
RX_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
RX_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
RX_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
RX_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
RX_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
RX_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
RX_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
RX_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
RX_USER36 |
User 36 |
|
User 36 |
Boolean |
RX_USER37 |
User 37 |
|
User 37 |
Boolean |
RX_USER38 |
User 38 |
|
User 38 |
Boolean |
RX_USER39 |
User 39 |
|
User 39 |
Boolean |
RX_USER40 |
User 40 |
|
User 40 |
Boolean |
RX_VAR_CD |
Variable Speed |
nnn |
Variable Speed |
Integer |
RX_VAR_TY |
Variable Speed Text |
25x |
Variable Speed Text |
Text |
RX_VENDOR |
Vendor |
30x |
Vendor |
Text |
RX_VLT_MTR |
Volts |
nnnn.nn |
Volts |
Double |
RX_WO_COMM |
WO Comment |
255x |
Short WO Comment |
Text |