SMPUMPS

Pump Inventory

Field Name

Caption

Mask

Description

Field Type

PM_ACL_CD

Asset Class

25x

Asset Class

String

PM_ACL_TY

Asset Class Text

60x

Asset Class Text

String

PM_ALRMELEV

Alarm Elev

nnnnn.nn

Pump Alarm Elevation

Double

PM_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

PM_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

PM_BFRQ_CD

Billing Freq

nnn

Billing Freq:

Integer

PM_BFRQ_TY

Billing Freq. Text

25x

Billing Freq Text:

Text

PM_BOOK

Book Value

nnnnnnnn.nn

Book Value

Double

PM_BR_CD

Default WO Cat

10x

Default Category Code

Text

PM_BR_TY

Default WO Cat Text

60x

Default Category Text

Text

PM_CAPCITY

Capacity

nnnnnn.nn

Pump Capacity

Double

PM_CFR_CD

Cleaning Freq Units

nnn

Cleaning Freq Units

Integer

PM_CFR_TY

Cleaning Freq Units Tex

10x

Cleaning Freq Units Tex

Text

PM_CFREQ

Cleaning Freq

nnn

Cleaning Freq

Integer

PM_CFRQ_CD

Contract Freq.

nnn

Contract Freq

Integer

PM_CFRQ_TY

Contract Freq. Text

25x

Contract Freq Text

Text

PM_CLSS_CD

Classification

nnn

Pump Classification Code

Integer

PM_CLSS_TY

Classification Text

25x

Pump Classification Text

Text

PM_CNDM_CD

Motor Condition

nnn

Motor Condition

Integer

PM_CNDM_TY

Motor Condition Text

25x

Motor Condition Text

Text

PM_CNDP_CD

Pump Condition

nnn

Pump Condition

Integer

PM_CNDP_TY

Pump Condition Text

25x

Pump Condition Text

Text

PM_CNDS_CD

Seal Condition

nnn

Seal Condition

Integer

PM_CNDS_TY

Seal Condition Text

25x

Seal Condition Text

Text

PM_CNTL_CD

Pump Controller

nnn

Pump Controller Type Code

Integer

PM_CNTL_TY

Pump Controller Text

25x

Pump Controller Type Text

Text

PM_CO_ID

 

 

Link to SMCOMMENT

Long Integer

PM_COF

Consequence of Failure

nnnn.

Consequence of Failure

Double

PM_COMMENT1

Long Note

 

Long Note

Memo

PM_CON_CST

Contract Cost

nnnnnnnn.nn

Contract Cost:

Double

PM_CRT_BY

Created By

25x

Created By

Text

PM_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

PM_CUR_DT

Current Date

mm/dd/yyyy

Current Date

Date/Time

PM_CURHR

Current Hourmeter

nnnnnnnn.n

Current Hourmeter

Double

PM_CUROTH

Current Other Meter

nnnnnnnn.n

Current Other Meter

Double

PM_DEP_AMT

Dep. Amount

nnnnnnnn.nn

Depreciation Amount

Double

PM_DEP_DT

Dep. Date

mm/dd/yyyy

Depreciation Date

Date/Time

PM_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

PM_DSC_DIA

DS End Dia (in)

nnnn.nn

Discharge Diameter (in)

Double

PM_DSCH_CD

DS End Type

nnn

Discharge End Type Code

Integer

PM_DSCH_TY

DS End Type Text

25x

Discharge End Type Text

Text

PM_DSCL_EL

DS CL Elev (ft)

nnnn.nn

Discharge Elevation (ft)

Double

PM_DYNM_HD

TDH (ft)

nnnnn.nn

Total Dynamic Head (ft)

Double

PM_FASSET

Fixed Asset ID

nnnnnnnn

Fixed Asset ID

Long Integer

PM_H1_HIGH

High H 1 (ft)

nnnn.nn

High Speed Head 1 (ft)

Double

PM_H1_LOW

Low H 1 (ft)

nnnn.nn

Low Speed Head 1 (ft)

Double

PM_H2_HIGH

High H 2 (ft)

nnnn.nn

High Speed Head 2 (ft)

Double

PM_H2_LOW

Low H 2 (ft)

nnnn.nn

Low Speed Head 2 (ft)

Double

PM_H3_HIGH

High H 3 (ft)

nnnn.nn

High Speed Head 3 (ft)

Double

PM_H3_LOW

Low H 3 (ft)

