SMQF

Storm Water Quality Management Plan Inventory

Field Name

Caption

Mask

Description

Field Type

QF_303DP

303D Pollutants

250x

303D Pollutants

String

QF_ACT_DT

Active Date

mm/dd/yyyy hh:mm am

Active Date

DateTime

QF_ACTIVE

Active Project

 

Active Project

Boolean

QF_ADR_B2

Street Post Building No

8x

Street Post Building No

String

QF_ADR_B22

Street 2 Post Building No

8x

Street 2 Post Building No

String

QF_ADR_BDG

Address

nnnnnnnn

Address

Long Integer

QF_ADR_DIR

Street Direction

2x

Street Direction

String

QF_ADR_PT

Street Prefix

5x

Street Prefix

String

QF_ADR_SFX

Street Suffix

5x

Street Suffix

String

QF_ADR_STR

Street Name

50x

Street Name

String

QF_ADR_TY

Street Type

5x

Street Type

String

QF_ADR2_PT

Street 2 Prefix Type

5x

Street 2 Prefix Type

String

QF_ADRBDG2

Address 2

nnnnnnnn

Address 2

Long Integer

QF_ADRDIR2

Street Direction 2

2x

Street Direction 2

String

QF_ADRSFX2

Street Suffix 2

5x

Street Suffix 2

String

QF_ADRSTR2

Street Name 2

50x

Street Name 2

String

QF_ADRTY2

Street Type 2

5x

Street Type 2

String

QF_APN

APN

40x

APN

String

QF_APT_NO

Apt Number

25x

Apt Number

String

QF_AUNT1_CD

Area Units 1

nnn

Area Units 1

Integer

QF_AUNT1_TY

Area Units 1 Text

10x

Area Units 1 Text

String

QF_AUNT2_CD

Area Units 2

nnn

Area Units 2

Integer

QF_AUNT2_TY

Area Units 2 Text

10x

Area Units 2 Text

String

QF_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

QF_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

QF_BADDR1

BMP Address 1

50x

BMP Address 1

String

QF_BADDR2

BMP Address 2

50x

BMP Address 2

String

QF_BCITY

BMP City

30x

BMP City

String

QF_BEMAIL

BMP Email

150x

BMP Email

String

QF_BFAX

BMP Fax

25x

BMP Fax

String

QF_BMPM

BMP Manager

50x

BMP Manager

String

QF_BMPNOTE

BMP Notes

250x

BMP Notes

String

QF_BNAME

BMP Name

50x

BMP Name

String

QF_BPHONE

BMP Phone

25x

BMP Phone

String

QF_BPOSTAL

BMP Zip Code

15x

BMP Zip Code

String

QF_BR_CD

Default Category Code

10x

Default Category Code

String

QF_BR_TY

Default Category Code

60x

Default Category Code

String

QF_BSTATE

BMP State

30x

BMP State

String

QF_CITY

City

30x

City

String

QF_CNOT_CD

Notification

nnn

Notification

Integer

QF_CNOT_DT

Notification Date

mm/dd/yyyy hh:mm am

Notification Date

DateTime

QF_CNOT_TY

Notification Text

50x

Notification Text

String

QF_CONDNO

Condition Numbers

250x

Condition Numbers

String

QF_CRT_BY

Created By

25x

Created By

String

QF_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

QF_CSTREET

Cross Street

50x

Cross Street

String

QF_DESC

Description

250x

Description

String

QF_DFIRW

Distance from Immediate Receiving Water

nnnnnnnn.nn

Distance from Immediate Receiving Water

Double

QF_DOC_FLG

Document Flag

 

Document Flag

Boolean

QF_DRW303DL

Are Downstream Receiving Waters 303D Listed?

 

Are Downstream Receiving Waters 303D Listed?

Boolean

QF_DT_CD

Development Type

10x

Development Type

String

QF_DT_TY

Development Type Text

60x

Development Type Text

String

QF_DUNITS

Dwelling Units

nnn

Dwelling Units

Integer

QF_DUNT_CD

Distance Units

nnn

Distance Units

Integer

