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 |