nnnn.nn

Low Speed Head 3 (ft)

Double

PM_H4_HIGH

High H 4 (ft)

nnnn.nn

High Speed Head 4 (ft)

Double

PM_H4_LOW

Low H 4 (ft)

nnnn.nn

Low Speed Head 4 (ft)

Double

PM_H5_HIGH

High H 5 (ft)

nnnn.nn

High Speed Head 5 (ft)

Double

PM_H5_LOW

Low H 5 (ft)

nnnn.nn

Low Speed Head 5 (ft)

Double

PM_H6_HIGH

High H 6 (ft)

nnnn.nn

High Speed Head 6 (ft)

Double

PM_H6_LOW

Low H 6 (ft)

nnnn.nn

Low Speed Head 6 (ft)

Double

PM_HIGH_SP

High Speed (rpm)

nnnn

High Speed (rpm)

Integer

PM_HORSPWR

Horsepower

nnnn.nn

Motor Horsepower

Double

PM_ID

Pump Rec #

nnnnnnnn

Unique ID

Long Integer

PM_IFREQ

Inspection Freq

nnn

Inspection Freq

Integer

PM_IFRQ_CD

Inspection Freq Units

nnn

Inspection Freq Units

Integer

PM_IFRQ_TY

Inspection Freq Units Text

10x

Inspection Freq Units Text

String

PM_IMG_FLG

 

 

Image Available

Boolean

PM_IMP_DIA

Impeller Dia (in)

nnn.nn

Impeller Diameter (in)

Double

PM_IMP_MOD

Impeller Model #

25x

Impeller Model Number

Text

PM_INMAP

In Map?

 

Not Used

Boolean

PM_INS_EXP

Ins. Expires

mm/dd/yyyy

Expires

Date/Time

PM_INS_MTR

Motor Installed

mm/dd/yyyy

Date Motor installed

Date/Time

PM_INSCOCD

Insurance Co.

nnn

Insurance Co.

Integer

PM_INSCOTY

Insurance Co. Text

25x

Insurance Co. Text

Text

PM_INSP_DT

Date Inspected

mm/dd/yyyy

Inspection Date

Date/Time

PM_INST_BY

Installed By

30x

Installed By

Text

PM_INST_DT

Pump Installed

mm/dd/yyyy

Date Pump installed

Date/Time

PM_LCLN_DT

Last Cleaning Date

mm/dd/yyyy

Last Cleaning Date

Date/Time

PM_LOCATE

Pump Location

100x

Pump Location

Text

PM_LOK_RTR

Lock Rotor Amps

nnnn

Lock Rotor Amps

Long Integer

PM_LOW_SP

Low Speed (rpm)

nnnn

Low Speed (rpm)

Integer

PM_LUB_CD

Lubrication Type

nnn

Seal Lubrication Type Code

Integer

PM_LUB_TY

Lubrication Type Txt

25x

Seal Lubrication Type Text

Text

PM_LWOT_DT

Last WO Task Date

mm/dd/yyyy

Last WO Task Date

DateTime

PM_MAX_DT

Service Life

nnnn.nnn

Maximum Years

Double

PM_MITIGAT

Mitigation

nnnnnnnn.nn

Mitigation

Double

PM_MLOC_CD

Motor Installation

nnn

Motor Installation Code

Integer

PM_MLOC_TY

Motor Inst Text

25x

Motor Installation Text

Text

PM_MMDL_NO

Motor Model #

25x

Motor Model Number

Text

PM_MMFG_CD

Motor Mfg

nnn

Motor Manufacturer Code

Integer

PM_MMFG_TY

Motor Mfg Text

25x

Motor Manufacturer Text

Text

PM_MNXT

Next Motor Insp

mm/dd/yyyy

Next Motor Insp

Date/Time

PM_MOD_BY

Last Modified By

25x

Modified By

Text

PM_MOD_DT

Last Modified Date

mm/dd/yyyy

Modified Date

Date/Time

PM_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

PM_MOV_FLG

 

 

Movie Available

Boolean

PM_MTR_EFF

Motor Efficiency

nnn.nn

Motor Efficiency

Double

PM_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

PM_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

PM_NCLN_DT

Next Cleaning Date

mm/dd/yyyy

Next Cleaning Date

Date/Time

PM_NOWORK

No WO/PM/Req

 

No WO/PM/Req

Boolean

PM_NUMBER

Pump Number

30x

Pump Number

