SMQSI

Storm Water Quality Construction Site Inspection

Field Name	Caption	Mask	Description	Field Type
HI_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
HI_CAECP	Is there a copy of the approved Erosion Control Plan on Site?		Is there a copy of the approved Erosion Control Plan on Site?	Boolean
HI_CAN	Describe Corrective Actions Necessary (if applicable)	250x	Describe Corrective Actions Necessary (if applicable)	String
HI_CNOTES	Complaint Notes	250x	Complaint Notes	String
HI_CONTACT	Facility Contact	50x	Facility Contact	String
HI_CRT_BY	Created By	25x	Created By	String
HI_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
HI_CSWPPPOS	Is there a current, updated copy of the Stormwater Pollution Prevention Plan (SWPPP) on Site?		Is there a current, updated copy of the Stormwater Pollution Prevention Plan (SWPPP) on Site?	Boolean
HI_CWAG	Are concrete washout areas properly constructed/located, and spill contained to prevent discharge?		Are concrete washout areas properly constructed/located, and spill contained to prevent discharge?	Boolean
HI_DOC_FLG	Document Flag		Document Flag	Boolean
HI_FEE	Agency Fee	nnnnnnnn.nn	Agency Fee	Double
HI_FUA_DT	Follow-up Action Date	mm/dd/yyyy hh:mm am	Follow-up Action Date	DateTime
HI_FUAN	Is Follow-up Actions Necessary?		Is Follow-up Actions Necessary?	Boolean
HI_FUANN	Describe Follow-up Actions Necessary (if applicable)	250x	Describe Follow-up Actions Necessary (if applicable)	String
HI_GOBSN	Additional Observations	250x	Additional Observations	String
HI_HMAC	Are hazardous materials in an approved area, covered, and contained?		Are hazardous materials in an approved area, covered, and contained?	Boolean
HI_ID	Construction Site Inspection Rec #	nnnnnnnn	Autonumber ID	Long Integer
HI_IEIS	Are points of ingress/egress inspected and swept as needed?		Are points of ingress/egress inspected and swept as needed?	Boolean
HI_IESS	Are points of ingress/egress at site stabilized?		Are points of ingress/egress at site stabilized?	Boolean
HI_INSP_CD	Inspector	nnn	Inspector	Integer
HI_INSP_DT	Inspection Date	mm/dd/yyyy hh:mm am	Inspection Date	DateTime
HI_INSP_TY	Inspector Text	50x	Inspector Text	String
HI_INSPE_TM	Inspection End Time	mm/dd/yyyy hh:mm am	Inspection End Time	DateTime
HI_INSPS_TM	Inspection Start Time	mm/dd/yyyy hh:mm am	Inspection Start Time	DateTime
HI_LATEST	Latest Inspection		Latest Inspection	Boolean
HI_LOEA_CD	Level of Enforcement Action Taken	10x	Level of Enforcement Action Taken	String
HI_LOEA_TY	Level of Enforcement Action Taken Text	60x	Level of Enforcement Action Taken Text	String
HI_MAINTREQ	Maint Requested		Maint Requested	Boolean
HI_MOD_BY	Last Modified By	25x	Last Modified By	String
HI_MOD_DT	Last Modified Date	mm/dd/yyyy hh:mm am	Last Modified Date	DateTime
HI_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
HI_NEEDREP	Needs WO		Needs WO	Boolean
HI_NIF	Were any deficiencies noted for this inspection?		Were any deficiencies noted for this inspection?	Boolean
HI_NIFN	Note any deficiences noted for this inspection	250x	Note any deficiences noted for this inspection	String
HI_NINSP_DT	Next Inspection Date	mm/dd/yyyy hh:mm am	Next Inspection Date	DateTime
HI_OEAT	Other enforcement actions taken (if applicable)	250x	Other enforcement actions taken (if applicable)	String
HI_PHONE	Contact Phone	25x	Contact Phone	String
HI_PHOTO	Photo Taken		Photo Taken	Boolean
HI_PIF	Is this a follow-up inspection, were previous deficiencies corrected?		Is this a follow-up inspection, were previous deficiencies corrected?	Boolean
HI_PTBMP	Are portable toilets BMPs in place?		Are portable toilets BMPs in place?	Boolean
HI_QS_ID	Construction Site Inventory Rec #	nnnnnnnn	Link to SMQS.QS_ID	Long Integer
HI_RBS	Risk Based Score	nnn	Risk Based Score	Integer
HI_ROWVER			Rowversion for optimistic locking	TimeStamp
HI_RQ_ID	Request Rec #	nnnnnnnn	Link to WKREQ.RQ_ID	Long Integer
HI_SBMPSG	Are the Structural BMPs (de-silting basins, etc.) in a good state of repair and being maintained		Are the Structural BMPs (de-silting basins, etc.) in a good state of repair and being maintained	Boolean
HI_SCBMP	Are sediment control BMPs (gravel or sand bags, silt fences, etc.) properly installed and maintained at the construction site?		Are sediment control BMPs (gravel or sand bags, silt fences, etc.) properly installed and maintained at the construction site?	Boolean
HI_SDPSI	Are all storm drain inlets protected from sediment inflow?		Are all storm drain inlets protected from sediment inflow?	Boolean
HI_SFLW	Is the site free of litter and liquid waste?		Is the site free of litter and liquid waste?	Boolean
HI_SPC	Are stock piles of non-hazardous material covered or contained?		Are stock piles of non-hazardous material covered or contained?	Boolean
HI_TRC	Are trash receptacles covered?		Are trash receptacles covered?	Boolean
HI_TYPE_CD	Inspection Type	nnn	Inspection Type	Integer
HI_TYPE_TY	Inspection Type Text	50x	Inspection Type Text	String
HI_USER1CD	User 1	nnn	User 1	Integer
HI_USER1TY	User 1 Text	50x	User 1 Text	String
HI_USER2CD	User 2	nnn	User 2	Integer
HI_USER2TY	User 2 Text	50x	User 2 Text	String
HI_USER3CD	User 3	nnn	User 3	Integer
HI_USER3TY	User 3 Text	50x	User 3 Text	String
HI_USER4CD	User 4	nnn	User 4	Integer
HI_USER4TY	User 4 Text	50x	User 4 Text	String
HI_USER5CD	User 5	nnn	User 5	Integer
HI_USER5TY	User 5 Text	50x	User 5 Text	String
HI_USER6	User 6	50x	User 6	String
HI_USER7	User 7	50x	User 7	String
HI_USER8	User 8	50x	User 8	String
HI_USER9	User 9	50x	User 9	String
HI_USER10	User 10	50x	User 10	String
HI_USER11	User 11	nnnnnnnn.nn	User 11	Double
HI_USER12	User 12	nnnnnnnn.nn	User 12	Double
HI_USER13	User 13	nnnnnnnn.nn	User 13	Double
HI_USER14	User 14	nnnnnnnn.nn	User 14	Double
HI_USER15	User 15	nnnnnnnn.nn	User 15	Double
HI_USER16	User 16	mm/dd/yyyy hh:mm am	User 16	DateTime
HI_USER17	User 17	mm/dd/yyyy hh:mm am	User 17	DateTime
HI_USER18	User 18	mm/dd/yyyy hh:mm am	User 18	DateTime
HI_USER19	User 19	mm/dd/yyyy hh:mm am	User 19	DateTime
HI_USER20	User 20	mm/dd/yyyy hh:mm am	User 20	DateTime
HI_USER21	User 21		User 21	Boolean
HI_USER22	User 22		User 22	Boolean
HI_USER23	User 23		User 23	Boolean
HI_USER24	User 24		User 24	Boolean
HI_USER25	User 25		User 25	Boolean
HI_USER26CD	User 26	nnn	User 26	Integer
HI_USER26TY	User 26 Text	50x	User 26 Text	String
HI_USER27CD	User 27	nnn	User 27	Integer
HI_USER27TY	User 27 Text	50x	User 27 Text	String
HI_USER28CD	User 28	nnn	User 28	Integer
HI_USER28TY	User 28 Text	50x	User 28 Text	String
HI_USER29CD	User 29	nnn	User 29	Integer
HI_USER29TY	User 29 Text	50x	User 29 Text	String
HI_USER30CD	User 30	nnn	User 30	Integer
HI_USER30TY	User 30 Text	50x	User 30 Text	String
HI_USER31	User 31	50x	User 31	String
HI_USER32	User 32	50x	User 32	String
HI_USER33	User 33	50x	User 33	String
HI_USER34	User 34	50x	User 34	String
HI_USER35	User 35	50x	User 35	String
HI_USER36	User 36	nnnnnnnn.nn	User 36	Double
HI_USER37	User 37	nnnnnnnn.nn	User 37	Double
HI_USER38	User 38	nnnnnnnn.nn	User 38	Double
HI_USER39	User 39	nnnnnnnn.nn	User 39	Double
HI_USER40	User 40	nnnnnnnn.nn	User 40	Double
HI_USER41	User 41	mm/dd/yyyy hh:mm am	User 41	DateTime
HI_USER42	User 42	mm/dd/yyyy hh:mm am	User 42	DateTime
HI_USER43	User 43	mm/dd/yyyy hh:mm am	User 43	DateTime
HI_USER44	User 44	mm/dd/yyyy hh:mm am	User 44	DateTime
HI_USER45	User 45	mm/dd/yyyy hh:mm am	User 45	DateTime
HI_USER46	User 46		User 46	Boolean
HI_USER47	User 47		User 47	Boolean
HI_USER48	User 48		User 48	Boolean
HI_USER49	User 49		User 49	Boolean
HI_USER50	User 50		User 50	Boolean
HI_VEFP	Are vehicle/equipment fueling, cleaning & maintenance areas clean, free of spills or leaks, and protected from run-on and run-off?		Are vehicle/equipment fueling, cleaning & maintenance areas clean, free of spills or leaks, and protected from run-on and run-off?	Boolean
HI_WECPI	Are wind erosion controls properly implemented?		Are wind erosion controls properly implemented?	Boolean
HI_WO_ID	Work Order Rec #	nnnnnnnn	Link to WKORDER.WO_ID	Long Integer
HI_WQP_CD	WQ Prioritization	nnn	WQ Prioritization	Integer
HI_WQP_TY	WQ Prioritization Text	50x	WQ Prioritization Text	String