SMQI

Storm Water Quality Industrial Inventory

Field Name	Caption	Mask	Description	Field Type
QI_303DP	303D Pollutants	250x	303D Pollutants	String
QI_401	401 Certification		401 Certification	Boolean
QI_AACCOUNT	Asset Account #	45x	Asset Account #	Text
QI_ACT_DT	Active Date	mm/dd/yyyy hh:mm am	Active Date	DateTime
QI_ACTIVE	Active Project		Active Project	Boolean
QI_ADR_B2	Street Post Building No	8x	Street Post Building No	String
QI_ADR_B22	Street 2 Post Building No	8x	Street 2 Post Building No	String
QI_ADR_BDG	Address	nnnnnnnn	Address	Long Integer
QI_ADR_DIR	Street Direction	2x	Street Direction	String
QI_ADR_PT	Street Prefix	5x	Street Prefix	String
QI_ADR_SFX	Street Suffix	5x	Street Suffix	String
QI_ADR_STR	Street Name	50x	Street Name	String
QI_ADR_TY	Street Type	5x	Street Type	String
QI_ADR2_PT	Street 2 Prefix Type	5x	Street 2 Prefix Type	String
QI_ADRBDG2	Address 2	nnnnnnnn	Address 2	Long Integer
QI_ADRDIR2	Street Direction 2	2x	Street Direction 2	String
QI_ADRSFX2	Street Suffix 2	5x	Street Suffix 2	String
QI_ADRSTR2	Street Name 2	50x	Street Name 2	String
QI_ADRTY2	Street Type 2	5x	Street Type 2	String
QI_APN	APN	40x	APN	String
QI_APNUMACT	Asset Proj No - Acct	40x	Asset Proj No - Acct	Text
QI_APT_NO	Apt Number	25x	Apt Number	String
QI_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
QI_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
QI_BDESC	Business Description	100x	Business Description	String
QI_BNAME	Business Name	50x	Business Name	String
QI_BR_CD	Default Category Code	10x	Default Category Code	String
QI_BR_TY	Default Category Code	60x	Default Category Code	String
QI_CADDR1	Contact Address 1	50x	Contact Address 1	String
QI_CADDR2	Contact Address 2	50x	Contact Address 2	String
QI_CCITY	City	100x	City	String
QI_CEMAIL	Contact Email	150x	Contact Email	String
QI_CFAX	Contact Fax	25x	Contact Fax	String
QI_CITY	City	100x	City	String
QI_CMOBILE	Contact Mobile/Cell Phone	25x	Contact Mobile/Cell Phone	String
QI_CNAME	Contact Name	50x	Contact Name	String
QI_CNOT_CD	Notification	nnn	Notification	Integer
QI_CNOT_DT	Notification Date	mm/dd/yyyy hh:mm am	Notification Date	DateTime
QI_CNOT_TY	Notification Text	50x	Notification Text	String
QI_COMMENT1	Long Note		Long Note	Memo
QI_COND_CD	Condition	nnn	Condition	Integer
QI_COND_TY	Condition Text	100x	Condition Text	Text
QI_CPHONE	Contact Phone	25x	Contact Phone	String
QI_CPOSTAL	Zip Code	15x	Zip Code	String
QI_CRT_BY	Created By	25x	Created By	String
QI_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
QI_CSTATE	State	30x	State	String
QI_CSTREET	Cross Street	50x	Cross Street	String
QI_DFIRW	Distance from Immediate Receiving Water	nnnnnnnn.nn	Distance from Immediate Receiving Water	Double
QI_DOC_FLG	Document Flag		Document Flag	Boolean
QI_DRW303DL	Are Downstream Receiving Waters 303D Listed?		Are Downstream Receiving Waters 303D Listed?	Boolean
QI_DUNT_CD	Distance Units	nnn	Distance Units	Integer
QI_DUNT_TY	Distance Units Text	10x	Distance Units Text	String
QI_FLLW_DT	Follow-up Date	mm/dd/yyyy hh:mm am	Follow-up Date	DateTime
QI_GISNEED_CD	Needs GIS	nnn	Needs GIS	Integer
QI_GISNEED_TY	Needs GIS Text	100x	Needs GIS Text	Text
QI_ID	Industrial Record No	nnnnnnnn	Industrial Record No	Long Integer
QI_IFREQ	Inspection Freq	nnn	Inspection Freq	Integer
QI_IFRQ_CD	Inspection Freq Units	nnn	Inspection Freq Units	Integer
QI_IFRQ_TY	Inspection Freq Units Text	10x	Inspection Freq Units Text	String
QI_INAC_DT	Inactive Date	mm/dd/yyyy hh:mm am	Inactive Date	DateTime
QI_INMAP	Flag indicating this feature is in the map		Flag indicating this feature is in the map	Boolean
QI_IRW303DL	Is Immediate Receiving Waters 303D Listed?		Is Immediate Receiving Waters 303D Listed?	Boolean
QI_LATLONG_X	Latlong X	nnnnnnnn.nn	Latlong X	Double
QI_LATLONG_Y	Latlong Y	nnnnnnnn.nn	Latlong Y	Double
QI_LICID	License ID	50x	License ID	String
QI_LINS_DT	Last Inspection Date	mm/dd/yyyy hh:mm am	Last Inspection Date	DateTime
QI_LINS_TM	Last Inspection Time	mm/dd/yyyy hh:mm am	Last Inspection Time	DateTime
QI_LOCATE	General Location	100x	General Location	String
QI_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
QI_MOD_BY	Last Modified By	25x	Last Modified By	String
QI_MOD_DT	Last Modified Date	mm/dd/yyyy hh:mm am	Last Modified Date	DateTime
QI_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
QI_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
QI_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
QI_NAIC_CD	NAICS Code	10x	NAICS Code	String
QI_NAIC_TY	NAICS Text	60x	NAICS Text	String
QI_NEC	No Exposure Certification		No Exposure Certification	Boolean
QI_NINS_DT	Next Inspection Date	mm/dd/yyyy hh:mm am	Next Inspection Date	DateTime
QI_NONA	NONA		NONA	Boolean
QI_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
QI_NUMBER	Industrial ID	30x	Industrial ID	String
QI_OADDR1	Owner Contact Address 1	50x	Owner Contact Address 1	String
QI_OADDR2	Owner Contact Address 2	50x	Owner Contact Address 2	String
QI_OCITY	Owner City	100x	Owner City	String
QI_OCOMMENT	Owner Comment	250x	Owner Comment	String
QI_OEMAIL	Owner Contact Email	150x	Owner Contact Email	String
QI_OFAX	Owner Contact Fax	25x	Owner Contact Fax	String
QI_ONAME	Owner Name	50x	Owner Name	String
QI_OPERMIT	Other Permit	250x	Other Permit	String
QI_OPHONE	Owner Contact Phone	25x	Owner Contact Phone	String
QI_OPOSTAL	Owner Zip Code	15x	Owner Zip Code	String
QI_ORP	Owner/Respon Party	50x	Owner/Respon Party	String
QI_OSTATE	Owner State	30x	Owner State	String
QI_OUTDESC	Outreach Description	250x	Outreach Description	String
QI_OUTREAC	Outreach		Outreach	Boolean
QI_PERM_CD	Permit	10x	Permit	String
QI_PERM_TY	Permit Description	60x	Permit Description	String
QI_POCBV	Pollutants of Concern - Bacteria/Virus		Pollutants of Concern - Bacteria/Virus	Boolean
QI_POCHM	Pollutants of Concern - Heavy Metals		Pollutants of Concern - Heavy Metals	Boolean
QI_POCN	Pollutants of Concern - Nutrients		Pollutants of Concern - Nutrients	Boolean
QI_POCNOTE	Pollutants of Concern - Note	250x	Pollutants of Concern - Note	String
QI_POCO	Pollutants of Concern - Other		Pollutants of Concern - Other	Boolean
QI_POCOC	Pollutants of Concern - Organic Componds		Pollutants of Concern - Organic Componds	Boolean
QI_POCODS	Pollutants of Concern - Oxygen Demand Substances		Pollutants of Concern - Oxygen Demand Substances	Boolean
QI_POCOG	Pollutants of Concern - Oil & Grease		Pollutants of Concern - Oil & Grease	Boolean
QI_POCP	Pollutants of Concern - Pesticides		Pollutants of Concern - Pesticides	Boolean
QI_POCS	Pollutants of Concern - Sediments		Pollutants of Concern - Sediments	Boolean
QI_POCTD	Pollutants of Concern - Trash & Debris		Pollutants of Concern - Trash & Debris	Boolean
QI_POSTAL	Zip Code	15x	Zip Code	String
QI_PROPTAG	Property ID Tag	52x	Property ID Tag	String
QI_QA_ID	Link to Site Record	nnnnnnnn	Link to Site Record: SMQSITE	Long Integer
QI_REF	Ref/File Number	30x	Ref/File Number	String
QI_REMI_DT	Reported to RWQCB Reminder Date	mm/dd/yyyy hh:mm am	Reported to RWQCB Reminder Date	DateTime
QI_ROWVER			Rowversion for optimistic locking	TimeStamp
QI_RW_CD	Immediate Receiving Water	10x	Immediate Receiving Water	String
QI_RW_TY	Immediate Receiving Water Text	60x	Immediate Receiving Water Text	String
QI_SIC_CD	SIC Code	nnn	SIC Code	Integer
QI_SIC_TY	SIC Text	100x	SIC Text	String
QI_SRN_CD	SubReach Number	10x	SubReach Number	String
QI_SRN_TY	SubReach Number Text	60x	SubReach Number Text	String
QI_STAT_CD	Status	nnn	Status	Integer
QI_STAT_TY	Status Text	25x	Status Text	String
QI_STATE	State	30x	State	String
QI_STYPE_CD	GIS Subtype Code	nnn	GIS Subtype Code	Integer
QI_STYPE_TY	GIS Subtype Text	25x	GIS Subtype Text	String
QI_TASBS	Tributary to an Area of Speical Biological Significance (ASBS)		Tributary to an Area of Speical Biological Significance (ASBS)	Boolean
QI_TITL_CD	Title	nnn	Title	Integer
QI_TITL_TY	Title Text	50x	Title Text	String
QI_USER1CD	User 1	nnn	User 1	Integer
QI_USER1TY	User 1 Text	50x	User 1 Text	String
QI_USER2CD	User 2	nnn	User 2	Integer
QI_USER2TY	User 2 Text	50x	User 2 Text	String
QI_USER3CD	User 3	nnn	User 3	Integer
QI_USER3TY	User 3 Text	50x	User 3 Text	String
QI_USER4CD	User 4	nnn	User 4	Integer
QI_USER4TY	User 4 Text	50x	User 4 Text	String
QI_USER5CD	User 5	nnn	User 5	Integer
QI_USER5TY	User 5 Text	50x	User 5 Text	String
QI_USER6	User 6	50x	User 6	String
QI_USER7	User 7	50x	User 7	String
QI_USER8	User 8	50x	User 8	String
QI_USER9	User 9	50x	User 9	String
QI_USER10	User 10	50x	User 10	String
QI_USER11	User 11	nnnnnnnn.nn	User 11	Double
QI_USER12	User 12	nnnnnnnn.nn	User 12	Double
QI_USER13	User 13	nnnnnnnn.nn	User 13	Double
QI_USER14	User 14	nnnnnnnn.nn	User 14	Double
QI_USER15	User 15	nnnnnnnn.nn	User 15	Double
QI_USER16	User 16	mm/dd/yyyy hh:mm am	User 16	DateTime
QI_USER17	User 17	mm/dd/yyyy hh:mm am	User 17	DateTime
QI_USER18	User 18	mm/dd/yyyy hh:mm am	User 18	DateTime
QI_USER19	User 19	mm/dd/yyyy hh:mm am	User 19	DateTime
QI_USER20	User 20	mm/dd/yyyy hh:mm am	User 20	DateTime
QI_USER21	User 21		User 21	Boolean
QI_USER22	User 22		User 22	Boolean
QI_USER23	User 23		User 23	Boolean
QI_USER24	User 24		User 24	Boolean
QI_USER25	User 25		User 25	Boolean
QI_USER26CD	User 26	nnn	User 26	Integer
QI_USER26TY	User 26 Text	50x	User 26 Text	String
QI_USER27CD	User 27	nnn	User 27	Integer
QI_USER27TY	User 27 Text	50x	User 27 Text	String
QI_USER28CD	User 28	nnn	User 28	Integer
QI_USER28TY	User 28 Text	50x	User 28 Text	String
QI_USER29CD	User 29	nnn	User 29	Integer
QI_USER29TY	User 29 Text	50x	User 29 Text	String
QI_USER30CD	User 30	nnn	User 30	Integer
QI_USER30TY	User 30 Text	50x	User 30 Text	String
QI_USER31	User 31	50x	User 31	String
QI_USER32	User 32	50x	User 32	String
QI_USER33	User 33	50x	User 33	String
QI_USER34	User 34	50x	User 34	String
QI_USER35	User 35	50x	User 35	String
QI_USER36	User 36	nnnnnnnn.nn	User 36	Double
QI_USER37	User 37	nnnnnnnn.nn	User 37	Double
QI_USER38	User 38	nnnnnnnn.nn	User 38	Double
QI_USER39	User 39	nnnnnnnn.nn	User 39	Double
QI_USER40	User 40	nnnnnnnn.nn	User 40	Double
QI_USER41	User 41	mm/dd/yyyy hh:mm am	User 41	DateTime
QI_USER42	User 42	mm/dd/yyyy hh:mm am	User 42	DateTime
QI_USER43	User 43	mm/dd/yyyy hh:mm am	User 43	DateTime
QI_USER44	User 44	mm/dd/yyyy hh:mm am	User 44	DateTime
QI_USER45	User 45	mm/dd/yyyy hh:mm am	User 45	DateTime
QI_USER46	User 46		User 46	Boolean
QI_USER47	User 47		User 47	Boolean
QI_USER48	User 48		User 48	Boolean
QI_USER49	User 49		User 49	Boolean
QI_USER50	User 50		User 50	Boolean
QI_USER51CD	User 51	10x	User 51	String
QI_USER51TY	User 51 Text	60x	User 51 Text	String
QI_USER52CD	User 52	10x	User 52	String
QI_USER52TY	User 52 Text	60x	User 52 Text	String
QI_USER53CD	User 53	10x	User 53	String
QI_USER53TY	User 53 Text	60x	User 53 Text	String
QI_USER54CD	User 54	10x	User 54	String
QI_USER54TY	User 54 Text	60x	User 54 Text	String
QI_USER55CD	User 55	10x	User 55	String
QI_USER55TY	User 55 Text	60x	User 55 Text	String
QI_WDID	WDID#	30x	WDID#	String
QI_WSMPID	WQMP ID#	30x	WQMP ID#	String
QI_X	X Coordinate	nnnnnnnn.nn	X Coordinate	Double
QI_Y	Y Coordinate	nnnnnnnn.nn	Y Coordinate	Double
QI_Z	Elevation	nnnnnnnn.nn	Elevation	Double