SWSTATN

Sewer Pump Station

Field Name	Caption	Mask	Description	Field Type
SN_ACL_CD	Asset Class	25x	Asset Class	String
SN_ACL_TY	Asset Class Text	60x	Asset Class Text	String
SN_ACTIVE	Active		Active Flag	Boolean
SN_ADR_B2	Street Post Bldg No	8x	Street Post Building No	Text
SN_ADR_BDG	Address	nnnnnn	Address - Building Number	Long Integer
SN_ADR_DIR	Street Direction	2x	Address - Street Direction	Text
SN_ADR_PT	Street Prefix Type	5x	Street Prefix Type	Text
SN_ADR_SFX	Street Suffix	5x	Address - Street Suffix	Text
SN_ADR_STR	Street Name	50x	Address - Street Name	Text
SN_ADR_TY	Street Type	5x	Address - Street Type	Text
SN_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
SN_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
SN_BL_ID	Building Rec #	nnnnnnnn	Link to EFBLDG.BL_ID	Long Integer
SN_BL_NAME	Building Name	40x	Building Name	Text
SN_BL_NUMB	Alt Bldg No	20x	Building ID	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_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_CITY_CD	City Code	nnn	City Code	Integer
SN_CITY_TY	City Description	50x	City Description	String
SN_COF	Consequence of Failure	nnnn.	Consequence of Failure	Double
SN_CONSTR	Project Number	20x	Project Number	Text
SN_CONTRCT	Constructed By	30x	Constructed By	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_DATE	Date Completed	mm/dd/yyyy	Date Completed	Date/Time
SN_DESIGN	Designed By	30x	Designed By	Text
SN_DHEAD	Dynamic Head	nnnnnnnnn.nn	Dynamic Head	Double
SN_DISC_CD	Discharge Type	nnn	Discharge Type	Integer
SN_DISC_TY	Discharge Type Text	25x	Discharge Type Text	Text
SN_DOC_FLG	Document Available		Document Available	Boolean
SN_DRATE	Discharge Rate	nnnnnnnnn.nn	Discharge Rate	Double
SN_ELEC_CD	Electrical Condition	nnn	Electrical Condition : Electrical Condition Code	Integer
SN_ELEC_TY	Electrical Cond Text	25x	Electrical Condition Text	Text
SN_FASSET	Fixed Asset ID	nnnnnnnn	Fixed Asset ID	Long Integer
SN_FLO_CAP	Stn Capacity (gpm)	nnnnnnnn.n	Station Capacity (gpm)	Double
SN_FMDIA	Force Main Dia	nnnnnnnnn.	Force Main Diameter	Double
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_INMAP	In Map?		Flag indicating this feature is in the map	Boolean
SN_INSP_DT	Date Inspected	mm/dd/yyyy	Date Inspected : Date of Inspection	Date/Time
SN_INST_DT	Install Date	mm/dd/yyyy	Install Date	Date/Time
SN_INST1	Instructions 1	254x	Instructions 1	Text
SN_INST2	Instructions 2	254x	Instructions 2	Text
SN_INST3	Instructions 3	254x	Instructions 3	Text
SN_INST4	Instructions 4	254x	Instructions 4	Text
SN_INST5	Instructions 5	254x	Instructions 5	Text
SN_LCLN_DT	Last Cleaning Date	mm/dd/yyyy	Last Cleaning Date	Date/Time
SN_LOCATIO	Gen Location	200x	General Location	Text
SN_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
SN_MANG_CD	Managed By	nnn	Managed By	Integer
SN_MANG_TY	Managed By Text	25x	Managed By Text	Text
SN_MECH_CD	Mechanical Cond.	nnn	Mechanical Condition : Mechanical Condition Code	Integer
SN_MECH_TY	Mechanical Cond. Txt	25x	Mechanical Condition Text	Text
SN_MHID	Structure Rec #		Link to SWNETMH.MA_MHID	Long Integer
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_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_NCLN_DT	Next Cleaning Date	mm/dd/yyyy	Next Cleaning Date	Date/Time
SN_NMNT_DT	Next Insp Date	mm/dd/yyyy	Next Station Insp. : Calculated Date of Next Inspection	Date/Time
SN_NODE_NO	Pump Station ID	30x	Pump Station ID	Text
SN_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
SN_OCAP	Overflow Capacity	nnnnnnnnn.nn	Overflow Capacity	Double
SN_OWN_CD	Owned By	nnn	Owned By	Integer
SN_OWN_TY	Owned By Text	25x	Owned By Text	Text
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_PLATE1	Plate 1	30x	Plate 1	Text
SN_PLATE10	Plate 10	30x	Plate 10	Text
SN_PLATE11	Plate 11	30x	Plate 11	Text
SN_PLATE12	Plate 12	30x	Plate 12	Text
SN_PLATE13	Plate 13	30x	Plate 13	Text
SN_PLATE14	Plate 14	30x	Plate 14	Text
SN_PLATE15	Plate 15	30x	Plate 15	Text
SN_PLATE16	Plate 16	30x	Plate 16	Text
SN_PLATE17	Plate 17	30x	Plate 17	Text
SN_PLATE18	Plate 18	30x	Plate 18	Text
SN_PLATE19	Plate 19	30x	Plate 19	Text
SN_PLATE2	Plate 2	30x	Plate 2	Text
SN_PLATE20	Plate 20	30x	Plate 20	Text
SN_PLATE3	Plate 3	30x	Plate 3	Text
SN_PLATE4	Plate 4	30x	Plate 4	Text
SN_PLATE5	Plate 5	30x	Plate 5	Text
SN_PLATE6	Plate 6	30x	Plate 6	Text
SN_PLATE7	Plate 7	30x	Plate 7	Text
SN_PLATE8	Plate 8	30x	Plate 8	Text
SN_PLATE9	Plate 9	30x	Plate 9	Text
SN_POF	Probability of Failure	nnn.nn	Probability of Failure	Double
SN_POSTAL	Zip Code	15x	Zip Code	Text
SN_POWERP	Power Provider	50x	Power Provider	Text
SN_PP_ID	Process Rec #	nnnnnnnn	Link to EFPLANTP.PP_ID	Long Integer
SN_PPPHONE	Provider Phone	30x	Power Provider Phone	Text
SN_PRE952_CD	Pre 952 Status		Pre 952 Status	Small Integer
SN_PRE952_TY	Pre 952 Status Text	25x	Pre 952 Status Text	String
SN_PROPTAG		52x	Property ID Tag	Text
SN_PVALUE	Present Value	nnnnnnnn.nn	Present Value	Double
SN_RCOST	Replacement Cost	nnnnn.nn	Replacement Cost	Double
SN_REPL_DT	Replacement Date	mm/dd/yyyy	Replacement Date	Date/Time
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_SGEN	Standby Generator		Standby Generator	Boolean
SN_SHEAD	Static Head	nnnnnnnnn.nn	Static Head	Double
SN_TPMPRD	Total Pump Reading	nnnnnnnn.nn	Total Pump Reading	Double
SN_STAT_CD	Status	nnn	Status	Integer
SN_STAT_TY	Status Text	25x	Status Text	Text
SN_STN_ID	Station Rec #	nnnnnnnn	Unique ID	Long Integer
SN_STN_NAM	Station Name	30x	Station Name	Text
SN_STRT_CD	Structural Cond.	nnn	Structural Condition : Structural Condition Code	Integer
SN_STRT_TY	Structural Cond. Txt	25x	Structural Condition Text	Text
SN_STYPE_CD	Subtype	nnn	GIS Subtype Code	Integer
SN_STYPE_TY	Subtype Text	25x	GIS Subtype Text	Text
SN_TAKEOFFLINE	Take Off-Line Flag		Take Off-Line Flag	Boolean
SN_TOTAL_C	Construction Cost	nnnnnnnnn.nn	Construction Cost	Double
SN_TYPE_CD	Station Type	nnn	Station Type Code	Integer
SN_TYPE_TY	Station Type Text	25x	Station 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	nnnnnnnnn.nn	User 4	Double
SN_USER5	User 5	30x	User 5	Text
SN_USER6	User 6		User 6	Boolean
SN_USER7	User 7		User 7	Boolean
SN_USER8	User 8		User 8	Boolean
SN_USER9	User 9	mm/dd/yyyy	User 9	Date/Time
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	-nnnnnnnnn.nn	User 12	Double
SN_USER13	User 13	-nnnnnnnnn.nn	User 13	Double
SN_USER14	User 14	30x	User 14	Text
SN_USER15	User 15	30x	User 15	Text
SN_USER16CD	User 16	nnn	User 16	Integer
SN_USER16TY	User 16 Text	50x	User 16 Text	String
SN_USER17CD	User 17	nnn	User 17	Integer
SN_USER17TY	User 17 Text	50x	User 17 Text	String
SN_USER18CD	User 18	nnn	User 18	Integer
SN_USER18TY	User 18 Text	50x	User 18 Text	String
SN_USER19CD	User 19	nnn	User 19	Integer
SN_USER19TY	User 19 Text	50x	User 19 Text	String
SN_USER20CD	User 20	nnn	User 20	Integer
SN_USER20TY	User 20 Text	50x	User 20 Text	String
SN_USER21	User 21	50x	User 21	String
SN_USER22	User 22	50x	User 22	String
SN_USER23	User 23	50x	User 23	String
SN_USER24	User 24	50x	User 24	String
SN_USER25	User 25	50x	User 25	String
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 hh:mm am	User 31	DateTime
SN_USER32	User 32	mm/dd/yyyy hh:mm am	User 32	DateTime
SN_USER33	User 33	mm/dd/yyyy hh:mm am	User 33	DateTime
SN_USER34	User 34	mm/dd/yyyy hh:mm am	User 34	DateTime
SN_USER35	User 35	mm/dd/yyyy hh:mm am	User 35	DateTime
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_USER46CD	User 46	10x	User 46	String
SN_USER46TY	User 46 Text	60x	User 46 Text	String
SN_USER47CD	User 47	10x	User 47	String
SN_USER47TY	User 47 Text	60x	User 47 Text	String
SN_USER48CD	User 48	10x	User 48	String
SN_USER48TY	User 48 Text	60x	User 48 Text	String
SN_USER49CD	User 49	10x	User 49	String
SN_USER49TY	User 49 Text	60x	User 49 Text	String
SN_USER50CD	User 50	10x	User 50	String
SN_USER50TY	User 50 Text	60x	User 50 Text	String
SN_USER51	User 51		User 51	Boolean
SN_USER52	User 52		User 52	Boolean
SN_USER53	User 53		User 53	Boolean
SN_USER54	User 54		User 54	Boolean
SN_USER55	User 55		User 55	Boolean
SN_USER56	User 56		User 56	Boolean
SN_USER57	User 57		User 57	Boolean
SN_USER58	User 58		User 58	Boolean
SN_USER59	User 59		User 59	Boolean
SN_USER60	User 60		User 60	Boolean
SN_VOLT	Voltage	nnnnnnnnn.nn	Voltage	Double
SN_VPHA_CD	Voltage Phase	nnn	Voltage Phase	Integer
SN_VPHA_TY	Voltage Phase Text	25x	Voltage Phase Text	Text
SN_WO_COMM	Short Comment	255x	This short comment gets copied to work orders	Text
SN_WWAREA	Area	nnnnn.nn	Wet Well Area = (2(pie) * r^2) or (Width * Length)	Double
SN_WWBOT	Bottom Elevation	nnnnnnnnn.nn	Wet Well Bottom Elevation	Double
SN_WWDIA	Dia/Width	nnnnn.nn	Wet Well Diameter or Width	Double
SN_WWINVRT	Invert Elevation	nnnnnnnnn.nn	Wet Well Invert Elevation	Double
SN_WWLEN	Length	nnnnn.nn	Wet Well Length	Double
SN_WWRIM	Rim Elevation	nnnnnnnnn.nn	Wet Well Rim Elevation	Double
SN_X	X Coordinate	-nnnnnnnnn.nnnnnnnn	X Coordinate	Double
SN_Y	Y Coordinate	-nnnnnnnnn.nnnnnnnn	Y Coordinate	Double