SMSLOT

Pump Slot

Field Name

Caption

Mask

Description

Field Type

SL_ALRMELEV

Pump Alarm Elev

-nnnnn.nn

Pump Alarm Elevation

Double

SL_CRT_BY

Created By

25x

Created By

Text

SL_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

SL_ID

Pump Slot Rec #

 

AutoID

Long Integer

SL_LOCATE

Location

100x

General Location

Text

SL_MOD_BY

Last Modified By

25x

Modified By:

Text

SL_MOD_DT

Last Modified Date

mm/dd/yyyy

Date Modified:

Date/Time

SL_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

SL_NUMBER

Slot Number

10x

Slot Number

Text

SL_OFFELEV

Pump Off Elev

-nnnnn.nn

Pump Off Elevation

Double

SL_ONELEV

Pump On Elev

-nnnnn.nn

Pump On Elevation

Double

SL_PM_ID

Pump Rec #

nnnnnnnn

Link to SMPUMPS.PM_ID

Long Integer

SL_PN_ID

Pump Station Rec #

nnnnnnnn

Link to SMSTATN.PN_ID

Long Integer

SL_PNUM

Pump Number

30x

Active Pump Number

Text

SL_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

SL_SCADAT

SCADA Tag

30x

SCADA Tag

String

SL_STAT_CD

Status

nnn

Status

Integer

SL_STAT_TY

Status Text

25x

Status Text

Text

SL_TSR

Total Slot Reading

nnnnnnnn.nn

Total Slot Reading

Double