SMQM

Storm Water Quality Municipal Inventory

Field Name	Caption	Mask	Description	Field Type
QM_303DP	303D Pollutants	250x	303D Pollutants	String
QM_AACCOUNT	Asset Account #	45x	Asset Account #	Text
QM_ACT_DT	Active Date	mm/dd/yyyy hh:mm am	Active Date	DateTime
QM_ACTIVE	Active Project		Active Project	Boolean
QM_ADR_B2	Street Post Building No	8x	Street Post Building No	String
QM_ADR_B22	Street 2 Post Building No	8x	Street 2 Post Building No	String
QM_ADR_BDG	Address	nnnnnnnn	Address	Long Integer
QM_ADR_DIR	Street Direction	2x	Street Direction	String
QM_ADR_PT	Street Prefix	5x	Street Prefix	String
QM_ADR_SFX	Street Suffix	5x	Street Suffix	String
QM_ADR_STR	Street Name	50x	Street Name	String
QM_ADR_TY	Street Type	5x	Street Type	String
QM_ADR2_PT	Street 2 Prefix Type	5x	Street 2 Prefix Type	String
QM_ADRBDG2	Address 2	nnnnnnnn	Address 2	Long Integer
QM_ADRDIR2	Street Direction 2	2x	Street Direction 2	String
QM_ADRSFX2	Street Suffix 2	5x	Street Suffix 2	String
QM_ADRSTR2	Street Name 2	50x	Street Name 2	String
QM_ADRTY2	Street Type 2	5x	Street Type 2	String
QM_APN	APN	40x	APN	String
QM_APNUMACT	Asset Proj No - Acct	40x	Asset Proj No - Acct	Text
QM_APT_NO	Apt Number	25x	Apt Number	String
QM_AREA	Area	nnnnnnnn.nn	Area	Double
QM_AUNT_CD	Area Units	nnn	Area Units	Integer
QM_AUNT_TY	Area Units Text	10x	Area Units Text	String
QM_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
QM_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
QM_BR_CD	Default Category Code	10x	Default Category Code	String
QM_BR_TY	Default Category Code	60x	Default Category Code	String
QM_CADDR1	Contact Address 1	50x	Contact Address 1	String
QM_CADDR2	Contact Address 2	50x	Contact Address 2	String
QM_CCITY	City	100x	City	String
QM_CEMAIL	Contact Email	150x	Contact Email	String
QM_CFAX	Contact Fax	25x	Contact Fax	String
QM_CITY	City	100x	City	String
QM_CMOBILE	Contact Mobile/Cell Phone	25x	Contact Mobile/Cell Phone	String
QM_CNAME	Contact Name	50x	Contact Name	String
QM_CNOT_CD	Notification	nnn	Notification	Integer
QM_CNOT_DT	Notification Date	mm/dd/yyyy hh:mm am	Notification Date	DateTime
QM_CNOT_TY	Notification Text	50x	Notification Text	String
QM_COMMENT1	Long Note		Long Note	Memo
QM_COND_CD	Condition	nnn	Condition	Integer
QM_COND_TY	Condition Text	100x	Condition Text	Text
QM_CPHONE	Contact Phone	25x	Contact Phone	String
QM_CPOSTAL	Zip Code	15x	Zip Code	String
QM_CRT_BY	Created By	25x	Created By	String
QM_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
QM_CSTATE	State	30x	State	String
QM_CSTREET	Cross Street	50x	Cross Street	String
QM_DEPT_CD	Department	10x	Department	String
QM_DEPT_TY	Department Text	60x	Department Text	String
QM_DFIRW	Distance from Immediate Receiving Water	nnnnnnnn.nn	Distance from Immediate Receiving Water	Double
QM_DOC_FLG	Document Flag		Document Flag	Boolean
QM_DRW303DL	Are Downstream Receiving Waters 303D Listed?		Are Downstream Receiving Waters 303D Listed?	Boolean
QM_DUNT_CD	Distance Units	nnn	Distance Units	Integer
QM_DUNT_TY	Distance Units Text	10x	Distance Units Text	String
QM_FDESC	Facility Description	100x	Facility Description	String
QM_FLLW_DT	Follow-up Date	mm/dd/yyyy hh:mm am	Follow-up Date	DateTime
QM_GISNEED_CD	Needs GIS	nnn	Needs GIS	Integer
QM_GISNEED_TY	Needs GIS Text	100x	Needs GIS Text	Text
QM_ID	Municipal Record No	nnnnnnnn	Auto ID	Long Integer
QM_IFREQ	Inspection Freq	nnn	Inspection Freq	Integer
QM_IFRQ_CD	Inspection Freq Units	nnn	Inspection Freq Units	Integer
QM_IFRQ_TY	Inspection Freq Units Text	10x	Inspection Freq Units Text	String
QM_INAC_DT	Inactive Date	mm/dd/yyyy hh:mm am	Inactive Date	DateTime
QM_INMAP	Flag indicating this feature is in the map		Flag indicating this feature is in the map	Boolean
QM_IRW303DL	Is Immediate Receiving Waters 303D Listed?		Is Immediate Receiving Waters 303D Listed?	Boolean
QM_LATLONG_X	Latlong X	nnnnnnnn.nn	Latlong X	Double
QM_LATLONG_Y	Latlong Y	nnnnnnnn.nn	Latlong Y	Double
QM_LINS_DT	Last Inspection Date	mm/dd/yyyy hh:mm am	Last Inspection Date	DateTime
QM_LINS_TM	Last Inspection Time	mm/dd/yyyy hh:mm am	Last Inspection Time	DateTime
QM_LOCATE	General Location	100x	General Location	String
QM_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
QM_MOD_BY	Last Modified By	25x	Last Modified By	String
QM_MOD_DT	Last Modified Date	mm/dd/yyyy hh:mm am	Last Modified Date	DateTime
QM_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
QM_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
QM_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
QM_NINS_DT	Next Inspection Date	mm/dd/yyyy hh:mm am	Next Inspection Date	DateTime
QM_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
QM_NUMBER	Municipal ID	30x	Unique ID	String
QM_OPERMIT	Other Permit	250x	Other Permit	String
QM_OUTDESC	Outreach Description	250x	Outreach Description	String
QM_OUTREAC	Outreach		Outreach	Boolean
QM_POCBV	Pollutants of Concern - Bacteria/Virus		Pollutants of Concern - Bacteria/Virus	Boolean
QM_POCHM	Pollutants of Concern - Heavy Metals		Pollutants of Concern - Heavy Metals	Boolean
QM_POCN	Pollutants of Concern - Nutrients		Pollutants of Concern - Nutrients	Boolean
QM_POCNOTE	Pollutants of Concern - Note	250x	Pollutants of Concern - Note	String
QM_POCO	Pollutants of Concern - Other		Pollutants of Concern - Other	Boolean
QM_POCOC	Pollutants of Concern - Organic Componds		Pollutants of Concern - Organic Componds	Boolean
QM_POCODS	Pollutants of Concern - Oxygen Demand Substances		Pollutants of Concern - Oxygen Demand Substances	Boolean
QM_POCOG	Pollutants of Concern - Oil & Grease		Pollutants of Concern - Oil & Grease	Boolean
QM_POCP	Pollutants of Concern - Pesticides		Pollutants of Concern - Pesticides	Boolean
QM_POCS	Pollutants of Concern - Sediments		Pollutants of Concern - Sediments	Boolean
QM_POCTD	Pollutants of Concern - Trash & Debris		Pollutants of Concern - Trash & Debris	Boolean
QM_POSTAL	Zip Code	15x	Zip Code	String
QM_PROPTAG	Property ID Tag	52x	Property ID Tag	String
QM_QA_ID	Link to Site Record	nnnnnnnn	Link to Site Record: SMQSITE	Long Integer
QM_REF	Ref/File Number	30x	Ref/File Number	String
QM_ROWVER			Rowversion for optimistic locking	TimeStamp
QM_RW_CD	Immediate Receiving Water	10x	Immediate Receiving Water	String
QM_RW_TY	Immediate Receiving Water Text	60x	Immediate Receiving Water Text	String
QM_SRN_CD	SubReach Number	10x	SubReach Number	String
QM_SRN_TY	SubReach Number Text	60x	SubReach Number Text	String
QM_STAT_CD	Status	nnn	Status	Integer
QM_STAT_TY	Status Text	25x	Status Text	String
QM_STATE	State	30x	State	String
QM_STYPE_CD	GIS Subtype Code	nnn	GIS Subtype Code	Integer
QM_STYPE_TY	GIS Subtype Text	25x	GIS Subtype Text	String
QM_TASBS	Tributary to an Area of Speical Biological Significance (ASBS)		Tributary to an Area of Speical Biological Significance (ASBS)	Boolean
QM_TITL_CD	Title	nnn	Title	Integer
QM_TITL_TY	Title Text	50x	Title Text	String
QM_USER1CD	User 1	nnn	User 1	Integer
QM_USER1TY	User 1 Text	50x	User 1 Text	String
QM_USER2CD	User 2	nnn	User 2	Integer
QM_USER2TY	User 2 Text	50x	User 2 Text	String
QM_USER3CD	User 3	nnn	User 3	Integer
QM_USER3TY	User 3 Text	50x	User 3 Text	String
QM_USER4CD	User 4	nnn	User 4	Integer
QM_USER4TY	User 4 Text	50x	User 4 Text	String
QM_USER5CD	User 5	nnn	User 5	Integer
QM_USER5TY	User 5 Text	50x	User 5 Text	String
QM_USER6	User 6	50x	User 6	String
QM_USER7	User 7	50x	User 7	String
QM_USER8	User 8	50x	User 8	String
QM_USER9	User 9	50x	User 9	String
QM_USER10	User 10	50x	User 10	String
QM_USER11	User 11	nnnnnnnn.nn	User 11	Double
QM_USER12	User 12	nnnnnnnn.nn	User 12	Double
QM_USER13	User 13	nnnnnnnn.nn	User 13	Double
QM_USER14	User 14	nnnnnnnn.nn	User 14	Double
QM_USER15	User 15	nnnnnnnn.nn	User 15	Double
QM_USER16	User 16	mm/dd/yyyy hh:mm am	User 16	DateTime
QM_USER17	User 17	mm/dd/yyyy hh:mm am	User 17	DateTime
QM_USER18	User 18	mm/dd/yyyy hh:mm am	User 18	DateTime
QM_USER19	User 19	mm/dd/yyyy hh:mm am	User 19	DateTime
QM_USER20	User 20	mm/dd/yyyy hh:mm am	User 20	DateTime
QM_USER21	User 21		User 21	Boolean
QM_USER22	User 22		User 22	Boolean
QM_USER23	User 23		User 23	Boolean
QM_USER24	User 24		User 24	Boolean
QM_USER25	User 25		User 25	Boolean
QM_USER26CD	User 26	nnn	User 26	Integer
QM_USER26TY	User 26 Text	50x	User 26 Text	String
QM_USER27CD	User 27	nnn	User 27	Integer
QM_USER27TY	User 27 Text	50x	User 27 Text	String
QM_USER28CD	User 28	nnn	User 28	Integer
QM_USER28TY	User 28 Text	50x	User 28 Text	String
QM_USER29CD	User 29	nnn	User 29	Integer
QM_USER29TY	User 29 Text	50x	User 29 Text	String
QM_USER30CD	User 30	nnn	User 30	Integer
QM_USER30TY	User 30 Text	50x	User 30 Text	String
QM_USER31	User 31	50x	User 31	String
QM_USER32	User 32	50x	User 32	String
QM_USER33	User 33	50x	User 33	String
QM_USER34	User 34	50x	User 34	String
QM_USER35	User 35	50x	User 35	String
QM_USER36	User 36	nnnnnnnn.nn	User 36	Double
QM_USER37	User 37	nnnnnnnn.nn	User 37	Double
QM_USER38	User 38	nnnnnnnn.nn	User 38	Double
QM_USER39	User 39	nnnnnnnn.nn	User 39	Double
QM_USER40	User 40	nnnnnnnn.nn	User 40	Double
QM_USER41	User 41	mm/dd/yyyy hh:mm am	User 41	DateTime
QM_USER42	User 42	mm/dd/yyyy hh:mm am	User 42	DateTime
QM_USER43	User 43	mm/dd/yyyy hh:mm am	User 43	DateTime
QM_USER44	User 44	mm/dd/yyyy hh:mm am	User 44	DateTime
QM_USER45	User 45	mm/dd/yyyy hh:mm am	User 45	DateTime
QM_USER46	User 46		User 46	Boolean
QM_USER47	User 47		User 47	Boolean
QM_USER48	User 48		User 48	Boolean
QM_USER49	User 49		User 49	Boolean
QM_USER50	User 50		User 50	Boolean
QM_USER51CD	User 51	10x	User 51	String
QM_USER51TY	User 51 Text	60x	User 51 Text	String
QM_USER52CD	User 52	10x	User 52	String
QM_USER52TY	User 52 Text	60x	User 52 Text	String
QM_USER53CD	User 53	10x	User 53	String
QM_USER53TY	User 53 Text	60x	User 53 Text	String
QM_USER54CD	User 54	10x	User 54	String
QM_USER54TY	User 54 Text	60x	User 54 Text	String
QM_USER55CD	User 55	10x	User 55	String
QM_USER55TY	User 55 Text	60x	User 55 Text	String
QM_WQPR_CD	WQ Prioritization	nnn	WQ Prioritization	Integer
QM_WQPR_TY	WQ Prioritization Text	50x	WQ Prioritization Text	String
QM_WSMPID	WQMP ID#	30x	WQMP ID#	String
QM_X	X Coordinate	nnnnnnnn.nn	X Coordinate	Double
QM_Y	Y Coordinate	nnnnnnnn.nn	Y Coordinate	Double
QM_Z	Elevation	nnnnnnnn.nn	Elevation	Double