QF_DUNT_TY

Distance Units Text

10x

Distance Units Text

String

QF_FA_DT

Final Approval Date

mm/dd/yyyy hh:mm am

Final Approval Date

DateTime

QF_FLLW_DT

Follow-up Date

mm/dd/yyyy hh:mm am

Follow-up Date

DateTime

QF_ID

Water Quality Management Plan Record No

nnnnnnnn

Water Quality Management Plan Record No

Long Integer

QF_IFREQ

Inspection Freq

nnn

Inspection Freq

Integer

QF_IFRQ_CD

Inspection Freq Units

nnn

Inspection Freq Units

Integer

QF_IFRQ_TY

Inspection Freq Units Text

10x

Inspection Freq Units Text

String

QF_INAC_DT

Inactive Date

mm/dd/yyyy hh:mm am

Inactive Date

DateTime

QF_INMAP

Flag indicating this feature is in the map

 

Flag indicating this feature is in the map

Boolean

QF_IROADS

Does Project include Roads?

 

Does Project include Roads?

Boolean

QF_IRW303DL

Is Immediate Receiving Waters 303D Listed?

 

Is Immediate Receiving Waters 303D Listed?

Boolean

QF_IWAIVER

Includes Waivers?

 

Includes Waivers?

Boolean

QF_LADDR1

Location Address 1

50x

Location Address 1

String

QF_LADDR2

Location Address 2

50x

Location Address 2

String

QF_LANDUSE

Land Use Type

100x

Land Use Type

String

QF_LATLONG_X

Latlong X

nnnnnnnn.nn

Latlong X

Double

QF_LATLONG_Y

Latlong Y

nnnnnnnn.nn

Latlong Y

Double

QF_LCITY

Location City

30x

Location City

String

QF_LINS_DT

Last Inspection Date

mm/dd/yyyy hh:mm am

Last Inspection Date

DateTime

QF_LINS_TM

Last Inspection Time

mm/dd/yyyy hh:mm am

Last Inspection Time

DateTime

QF_LOCATE

General Location

100x

General Location

String

QF_LPOSTAL

Location Zip Code

15x

Location Zip Code

String

QF_LSTATE

Location State

30x

Location State

String

QF_LWOT_DT

Last WO Task Date

mm/dd/yyyy

Last WO Task Date

DateTime

QF_MAR

Maintaintenance Agreement Recorded

 

Maintaintenance Agreement Recorded

Boolean

QF_METE

Pollutants of Concern - Metals - Expected

 

Pollutants of Concern - Metals - Expected

Boolean

QF_METNA

Pollutants of Concern - Metals - N/A

 

Pollutants of Concern - Metals - N/A

Boolean

QF_METP

Pollutants of Concern - Metals - Potential

 

Pollutants of Concern - Metals - Potential

Boolean

QF_MOD_BY

Last Modified By

25x

Last Modified By

String

QF_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

QF_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

QF_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

QF_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

QF_NAPE

Pollutants of Concern - Noxious Aquatic Plants - Expected

 

Pollutants of Concern - Noxious Aquatic Plants - Expected

Boolean

QF_NAPNA

Pollutants of Concern - Noxious Aquatic Plants - N/A

 

Pollutants of Concern - Noxious Aquatic Plants - N/A

Boolean

QF_NAPP

Pollutants of Concern - Noxious Aquatic Plants - Potential

 

Pollutants of Concern - Noxious Aquatic Plants - Potential

Boolean

QF_NINS_DT

Next Inspection Date

mm/dd/yyyy hh:mm am

Next Inspection Date

DateTime

QF_NNE

Pollutants of Concern - Nutrients - Nitrogen - Expected

 

Pollutants of Concern - Nutrients - Nitrogen - Expected

Boolean

QF_NNNA

Pollutants of Concern - Nutrients - Nitrogen - N/A

 

Pollutants of Concern - Nutrients - Nitrogen - N/A

Boolean

QF_NNP

Pollutants of Concern - Nutrients - Nitrogen - Potential

 

Pollutants of Concern - Nutrients - Nitrogen - Potential

