SMQADF

Storm Water Quality Annual Drainage Facility Summary

Field Name

Caption

Mask

Description

Field Type

AD_CRT_BY

Created By

25x

Created By

String

AD_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

AD_DBC

Debris & Detention Basins Cleaned (%)

nnnnnnnn.nn

Debris & Detention Basins Cleaned (%)

Double

AD_DBCF

Debris & Detention Basins Cleaning Frequency (times/year)

nnnnnnnn.nn

Debris & Detention Basins Cleaning Frequency (times/year)

Double

AD_DBD

Debris & Detention Basins Debris Collected (cy)

nnnnnnnn.nn

Debris & Detention Basins Debris Collected (cy)

Double

AD_DBI

Debris & Detention Basins Total Inventory (ft)

nnnnnnnn.nn

Debris & Detention Basins Total Inventory (ft)

Double

AD_DBINSP

Debris & Detention Basins Inspected (%)

nnnnnnnn.nn

Debris & Detention Basins Inspected (%)

Double

AD_DBINSPF

Debris & Detention Basins Inspection Frequency (times/year)

nnnnnnnn.nn

Debris & Detention Basins Inspection Frequency (times/year)

Double

AD_DIC

Drain Inlets Cleaned (%)

nnnnnnnn.nn

Drain Inlets Cleaned (%)

Double

AD_DICF

Drain Inlets Cleaning Frequency (times/year)

nnnnnnnn.nn

Drain Inlets Cleaning Frequency (times/year)

Double

AD_DID

Drain Inlets Debris Collected (cy)

nnnnnnnn.nn

Drain Inlets Debris Collected (cy)

Double

AD_DII

Drain Inlets Total Inventory (ft)

nnnnnnnn.nn

Drain Inlets Total Inventory (ft)

Double

AD_DIINSP

Drain Inlets Inspected (%)

nnnnnnnn.nn

Drain Inlets Inspected (%)

Double

AD_DIINSPF

Drain Inlets Inspection Frequency (times/year)

nnnnnnnn.nn

Drain Inlets Inspection Frequency (times/year)

Double

AD_DOC_FLG

Document Flag

 

Document Flag

Boolean

AD_ID

Water Quality Drainage Facility Record Number

nnnnnnnn

Water Quality Drainage Facility Record Number

Long Integer

AD_LT

Debris Characterization - Litter/Trash

nnnnnnnn.nn

Debris Characterization - Litter/Trash

Double

AD_MOD_BY

Last Modified By

25x

Last Modified By

String

AD_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

AD_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

AD_OCC

Open Channel Cleaned (%)

nnnnnnnn.nn

Open Channel Cleaned (%)

Double

AD_OCCF

Open Channel Cleaning Frequency (times/year)

nnnnnnnn.nn

Open Channel Cleaning Frequency (times/year)

Double

AD_OCD

Open Channel Debris Collected (cy)

nnnnnnnn.nn

Open Channel Debris Collected (cy)

Double

AD_OCI

Open Channel Total Inventory (ft)

nnnnnnnn.nn

Open Channel Total Inventory (ft)

Double

AD_OCINSP

Open Channel Inspected (%)

nnnnnnnn.nn

Open Channel Inspected (%)

Double

AD_OCINSPF

Open Channel Inspection Frequency (times/year)

nnnnnnnn.nn

Open Channel Inspection Frequency (times/year)

Double

AD_OM

Debris Characterization - Organic Mater

nnnnnnnn.nn

Debris Characterization - Organic Mater

Double

AD_OTM

Debris Characterization - Other Materials

nnnnnnnn.nn

Debris Characterization - Other Materials

Double

AD_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

AD_SCOMMENT

Short Comment

250x

Short Comment

String

AD_SED

Debris Characterization - Sediment

nnnnnnnn.nn

Debris Characterization - Sediment

Double

AD_UDC

Underground Drains Cleaned (%)

nnnnnnnn.nn

Underground Drains Cleaned (%)

Double

AD_UDCF

Underground Drains Cleaning Frequency (times/year)

nnnnnnnn.nn

Underground Drains Cleaning Frequency (times/year)

Double

AD_UDD

Underground Debris Collected (cy)

nnnnnnnn.nn

Underground Debris Collected (cy)

Double

AD_UDI

Underground Drains Total Inventory (ft)

nnnnnnnn.nn

Underground Drains Total Inventory (ft)

Double

AD_UDINSP

Underground Drains Inspected (%)

nnnnnnnn.nn

Underground Drains Inspected (%)

Double

AD_UDINSPF

Underground Drains Inspection Frequency (times/year)

nnnnnnnn.nn

Underground Drains Inspection Frequency (times/year)

Double

AD_USER1CD

User 1

nnn

User 1

Integer

AD_USER1TY

User 1 Text

50x

User 1 Text

String

AD_USER2CD

User 2

nnn

User 2

Integer

AD_USER2TY

User 2 Text

50x

User 2 Text

String

AD_USER3CD

User 3

nnn

User 3

Integer

AD_USER3TY

User 3 Text

50x

User 3 Text

String

AD_USER4CD

User 4

nnn

User 4

Integer

AD_USER4TY

User 4 Text

50x

User 4 Text

String

AD_USER5CD

User 5

nnn

User 5

Integer

AD_USER5TY

User 5 Text

50x

User 5 Text

String

AD_USER6

User 6

50x

User 6

String

AD_USER7

User 7

50x

User 7

String

AD_USER8

User 8

50x

User 8

String

AD_USER9

User 9

50x

User 9

String

AD_USER10

User 10

50x

User 10

String

AD_USER11

User 11

nnnnnnnn.nn

User 11

Double

AD_USER12

User 12

nnnnnnnn.nn

User 12

Double

AD_USER13

User 13

nnnnnnnn.nn

User 13

Double

AD_USER14

User 14

nnnnnnnn.nn

User 14

Double

AD_USER15

User 15

nnnnnnnn.nn

User 15

Double

AD_USER16

User 16

mm/dd/yyyy hh:mm am

User 16

DateTime

AD_USER17

User 17

mm/dd/yyyy hh:mm am

User 17

DateTime

AD_USER18

User 18

mm/dd/yyyy hh:mm am

User 18

DateTime

AD_USER19

User 19

mm/dd/yyyy hh:mm am

User 19

DateTime

AD_USER20

User 20

mm/dd/yyyy hh:mm am

User 20

DateTime

AD_USER21

User 21

 

User 21

Boolean

AD_USER22

User 22

 

User 22

Boolean

AD_USER23

User 23

 

User 23

Boolean

AD_USER24

User 24

 

User 24

Boolean

AD_USER25

User 25

 

User 25

Boolean

AD_YEAR

Year

nnn

Year

Integer