Storm Water Quality Municipal Inspection
Field Name |
Caption |
Mask |
Description |
Field Type |
LI_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 |
LI_BMPIOSA |
Are BMPs implemented in outdoor storage areas |
|
Are BMPs implemented in outdoor storage areas |
Boolean |
LI_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 |
LI_BMPIPA |
Are BMPs implemented in outdoor commercial process areas? |
|
Are BMPs implemented in outdoor commercial process areas? |
Boolean |
LI_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 |
LI_CAN |
Describe Corrective Actions Necessary (if applicable) |
250x |
Describe Corrective Actions Necessary (if applicable) |
String |
LI_CNOTES |
If Complaint or follow-up then describe reason |
250x |
If Complaint or follow-up then describe reason |
String |
LI_CONTACT |
Facility Contact |
50x |
Facility Contact |
String |
LI_CRT_BY |
Created By |
25x |
Created By |
String |
LI_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
LI_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 |
LI_DANSW |
Does this facility discharge authorized non-storm water to the storm drain system? |
|
Does this facility discharge authorized non-storm water to the storm drain system? |
Boolean |
LI_DOC_FLG |
Document Flag |
|
Document Flag |
Boolean |
LI_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 |
LI_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 |
LI_FUA_DT |
Follow-up Action Date |
mm/dd/yyyy hh:mm am |
Follow-up Action Date |
DateTime |
LI_FUAN |
Is Follow-up Actions Necessary? |
|
Is Follow-up Actions Necessary? |
Boolean |
LI_FUANN |
Describe Follow-up Actions Necessary (if applicable) |
250x |
Describe Follow-up Actions Necessary (if applicable) |
String |
LI_GOBSN |
Additional Observations |
250x |
Additional Observations |
String |
LI_ID |
Municipal Inspection Rec # |
nnnnnnnn |
Autonumber ID |
Long Integer |
LI_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 |
LI_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 |
LI_INSP_CD |
Inspector |
nnn |
Inspector |
Integer |
LI_INSP_DT |
Inspection Date |
mm/dd/yyyy hh:mm am |
Inspection Date |
DateTime |
LI_INSP_TY |
Inspector Text |
50x |
Inspector Text |
String |
LI_INSPE_TM |
Inspection End Time |
mm/dd/yyyy hh:mm am |
Inspection End Time |
DateTime |
LI_INSPS_TM |
Inspection Start Time |
mm/dd/yyyy hh:mm am |
Inspection Start Time |
DateTime |
LI_IPACO |
Are Industrial process activities conducted outdoors? |
|
Are Industrial process activities conducted outdoors? |
Boolean |
LI_IPACON |
If Industrial process activities are conducted outdoors then please describe |
250x |
If Industrial process activities are conducted outdoors then please describe |
String |
LI_LAPM |
Are landscaped areas properly maintained and free of erosion? |
|
Are landscaped areas properly maintained and free of erosion? |
Boolean |
LI_LATEST |
Latest Inspection |
|
Latest Inspection |
Boolean |
LI_LOEA_CD |
Level of Enforcement Action Taken |
10x |
Level of Enforcement Action Taken |
String |
LI_LOEA_TY |
Level of Enforcement Action Taken Text |
60x |
Level of Enforcement Action Taken Text |
String |
LI_MAINTREQ |
Maint Requested |
|
Maint Requested |
Boolean |
LI_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 |
LI_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
LI_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
LI_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
LI_NEEDREP |
Needs WO |
|
Needs WO |
Boolean |
LI_NIF |
Were any deficiencies noted for this inspection? |
|
Were any deficiencies noted for this inspection? |
Boolean |
LI_NIFN |
Note any deficiences noted for this inspection |
250x |
Note any deficiences noted for this inspection |
String |
LI_NINSP_DT |
Next Inspection Date |
mm/dd/yyyy hh:mm am |
Next Inspection Date |
DateTime |
LI_OEAT |
Other enforcement actions taken (if applicable) |
250x |
Other enforcement actions taken (if applicable) |
String |
LI_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 |
LI_PHONE |
Contact Phone |
25x |
Contact Phone |
String |
LI_PHOTO |
Photo Taken |
|
Photo Taken |
Boolean |
LI_PIF |
Is this a follow-up inspection, were previous deficiencies corrected? |
|
Is this a follow-up inspection, were previous deficiencies corrected? |
Boolean |
LI_QM_ID |
Municipal Inventory Rec # |
nnnnnnnn |
Long Integer |
|
LI_RBS |
Risk Based Score |
nnn |
Risk Based Score |
Integer |
LI_ROWVER |
|
|
Rowversion for optimistic locking |
TimeStamp |
LI_RQ_ID |
Request Rec # |
nnnnnnnn |
Long Integer |
|
LI_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 |
LI_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 |
LI_SCPIP |
Is there a spill containment plan in place? |
|
Is there a spill containment plan in place? |
Boolean |
LI_SDIOS |
Are there storm drain inlets on-site? |
|
Are there storm drain inlets on-site? |
Boolean |
LI_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 |
LI_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 |
LI_SFLW |
Is the site free of litter and liquid waste? |
|
Is the site free of litter and liquid waste? |
Boolean |
LI_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 |
LI_TYPE_CD |
Inspection Type |
nnn |
Inspection Type |
Integer |
LI_TYPE_TY |
Inspection Type Text |
50x |
Inspection Type Text |
String |
LI_USER10 |
User 10 |
50x |
User 10 |
String |
LI_USER11 |
User 11 |
nnnnnnnn.nn |
User 11 |
Double |
LI_USER12 |
User 12 |
nnnnnnnn.nn |
User 12 |
Double |
LI_USER13 |
User 13 |
nnnnnnnn.nn |
User 13 |
Double |
LI_USER14 |
User 14 |
nnnnnnnn.nn |
User 14 |
Double |
LI_USER15 |
User 15 |
nnnnnnnn.nn |
User 15 |
Double |
LI_USER16 |
User 16 |
mm/dd/yyyy hh:mm am |
User 16 |
DateTime |
LI_USER17 |
User 17 |
mm/dd/yyyy hh:mm am |
User 17 |
DateTime |
LI_USER18 |
User 18 |
mm/dd/yyyy hh:mm am |
User 18 |
DateTime |
LI_USER19 |
User 19 |
mm/dd/yyyy hh:mm am |
User 19 |
DateTime |
LI_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
LI_USER1TY |
User 1 Text |
50x |
User 1 Text |
String |
LI_USER20 |
User 20 |
mm/dd/yyyy hh:mm am |
User 20 |
DateTime |
LI_USER21 |
User 21 |
|
User 21 |
Boolean |
LI_USER22 |
User 22 |
|
User 22 |
Boolean |
LI_USER23 |
User 23 |
|
User 23 |
Boolean |
LI_USER24 |
User 24 |
|
User 24 |
Boolean |
LI_USER25 |
User 25 |
|
User 25 |
Boolean |
LI_USER26CD |
User 26 |
nnn |
User 26 |
Integer |
LI_USER26TY |
User 26 Text |
50x |
User 26 Text |
String |
LI_USER27CD |
User 27 |
nnn |
User 27 |
Integer |
LI_USER27TY |
User 27 Text |
50x |
User 27 Text |
String |
LI_USER28CD |
User 28 |
nnn |
User 28 |
Integer |
LI_USER28TY |
User 28 Text |
50x |
User 28 Text |
String |
LI_USER29CD |
User 29 |
nnn |
User 29 |
Integer |
LI_USER29TY |
User 29 Text |
50x |
User 29 Text |
String |
LI_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
LI_USER2TY |
User 2 Text |
50x |
User 2 Text |
String |
LI_USER30CD |
User 30 |
nnn |
User 30 |
Integer |
LI_USER30TY |
User 30 Text |
50x |
User 30 Text |
String |
LI_USER31 |
User 31 |
50x |
User 31 |
String |
LI_USER32 |
User 32 |
50x |
User 32 |
String |
LI_USER33 |
User 33 |
50x |
User 33 |
String |
LI_USER34 |
User 34 |
50x |
User 34 |
String |
LI_USER35 |
User 35 |
50x |
User 35 |
String |
LI_USER36 |
User 36 |
nnnnnnnn.nn |
User 36 |
Double |
LI_USER37 |
User 37 |
nnnnnnnn.nn |
User 37 |
Double |
LI_USER38 |
User 38 |
nnnnnnnn.nn |
User 38 |
Double |
LI_USER39 |
User 39 |
nnnnnnnn.nn |
User 39 |
Double |
LI_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
LI_USER3TY |
User 3 Text |
50x |
User 3 Text |
String |
LI_USER40 |
User 40 |
nnnnnnnn.nn |
User 40 |
Double |
LI_USER41 |
User 41 |
mm/dd/yyyy hh:mm am |
User 41 |
DateTime |
LI_USER42 |
User 42 |
mm/dd/yyyy hh:mm am |
User 42 |
DateTime |
LI_USER43 |
User 43 |
mm/dd/yyyy hh:mm am |
User 43 |
DateTime |
LI_USER44 |
User 44 |
mm/dd/yyyy hh:mm am |
User 44 |
DateTime |
LI_USER45 |
User 45 |
mm/dd/yyyy hh:mm am |
User 45 |
DateTime |
LI_USER46 |
User 46 |
|
User 46 |
Boolean |
LI_USER47 |
User 47 |
|
User 47 |
Boolean |
LI_USER48 |
User 48 |
|
User 48 |
Boolean |
LI_USER49 |
User 49 |
|
User 49 |
Boolean |
LI_USER4CD |
User 4 |
nnn |
User 4 |
Integer |
LI_USER4TY |
User 4 Text |
50x |
User 4 Text |
String |
LI_USER50 |
User 50 |
|
User 50 |
Boolean |
LI_USER5CD |
User 5 |
nnn |
User 5 |
Integer |
LI_USER5TY |
User 5 Text |
50x |
User 5 Text |
String |
LI_USER6 |
User 6 |
50x |
User 6 |
String |
LI_USER7 |
User 7 |
50x |
User 7 |
String |
LI_USER8 |
User 8 |
50x |
User 8 |
String |
LI_USER9 |
User 9 |
50x |
User 9 |
String |
LI_VBMP |
Are vehicle or equipment repair/maintenance BMPs being implemented? |
|
Are vehicle or equipment repair/maintenance BMPs being implemented? |
Boolean |
LI_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 |
LI_VCBMP |
Are vehicle, equipment, and exterior surface cleaning BMPs being implemented? |
|
Are vehicle, equipment, and exterior surface cleaning BMPs being implemented? |
Boolean |
LI_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 |
LI_VECOS |
Is vehicle, equipment or exterior surface cleaning being performed on site? |
|
Is vehicle, equipment or exterior surface cleaning being performed on site? |
Boolean |
LI_VEROS |
Is vehicle or equipment repair/maintenance performed on site? |
|
Is vehicle or equipment repair/maintenance performed on site? |
Boolean |
LI_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |
|
LI_WQP_CD |
WQ Prioritization |
nnn |
WQ Prioritization |
Integer |
LI_WQP_TY |
WQ Prioritization Text |
50x |
WQ Prioritization Text |
String |
LI_WSP |
Are the contents of waste receptacles protected from contact with stormwater? |
|
Are the contents of waste receptacles protected from contact with stormwater? |
Boolean |
LI_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 |