Text

PM_OFFELEV

Off Elevation

nnnnn.nn

Pump Off Elevation

Double

PM_ONELEV

On Elevation

nnnnn.nn

Pump On Elevation

Double

PM_PARENTOFFLINE

Parent Off-Line Flag

 

Parent Off-Line Flag

Boolean

PM_PHAS_CD

Electrical Phase

nnn

Electrical Phase Code

Integer

PM_PHAS_TY

Electrical Phase Txt

25x

Electrical Phase Text

Text

PM_PLATE1

Plate 1

30x

Plate 1

Text

PM_PLATE10

Plate 10

30x

Plate 10

Text

PM_PLATE11

Plate 11

30x

Plate 11

Text

PM_PLATE12

Plate 12

30x

Plate 12

Text

PM_PLATE13

Plate 13

30x

Plate 13

Text

PM_PLATE14

Plate 14

30x

Plate 14

Text

PM_PLATE15

Plate 15

30x

Plate 15

Text

PM_PLATE16

Plate 16

30x

Plate 16

Text

PM_PLATE17

Plate 17

30x

Plate 17

Text

PM_PLATE18

Plate 18

30x

Plate 18

Text

PM_PLATE19

Plate 19

30x

Plate 19

Text

PM_PLATE2

Plate 2

30x

Plate 2

Text

PM_PLATE20

Plate 20

30x

Plate 20

Text

PM_PLATE3

Plate 3

30x

Plate 3

Text

PM_PLATE4

Plate 4

30x

Plate 4

Text

PM_PLATE5

Plate 5

30x

Plate 5

Text

PM_PLATE6

Plate 6

30x

Plate 6

Text

PM_PLATE7

Plate 7

30x

Plate 7

Text

PM_PLATE8

Plate 8

30x

Plate 8

Text

PM_PLATE9

Plate 9

30x

Plate 9

Text

PM_PMDL_NO

Pump Model #

25x

Pump Model Number

Text

PM_PMFG_CD

Pump Mfg

nnn

Pump Manufacturer Code

Integer

PM_PMFG_TY

Pump Mfg Text

25x

Pump Manufacturer Text

Text

PM_PMP_SZ

Pump Size

25x

Pump Size

Text

PM_PN_ID

Station Rec #

nnnnnnnn

Link to SMSTATN.PN_ID

Long Integer

PM_PN_NAME

Station Name

30x

Pump Station Name

Text

PM_PN_NUMB

Station Number

30x

Pump Station Number

Text

PM_PNXT

Next Pump Insp

mm/dd/yyyy

Next Pump Insp

Date/Time

PM_PO

Purchase Order

30x

Purchase Order

Text

PM_POF

Probability of Failure

nnn.nn

Probability of Failure

Double

PM_PRE952_CD

Pre 952 Status

 

Pre 952 Status

Small Integer

PM_PRE952_TY

Pre 952 Status Text

25x

Pre 952 Status Text

String

PM_PRIM_CD

Priming Type

nnn

Pump Priming Type Code

Integer

PM_PRIM_TY

Priming Type Text

25x

Pump Priming Type Text

Text

PM_PRJ_NO

Project Number

25x

Project Number

Text

PM_PUR_DT

Purchase Date

mm/dd/yyyy

Purchase Date:

Date/Time

PM_PURCOST

Purchase Amount

nnnnnnnn.nn

Purchase Cost:

Double

PM_PVALUE

Present Value

nnnnnnnnn.nn

Present Value

Double

PM_Q1_HIGH

High Q 1 (gpm)

nnnn.nn

High Speed Flow Rate 1 (gpm)

Double

PM_Q1_LOW

Low Q 1 (gpm)

nnnn.nn

Low Speed Flow Rate 1 (gpm)

Double

PM_Q2_HIGH

High Q 2 (gpm)

nnnn.nn

High Speed Flow Rate 2 (gpm)

Double

PM_Q2_LOW

Low Q 2 (gpm)

nnnn.nn

Low Speed Flow Rate 2 (gpm)

Double

PM_Q3_HIGH

High Q 3 (gpm)

nnnn.nn

High Speed Flow Rate 3 (gpm)

Double

PM_Q3_LOW

Low Q 3 (gpm)

nnnn.nn

Low Speed Flow Rate 3 (gpm)

Double

PM_Q4_HIGH

High Q 4 (gpm)

nnnn.nn

High Speed Flow Rate 4 (gpm)

