SWFOGR

Sewer FOG Receiving Station

Field Name

Caption

Mask

Description

Field Type

RV_ACTIVE

Active Rec Station

 

Active Facility

Boolean

RV_ADDR1

Address 1

50x

Address 1

Text

RV_ADDR2

Address 2

50x

Address 2

Text

RV_ADDR3

Address 3

50x

Address 3

Text

RV_COUN_CD

County

nnn

County

Integer

RV_COUN_TY

County Text

30x

County Text

Text

RV_CRT_BY

Created By

25x

Created By

Text

RV_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

RV_DOC_FLG

Document Available

 

Document Flag

Boolean

RV_EPD

EPD Permit #

50x

EPD Approval/Permit Number

Text

RV_ID

Rec Station Record No

nnnnnnnn

Facilities Record #

Long Integer

RV_INMAP

In Map?

 

Flag indicating this feature is in the map

Boolean

RV_IPP

Indus PreTreat Permit #

50x

Industrial Pretreatment Permit Number

Text

RV_LAS

LAS #

50x

LAS Number

Text

RV_LOCATE

General Location

100x

General Location

Text

RV_MOD_BY

Last Modified By

25x

Last Modified By

Text

RV_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

RV_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

RV_NAME

Rec Station Name

50x

Facility Name

Text

RV_NPDES

NPDES #

50x

NPDES Number

Text

RV_NUMBER

Rec Station Number

30x

Facility Number

Text

RV_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

RV_STYPE_CD

Subtype

nnn

GIS Subtype Code

Integer

RV_STYPE_TY

Subtype Text

25x

GIS Subtype Text

Text

RV_SWHAND

Solid Waste Handling #

50x

Solid Waste Handling Number

Text

RV_USER10

User 10

30x

User 10

Text

RV_USER11

User 11

nnnnnnnn.nn

User 11

Double

RV_USER12

User 12

nnnnnnnn.nn

User 12

Double

RV_USER13

User 13

nnnnnnnn.nn

User 13

Double

RV_USER14

User 14

nnnnnnnn.nn

User 14

Double

RV_USER15

User 15

nnnnnnnn.nn

User 15

Double

RV_USER16

User 16

mm/dd/yyyy

User 16

Date/Time

RV_USER17

User 17

mm/dd/yyyy

User 17

Date/Time

RV_USER18

User 18

mm/dd/yyyy

User 18

Date/Time

RV_USER19

User 19

mm/dd/yyyy

User 19

Date/Time

RV_USER1CD

User 1

nnn

User 1

Integer

RV_USER1TY

User 1 Text

30x

User 1 Text

Text

RV_USER20

User 20

mm/dd/yyyy

User 20

Date/Time

RV_USER21

User 21

 

User 21

Boolean

RV_USER22

User 22

 

User 22

Boolean

RV_USER23

User 23

 

User 23

Boolean

RV_USER24

User 24

 

User 24

Boolean

RV_USER25

User 25

 

User 25

Boolean

RV_USER2CD

User 2

nnn

User 2

Integer

RV_USER2TY

User 2 Text

30x

User 2 Text

Text

RV_USER3CD

User 3

nnn

User 3

Integer

RV_USER3TY

User 3 Text

30x

User 3 Text

Text

RV_USER4CD

User 4

nnn

User 4

Integer

RV_USER4TY

User 4 Text

30x

User 4 Text

Text

RV_USER5CD

User 5

nnn

User 5

Integer

RV_USER5TY

User 5 Text

30x

User 5 Text

Text

RV_USER6

User 6

30x

User 6

Text

RV_USER7

User 7

30x

User 7

Text

RV_USER8

User 8

30x

User 8

Text

RV_USER9

User 9

30x

User 9

Text

RV_X

X Coordinate

-nnnnnnnnn.nnnnnnnn

X Coordinate

Double

RV_Y

Y Coordinate

-nnnnnnnnn.nnnnnnnn

Y Coordinate

Double

RV_Z

Elevation

nnnnnnnnn.nn

Elevation

Double