Boolean

QF_NOWORK

No WO/PM/Req

 

No WO/PM/Req

Boolean

QF_NPE

Pollutants of Concern - Nutrients - Phosphorous - Expected

 

Pollutants of Concern - Nutrients - Phosphorous - Expected

Boolean

QF_NPNA

Pollutants of Concern - Nutrients - Phosphorous - N/A

 

Pollutants of Concern - Nutrients - Phosphorous - N/A

Boolean

QF_NPP

Pollutants of Concern - Nutrients - Phosphorous - Potential

 

Pollutants of Concern - Nutrients - Phosphorous - Potential

Boolean

QF_NUMBER

Water Quality Management Plan ID:  WQMP ID

30x

Water Quality Management Plan ID:  WQMP ID

String

QF_O1E

Pollutants of Concern - Other 1 - Expected

 

Pollutants of Concern - Other 1 - Expected

Boolean

QF_O1P

Pollutants of Concern - Other 1 - Potential

 

Pollutants of Concern - Other 1 - Potential

Boolean

QF_O2E

Pollutants of Concern - Other 2 - Expected

 

Pollutants of Concern - Other 2 - Expected

Boolean

QF_O2P

Pollutants of Concern - Other 2 - Potential

 

Pollutants of Concern - Other 2 - Potential

Boolean

QF_OADDR1

Owner Contact Address 1

50x

Owner Contact Address 1

String

QF_OADDR2

Owner Contact Address 2

50x

Owner Contact Address 2

String

QF_OAGE

Pollutants of Concern - Oil and Grease - Expected

 

Pollutants of Concern - Oil and Grease - Expected

Boolean

QF_OAGNA

Pollutants of Concern - Oil and Grease - N/A

 

Pollutants of Concern - Oil and Grease - N/A

Boolean

QF_OAGP

Pollutants of Concern - Oil and Grease - Potential

 

Pollutants of Concern - Oil and Grease - Potential

Boolean

QF_OCE

Pollutants of Concern - Organic Compounds - Expected

 

Pollutants of Concern - Organic Compounds - Expected

Boolean

QF_OCITY

Owner City

30x

Owner City

String

QF_OCNA

Pollutants of Concern - Organic Compounds - N/A

 

Pollutants of Concern - Organic Compounds - N/A

Boolean

QF_OCP

Pollutants of Concern - Organic Compounds - Potential

 

Pollutants of Concern - Organic Compounds - Potential

Boolean

QF_OEMAIL

Owner Contact Email

150x

Owner Contact Email

String

QF_OFAX

Owner Contact Fax

25x

Owner Contact Fax

String

QF_ONAME

Owner Name

50x

Owner Name

String

QF_OPHONE

Owner Contact Phone

25x

Owner Contact Phone

String

QF_OPOSTAL

Owner Zip Code

15x

Owner Zip Code

String

QF_ORP

Property Owner

50x

Property Owner

String

QF_OSTATE

Owner State

30x

Owner State

String

QF_PAREA

Pervious Area

nnnnnnnn.nn

Pervious Area

Double

QF_PBVE

Pollutants of Concern - Pathogens -  Bacteria/Virus - Expected

 

Pollutants of Concern - Pathogens -  Bacteria/Virus - Expected

Boolean

QF_PBVNA

Pollutants of Concern - Pathogens -  Bacteria/Virus - N/A

 

Pollutants of Concern - Pathogens -  Bacteria/Virus - N/A

Boolean

QF_PBVP

Pollutants of Concern - Pathogens -  Bacteria/Virus - Potential

 

Pollutants of Concern - Pathogens -  Bacteria/Virus - Potential

Boolean

QF_PCOMMENTS

Pollutant Comments

250x

Pollutant Comments

String

QF_PERMITNO

Permit Numbers

250x

Permit Numbers

String

QF_PHASED

Is the Project going to be phased?

 

Is the Project going to be phased?

Boolean

QF_PHE

Pollutants of Concern - Pesticides/Herbicides - Expected

 

Pollutants of Concern - Pesticides/Herbicides - Expected

