SWSLOT

Pump Slots

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

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 SWPUMPS.PM_PUMPID

Long Integer

SL_PNUM

Pump Number

30x

Active Pump Number

Text

SL_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

SL_SN_ID

Pump Station Rec #

nnnnnnnn

Link to SWSTATN.SN_ID

Long Integer

SL_STAT_CD

Status

nnn

Status

Integer

SL_STAT_TY

Status Text

25x

Status Text

Text