SWSCONN

Sewer Service Connections

Field Name	Caption	Mask	Description	Field Type
SX_ACCTID	Account Identifier	30x	Account Identifier	Text
SX_ACTIVE	Active		Active Flag	Boolean
SX_ADR_APT	Apartment No	8x	Apartment Number	Text
SX_ADR_B2	Street Post Bldg No	8x	Street Post Building No	Text
SX_ADR_BDG	Building No	nnnnnn	Address	Long Integer
SX_ADR_BDG	Building No	nnnnnn	Address	Long Integer
SX_ADR_DIR	Address	2x	Street Direction	Text
SX_ADR_PT	Street Prefix Type	5x	Street Prefix	Text
SX_ADR_SFX	Street Suffix	5x	Street Suffix	Text
SX_ADR_STR	Street Name	50x	Street Name	Text
SX_ADR_STR	Street Name	50x	Street Name	Text
SX_ADR_TY	Street Type	5x	Street Type	Text
SX_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
SX_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
SX_BASIN	Flow Basin	25x	Flow Basin	Text
SX_BR_CD	Default WO Cat	10x	Default Category Code	Text
SX_BR_TY	Default WO Cat Text	60x	Default Category Text	Text
SX_CFREQ	Cleaning Freq	nnn	Cleaning Freq	Integer
SX_CFRQ_CD	Cleaning Freq Units	nnn	Cleaning Freq Units	Integer
SX_CFRQ_TY	Cleaning Freq Units Tex	10x	Cleaning Freq Units Tex	Text
SX_CITY_CD	City	nnn	City	Integer
SX_CITY_TY	City Text	50x	City Text	Text
SX_COF	Consequence of Failure	nnnn.nn	Consequence of Failure	Double
SX_COV_CD	Cover Type	nnn	Cover	Integer
SX_COV_TY	Cover Type Text	25x	Cover Text	Text
SX_CRIT_FLG	Critical Customer		Critical Customer Flag	Boolean
SX_CRT_BY	Created By	25x	Created By	Text
SX_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
SX_CTO_CD	Connected To	nnn	Connected To - Pipe, Manhole, Other?	Integer
SX_CTO_TY	Connected To Text	25x	Connected To Text	Text
SX_DEPTH	Depth	nnnn.n	Depth	Double
SX_DESCR	Description	100x	Description	Text
SX_DIA	Diameter	nnnn.n	Diameter	Double
SX_DOC_FLG	Document Available		Doc Available	Boolean
SX_EASEMNT	In Easement		In Easement	Boolean
SX_ELEV	Elevation	-nnnnn.nn	Elevation (ft)	Double
SX_ELEV1	Alt Elevation	-nnnnn.nn	Alternate Elev (ft)	Double
SX_FASSET	Fixed Asset ID	nnnnnnnn	Fixed Asset ID	Long Integer
SX_FLOW	Sum Flow	-nnnnnnnnn.nn	Sum Flow	Double
SX_GPS_DT	GPS Date	mm/dd/yyyy	GPS Date	Date/Time
SX_GPS_FLG	GPS Located		GPS Located	Boolean
SX_ID	Serv Conn Rec #	nnnnnnnn	Service Connection Record Number	Long Integer
SX_INMAP	In Map Flag		In Map Flag	Boolean
SX_INSP_CD	Inspected By	nnn	Inspected By	Integer
SX_INSP_DT	Date Inspected	mm/dd/yyyy	Date Inspected	Date/Time
SX_INSP_TY	Inspected By Text	25x	Inspected By Text	Text
SX_INST_DT	Date Installed	mm/dd/yyyy	Date Installed	Date/Time
SX_LCLN_DT	Last Cleaning Date	mm/dd/yyyy	Last Cleaning Date	Date/Time
SX_LMETER_FLG	Large Meter Flag		Large Meter Flag	Boolean
SX_LOCATE	General Location	200x	General Location	Text
SX_LOCATIONID	Location Identifier	30x	Location Identifier	Text
SX_LOT	Lot Number	20x	Lot Number	Text
SX_MA_ID	Structure Rec Number	nnnnnnnn	Link to SWNETMH.MA_MHID	Long Integer
SX_MANG_CD	Managed By	nnn	Managed By	Integer
SX_MANG_TY	Managed By Text	25x	Managed By Text	Text
SX_MAP_NO	Map Number	15x	Map Number	Text
SX_MAP1_NO	Alt Map Number	15x	Alternate Map Number	Text
SX_MAT_CD	Material	nnn	Material	Integer
SX_MAT_TY	Material Text	25x	Material Text	Text
SX_MDL_NO		25x	Model Number	Text
SX_MFG_CD		10x	Manufacture	Text
SX_MFG_TY		60x	Manufacturer Text	Text
SX_MITIGAT	Mitigation	nnnnnnnn.nn	Mitigation	Double
SX_MOD_BY	Last Modified By	25x	Last Modified By	Text
SX_MOD_DT	Last Modified Date	mm/dd/yyyy	Last Modified Date	Date/Time
SX_MOD_TM	Last Modified Time	hh:mm am	Last Modified Time	Date/Time
SX_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
SX_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
SX_NAME	Facility Name	100x	Facility Name	Text
SX_NCLN_DT	Next Cleaning Date	mm/dd/yyyy	Next Cleaning Date	Date/Time
SX_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
SX_NT_ID	Pipe Rec Number	nnnnnnnn	Link to SWNET.NT_ID	Long Integer
SX_NUMBER	Serv Conn Number	30x	Service Connection Number	Text
SX_OWN_CD	Owned By	nnn	Owned By	Integer
SX_OWN_TY	Owned By Text	25x	Owned By Text	Text
SX_POF	Probability of Failure	nnn.nn	Probability of Failure	Double
SX_POSTAL	Zip Code	15x	Zip Code	Text
SX_PROPTAG	Property ID Tag	20x	Property ID Tag	Text
SX_PVALUE	Present Value	nnnnnnnnn.nn	Present Value	Double
SX_RCOST	Replacement Cost	nnnnn.nn	Replacement Cost	Double
SX_REPL_DT	Replacement Date	mm/dd/yyyy	Replacement Date	Date/Time
SX_RISK	Risk	nnnn.nn	Risk - COF * POF	Double
SX_RLIFE	Remaining Life	nnnn.nn	Remaining Life	Double
SX_ROTATION	Rotation	-nnnnnnnnn.nn	Rotation	Double
SX_ROWVER			Rowversion for optimistic locking	Date/Time
SX_RSLT_CD	Insp Results	nnn	Inspection Results Code	Integer
SX_RSLT_TY	Insp Results Text	25x	Inspection Results Text	Text
SX_RVALUE	Replacement Value	nnnnnnnnn.nn	Replacement Value	Double
SX_SERL_NO		25x	Serial Number	Text
SX_SIZE			Size (in)	Double
SX_SRC_CD	GPS Source	nnn	GPS Source	Integer
SX_SRC_TY	GPS Source Text	25x	GPS Source Text	Text
SX_STAT_CD	Status	nnn	Status	Integer
SX_STAT_TY	Status Text	25x	Status Text	Text
SX_STYPE_CD	GIS SubType	nnn	GIS SubType	Integer
SX_STYPE_TY	GIS SubType Text	25x	GIS SubType Text	Text
SX_SUBD_CD	Subdivision	10x	Subdivision	Text
SX_SUBD_TY	Subdivision Text	60x	Subdivision Text	Text
SX_SV_ID	Serv Lateral Rec #	nnnnnnnn	Link to SWSERV.SV_ID	Long Integer
SX_SYS_CD			System	Integer
SX_SYS_TY		25x	System Text	Text
SX_TYPE_CD	Type	nnn	Type	Integer
SX_TYPE_TY	Type Text	25x	Type Text	Text
SX_USER1CD	User 1	nnn	User 1	Integer
SX_USER1TY	User 1 Text	25x	User 1 Text	Text
SX_USER2CD	User 2	nnn	User 2	Integer
SX_USER2TY	User 2 Text	25x	User 2 Text	Text
SX_USER3CD	User 3	nnn	User 3	Integer
SX_USER3TY	User 3 Text	25x	User 3 Text	Text
SX_USER4	User 4	30x	User 4	Text
SX_USER5	User 5	30x	User 5	Text
SX_USER6	User 6	30x	User 6	Text
SX_USER7	User 7	-nnnnnnnnn.nn	User 7	Double
SX_USER8	User 8	-nnnnnnnnn.nn	User 8	Double
SX_USER9	User 9	-nnnnnnnnn.nn	User 9	Double
SX_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
SX_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
SX_USER12	User 12	mm/dd/yyyy	User 12	Date/Time
SX_USER13	User 13		User 13	Boolean
SX_USER14	User 14		User 14	Boolean
SX_USER15	User 15		User 15	Boolean
SX_USER16CD	User 16	nnn	User 16	Integer
SX_USER16TY	User 16 Text	50x	User 16 Text	String
SX_USER17CD	User 17	nnn	User 17	Integer
SX_USER17TY	User 17 Text	50x	User 17 Text	String
SX_USER18CD	User 18	nnn	User 18	Integer
SX_USER18TY	User 18 Text	50x	User 18 Text	String
SX_USER19CD	User 19	nnn	User 19	Integer
SX_USER19TY	User 19 Text	50x	User 19 Text	String
SX_USER20CD	User 20	nnn	User 20	Integer
SX_USER20TY	User 20 Text	50x	User 20 Text	String
SX_USER21	User 21	50x	User 21	String
SX_USER22	User 22	50x	User 22	String
SX_USER23	User 23	50x	User 23	String
SX_USER24	User 24	50x	User 24	String
SX_USER25	User 25	50x	User 25	String
SX_USER26	User 26	nnnnnnnn.nn	User 26	Double
SX_USER27	User 27	nnnnnnnn.nn	User 27	Double
SX_USER28	User 28	nnnnnnnn.nn	User 28	Double
SX_USER29	User 29	nnnnnnnn.nn	User 29	Double
SX_USER30	User 30	nnnnnnnn.nn	User 30	Double
SX_USER31	User 31	mm/dd/yyyy hh:mm am	User 31	DateTime
SX_USER32	User 32	mm/dd/yyyy hh:mm am	User 32	DateTime
SX_USER33	User 33	mm/dd/yyyy hh:mm am	User 33	DateTime
SX_USER34	User 34	mm/dd/yyyy hh:mm am	User 34	DateTime
SX_USER35	User 35	mm/dd/yyyy hh:mm am	User 35	DateTime
SX_USER36	User 36		User 36	Boolean
SX_USER37	User 37		User 37	Boolean
SX_USER38	User 38		User 38	Boolean
SX_USER39	User 39		User 39	Boolean
SX_USER40	User 40		User 40	Boolean
SX_WO_COMM	WO Comment	255x	Short WO Comment	Text
SX_X	X Coordinate	-nnnnnnnnn.nnnnnnnn	X Coordinate	Double
SX_Y	Y Coordinate	-nnnnnnnnn.nnnnnnnn	Y Coordinate	Double