Storm Water Quality Industrial Inspection
Field Name |
Caption |
Mask |
Description |
Field Type |
UI_ACNRI |
Check to calculate date from last inspection (12 months for high, 24 months for medium and 60 months for low (based on WQ Prioritization)) |
|
Check to calculate date from last inspection (12 months for high, 24 months for medium and 60 months for low (based on WQ Prioritization)) |
Boolean |
UI_BMPIOSA |
Are BMPs implemented in outdoor storage areas |
|
Are BMPs implemented in outdoor storage areas |
Boolean |
UI_BMPIOSAN |
If BMPs are not implemented in outdoor storage areas then please describe |
250x |
If BMPs are not implemented in outdoor storage areas then please describe |
String |
UI_BMPIPA |
Are BMPs implemented in outdoor commercial process areas? |
|
Are BMPs implemented in outdoor commercial process areas? |
Boolean |
UI_BMPIPAN |
If BMPs are implemented in outdoor commerical process areas then please describe |
250x |
If BMPs are implemented in outdoor commerical process areas then please describe |
String |
UI_CAN |
Describe Corrective Actions Necessary (if applicable) |
250x |
Describe Corrective Actions Necessary (if applicable) |
String |
UI_CNOTES |
If Complaint or follow-up then describe reason |
250x |
If Complaint or follow-up then describe reason |
String |
UI_CONTACT |
Facility Contact |
50x |
Facility Contact |
String |
UI_CRT_BY |
Created By |
25x |
Created By |
String |
UI_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
UI_CSWPPPOS |
Is there a copy of the Storm Water Pollution Plan (SWPPP) on Site? |
|
Is there a copy of the Storm Water Pollution Plan (SWPPP) on Site? |
Boolean |
UI_DOC_FLG |
Document Flag |
|
Document Flag |
Boolean |
UI_EUD |
Is there evidence of unauthorized non-storm water discharges, past spills, or illicit discharges to the storm drain system? |
|
Is there evidence of unauthorized non-storm water discharges, past spills, or illicit discharges to the storm drain system? |
Boolean |
UI_EUDN |
If there is evidence of unauthorized non-storm water discharges, past spills, or illicit discharges to the storm drain system then please describe |
250x |
If there is evidence of unauthorized non-storm water discharges, past spills, or illicit discharges to the storm drain system then please describe |
String |
UI_FEE |
Agency Fee |
nnnnnnnn.nn |
Agency Fee |
Double |
UI_FUA_DT |
Follow-up Action Date |
mm/dd/yyyy hh:mm am |
Follow-up Action Date |
DateTime |
UI_FUAN |
Is Follow-up Actions Necessary? |
|
Is Follow-up Actions Necessary? |
Boolean |
UI_FUANN |
Describe Follow-up Actions Necessary (if applicable) |
250x |
Describe Follow-up Actions Necessary (if applicable) |
String |
UI_GOBSN |
Additional Observations |
250x |
Additional Observations |
String |
UI_ID |
Industrial Inspection Rec # |
nnnnnnnn |
Autonumber ID |
Long Integer |
UI_IDSC |
Are there indoor drains or sinks connected to the storm drain system? |
|
Are there indoor drains or sinks connected to the storm drain system? |
Boolean |
UI_IDSCN |
If indoor drains or sinks are connected to the storm drain system then please describe |
250x |
If indoor drains or sinks are connected to the storm drain system then please describe |
String |
UI_INSP_CD |
Inspector |
nnn |
Inspector |
Integer |
UI_INSP_DT |
Inspection Date |
mm/dd/yyyy hh:mm am |
Inspection Date |
DateTime |
UI_INSP_TY |
Inspector Text |
50x |
Inspector Text |
String |
UI_INSPE_TM |
Inspection End Time |
mm/dd/yyyy hh:mm am |
Inspection End Time |
DateTime |
UI_INSPS_TM |
Inspection Start Time |
mm/dd/yyyy hh:mm am |
Inspection Start Time |
DateTime |
UI_IPACO |
Are Industrial process activities conducted outdoors? |
|
Are Industrial process activities conducted outdoors? |
Boolean |
UI_IPACON |
If Industrial process activities are conducted outdoors then please describe |
250x |
If Industrial process activities are conducted outdoors then please describe |
String |
UI_LAPM |
Are landscaped areas properly maintained and free of erosion? |
|
Are landscaped areas properly maintained and free of erosion? |
Boolean |
UI_LATEST |
Latest Inspection |
|
Latest Inspection |
Boolean |
UI_LOEA_CD |
Level of Enforcement Action Taken |
10x |
Level of Enforcement Action Taken |
String |
UI_LOEA_TY |
Level of Enforcement Action Taken Text |
60x |
Level of Enforcement Action Taken Text |
String |
UI_MAINTREQ |
Maint Requested |
|
Maint Requested |
Boolean |
UI_MCOS |
Is a mobile wash contractor being used to clean vehicles, equipment or exterior surfaces? |
|
Is a mobile wash contractor being used to clean vehicles, equipment or exterior surfaces? |
Boolean |
UI_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
UI_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
UI_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
UI_MWHA |
Are materials and waste handling adequate |
|
Are materials and waste handling adequate |
Boolean |
UI_MWHAN |
If materials and waste handling are not adequate then please describe |
250x |
If materials and waste handling are not adequate then please describe |
String |
UI_NEEDREP |
Needs WO |
|
Needs WO |
Boolean |
UI_NIF |
Were any deficiencies noted for this inspection? |
|
Were any deficiencies noted for this inspection? |
Boolean |
UI_NIFN |
Note any deficiences noted for this inspection |
250x |
Note any deficiences noted for this inspection |
String |
UI_NINSP_DT |
Next Inspection Date |
mm/dd/yyyy hh:mm am |
Next Inspection Date |
DateTime |
UI_OEAT |
Other enforcement actions taken (if applicable) |
250x |
Other enforcement actions taken (if applicable) |
String |
UI_PAPM |
Are parking areas properly maintained and free of debris and excessive oil? |
|
Are parking areas properly maintained and free of debris and excessive oil? |
Boolean |
UI_PHONE |
Contact Phone |
25x |
Contact Phone |
String |
UI_PHOTO |
Photo Taken |
|
Photo Taken |
Boolean |
UI_PIF |
Is this a follow-up inspection, were previous deficiencies corrected? |
|
Is this a follow-up inspection, were previous deficiencies corrected? |
Boolean |
UI_QI_ID |
Industrial Inventory Rec # |
nnnnnnnn |
Long Integer |
|
UI_RBS |
Risk Based Score |
nnn |
Risk Based Score |
Integer |
UI_ROWVER |
|
|
Rowversion for optimistic locking |
TimeStamp |
UI_RQ_ID |
Request Rec # |
nnnnnnnn |
Long Integer |
|
UI_RWSO |
Are raw materials, products, or wastes that have a potential to impact stormwater quality stored outside? |
|
Are raw materials, products, or wastes that have a potential to impact stormwater quality stored outside? |
Boolean |
UI_RWSON |
If raw materials, products, or wastes that have a potential to impact stormwater quality are stored outside then please describe |
250x |
If raw materials, products, or wastes that have a potential to impact stormwater quality are stored outside then please describe |
String |
UI_SCPIP |
Is there a spill containment plan in place? |
|
Is there a spill containment plan in place? |
Boolean |
UI_SDIOS |
Are there storm drain inlets on-site? |
|
Are there storm drain inlets on-site? |
Boolean |
UI_SDIPM |
Do the storm drain inlets appear to be properly maintained and/or cleaned? |
|
Do the storm drain inlets appear to be properly maintained and/or cleaned? |
Boolean |
UI_SDIPMN |
If the storm drain inlets do not appear to be properly maintained and/or cleaned then please describe |
250x |
If the storm drain inlets do not appear to be properly maintained and/or cleaned then please describe |
String |
UI_SFLW |
Is the site free of litter and liquid waste? |
|
Is the site free of litter and liquid waste? |
Boolean |
UI_SFLWN |
If the site is not free of litter and liquid waste then please describe |
250x |
If the site is not free of litter and liquid waste then please describe |
String |
UI_TYPE_CD |
Inspection Type |
nnn |
Inspection Type |
Integer |
UI_TYPE_TY |
Inspection Type Text |
50x |
Inspection Type Text |
String |
UI_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
UI_USER1TY |
User 1 Text |
50x |
User 1 Text |
String |
UI_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
UI_USER2TY |
User 2 Text |
50x |
User 2 Text |
String |
UI_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
UI_USER3TY |
User 3 Text |
50x |
User 3 Text |
String |
UI_USER4CD |
User 4 |
nnn |
User 4 |
Integer |
UI_USER4TY |
User 4 Text |
50x |
User 4 Text |
String |
UI_USER5CD |
User 5 |
nnn |
User 5 |
Integer |
UI_USER5TY |
User 5 Text |
50x |
User 5 Text |
String |
UI_USER6 |
User 6 |
50x |
User 6 |
String |
UI_USER7 |
User 7 |
50x |
User 7 |
String |
UI_USER8 |
User 8 |
50x |
User 8 |
String |
UI_USER9 |
User 9 |
50x |
User 9 |
String |
UI_USER10 |
User 10 |
50x |
User 10 |
String |
UI_USER11 |
User 11 |
nnnnnnnn.nn |
User 11 |
Double |
UI_USER12 |
User 12 |
nnnnnnnn.nn |
User 12 |
Double |
UI_USER13 |
User 13 |
nnnnnnnn.nn |
User 13 |
Double |
UI_USER14 |
User 14 |
nnnnnnnn.nn |
User 14 |
Double |
UI_USER15 |
User 15 |
nnnnnnnn.nn |
User 15 |
Double |
UI_USER16 |
User 16 |
mm/dd/yyyy hh:mm am |
User 16 |
DateTime |
UI_USER17 |
User 17 |
mm/dd/yyyy hh:mm am |
User 17 |
DateTime |
UI_USER18 |
User 18 |
mm/dd/yyyy hh:mm am |
User 18 |
DateTime |
UI_USER19 |
User 19 |
mm/dd/yyyy hh:mm am |
User 19 |
DateTime |
UI_USER20 |
User 20 |
mm/dd/yyyy hh:mm am |
User 20 |
DateTime |
UI_USER21 |
User 21 |
|
User 21 |
Boolean |
UI_USER22 |
User 22 |
|
User 22 |
Boolean |
UI_USER23 |
User 23 |
|
User 23 |
Boolean |
UI_USER24 |
User 24 |
|
User 24 |
Boolean |
UI_USER25 |
User 25 |
|
User 25 |
Boolean |
UI_USER26CD |
User 26 |
nnn |
User 26 |
Integer |
UI_USER26TY |
User 26 Text |
50x |
User 26 Text |
String |
UI_USER27CD |
User 27 |
nnn |
User 27 |
Integer |
UI_USER27TY |
User 27 Text |
50x |
User 27 Text |
String |
UI_USER28CD |
User 28 |
nnn |
User 28 |
Integer |
UI_USER28TY |
User 28 Text |
50x |
User 28 Text |
String |
UI_USER29CD |
User 29 |
nnn |
User 29 |
Integer |
UI_USER29TY |
User 29 Text |
50x |
User 29 Text |
String |
UI_USER30CD |
User 30 |
nnn |
User 30 |
Integer |
UI_USER30TY |
User 30 Text |
50x |
User 30 Text |
String |
UI_USER31 |
User 31 |
50x |
User 31 |
String |
UI_USER32 |
User 32 |
50x |
User 32 |
String |
UI_USER33 |
User 33 |
50x |
User 33 |
String |
UI_USER34 |
User 34 |
50x |
User 34 |
String |
UI_USER35 |
User 35 |
50x |
User 35 |
String |
UI_USER36 |
User 36 |
nnnnnnnn.nn |
User 36 |
Double |
UI_USER37 |
User 37 |
nnnnnnnn.nn |
User 37 |
Double |
UI_USER38 |
User 38 |
nnnnnnnn.nn |
User 38 |
Double |
UI_USER39 |
User 39 |
nnnnnnnn.nn |
User 39 |
Double |
UI_USER40 |
User 40 |
nnnnnnnn.nn |
User 40 |
Double |
UI_USER41 |
User 41 |
mm/dd/yyyy hh:mm am |
User 41 |
DateTime |
UI_USER42 |
User 42 |
mm/dd/yyyy hh:mm am |
User 42 |
DateTime |
UI_USER43 |
User 43 |
mm/dd/yyyy hh:mm am |
User 43 |
DateTime |
UI_USER44 |
User 44 |
mm/dd/yyyy hh:mm am |
User 44 |
DateTime |
UI_USER45 |
User 45 |
mm/dd/yyyy hh:mm am |
User 45 |
DateTime |
UI_USER46 |
User 46 |
|
User 46 |
Boolean |
UI_USER47 |
User 47 |
|
User 47 |
Boolean |
UI_USER48 |
User 48 |
|
User 48 |
Boolean |
UI_USER49 |
User 49 |
|
User 49 |
Boolean |
UI_USER50 |
User 50 |
|
User 50 |
Boolean |
UI_VBMP |
Are vehicle or equipment repair/maintenance BMPs being implemented? |
|
Are vehicle or equipment repair/maintenance BMPs being implemented? |
Boolean |
UI_VBMPN |
If vehicle or equipment repair/maintenance BMPs not being implemented then please describe |
250x |
If vehicle or equipment repair/maintenance BMPs not being implemented then please describe |
String |
UI_VCBMP |
Are vehicle, equipment, and exterior surface cleaning BMPs being implemented? |
|
Are vehicle, equipment, and exterior surface cleaning BMPs being implemented? |
Boolean |
UI_VCBMPN |
If vehicle, equipment, and exterior surface cleaning BMPs not being implemented then please describe |
250x |
If vehicle, equipment, and exterior surface cleaning BMPs not being implemented then please describe |
String |
UI_VECOS |
Is vehicle, equipment or exterior surface cleaning being performed on site? |
|
Is vehicle, equipment or exterior surface cleaning being performed on site? |
Boolean |
UI_VEROS |
Is vehicle or equipment repair/maintenance performed on site? |
|
Is vehicle or equipment repair/maintenance performed on site? |
Boolean |
UI_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |
|
UI_WQP_CD |
WQ Prioritization |
nnn |
WQ Prioritization |
Integer |
UI_WQP_TY |
WQ Prioritization Text |
50x |
WQ Prioritization Text |
String |
UI_WSP |
Are the contents of waste receptacles protected from contact with stormwater? |
|
Are the contents of waste receptacles protected from contact with stormwater? |
Boolean |
UI_WSPN |
If the contents of waste receptacles are not protected from contact with stormwater then please describe |
250x |
If the contents of waste receptacles are not protected from contact with stormwater then please describe |
String |