Double

PM_Q4_LOW

Low Q 4 (gpm)

nnnn.nn

Low Speed Flow Rate 4 (gpm)

Double

PM_Q5_HIGH

High Q 5 (gpm)

nnnn.nn

High Speed Flow Rate 5 (gpm)

Double

PM_Q5_LOW

Low Q 5 (gpm)

nnnn.nn

Low Speed Flow Rate 5 (gpm)

Double

PM_Q6_HIGH

High Q 6 (gpm)

nnnn.nn

High Speed Flow Rate 6 (gpm)

Double

PM_Q6_LOW

Low Q 6 (gpm)

nnnn.nn

Low Speed Flow Rate 6 (gpm)

Double

PM_RCOST

Replacement Cost

nnnnn.nn

Replacement Cost

Double

PM_RECEIVE

Received Date

mm/dd/yyyy

Received Date:

Date/Time

PM_RENTED

Rented?

 

Rented?

Boolean

PM_REP_CST

Replace Cost

nnnnnnnn.nn

Replacement Cost

Double

PM_REP_DT

Replace Date

mm/dd/yyyy

Replacement Date

Date/Time

PM_REPL_DT

Replacement Date

mm/dd/yyyy

Replacement Date

Date/Time

PM_RFX_CST

Fixed Rate

nnnnnnnn.nn

Fixed Rental Rate

Double

PM_RHR_CST

Hourly Rate

nnnnnnnn.nn

Hourly Rental Rate

Double

PM_RISK

Risk

nnnn.

Risk - COF * POF

Double

PM_RLIFE

Remaining Life

nnnn.nn

Remaining Life

Double

PM_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

PM_RPM_MTR

Motor RPM

nnnn

Motor RPM

Long Integer

PM_RVALUE

Replacement Value

nnnnnnnnn.nn

Replacement Value

Double

PM_SALVAGE

Salvage Value

nnnnnnnn.nn

Salvage Value

Double

PM_SBY_CD

Standby Power

nnn

Standby Power Code

Integer

PM_SBY_TY

Standby Power Text

25x

Standby Power Text

Text

PM_SEAL_DT

Seal Installed

mm/dd/yyyy

Date Seal Installed

Date/Time

PM_SHT_OFH

Shutoff Head H (ft)

nnnn.nn

High Speed Shutoff Head (ft) (Field currently not used)

Double

PM_SHT_OFL

Shutoff Head L (ft)

nnnn.nn

Low Speed Shutoff Head (ft)

Double

PM_SL_ID

Pump Slot Rec #

nnnnnnnn

Link to SMSLOT.SL_ID

Long Integer

PM_SL_NO

Slot Number

10x

Slot Number

Text

PM_SMDL_NO

Seal Model #

25x

Seal Model Number

Text

PM_SMFG_CD

Seal Mfg

nnn

Seal Manufacturer Code

Integer

PM_SMFG_TY

Seal Mfg Text

25x

Seal Manufacturer Text

Text

PM_SNXT

Next Seal Insp

mm/dd/yyyy

Next Seal Insp

Date/Time

PM_SRL_MTR

Motor Serial #

25x

Motor Serial Number

Text

PM_SRL_PMP

Pump Serial #

25x

Pump Serial Number

Text

PM_SRL_SEL

Seal Serial #

25x

Seal Serial Number

Text

PM_STAGES

Number of Stages

nn

Number of Stages

Long Integer

PM_STAT_CD

Status

nnn

Pump Status

Integer

PM_STAT_TY

Status Text

25x

Pump Status Text

Text

PM_STRT_CD

Starter Type

nnn

Starter Type Code

Integer

PM_STRT_TY

Starter Type Text

25x

Starter Type Text

Text

PM_STYPE_CD

GIS Subtype

nnn

GIS Subtype Code

Integer

PM_STYPE_TY

GIS SubType Text

25x

GIS Subtype Text

Text

PM_SUC_DIA

SS End Dia (in)

nnnn.nn

Suction End Diameter (in)

Double

PM_SUCD_CD

SS End Type

nnn

Suction End Type Code

Integer

PM_SUCD_TY

SS End Type Text

25x

Suction End Type Text

Text

PM_SUCL_EL

SS CL Elev (ft)

nnnn.nn

Suction End Elevation (ft)

Double

PM_TSEL_CD

Seal Type

nnn

Seal Type Code

Integer

PM_TSEL_TY

