SWIPTFM

Sewer IPT Facility Monitoring Points

Field Name

Caption

Mask

Description

Field Type

MF_BR_CD

Default WO Cat

10x

Default Category Code

Text

MF_BR_TY

Default WO Cat Text

60x

Default Category Code

Text

MF_CRT_BY

Created By

25x

Created By

Text

MF_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

MF_DESC

General Description

254x

General Description

Text

MF_DOC_FLG

Document Available

 

Document Flag

Boolean

MF_HE_CD

Has Electricity

nnn

Has Electricity

Integer

MF_HE_TY

Has Electricity Text

30x

Has Electricity Text

Text

MF_ID

IPT Monitoring Pnt Rec #

nnnnnnnn

IPT Monitoring Points Record Number

Long Integer

MF_IF_ID

IPT Facility Rec #

nnnnnnnn

Link to SWIPTF.IF_ID

Long Integer

MF_INMAP

In Map?

 

Flag indicating this feature is in the map

Boolean

MF_ISSD_DT

Date Issued

mm/dd/yyyy

Date Issued

Date/Time

MF_LWOT_DT

Last WO Task Date

mm/dd/yyyy

Last WO Task Date

DateTime

MF_MD_CD

Measure Device

nnn

Measure Device

Integer

MF_MD_TY

Measure Device Text

30x

Measure Device Text

Text

MF_MOD_BY

Last Mod By

25x

Last Modified By

Text

MF_MOD_DT

Last Mod Date

mm/dd/yyyy

Last Modified Date

Date/Time

MF_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

MF_NAME

Monitoring Point

40x

Monitoring Point

Text

MF_NOTES

Sampling Notes

254x

Sampling Notes

Text

MF_NOWORK

No WO/PM/Req

 

No WO/PM/Req

Boolean

MF_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

MF_SAFE

Safety

254x

Safety

Text

MF_STYPE_CD

Subtype

nnn

GIS Subtype Code

Integer

MF_STYPE_TY

Subtype Text

25x

GIS Subtype Text

Text

MF_TS_CD

Treatment System

nnn

Treatment System

Integer

MF_TS_TY

Treatment System Text

30x

Treatment System Text

Text

MF_USER1CD

User 1

nnn

User 1

Integer

MF_USER1TY

User 1 Text

30x

User 1 Text

Text

MF_USER2CD

User 2

nnn

User 2

Integer

MF_USER2TY

User 2 Text

30x

User 2 Text

Text

MF_USER3CD

User 3

nnn

User 3

Integer

MF_USER3TY

User 3 Text

30x

User 3 Text

Text

MF_USER4CD

User 4

nnn

User 4

Integer

MF_USER4TY

User 4 Text

30x

User 4 Text

Text

MF_USER5CD

User 5

nnn

User 5

Integer

MF_USER5TY

User 5 Text

30x

User 5 Text

Text

MF_USER6

User 6

30x

User 6

Text

MF_USER7

User 7

30x

User 7

Text

MF_USER8

User 8

30x

User 8

Text

MF_USER9

User 9

30x

User 9

Text

MF_USER10

User 10

30x

User 10

Text

MF_USER11

User 11

nnnnnnnn.nn

User 11

Double

MF_USER12

User 12

nnnnnnnn.nn

User 12

Double

MF_USER13

User 13

nnnnnnnn.nn

User 13

Double

MF_USER14

User 14

nnnnnnnn.nn

User 14

Double

MF_USER15

User 15

nnnnnnnn.nn

User 15

Double

MF_USER16

User 16

mm/dd/yyyy

User 16

Date/Time

MF_USER17

User 17

mm/dd/yyyy

User 17

Date/Time

MF_USER18

User 18

mm/dd/yyyy

User 18

Date/Time

MF_USER19

User 19

mm/dd/yyyy

User 19

Date/Time

MF_USER20

User 20

mm/dd/yyyy

User 20

Date/Time

MF_USER21

User 21

 

User 21

Boolean

MF_USER22

User 22

 

User 22

Boolean

MF_USER23

User 23

 

User 23

Boolean

MF_USER24

User 24

 

User 24

Boolean

MF_USER25

User 25

 

User 25

Boolean

MF_USER26CD

User 26

10x

User 26

String

MF_USER26TY

User 26 Text

60x

User 26 Text

String

MF_USER27CD

User 27

10x

User 27

String

MF_USER27TY

User 27 Text

60x

User 27 Text

String

MF_USER28CD

User 28

10x

User 28

String

MF_USER28TY

User 28 Text

60x

User 28 Text

String

MF_USER29CD

User 29

10x

User 29

String

MF_USER29TY

User 29 Text

60x

User 29 Text

String

MF_USER30CD

User 30

10x

User 30

String

MF_USER30TY

User 30 Text

60x

User 30 Text

String

MF_WWT_CD

Wastewater Type

nnn

Wastewater Type

Integer

MF_WWT_TY

Wastewater Type Text

30x

Wastewater Type Text

Text

MF_X

X Coordinate

-nnnnnnnnn.nnnnnnnn

X Coordinate

Double

MF_Y

Y Coordinate

-nnnnnnnnn.nnnnnnnn

Y Coordinate

Double

MF_Z

Elevation

nnnnnnnnn.nn

Elevation

Double