SWBLDGSUMP

Field Name

Caption

Mask

Description

Field Type

BB_BLDGID

Building Rec #

Link to SWBLDG.BD_BLDGID

Long Integer

BB_COMMENT1

Long Note

Long Note

Memo

BB_CRT_BY

Created By

25x

Created By

Text

BB_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

BB_DOC_FLG

Document Available

Document Available

Boolean

BB_DPNT_CD

Discharge Point

nnn

Discharge Point Code

Integer

BB_DPNT_TY

Discharge Point Text

25x

Discharge Point Text

Text

BB_DRNB_CD

Drains Basement

nnn

Drains Basement Code

Integer

BB_DRNB_TY

Drains Basement Text

25x

Drains Basement Text

Text

BB_DRNL_CD

Drains Laundry

nnn

Drains Laundry Code

Integer

BB_DRNL_TY

Drains Laundry Text

25x

Drains Laundry Text

Text

BB_DVLV_CD

Diverter Valve

nnn

Diverter Valve Code

Integer

BB_DVLV_TY

Diverter Valve Text

25x

Diverter Value Text

Text

BB_FNDC_CD

Foundation Conn

nnn

Foundation Connection Code

Integer

BB_FNDC_TY

Fndation Conn Text

25x

Foundation Connection Text

Text

BB_GPM

Flow Rate (gpm)

nnn.nn

Flow Rate (gpm)

Double

BB_GPM_REM

Remaining GPM

nnnn.nn

Remaining GPM

Double

BB_ID

Auto Number

nnnnnnnn

AutoID

Long Integer

BB_IMG_FLG

Image Available

Boolean

BB_MOD_BY

Modified By

25x

Modified By

Text

BB_MOD_DT

Modified Date

mm/dd/yyyy

Modified Date

Date/Time

BB_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

BB_MOV_FLG

Movie Available

Boolean

BB_PACT_CD

Pump Active

nnn

Pump Active Code

Integer

BB_PACT_TY

Pump Active Text

25x

Pump Active Text

Text

BB_PER_REM

% I/I Removed

nnn

% I/I Removed

Integer

BB_PXST_CD

Pump Exists

nnn

Pump Exists Code

Integer

BB_PXST_TY

Pump Exists Text

25x

Pump Exists Text

Text

BB_ROWVER

Rowversion for optimistic locking

Date/Time

BB_SCND_CD

Sump Pit Cond

nnn

Sump Pit Condition Code

Integer

BB_SCND_TY

Sump Pit Cond Text

25x

Sump Pit Condition Text

Text

BB_SDRN_CD

Sump Pit Drain

nnn

Sump Pit Drain Code

Integer

BB_SDRN_TY

Sump Pit Drain Text

25x

Sump Pit Drain Text

Text

BB_SSEL_CD

Sump Pit Sealed

nnn

Sump Pit Sealed Code

Integer

BB_SSEL_TY

Sump Pit Sealed Text

25x

Sump Pit Sealed Text

Text

BB_STAT_CD

Sump Status

nnn

Sump Status Code

Integer

BB_STAT_TY

Sump Status

25x

Sump Status Text

Text

BB_STYP_CD

Sump Pit Type

nnn

Sump Pit Type Code

Integer

BB_STYP_TY

Sump Pit Type Text

25x

Sump Pit Type Text

Text

BB_SUMP_NO

Sump #

nn

Sump #

Integer

BB_USER1

User 1

nnnnnnnnn.nn

User 1

Double

BB_USER2

User 2

30x

User 2

Text

Target Table

Target Field

Linking Field

Purpose

SWBLDG

BD_BLDGID

BB_BLDGID

Links the a sump record to the building inspection.