Seal Type Text

25x

Seal Type Text

Text

PM_TYPE_CD

Pump Type

nnn

Pump Type Code

Integer

PM_TYPE_TY

Pump Type Text

25x

Pump Type Text

Text

PM_USEHRS

Usable Hrs/Yr

nnnn

Usable Hrs/Yr

Integer

PM_USER1CD

User 1

nnn

User 1

Integer

PM_USER1TY

User 1 Text

25x

User 1 Text

Text

PM_USER2CD

User 2

nnn

User 2

Integer

PM_USER2TY

User 2 Text

25x

User 2 Text

Text

PM_USER3CD

User 3

nnn

User 3

Integer

PM_USER3TY

User 3 Text

25x

User 3 Text

Text

PM_USER4

User 4

30x

User 4

Text

PM_USER5

User 5

30x

User 5

Text

PM_USER6

User 6

30x

User 6

Text

PM_USER7

User 7

nnnnnnnnn.nn

User 7

Double

PM_USER8

User 8

nnnnnnnnn.nn

User 8

Double

PM_USER9

User 9

nnnnnnnnn.nn

User 9

Double

PM_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

PM_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

PM_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

PM_USER13

User 13

 

User 13

Boolean

PM_USER14

User 14

 

User 14

Boolean

PM_USER15

User 15

 

User 15

Boolean

PM_USER16CD

User 16

nnn

User 16

Integer

PM_USER16TY

User 16 Text

50x

User 16 Text

String

PM_USER17CD

User 17

nnn

User 17

Integer

PM_USER17TY

User 17 Text

50x

User 17 Text

String

PM_USER18CD

User 18

nnn

User 18

Integer

PM_USER18TY

User 18 Text

50x

User 18 Text

String

PM_USER19CD

User 19

nnn

User 19

Integer

PM_USER19TY

User 19 Text

50x

User 19 Text

String

PM_USER20CD

User 20

nnn

User 20

Integer

PM_USER20TY

User 20 Text

50x

User 20 Text

String

PM_USER21

User 21

50x

User 21

String

PM_USER22

User 22

50x

User 22

String

PM_USER23

User 23

50x

User 23

String

PM_USER24

User 24

50x

User 24

String

PM_USER25

User 25

50x

User 25

String

PM_USER26

User 26

nnnnnnnn.nn

User 26

Double

PM_USER27

User 27

nnnnnnnn.nn

User 27

Double

PM_USER28

User 28

nnnnnnnn.nn

User 28

Double

PM_USER29

User 29

nnnnnnnn.nn

User 29

Double

PM_USER30

User 30

nnnnnnnn.nn

User 30

Double

PM_USER31

User 31

mm/dd/yyyy hh:mm am

User 31

DateTime

PM_USER32

User 32

mm/dd/yyyy hh:mm am

User 32

DateTime

PM_USER33

User 33

mm/dd/yyyy hh:mm am

User 33

DateTime

PM_USER34

User 34

mm/dd/yyyy hh:mm am

User 34

DateTime

PM_USER35

User 35

mm/dd/yyyy hh:mm am

User 35

DateTime

PM_USER36

User 36

 

User 36

Boolean

PM_USER37

User 37

 

User 37

Boolean

PM_USER38

User 38

 

User 38

Boolean

PM_USER39

User 39

 

User 39

Boolean

PM_USER40

User 40

 

User 40

Boolean

PM_USER41CD

User 41

10x

User 41

String

PM_USER41TY

User 41 Text

60x

User 41 Text

String

PM_USER42CD

User 42

10x

User 42

String

PM_USER42TY

User 42 Text

60x

User 42 Text

String

PM_USER43CD

User 43

10x

User 43

String

PM_USER43TY

User 43 Text

60x

User 43 Text

String

PM_USER44CD

User 44

10x

User 44

String

PM_USER44TY

User 44 Text

60x

User 44 Text

String

PM_USER45CD

User 45

10x

User 45

String

PM_USER45TY

User 45 Text

60x

User 45 Text

String

PM_VAR_CD

Variable Speed

nnn

Variable Speed Code

Integer

PM_VAR_TY

Variable Speed Text

25x

Variable Speed Text

Text

PM_VENDOR

Vendor

30x

Vendor

Text

PM_VLT_MTR

Volts

nnnn

Motor Voltage

Long Integer

PM_WO_COMM

WO Comment

255x

This short comment gets copied to work orders

Text