SMQCI

Storm Water Quality Commercial Inspection

Field Name	Caption	Mask	Description	Field Type
KI_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
KI_BMPIOSA	Are BMPs implemented in outdoor storage areas		Are BMPs implemented in outdoor storage areas	Boolean
KI_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
KI_BMPIPA	Are BMPs implemented in outdoor commercial process areas?		Are BMPs implemented in outdoor commercial process areas?	Boolean
KI_BMPIPAN	If BMPs are implemented in outdoor commerical process areas then please describe	250x	If BMPs are implemented in outdoor commericial process areas then please describe	String
KI_CAN	Describe Corrective Actions Necessary (if applicable)	250x	Describe Corrective Actions Necessary (if applicable)	String
KI_CNOTES	If Complaint or follow-up then describe reason	250x	If Complaint or follow-up then describe reason	String
KI_CONTACT	Facility Contact	50x	Facility Contact	String
KI_CPACO	Are commercial process activities conducted outdoors?		Are commercial process activities conducted outdoors?	Boolean
KI_CPACON	If commercial process activities are conducted outdoors then please describe	250x	If commercial process activities are conducted outdoors then please describe	String
KI_CRT_BY	Created By	25x	Created By	String
KI_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
KI_DOC_FLG	Document Flag		Document Flag	Boolean
KI_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
KI_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
KI_FEE	Agency Fee	nnnnnnnn.nn	Agency Fee	Double
KI_FUA_DT	Follow-up Action Date	mm/dd/yyyy hh:mm am	Follow-up Action Date	DateTime
KI_FUAN	Is Follow-up Actions Necessary?		Is Follow-up Actions Necessary?	Boolean
KI_FUANN	Describe Follow-up Actions Necessary (if applicable)	250x	Describe Follow-up Actions Necessary (if applicable)	String
KI_GIAC	Does the grease interceptor have adequate capacity and is it properly maintained?		Does the grease interceptor have adequate capacity and is it properly maintained?	Boolean
KI_GIISL	Is a grease interceptor installed on the sewer lateral?		Is a grease interceptor installed on the sewer lateral?	Boolean
KI_GIRA	Are grease interceptor maintenance records available?		Are grease interceptor maintenance records available?	Boolean
KI_GOBSN	Additional Observations	250x	Additional Observations	String
KI_GOG	Is there grease on the ground next to the outdoor grease container(s)?		Is there grease on the ground next to the outdoor grease container(s)?	Boolean
KI_GRPU	Is grease regularly picked up by a service company?		Is grease regularly picked up by a service company?	Boolean
KI_ID	Commercial Inspection Rec #	nnnnnnnn	Autonumber ID	Long Integer
KI_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
KI_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
KI_INSP_CD	Inspector	nnn	Inspector	Integer
KI_INSP_DT	Inspection Date	mm/dd/yyyy hh:mm am	Inspection Date	DateTime
KI_INSP_TY	Inspector Text	50x	Inspector Text	String
KI_INSPE_TM	Inspection End Time	mm/dd/yyyy hh:mm am	Inspection End Time	DateTime
KI_INSPS_TM	Inspection Start Time	mm/dd/yyyy hh:mm am	Inspection Start Time	DateTime
KI_LAPM	Are landscaped areas properly maintained and free of erosion?		Are landscaped areas properly maintained and free of erosion?	Boolean
KI_LATEST	Latest Inspection		Latest Inspection	Boolean
KI_LDTC	Are liquids being disposed of in trash containers or compactors?		Are liquids being disposed of in trash containers or compactors?	Boolean
KI_LOEA_CD	Level of Enforcement Action Taken	10x	Level of Enforcement Action Taken	String
KI_LOEA_TY	Level of Enforcement Action Taken Text	60x	Level of Enforcement Action Taken Text	String
KI_LOG	Is there any liquid or solid waste on the ground around trash containers or compactors?		Is there any liquid or solid waste on the ground around trash containers or compactors?	Boolean
KI_MAINTREQ	Maint Requested		Maint Requested	Boolean
KI_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
KI_MOD_BY	Last Modified By	25x	Last Modified By	String
KI_MOD_DT	Last Modified Date	mm/dd/yyyy hh:mm am	Last Modified Date	DateTime
KI_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
KI_MWHA	Are materials and waste handling adequate		Are materials and waste handling adequate	Boolean
KI_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
KI_NEEDREP	Needs WO		Needs WO	Boolean
KI_NIF	Were any deficiencies noted for this inspection?		Were any deficiencies noted for this inspection?	Boolean
KI_NIFN	Note any deficiences noted for this inspection	250x	Note any deficiences noted for this inspection	String
KI_NINSP_DT	Next Inspection Date	mm/dd/yyyy hh:mm am	Next Inspection Date	DateTime
KI_OEAT	Other enforcement actions taken (if applicable)	250x	Other enforcement actions taken (if applicable)	String
KI_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
KI_PHONE	Contact Phone	25x	Contact Phone	String
KI_PHOTO	Photo Taken		Photo Taken	Boolean
KI_PIF	Is this a follow-up inspection, were previous deficiencies corrected?		Is this a follow-up inspection, were previous deficiencies corrected?	Boolean
KI_QC_ID	Commercial Inventory Rec #	nnnnnnnn	Link to SMQC.QC_ID	Long Integer
KI_RBS	Risk Based Score	nnn	Risk Based Score	Integer
KI_ROWVER			Rowversion for optimistic locking	TimeStamp
KI_RQ_ID	Request Rec #	nnnnnnnn	Link to WKREQ.RQ_ID	Long Integer
KI_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
KI_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
KI_SC	Is the secondary containment around the outdoor grease container(s) in place and adequate?		Is the secondary containment around the outdoor grease container(s) in place and adequate?	Boolean
KI_SCPIP	Is there a spill containment plan in place?		Is there a spill containment plan in place?	Boolean
KI_SCTC	Is the secondary containment around trash compactor(s) in place and adequate?		Is the secondary containment around trash compactor(s) in place and adequate?	Boolean
KI_SDIOS	Are there storm drain inlets on-site?		Are there storm drain inlets on-site?	Boolean
KI_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
KI_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
KI_SFLW	Is the site free of litter and liquid waste?		Is the site free of litter and liquid waste?	Boolean
KI_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
KI_TCOS	Is there a trash compactor on site?		Is there a trash compactor on site?	Boolean
KI_TYPE_CD	Inspection Type	nnn	Inspection Type	Integer
KI_TYPE_TY	Inspection Type Text	50x	Inspection Type Text	String
KI_USER1CD	User 1	nnn	User 1	Integer
KI_USER1TY	User 1 Text	50x	User 1 Text	String
KI_USER2CD	User 2	nnn	User 2	Integer
KI_USER2TY	User 2 Text	50x	User 2 Text	String
KI_USER3CD	User 3	nnn	User 3	Integer
KI_USER3TY	User 3 Text	50x	User 3 Text	String
KI_USER4CD	User 4	nnn	User 4	Integer
KI_USER4TY	User 4 Text	50x	User 4 Text	String
KI_USER5CD	User 5	nnn	User 5	Integer
KI_USER5TY	User 5 Text	50x	User 5 Text	String
KI_USER6	User 6	50x	User 6	String
KI_USER7	User 7	50x	User 7	String
KI_USER8	User 8	50x	User 8	String
KI_USER9	User 9	50x	User 9	String
KI_USER10	User 10	50x	User 10	String
KI_USER11	User 11	nnnnnnnn.nn	User 11	Double
KI_USER12	User 12	nnnnnnnn.nn	User 12	Double
KI_USER13	User 13	nnnnnnnn.nn	User 13	Double
KI_USER14	User 14	nnnnnnnn.nn	User 14	Double
KI_USER15	User 15	nnnnnnnn.nn	User 15	Double
KI_USER16	User 16	mm/dd/yyyy hh:mm am	User 16	DateTime
KI_USER17	User 17	mm/dd/yyyy hh:mm am	User 17	DateTime
KI_USER18	User 18	mm/dd/yyyy hh:mm am	User 18	DateTime
KI_USER19	User 19	mm/dd/yyyy hh:mm am	User 19	DateTime
KI_USER20	User 20	mm/dd/yyyy hh:mm am	User 20	DateTime
KI_USER21	User 21		User 21	Boolean
KI_USER22	User 22		User 22	Boolean
KI_USER23	User 23		User 23	Boolean
KI_USER24	User 24		User 24	Boolean
KI_USER25	User 25		User 25	Boolean
KI_USER26CD	User 26	nnn	User 26	Integer
KI_USER26TY	User 26 Text	50x	User 26 Text	String
KI_USER27CD	User 27	nnn	User 27	Integer
KI_USER27TY	User 27 Text	50x	User 27 Text	String
KI_USER28CD	User 28	nnn	User 28	Integer
KI_USER28TY	User 28 Text	50x	User 28 Text	String
KI_USER29CD	User 29	nnn	User 29	Integer
KI_USER29TY	User 29 Text	50x	User 29 Text	String
KI_USER30CD	User 30	nnn	User 30	Integer
KI_USER30TY	User 30 Text	50x	User 30 Text	String
KI_USER31	User 31	50x	User 31	String
KI_USER32	User 32	50x	User 32	String
KI_USER33	User 33	50x	User 33	String
KI_USER34	User 34	50x	User 34	String
KI_USER35	User 35	50x	User 35	String
KI_USER36	User 36	nnnnnnnn.nn	User 36	Double
KI_USER37	User 37	nnnnnnnn.nn	User 37	Double
KI_USER38	User 38	nnnnnnnn.nn	User 38	Double
KI_USER39	User 39	nnnnnnnn.nn	User 39	Double
KI_USER40	User 40	nnnnnnnn.nn	User 40	Double
KI_USER41	User 41	mm/dd/yyyy hh:mm am	User 41	DateTime
KI_USER42	User 42	mm/dd/yyyy hh:mm am	User 42	DateTime
KI_USER43	User 43	mm/dd/yyyy hh:mm am	User 43	DateTime
KI_USER44	User 44	mm/dd/yyyy hh:mm am	User 44	DateTime
KI_USER45	User 45	mm/dd/yyyy hh:mm am	User 45	DateTime
KI_USER46	User 46		User 46	Boolean
KI_USER47	User 47		User 47	Boolean
KI_USER48	User 48		User 48	Boolean
KI_USER49	User 49		User 49	Boolean
KI_USER50	User 50		User 50	Boolean
KI_VBMP	Are vehicle or equipment repair/maintenance BMPs being implemented?		Are vehicle or equipment repair/maintenance BMPs being implemented?	Boolean
KI_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
KI_VCBMP	Are vehicle, equipment, and exterior surface cleaning BMPs being implemented?		Are vehicle, equipment, and exterior surface cleaning BMPs being implemented?	Boolean
KI_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
KI_VECOS	Is vehicle, equipment or exterior surface cleaning being performed on site?		Is vehicle, equipment or exterior surface cleaning being performed on site?	Boolean
KI_VEROS	Is vehicle or equipment repair/maintenance performed on site?		Is vehicle or equipment repair/maintenance performed on site?	Boolean
KI_WO_ID	Work Order Rec #	nnnnnnnn	Link to WKORDER.WO_ID	Long Integer
KI_WQP_CD	WQ Prioritization	nnn	WQ Prioritization	Integer
KI_WQP_TY	WQ Prioritization Text	50x	WQ Prioritization Text	String
KI_WSP	Are the contents of waste receptacles protected from contact with stormwater?		Are the contents of waste receptacles protected from contact with stormwater?	Boolean
KI_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