EFPUMPEQ

Link to Pump Inventory

Field Name

Caption

Mask

Description

Field Type

EP_CRT_BY

Created By

25x

Created By

Text

EP_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

EP_GE_ID

Equip Rec #

nnnnnnnn

Link to EFEQUIP.GE_ID

Long Integer

EP_ID

Link Rec #

nnnnnnnn

Unique ID

Long Integer

EP_MOD_BY

Last Modified By

25x

Last Modified By

Text

EP_MOD_DT

Last Modified Date

mm/dd/yyyy

Modification Date

Date/Time

EP_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

EP_PM_CD

Pump

nnn

Pump Module: 1=Water Distribution, 2=Raw Water, 3=Recycled Water, 4=Sewer, 5=Storm

Integer

EP_PM_ID

Pump Rec #

nnnnnnnn

Link to %%PUMPS record

Long Integer

EP_PM_TY

Pump Type

25x

Pump Module Text

Text

EP_ROWVER

 

 

Rowversion for optimistic locking

Date/Time