SWSERV

Service Laterals Inventory

Field Name	Caption	Mask	Description	Field Type
SV_ACTIVE	Active		Active Flag	Boolean
SV_ADD_NO	Address Count	nn	Address Count	Integer
SV_ADDID	Address Rec #		Link to CMADDR.AD_ID	Long Integer
SV_ADR_APT	Apartment No	8x	Apartment Number	Text
SV_ADR_B2	Street Post Bldg No	8x	Street Post Building No	Text
SV_ADR_BDG	Address	nnnnnn	Address : Building Number	Long Integer
SV_ADR_DIR	Street Direction	2x	Address - Direction	Text
SV_ADR_PT	Street Prefix Type	5x	Street Prefix Type	Text
SV_ADR_SFX	Street Suffix	5x	Address - Suffix	Text
SV_ADR_STR	Street Name	50x	Address - Street Name	Text
SV_ADR_TY	Street Type	5x	Address - Street Type	Text
SV_ALCT_CD	Alley Cut	nnn	Alley Cut Code	Integer
SV_ALCT_TY	Alley Cut Text	25x	Alley Cut Text	Text
SV_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
SV_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
SV_BASIN	Flow Basin	25x	Flow Basin	Text
SV_BR_CD	Default WO Cat	10x	Default Category Code	Text
SV_BR_TY	Default WO Cat Text	60x	Default Category Text	Text
SV_CDIR_CD	Dir from Main	nnn	Direction from Main : Direction from Line Segment Code	Integer
SV_CDIR_TY	Dir from Main Text	25x	Dir. from Main Text : Direction from Line Segment Description	Text
SV_CFREQ	Cleaning Freq	nnn	Cleaning Freq	Integer
SV_CFRQ_CD	Cleaning Freq Units	nnn	Cleaning Freq Units	Integer
SV_CFRQ_TY	Cleaning Freq Units Tex	10x	Cleaning Freq Units Tex	Text
SV_CITY_CD	Facility	nnn	Facility Code	Integer
SV_CITY_TY	Facility Text	50x	Facility Description	Text
SV_COF	Consequence of Failure	nnnn.	Consequence of Failure	Double
SV_CON_CD	Connection Type	nnn	Connection Type Code	Integer
SV_CON_DST	Dist from Structure	nnnn.n	Dist from Manhole	Double
SV_CON_NO	Lateral No.	nnn	Lateral #	Integer
SV_CON_TY	Connection Text	25x	Connection Type Text	Text
SV_CONNID	Service Conn Rec #		Link to SWSCONN.SX_ID	Long Integer
SV_CRT_BY	Created By	25x	Created By	Text
SV_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
SV_CTO_CD	Connected To	nnn	Connected To - Pipe, Manhole, Other?	Integer
SV_CTO_TY	Connected To Text	25x	Connected To Text	Text
SV_DIA	Diameter (in)	nnnn.n	Diameter (in)	Double
SV_DIR	Angle from Main	nnn	Angle from Main	Integer
SV_DIR_CD	Measured From	nnn	Dist Measured From	Integer
SV_DIR_TY	Measured From Text	25x	Dist Measured From Text	Text
SV_DIST	Distance	nnnn	Distance	Integer
SV_DOC_FLG	Document Available		Document Available	Boolean
SV_DPTH_EN	Depth at End	nnnn.n	Depth at End : If Different from PL	Double
SV_DPTH_MN	Depth at Main	nnnn.n	Depth at Main : Service Depth at the Main	Double
SV_DPTH_PL	Depth at PL	nnnn.n	Depth at PL	Double
SV_DRN_CD	Drains	nnn	Drains Code	Integer
SV_DRN_TY	Drains Text	25x	Drains Text	Text
SV_DS_DIST	Dist from DS Struct	-nnnn.n	Dist from DS MH : Distance from DS Manhole	Double
SV_DT_INSP	Date Inspected	mm/dd/yyyy	Date Inspected	Date/Time
SV_FASSET	Fixed Asset ID	nnnnnnnn	Fixed Asset ID	Long Integer
SV_GREASE	Grease Interceptor	nnnnnnn	Grease Interceptor	Long Integer
SV_GWCL_CD	Groundwtr Cleanup	nnn	Groundwater Cleanup Code	Integer
SV_GWCL_TY	GW Cleanup Text	25x	Groundwater Cleanup Text	Text
SV_IFREQ	Inspection Freq	nnn	Inspection Freq	Integer
SV_IFRQ_CD	Inspection Freq Units	nnn	Inspection Freq Units	Integer
SV_IFRQ_TY	Inspection Freq Units Text	10x	Inspection Freq Units Text	String
SV_IMG_FLG			Image Available	Boolean
SV_INMAP	In Map?		Flag indicating this feature is in the map	Boolean
SV_INSN_DT	Next Inspection Date	mm/dd/yyyy hh:mm am	Next Inspection Date	DateTime
SV_INSP_CD	Inspected By	nnn	Inspected By	Integer
SV_INSP_NO	Inspection Number	10x	Inspection Number	Text
SV_INSP_TY	Inspected By Text	25x	Inspected By Text	Text
SV_INST1	Instructions 1	254x	Instructions 1	Text
SV_INST2	Instructions 2	254x	Instructions 2	Text
SV_INST3	Instructions 3	254x	Instructions 3	Text
SV_INST4	Instructions 4	254x	Instructions 4	Text
SV_INST5	Instructions 5	254x	Instructions 5	Text
SV_INSTALL	Date Installed	mm/dd/yyyy	Date Installed	Date/Time
SV_LCLN_DT	Last Cleaning Date	mm/dd/yyyy	Last Cleaning Date	Date/Time
SV_LENGTH	Length (ft)	nnnn.n	Length (ft)	Double
SV_LINR_CD	Line Type	nnn	Line Type Code	Integer
SV_LINR_TY	Line Type Text	30x	Line Type Text	Text
SV_LOCATIO	Gen Location	100x	General Location	Text
SV_LOT	Lot Number	20x	Lot Number	Text
SV_MA_ID	Structure Rec #	nnnnnnnn	Link to SWNETMH.MA_MHID	Long Integer
SV_MANG_CD	Managed By	nnn	Managed By Code	Integer
SV_MANG_TY	Managed By Text	25x	Managed By Text	Text
SV_MAT_CD	Pipe Material	nnn	Pipe Material Code	Integer
SV_MAT_TY	Pipe Material Text	25x	Pipe Material Text	Text
SV_MAX_FT			Maximum Observation Length (ft)	Double
SV_MAX_OBS			Maximum Observation #	Integer
SV_MITIGAT	Mitigation	nnnnnnnn.nn	Mitigation	Double
SV_MOD_BY	Modified By	25x	Modified By	Text
SV_MOD_DT	Modified Date	mm/dd/yyyy	Modified Date	Date/Time
SV_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
SV_MOV_FLG			Movie Available	Boolean
SV_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
SV_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
SV_NCLN_DT	Next Cleaning Date	mm/dd/yyyy	Next Cleaning Date	Date/Time
SV_NETID	Pipe Rec #		Link to SWNET.NT_ID	Long Integer
SV_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
SV_OADDR1	Owner Address 1	50x	Owner Address 1	Text
SV_OADDR2	Owner Address 2	50x	Owner Address 2	Text
SV_OADDR3	Owner Address 3	50x	Owner Address 3	Text
SV_OBUS	Owner Business	50x	Owner Business	Text
SV_OEMAIL	Owner E-mail	150x	Owner E-Mail	Text
SV_ONAME	Owner Name	50x	Owner Name	Text
SV_OPHONE1	Owner Phone 1	25x	Owner Phone 1	Text
SV_OPHONE2	Owner Phone 2	25x	Owner Phone 2	Text
SV_OPHONE3	Owner Phone 3	25x	Owner Phone 3	Text
SV_OPHONE4	Owner Phone 4	25x	Owner Phone 4	Text
SV_OWN_CD	Owned By	nnn	Owned By Code	Integer
SV_OWN_TY	Owned By Text	25x	Owned By Text	Text
SV_POF	Probability of Failure	nnn.nn	Probability of Failure	Double
SV_POSTAL	Zip Code	15x	Zip Code	Text
SV_PRETRCD	Pretreatment	nnn	Pretreatment Code	Integer
SV_PRETRTY	Pretreatment Text	25x	Pretreatment Text	Text
SV_PROPTAG	Property ID Tag	20x	Property ID Tag	Text
SV_PVALUE	Present Value	nnnnnnnn.nn	Present Value	Double
SV_RCOST	Replacement Cost	nnnnn.nn	Replacement Cost	Double
SV_REPL_DT	Replacement Date	mm/dd/yyyy	Replacement Date	Date/Time
SV_RESN_CD	Connection Reason	nnn	Connection Reason Code	Integer
SV_RESN_TY	Connect Reason Text	25x	Connection Reason Text	Text
SV_RISK	Risk	nnnn.	Risk - COF * POF	Double
SV_RLIFE	Remaining Life	nnnn.nn	Remaining Life	Double
SV_ROWVER			Rowversion for optimistic locking	Date/Time
SV_RSLT_CD	Insp Results	nnn	Inspection Results Code	Integer
SV_RSLT_TY	Insp Results Text	25x	Inspection Results Text	Text
SV_RVALUE	Replacement Value	nnnnnnnnn.nn	Replacement Value	Double
SV_SEPA_CD	Separator	nnn	Separator Code	Integer
SV_SEPA_TY	Separator Text	25x	Separator Text	Text
SV_SEPT_CD	Septic Tank Filled	nnn	Septic Tank Filled Code	Integer
SV_SEPT_FL	Date Septic Filled	mm/dd/yyyy	Date Septic Filled	Date/Time
SV_SEPT_TY	Sptic Tank Fill Text	25x	Septic Tank Fill Text	Text
SV_SERVID	Service Rec #	nnnnnnnn	Unique ID	Long Integer
SV_SLOPE	Slope / Fall %	nn.nnn	Slope / Fall %	Double
SV_STAT_CD	Source of Data	nnn	Source of Data Code	Integer
SV_STAT_TY	Source of Data Text	25x	Source of Data Text	Text
SV_STCT_CD	Street Cut	nnn	Street Cut Code	Integer
SV_STCT_TY	Street Cut Text	25x	Street Cut Text	Text
SV_STRC_CD	Structure Type	nnn	Structure Type Code	Integer
SV_STRC_ID	Service Structure	30x	Structure Number	Text
SV_STRC_TY	Structure Type Text	25x	Structure Type Text	Text
SV_STRC_X	X Coordinate	-nnnnnnnnn.nnnnnnnn	Structure X Coordinate	Double
SV_STRC_Y	Y Coordinate	-nnnnnnnnn.nnnnnnnn	Structure Y Coordinate	Double
SV_STRCDST	Dist from DS ST (ft)	nnnn.n	Structure Distance from Mainline	Double
SV_STYPE_CD	Subtype	nnn	GIS Subtype Code	Integer
SV_STYPE_TY	Subtype Text	25x	GIS Subtype Text	Text
SV_SUBD_CD	Subdivision	10x	Subdivision	Text
SV_SUBD_TY	Subdivision Text	60x	Subdivision Text	Text
SV_SVST_CD	Service Status	nnn	Service Status Code	Integer
SV_SVST_TY	Service Stat Text	25x	Service Status Text	Text
SV_SWCT_CD	Sidewalk Cut	nnn	Sidewalk Cut Code	Integer
SV_SWCT_TY	Sidewalk Cut Text	25x	Sidewalk Cut Text	Text
SV_TRAP_CD	Trap Size	nnn	Trap Size Code	Integer
SV_TRAP_TY	Trap Size Text	25x	Trap Size Text	Text
SV_USER1CD	User 1	nnn	User 1	Integer
SV_USER1TY	User 1 Text	25x	User 1 Text	Text
SV_USER2CD	User 2	nnn	User 2	Integer
SV_USER2TY	User 2 Text	25x	User 2 Text	Text
SV_USER3CD	User 3	nnn	User 3	Integer
SV_USER3TY	User 3 Text	25x	User 3 Text	Text
SV_USER4	User 4	nnnnnnnnn.nn	User 4	Double
SV_USER5	User 5	30x	User 5	Text
SV_USER6	User 6		User 6	Boolean
SV_USER7	User 7		User 7	Boolean
SV_USER8	User 8		User 8	Boolean
SV_USER9	User 9	mm/dd/yyyy	User 9	Date/Time
SV_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
SV_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
SV_USER12	User 12	-nnnnnnnnn.nn	User 12	Double
SV_USER13	User 13	-nnnnnnnnn.nn	User 13	Double
SV_USER14	User 14	30x	User 14	Text
SV_USER15	User 15	30x	User 15	Text
SV_USER16CD	User 16	nnn	User 16	Integer
SV_USER16TY	User 16 Text	50x	User 16 Text	String
SV_USER17CD	User 17	nnn	User 17	Integer
SV_USER17TY	User 17 Text	50x	User 17 Text	String
SV_USER18CD	User 18	nnn	User 18	Integer
SV_USER18TY	User 18 Text	50x	User 18 Text	String
SV_USER19CD	User 19	nnn	User 19	Integer
SV_USER19TY	User 19 Text	50x	User 19 Text	String
SV_USER20CD	User 20	nnn	User 20	Integer
SV_USER20TY	User 20 Text	50x	User 20 Text	String
SV_USER21	User 21	50x	User 21	String
SV_USER22	User 22	50x	User 22	String
SV_USER23	User 23	50x	User 23	String
SV_USER24	User 24	50x	User 24	String
SV_USER25	User 25	50x	User 25	String
SV_USER26	User 26	nnnnnnnn.nn	User 26	Double
SV_USER27	User 27	nnnnnnnn.nn	User 27	Double
SV_USER28	User 28	nnnnnnnn.nn	User 28	Double
SV_USER29	User 29	nnnnnnnn.nn	User 29	Double
SV_USER30	User 30	nnnnnnnn.nn	User 30	Double
SV_USER31	User 31	mm/dd/yyyy hh:mm am	User 31	DateTime
SV_USER32	User 32	mm/dd/yyyy hh:mm am	User 32	DateTime
SV_USER33	User 33	mm/dd/yyyy hh:mm am	User 33	DateTime
SV_USER34	User 34	mm/dd/yyyy hh:mm am	User 34	DateTime
SV_USER35	User 35	mm/dd/yyyy hh:mm am	User 35	DateTime
SV_USER36	User 36		User 36	Boolean
SV_USER37	User 37		User 37	Boolean
SV_USER38	User 38		User 38	Boolean
SV_USER39	User 39		User 39	Boolean
SV_USER40	User 40		User 40	Boolean
SV_WO_COMM	Short Comment	255x	This short comment gets copied to work orders	Text