Boolean

QF_PHNA

Pollutants of Concern - Pesticides/Herbicides - N/A

 

Pollutants of Concern - Pesticides/Herbicides - N/A

Boolean

QF_PHP

Pollutants of Concern - Pesticides/Herbicides - Potential

 

Pollutants of Concern - Pesticides/Herbicides - Potential

Boolean

QF_PMT_CD

Property Manager Type

10x

Property Manager Type

String

QF_PMT_TY

Property Manager Type Text

60x

Property Manager Type Text

String

QF_POSTAL

Zip Code

15x

Zip Code

String

QF_PROJNAME

Project Name

100x

Project Name

String

QF_PROPTAG

Property ID Tag

52x

Property ID Tag

String

QF_RECO_DT

Recorded Date

mm/dd/yyyy hh:mm am

Recorded Date

DateTime

QF_REF

Ref/File Number

30x

Ref/File Number

String

QF_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

QF_RW_CD

Immediate Receiving Water

10x

Immediate Receiving Water

String

QF_RW_TY

Immediate Receiving Water Text

60x

Immediate Receiving Water Text

String

QF_SEDE

Pollutants of Concern - Sediment - Expected

 

Pollutants of Concern - Sediment - Expected

Boolean

QF_SEDNA

Pollutants of Concern - Sediment - N/A

 

Pollutants of Concern - Sediment - N/A

Boolean

QF_SEDP

Pollutants of Concern - Sediment - Potential

 

Pollutants of Concern - Sediment - Potential

Boolean

QF_SRN_CD

SubReach Number

10x

SubReach Number

String

QF_SRN_TY

SubReach Number Text

60x

SubReach Number Text

String

QF_STAT_CD

Status

nnn

Status

Integer

QF_STAT_TY

Status Text

25x

Status Text

String

QF_STATE

State

30x

State

String

QF_STYPE_CD

GIS Subtype Code

nnn

GIS Subtype Code

Integer

QF_STYPE_TY

GIS Subtype Text

25x

GIS Subtype Text

String

QF_TASBS

Tributary to an Area of Speical Biological Significance (ASBS)

 

Tributary to an Area of Speical Biological Significance (ASBS)

Boolean

QF_TDE

Pollutants of Concern - Trash/Debris - Expected

 

Pollutants of Concern - Trash/Debris - Expected

Boolean

QF_TDNA

Pollutants of Concern - Trash/Debris - N/A

 

Pollutants of Concern - Trash/Debris - N/A

Boolean

QF_TDP

Pollutants of Concern - Trash/Debris - Potential

 

Pollutants of Concern - Trash/Debris - Potential

Boolean

QF_TIAREA

Impervious Area

nnnnnnnn.nn

Impervious Area

Double

QF_TNDAREA

Total New Development Area

nnnnnnnn.nn

Total New Development Area

Double

QF_TRDAREA

Total Re-Development Area

nnnnnnnn.nn

Total Re-Development Area

Double

QF_USER1CD

User 1

nnn

User 1

Integer

QF_USER1TY

User 1 Text

50x

User 1 Text

String

QF_USER2CD

User 2

nnn

User 2

Integer

QF_USER2TY

User 2 Text

50x

User 2 Text

String

QF_USER3CD

User 3

nnn

User 3

Integer

QF_USER3TY

User 3 Text

50x

User 3 Text

String

QF_USER4CD

User 4

nnn

User 4

Integer

QF_USER4TY

User 4 Text

50x

User 4 Text

String

QF_USER5CD

User 5

nnn

User 5

Integer

QF_USER5TY

User 5 Text

50x

User 5 Text

String

QF_USER6

User 6

50x

User 6

String

QF_USER7

User 7

50x

User 7

String

QF_USER8

User 8

50x

User 8

String

QF_USER9

User 9

50x

User 9

String

QF_USER10

User 10

50x

User 10

String

QF_USER11

User 11

nnnnnnnn.nn

User 11

Double

QF_USER12

User 12

nnnnnnnn.nn

User 12

Double

QF_USER13

User 13

nnnnnnnn.nn

