SMVSTRUC

Structure Inventory

Field Name	Caption	Mask	Description	Field Type
SN_ACCES_CD	Access Type	nnn	Access Type	Integer
SN_ACCES_TY	Access Type Text	25x	Access Type Text	Text
SN_ACTIVE	Active		Active	Boolean
SN_ADDR1	Address 1	50x	Address 1	Text
SN_ADDR2	Address 2	50x	Address 2	Text
SN_ADDR21	Address2 1	50x	Address2 1	Text
SN_ADDR22	Address2 2	50x	Address2 2	Text
SN_ADDR23	Address2 3	50x	Address2 3	Text
SN_ADDR3	Address 3	50x	Address 3	Text
SN_ADR_B2	Street Post Bldg No	8x	Street Post Building No	Text
SN_ADR_B22	Street Post Bldg No 2	8x	Street Post Building No 2	Text
SN_ADR_BDG	Address	nnnnnnn	Address - Building Number	Long Integer
SN_ADR_DIR	Direction	2x	Address - Direction	Text
SN_ADR_PT	Street Prefix Type	5x	Address Prefix Type	Text
SN_ADR_SFX	Suffix	5x	Address - Suffix	Text
SN_ADR_STR	Street Name	50x	Address - Street Name	Text
SN_ADR_TY	Type	5x	Address - Street Type	Text
SN_ADR2_PT	Street 2 Prefix Type	5x	Address 2 Prefix Type	Text
SN_ADRDIR2	Cross Street	2x	Address2 - Direction: Direction of Street	Text
SN_ADRSFX2	Address2 - Suffix	5x	Address2 Suffix	Text
SN_ADRSTR2	Address2 - Street Nm	50x	Address2 - Street Nam: Street Name	Text
SN_ADRTY2	Address2 - Street Ty	5x	Address2 - Street Typ: Street Type: Street, Avenue, Terrace, Lane, Bvld, etc.	Text
SN_ATT_SIZ	Attribute Size	nnnn.nn	Attribute Size	Double
SN_ATT_TYP	Attribute Type	nnn	Attribute Type	Integer
SN_ATT_X	Attri X offset (ft)	nnnn.nn	Attribute X offset from Manhole (ft)	Double
SN_ATT_Y	Attri Y offset (ft)	nnnn.nn	Attribute Y offset from Manhole (ft)	Double
SN_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
SN_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
SN_BASIN	Basin	10x	Flow Basin	Text
SN_BR_CD	Default WO Cat	10x	Default Category Code	Text
SN_BR_TY	Default WO Cat Text	60x	Default Category Text	Text
SN_CELL	Cell Phone	30x	Cell Phone	Text
SN_CELL2	Cell Phone 2	30x	Cell Phone 2	Text
SN_CFREQ	Cleaning Freq	nnn	Cleaning Freq	Integer
SN_CFRQ_CD	Cleaning Freq Units	nnn	Cleaning Freq Units	Integer
SN_CFRQ_TY	Cleaning Freq Units Tex	10x	Cleaning Freq Units Tex	Text
SN_CO_ID			Link to SMCOMMENT	Long Integer
SN_COF	Consequence of Failure	nnnn.	Consequence of Failure	Double
SN_COLTYCD	Overflow Type	nnn	Overflow Type Code	Integer
SN_COLTYTY	Overflow Type Text	25x	Overflow Type Text	Text
SN_COV_DIA	Cover Opening	nnn.nn	Cover Diameter	Double
SN_COVR_CD	Cover Type	nnn	Cover Type Code	Integer
SN_COVR_TY	Cover Type Text	25x	Cover Type Text	Text
SN_CREW	Collected By	30x	Person collecting the information	Text
SN_CRT_BY	Created By	25x	Created By	Text
SN_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
SN_CUTDEPTH	Pavement Cut Depth	nnnnnnnnn.nn	Pavement Cut Depth	Double
SN_D_AREA	Inlet Area	nnnn.nn	Total Drainage Area to Structure	Double
SN_DAREA	Drainage Area	30x	Drainage Area	Text
SN_DEPTH	Struct Depth (ft)	nnn.nn	Depth of the Structure	Double
SN_DISCHP	Discharge Point		Discharge Point (TRUE = Yes)	Boolean
SN_DOC_FLG	Document Available		Doc Available: Doc Flag	Boolean
SN_DT_COLL	Collection Date	mm/dd/yyyy	Date information was collected	Date/Time
SN_DT_NEXT	Next Mon. Date	mm/dd/yyyy	Next monitoring Date	Date/Time
SN_EMAIL	Email	150x	Email Address	Text
SN_EMAIL2	Email 2	150x	Email 2	Text
SN_FAC_CD	Facility	nnn	Facility Code	Integer
SN_FAC_TY	Facility Text	25x	Facility Text	Text
SN_FASSET	Fixed Asset ID	nnnnnnnn	Fixed Asset ID	Long Integer
SN_FLOWSUM	Flow Summary	nnnnnnnnn.nn	Flow Summary	Double
SN_FUNC_CD	Owner	nnn	Owner Code	Integer
SN_FUNC_TY	Owner Text	25x	Owner Text	Text
SN_GPS	GPS Flag		Has Structure been GPSed?	Boolean
SN_HIGHELE	High Pipe Elevation	nnnnnnnnn.nn	High Pipe Elevation	Double
SN_ID	Structure Rec #	nnnnnnnn	Unique ID	Long Integer
SN_IFREQ	Inspection Freq	nnn	Inspection Freq	Integer
SN_IFRQ_CD	Inspection Freq Units	nnn	Inspection Freq Units	Integer
SN_IFRQ_TY	Inspection Freq Units Text	10x	Inspection Freq Units Text	String
SN_IMG_FLG			Image Available	Boolean
SN_IN	# of In Conduits	nn	# of Conduits flowing into the structure	Integer
SN_INMAP	In Map?		Flag indicating this feature is in the map	Boolean
SN_INSN_DT	Next Inspection	mm/dd/yyyy	Next Inspection Date	Date/Time
SN_INSP_CD	Last Condition	nnn	Last Condition	Integer
SN_INSP_DT	Last Inspection	mm/dd/yyyy	Last Inspection Date	Date/Time
SN_INSP_TY	Last Condition Text	25x	Last Condition Text	Text
SN_INST_DT	Installation Date	mm/dd/yyyy	Installation Date	Date/Time
SN_INVELE	Invert Elevation	nnnnnnnnn.nn	Invert Elevation	Double
SN_IS_CD	Illicit Status	nnn	Illicit Status	Integer
SN_IS_TY	Illicit Status Text	25x	Illicit Status Text	Text
SN_IT_CD	Illicit Type	nnn	Illicit Type	Integer
SN_IT_TY	Illicit Type Text	25x	Illicit Type Text	Text
SN_LCLN_DT	Last Cleaning Date	mm/dd/yyyy	Last Cleaning Date	Date/Time
SN_LENGTH	Inside Length (in)	nnnn.nn	Length of the Structure	Double
SN_LINED	Lined		Lined	Boolean
SN_LINR_CD	Street Slope	nnn	Street Slope Code	Integer
SN_LINR_TY	Street Slope Text	25x	Street Slope Text	Text
SN_LOC_CD	Location	nnn	Location Code	Integer
SN_LOC_TY	Location Text	25x	Location Text	Text
SN_LOCATIO	Gen. Location	200x	General location of Structure	Text
SN_LOT_LOC	Lot Location	3x	Location in relation to the lot in address	Text
SN_LUSE_CD	Land Use	nnn	Land Use	Integer
SN_LUSE_TY	Land Use Text	30x	Land Use Text	Text
SN_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
SN_MACP_DT	MACP Date	mm/dd/yyyy	Last MACP Date	Date/Time
SN_MANG_CD	Managed By	nnn	Managed By	Integer
SN_MANG_TY	Managed By Text	25x	Managed By Text	Text
SN_MANX_DT	Next MACP	mm/dd/yyyy	Next MACP Date	Date/Time
SN_MAP_REF	Map Ref No.	15x	Map or Grid structure is located in	Text
SN_MATR_CD	Wall Material	nnn	Wall Material Code	Integer
SN_MATR_TY	Wall Material Text	25x	Wall Material Text	Text
SN_MITIGAT	Mitigation	nnnnnnnn.nn	Mitigation	Double
SN_MOD_BY	Modified By	25x	Modified By	Text
SN_MOD_DT	Modified Date	mm/dd/yyyy	Modified Date	Date/Time
SN_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
SN_MONSITE	Monitoring Site?		Is the structure a monitoring site?	Boolean
SN_MOV_FLG			Movie Available	Boolean
SN_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
SN_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
SN_NAME	Name	30x	Name	Text
SN_NAME2	Name 2	30x	Name 2	Text
SN_NCLN_DT	Next Cleaning Date	mm/dd/yyyy	Next Cleaning Date	Date/Time
SN_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
SN_NPDES	NPDES Permit?		Is structure included in NPDES permitting	Boolean
SN_O_TO	Outlet To	25x	This structure outlets to what?	Text
SN_OT_CD	Outfall Type	nnn	Outfall Type	Integer
SN_OT_TY	Outfall Type Text	25x	Outfall Type Text	Text
SN_OUT	# of Out Conduits	nn	# of Conduits flowing out of the structure	Integer
SN_OUTDIA	Outfall Diameter	nnnn.nn	Outfall Diameter	Double
SN_OUTFALL	Outfall Location	100x	Outfall Location	Text
SN_OUTHEI	Outfall Height	nnnn.nn	Outfall Height	Double
SN_OUTWID	Outfall Width	nnnn.nn	Outfall Width	Double
SN_PA_ID	Plant Rec #	nnnnnnnn	Link to EFPLANT.PA_ID	Long Integer
SN_PARENTOFFLINE	Parent Off-Line Flag		Parent Off-Line Flag	Boolean
SN_PER_IMP	% Impervious	nnn.nn	Drainage Area Percent Impervious	Double
SN_PERNO	Overflow Conn.	30x	Where does overflow go to	Text
SN_PHONE	Phone	30x	Phone	Text
SN_PHONE2	Phone 2	30x	Phone 2	Text
SN_POF	Probability of Failure	nnn.nn	Probability of Failure	Double
SN_POSTAL	Zip Code	15x	Zip Code	Text
SN_PP_ID	Process Rec #	nnnnnnnn	Link to EFPLANTP.PP_ID	Long Integer
SN_PROJ_NO	Project Number	50x	Project Number	String
SN_PROM	Structure O&&M	nnn.n	MACP Ratings O&M	Double
SN_PROPTAG		52x	Property ID Tag	Text
SN_PRS	Structure Structural	nnn.n	MACP Ratings Structural	Double
SN_PRT	Structure Total	nnn.n	MACPRatings Total	Double
SN_PVALUE	Present Value	nnnnnnnnn.nn	Present Value	Double
SN_QROM	Quick O&&M	30x	MACP Quick Rating O&M	Text
SN_QRS	Quick Structural	30x	MACP Quick Rating Structural	Text
SN_QRT	Quick Total	30x	MACP Quick Rating Total	Text
SN_RCOST	Replacement Cost	nnnnn.nn	Replacement Cost	Double
SN_REAS_CD	Reason	nnn	Sampling Reason	Integer
SN_REAS_TY	Reason Text	25x	Sampling Reason Text	Text
SN_REG_CD	Regulatory Type	nnn	Sampling Regulation Type	Integer
SN_REG_TY	Regulatory Type Text	25x	Sampling Regulation Type Text	Text
SN_REPL_DT	Replacement Date	mm/dd/yyyy	Replacement Date	Date/Time
SN_RIM_CD	Rim Status	nnn	Rim Elevation Status Code	Integer
SN_RIM_ELE	Rim Elevation	nnnn.nn	Elevation of the Structure Rim	Double
SN_RIM_TY	Rim Status Text	25x	Rim Elevation Status Text	Text
SN_RISK	Risk	nnnn.	Risk - COF * POF	Double
SN_RLIFE	Remaining Life	nnnn.nn	Remaining Life	Double
SN_ROWVER			Rowversion for optimistic locking	Date/Time
SN_RVALUE	Replacement Value	nnnnnnnnn.nn	Replacement Value	Double
SN_SEWID	San MH Rec #	nnnnnnn	Link to SWNETMH.MA_ID	Long Integer
SN_SEWSTRC	San Sewer Conn.		Does this structure exist in Sewer Manhole?	Boolean
SN_ST_NO	Structure #	30x	Storm Structure Number	Text
SN_STAT_CD	Status	nnn	Structure Status Code	Integer
SN_STAT_TY	Status Text	25x	Structure Status Text	Text
SN_STRM_CD	Receiving Stream	6x	Receiving Stream	Text
SN_STRM_TY	Receiving Stream Text	50x	Receiving Stream Text	Text
SN_STYPE_CD	Subtype	nnn	GIS Subtype Code	Integer
SN_STYPE_TY	Subtype Text	25x	GIS Subtype Text	Text
SN_SURF_CD	Surface Type	nnn	Surface Type Code	Integer
SN_SURF_TY	Surface Type Text	25x	Surface Type Text	Text
SN_TAKEOFFLINE	Take Off-Line Flag		Take Off-Line Flag	Boolean
SN_TOT_CAP	Capacity	nnnn.nn	Total Inlet capacity for entire structure	Double
SN_TOT_IMP	Total % Impervious	nnn.nn	Total % Impervious (Field currently not used)	Double
SN_TRACKNO	Tracking No	30x	Sampling Tracking No	Text
SN_TYPE_CD	Structure Type	nnn	Structure Type Code	Integer
SN_TYPE_TY	Structure Type Text	25x	Structure Type Text	Text
SN_USER1CD	User 1	nnn	User 1	Integer
SN_USER1TY	User 1 Text	25x	User 1 Text	Text
SN_USER2CD	User 2	nnn	User 2	Integer
SN_USER2TY	User 2 Text	25x	User 2 Text	Text
SN_USER3CD	User 3	nnn	User 3	Integer
SN_USER3TY	User 3 Text	25x	User 3 Text	Text
SN_USER4	User 4	30x	User 4	Text
SN_USER5	User 5	30x	User 5	Text
SN_USER6	User 6	30x	User 6	Text
SN_USER7	User 7	nnnnnnnnn.nn	User 7	Double
SN_USER8	User 8	nnnnnnnnn.nn	User 8	Double
SN_USER9	User 9	nnnnnnnnn.nn	User 9	Double
SN_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
SN_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
SN_USER12	User 12	mm/dd/yyyy	User 12	Date/Time
SN_USER13	User 13		User 13	Boolean
SN_USER14	User 14		User 14	Boolean
SN_USER15	User 15		User 15	Boolean
SN_USER16CD	User 16	nnn	User 16	Integer
SN_USER16TY	User 16 Text	25x	User 16 Text	Text
SN_USER17CD	User 17	nnn	User 17	Integer
SN_USER17TY	User 17 Text	25x	User 17 Text	Text
SN_USER18CD	User 18	nnn	User 18	Integer
SN_USER18TY	User 18 Text	25x	User 18 Text	Text
SN_USER19CD	User 19	nnn	User 19	Integer
SN_USER19TY	User 19 Text	25x	User 19 Text	Text
SN_USER20CD	User 20	nnn	User 20	Integer
SN_USER20TY	User 20 Text	25x	User 20 Text	Text
SN_USER21	User 21	30x	User 21	Text
SN_USER22	User 22	30x	User 22	Text
SN_USER23	User 23	30x	User 23	Text
SN_USER24	User 24	30x	User 24	Text
SN_USER25	User 25	30x	User 25	Text
SN_USER26	User 26	nnnnnnnn.nn	User 26	Double
SN_USER27	User 27	nnnnnnnn.nn	User 27	Double
SN_USER28	User 28	nnnnnnnn.nn	User 28	Double
SN_USER29	User 29	nnnnnnnn.nn	User 29	Double
SN_USER30	User 30	nnnnnnnn.nn	User 30	Double
SN_USER31	User 31	mm/dd/yyyy	User 31	Date/Time
SN_USER32	User 32	mm/dd/yyyy	User 32	Date/Time
SN_USER33	User 33	mm/dd/yyyy	User 33	Date/Time
SN_USER34	User 34	mm/dd/yyyy	User 34	Date/Time
SN_USER35	User 35	mm/dd/yyyy	User 35	Date/Time
SN_USER36	User 36		User 36	Boolean
SN_USER37	User 37		User 37	Boolean
SN_USER38	User 38		User 38	Boolean
SN_USER39	User 39		User 39	Boolean
SN_USER40	User 40		User 40	Boolean
SN_USER41CD	User 41	10x	User 41	String
SN_USER41TY	User 41 Text	60x	User 41 Text	String
SN_USER42CD	User 42	10x	User 42	String
SN_USER42TY	User 42 Text	60x	User 42 Text	String
SN_USER43CD	User 43	10x	User 43	String
SN_USER43TY	User 43 Text	60x	User 43 Text	String
SN_USER44CD	User 44	10x	User 44	String
SN_USER44TY	User 44 Text	60x	User 44 Text	String
SN_USER45CD	User 45	10x	User 45	String
SN_USER45TY	User 45 Text	60x	User 45 Text	String
SN_WIDTH	Inside Width (in)	nnnn.nn	Width of the Structure	Double
SN_WL_THK	Wall Thick (in)	nn.nn	Thickness of Structure Walls	Double
SN_WO_COMM	WO Comment	255x	This short comment gets copied to work orders	Text
SN_X	X coordinate	-nnnnnnnnn.nnnnnnnn	X coordinate: X coordinates if different from Easting	Double
SN_Y	Y coordinate	-nnnnnnnnn.nnnnnnnn	Y coordinate: Y coordinates if different from Northing	Double