SMQS

Storm Water Quality Construction Site Inventory

Field Name	Caption	Mask	Description	Field Type
QS_1602	1602 Permit		1602 Permit	Boolean
QS_303DP	303D Pollutants	250x	303D Pollutants	String
QS_401	401 Permit/Cert		401 Permit/Cert	Boolean
QS_404	404 Permit		404 Permit	Boolean
QS_AACCOUNT	Asset Account #	45x	Asset Account #	Text
QS_ACT_DT	Active Date	mm/dd/yyyy hh:mm am	Active Date	DateTime
QS_ACTIVE	Active Project		Active Project	Boolean
QS_ADR_B2	Street Post Building No	8x	Street Post Building No	String
QS_ADR_B22	Street 2 Post Building No	8x	Street 2 Post Building No	String
QS_ADR_BDG	Address	nnnnnnnn	Address	Long Integer
QS_ADR_DIR	Street Direction	2x	Street Direction	String
QS_ADR_PT	Street Prefix	5x	Street Prefix	String
QS_ADR_SFX	Street Suffix	5x	Street Suffix	String
QS_ADR_STR	Street Name	50x	Street Name	String
QS_ADR_TY	Street Type	5x	Street Type	String
QS_ADR2_PT	Street 2 Prefix Type	5x	Street 2 Prefix Type	String
QS_ADRBDG2	Address 2	nnnnnnnn	Address 2	Long Integer
QS_ADRDIR2	Street Direction 2	2x	Street Direction 2	String
QS_ADRSFX2	Street Suffix 2	5x	Street Suffix 2	String
QS_ADRSTR2	Street Name 2	50x	Street Name 2	String
QS_ADRTY2	Street Type 2	5x	Street Type 2	String
QS_APN	APN	40x	APN	String
QS_APNUMACT	Asset Proj No - Acct	40x	Asset Proj No - Acct	Text
QS_AREA	Area	nnnnnnnn.nn	Area	Double
QS_AUNT_CD	Area Units	nnn	Area Units	Integer
QS_AUNT_TY	Area Units Text	10x	Area Units Text	String
QS_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
QS_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
QS_BR_CD	Default Category Code	10x	Default Category Code	String
QS_BR_TY	Default Category Code	60x	Default Category Code	String
QS_CADDR1	Contact Address 1	50x	Contact Address 1	String
QS_CADDR2	Contact Address 2	50x	Contact Address 2	String
QS_CCITY	City	100x	City	String
QS_CEMAIL	Contact Email	150x	Contact Email	String
QS_CFAX	Contact Fax	25x	Contact Fax	String
QS_CITY	City	100x	City	String
QS_CMOBILE	Contact Mobile/Cell Phone	25x	Contact Mobile/Cell Phone	String
QS_CNAME	Contact Name	50x	Contact Name	String
QS_CNOT_CD	Notification	nnn	Notification	Integer
QS_CNOT_DT	Notification Date	mm/dd/yyyy hh:mm am	Notification Date	DateTime
QS_CNOT_TY	Notification Text	50x	Notification Text	String
QS_COND_CD	Condition	nnn	Condition	Integer
QS_COND_TY	Condition Text	100x	Condition Text	Text
QS_CPHONE	Contact Phone	25x	Contact Phone	String
QS_CPOSTAL	Zip Code	15x	Zip Code	String
QS_CRT_BY	Created By	25x	Created By	String
QS_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
QS_CSTATE	State	30x	State	String
QS_CSTREET	Cross Street	50x	Cross Street	String
QS_DFIRW	Distance from Immediate Receiving Water	nnnnnnnn.nn	Distance from Immediate Receiving Water	Double
QS_DOC_FLG	Document Flag		Document Flag	Boolean
QS_DRW303DL	Are Downstream Receiving Waters 303D Listed?		Are Downstream Receiving Waters 303D Listed?	Boolean
QS_DUNT_CD	Distance Units	nnn	Distance Units	Integer
QS_DUNT_TY	Distance Units Text	10x	Distance Units Text	String
QS_FLLW_DT	Follow-up Date	mm/dd/yyyy hh:mm am	Follow-up Date	DateTime
QS_GCONT	General Contractor	50x	General Contractor	String
QS_GISNEED_CD	Needs GIS	nnn	Needs GIS	Integer
QS_GISNEED_TY	Needs GIS Text	100x	Needs GIS Text	Text
QS_ID	Construct Site Record No	nnnnnnnn	Auto ID	Long Integer
QS_IFREQ	Inspection Freq	nnn	Inspection Freq	Integer
QS_IFRQ_CD	Inspection Freq Units	nnn	Inspection Freq Units	Integer
QS_IFRQ_TY	Inspection Freq Units Text	10x	Inspection Freq Units Text	String
QS_INAC_DT	Inactive Date	mm/dd/yyyy hh:mm am	Inactive Date	DateTime
QS_INMAP	Flag indicating this feature is in the map		Flag indicating this feature is in the map	Boolean
QS_IRW303DL	Are Immediate Receiving Waters 303D Listed?		Are Immediate Receiving Waters 303D Listed?	Boolean
QS_LATLONG_X	Latlong X	nnnnnnnn.nn	Latlong X	Double
QS_LATLONG_Y	Latlong Y	nnnnnnnn.nn	Latlong Y	Double
QS_LINS_DT	Last Inspection Date	mm/dd/yyyy hh:mm am	Last Inspection Date	DateTime
QS_LINS_TM	Last Inspection Time	mm/dd/yyyy hh:mm am	Last Inspection Time	DateTime
QS_LOCATE	General Location	200x	General Location	String
QS_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
QS_MOD_BY	Last Modified By	25x	Last Modified By	String
QS_MOD_DT	Last Modified Date	mm/dd/yyyy hh:mm am	Last Modified Date	DateTime
QS_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
QS_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
QS_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
QS_NINS_DT	Next Inspection Date	mm/dd/yyyy hh:mm am	Next Inspection Date	DateTime
QS_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
QS_NUMBER	Construction Site ID	30x	Construction Site ID	String
QS_OADDR1	Owner Contact Address 1	50x	Owner Contact Address 1	String
QS_OADDR2	Owner Contact Address 2	50x	Owner Contact Address 2	String
QS_OCITY	Owner City	100x	Owner City	String
QS_OCOMMENT	Owner Comment	250x	Owner Comment	String
QS_OEMAIL	Owner Contact Email	150x	Owner Contact Email	String
QS_OFAX	Owner Contact Fax	25x	Owner Contact Fax	String
QS_ONAME	Owner Name	50x	Owner Name	String
QS_OPERMIT	Other Permit	250x	Other Permit	String
QS_OPHONE	Owner Contact Phone	25x	Owner Contact Phone	String
QS_OPOSTAL	Owner Zip Code	15x	Owner Zip Code	String
QS_ORP	Owner/Respon Party	50x	Owner/Respon Party	String
QS_OSTATE	Owner State	30x	Owner State	String
QS_OTITL_CD	Owner Title	nnn	Owner Title	Integer
QS_OTITL_TY	Owner Title Text	50x	Owner Title Text	String
QS_OUTDESC	Outreach Description	250x	Outreach Description	String
QS_OUTREAC	Outreach		Outreach	Boolean
QS_PERM_CD	Permit	10x	Permit	String
QS_PERM_TY	Permit Text	60x	Permit Text	String
QS_PJ_ID	Work Project Rec#	nnnnnnnn	Link to WKPROJ.PJ_ID	Long Integer
QS_POSTAL	Zip Code	15x	Zip Code	String
QS_PP_ID	Work Permit Rec#	nnnnnnnn	Link to WKPERMIT.PP_ID	Long Integer
QS_QA_ID	Link to Site Record	nnnnnnnn	Link to Site Record: SMQSITE	Long Integer
QS_REF	Ref/File Number	30x	Ref/File Number	String
QS_ROWVER			Rowversion for optimistic locking	TimeStamp
QS_RW_CD	Immediate Receiving Water	10x	Immediate Receiving Water	String
QS_RW_TY	Immediate Receiving Water Text	60x	Immediate Receiving Water Text	String
QS_SRN_CD	SubReach Number	10x	SubReach Number	String
QS_SRN_TY	SubReach Number Text	60x	SubReach Number Text	String
QS_STAT_CD	Status	nnn	Status	Integer
QS_STAT_TY	Status Text	25x	Status Text	String
QS_STATE	State	30x	State	String
QS_STYPE_CD	GIS Subtype Code	nnn	GIS Subtype Code	Integer
QS_STYPE_TY	GIS Subtype Text	25x	GIS Subtype Text	String
QS_TASBS	Tributary to an Area of Speical Biological Significance (ASBS)		Tributary to an Area of Speical Biological Significance (ASBS)	Boolean
QS_TITL_CD	Title	nnn	Title	Integer
QS_TITL_TY	Title Text	50x	Title Text	String
QS_USER1CD	User 1	nnn	User 1	Integer
QS_USER1TY	User 1 Text	50x	User 1 Text	String
QS_USER2CD	User 2	nnn	User 2	Integer
QS_USER2TY	User 2 Text	50x	User 2 Text	String
QS_USER3CD	User 3	nnn	User 3	Integer
QS_USER3TY	User 3 Text	50x	User 3 Text	String
QS_USER4CD	User 4	nnn	User 4	Integer
QS_USER4TY	User 4 Text	50x	User 4 Text	String
QS_USER5CD	User 5	nnn	User 5	Integer
QS_USER5TY	User 5 Text	50x	User 5 Text	String
QS_USER6	User 6	50x	User 6	String
QS_USER7	User 7	50x	User 7	String
QS_USER8	User 8	50x	User 8	String
QS_USER9	User 9	50x	User 9	String
QS_USER10	User 10	50x	User 10	String
QS_USER11	User 11	nnnnnnnn.nn	User 11	Double
QS_USER12	User 12	nnnnnnnn.nn	User 12	Double
QS_USER13	User 13	nnnnnnnn.nn	User 13	Double
QS_USER14	User 14	nnnnnnnn.nn	User 14	Double
QS_USER15	User 15	nnnnnnnn.nn	User 15	Double
QS_USER16	User 16	mm/dd/yyyy hh:mm am	User 16	DateTime
QS_USER17	User 17	mm/dd/yyyy hh:mm am	User 17	DateTime
QS_USER18	User 18	mm/dd/yyyy hh:mm am	User 18	DateTime
QS_USER19	User 19	mm/dd/yyyy hh:mm am	User 19	DateTime
QS_USER20	User 20	mm/dd/yyyy hh:mm am	User 20	DateTime
QS_USER21	User 21		User 21	Boolean
QS_USER22	User 22		User 22	Boolean
QS_USER23	User 23		User 23	Boolean
QS_USER24	User 24		User 24	Boolean
QS_USER25	User 25		User 25	Boolean
QS_USER26CD	User 26	nnn	User 26	Integer
QS_USER26TY	User 26 Text	50x	User 26 Text	String
QS_USER27CD	User 27	nnn	User 27	Integer
QS_USER27TY	User 27 Text	50x	User 27 Text	String
QS_USER28CD	User 28	nnn	User 28	Integer
QS_USER28TY	User 28 Text	50x	User 28 Text	String
QS_USER29CD	User 29	nnn	User 29	Integer
QS_USER29TY	User 29 Text	50x	User 29 Text	String
QS_USER30CD	User 30	nnn	User 30	Integer
QS_USER30TY	User 30 Text	50x	User 30 Text	String
QS_USER31	User 31	50x	User 31	String
QS_USER32	User 32	50x	User 32	String
QS_USER33	User 33	50x	User 33	String
QS_USER34	User 34	50x	User 34	String
QS_USER35	User 35	50x	User 35	String
QS_USER36	User 36	nnnnnnnn.nn	User 36	Double
QS_USER37	User 37	nnnnnnnn.nn	User 37	Double
QS_USER38	User 38	nnnnnnnn.nn	User 38	Double
QS_USER39	User 39	nnnnnnnn.nn	User 39	Double
QS_USER40	User 40	nnnnnnnn.nn	User 40	Double
QS_USER41	User 41	mm/dd/yyyy hh:mm am	User 41	DateTime
QS_USER42	User 42	mm/dd/yyyy hh:mm am	User 42	DateTime
QS_USER43	User 43	mm/dd/yyyy hh:mm am	User 43	DateTime
QS_USER44	User 44	mm/dd/yyyy hh:mm am	User 44	DateTime
QS_USER45	User 45	mm/dd/yyyy hh:mm am	User 45	DateTime
QS_USER46	User 46		User 46	Boolean
QS_USER47	User 47		User 47	Boolean
QS_USER48	User 48		User 48	Boolean
QS_USER49	User 49		User 49	Boolean
QS_USER50	User 50		User 50	Boolean
QS_USER51CD	User 51	10x	User 51	String
QS_USER51TY	User 51 Text	60x	User 51 Text	String
QS_USER52CD	User 52	10x	User 52	String
QS_USER52TY	User 52 Text	60x	User 52 Text	String
QS_USER53CD	User 53	10x	User 53	String
QS_USER53TY	User 53 Text	60x	User 53 Text	String
QS_USER54CD	User 54	10x	User 54	String
QS_USER54TY	User 54 Text	60x	User 54 Text	String
QS_USER55CD	User 55	10x	User 55	String
QS_USER55TY	User 55 Text	60x	User 55 Text	String
QS_WDID	WDID#	30x	WDID#	String
QS_WQP_CD	WQ Priority	nnn	WQ Priority	Integer
QS_WQP_TY	WQ Priority Text	50x	WQ Priority Text	String
QS_WSMPID	WQMP ID#	30x	WQMP ID#	String
QS_X	X Coordinate	nnnnnnnn.nn	X Coordinate	Double
QS_Z	Elevation	nnnnnnnn.nn	Elevation	Double