User 13

Double

QF_USER14

User 14

nnnnnnnn.nn

User 14

Double

QF_USER15

User 15

nnnnnnnn.nn

User 15

Double

QF_USER16

User 16

mm/dd/yyyy hh:mm am

User 16

DateTime

QF_USER17

User 17

mm/dd/yyyy hh:mm am

User 17

DateTime

QF_USER18

User 18

mm/dd/yyyy hh:mm am

User 18

DateTime

QF_USER19

User 19

mm/dd/yyyy hh:mm am

User 19

DateTime

QF_USER20

User 20

mm/dd/yyyy hh:mm am

User 20

DateTime

QF_USER21

User 21

 

User 21

Boolean

QF_USER22

User 22

 

User 22

Boolean

QF_USER23

User 23

 

User 23

Boolean

QF_USER24

User 24

 

User 24

Boolean

QF_USER25

User 25

 

User 25

Boolean

QF_USER26CD

User 26

nnn

User 26

Integer

QF_USER26TY

User 26 Text

50x

User 26 Text

String

QF_USER27CD

User 27

nnn

User 27

Integer

QF_USER27TY

User 27 Text

50x

User 27 Text

String

QF_USER28CD

User 28

nnn

User 28

Integer

QF_USER28TY

User 28 Text

50x

User 28 Text

String

QF_USER29CD

User 29

nnn

User 29

Integer

QF_USER29TY

User 29 Text

50x

User 29 Text

String

QF_USER30CD

User 30

nnn

User 30

Integer

QF_USER30TY

User 30 Text

50x

User 30 Text

String

QF_USER31

User 31

50x

User 31

String

QF_USER32

User 32

50x

User 32

String

QF_USER33

User 33

50x

User 33

String

QF_USER34

User 34

50x

User 34

String

QF_USER35

User 35

50x

User 35

String

QF_USER36

User 36

nnnnnnnn.nn

User 36

Double

QF_USER37

User 37

nnnnnnnn.nn

User 37

Double

QF_USER38

User 38

nnnnnnnn.nn

User 38

Double

QF_USER39

User 39

nnnnnnnn.nn

User 39

Double

QF_USER40

User 40

nnnnnnnn.nn

User 40

Double

QF_USER41

User 41

mm/dd/yyyy hh:mm am

User 41

DateTime

QF_USER42

User 42

mm/dd/yyyy hh:mm am

User 42

DateTime

QF_USER43

User 43

mm/dd/yyyy hh:mm am

User 43

DateTime

QF_USER44

User 44

mm/dd/yyyy hh:mm am

User 44

DateTime

QF_USER45

User 45

mm/dd/yyyy hh:mm am

User 45

DateTime

QF_USER46

User 46

 

User 46

Boolean

QF_USER47

User 47

 

User 47

Boolean

QF_USER48

User 48

 

User 48

Boolean

QF_USER49

User 49

 

User 49

Boolean

QF_USER50

User 50

 

User 50

Boolean

QF_USER51CD

User 51

10x

User 51

String

QF_USER51TY

User 51 Text

60x

User 51 Text

String

QF_USER52CD

User 52

10x

User 52

String

QF_USER52TY

User 52 Text

60x

User 52 Text

String

QF_USER53CD

User 53

10x

User 53

String

QF_USER53TY

User 53 Text

60x

User 53 Text

String

QF_USER54CD

User 54

10x

User 54

String

QF_USER54TY

User 54 Text

60x

User 54 Text

String

QF_USER55CD

User 55

10x

User 55

String

QF_USER55TY

User 55 Text

60x

User 55 Text

String

QF_WDIDNO

WDID Numbers

250x

WDID Numbers

String

QF_WS_CD

Watershed

10x

Watershed

String

QF_WS_TY

Watershed Text

60x

Watershed Text

String

QF_X

X Coordinate

nnnnnnnn.nn

X Coordinate

Double

QF_Y

Y Coordinate

nnnnnnnn.nn

Y Coordinate

Double

QF_Z

Elevation

nnnnnnnn.nn

Elevation

Double