WTRPSTN

Raw Pump Station Inventory

Field Name	Caption	Mask	Description	Field Type
RS_ADR_B2	Street Post Bldg No	8x	Street Post Building No	Text
RS_ADR_BDG	Building No	nnnnnn	Address	Long Integer
RS_ADR_DIR	Address	2x	Street Direction	Text
RS_ADR_PT	Street Prefix Type	5x	Street Prefix	Text
RS_ADR_SFX	Street Suffix	5x	Street Suffix	Text
RS_ADR_STR	Street Name	50x	Street Name	Text
RS_ADR_TY	Street Type	5x	Street Type	Text
RS_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
RS_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
RS_BL_ID	Building Rec #	nnnnnnnn	Link to EFBLDG.BL_ID	Long Integer
RS_BL_NAME	Building Name	40x	Building Name	Text
RS_BL_NUMB	Building ID	20x	Building ID	Text
RS_BR_CD	Default WO Cat	10x	Default Category Code	Text
RS_BR_TY	Default WO Cat Text	60x	Default Category Text	Text
RS_CITY_CD			Facility	Integer
RS_CITY_TY		50x	Facility Text	Text
RS_CNAM_CD	Canal Name	10x	Canal Name	String
RS_CNAM_TY	Canal Name Text	60x	Canal Name Text	String
RS_COF	Consequence of Failure	nnnn.nn	Consequence of Failure	Double
RS_CRT_BY	Created By	25x	Created By	Text
RS_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
RS_DOC_FLG	Document Available		Doc Available	Boolean
RS_ELEC_CD	Electrical Cond	nnn	Electrical Rating	Integer
RS_ELEC_TY	Electrical Cond Text	25x	Electrical Rating Text	Text
RS_FACILNO	Facility Number	nnnnnnnn	Facility Number	Long Integer
RS_FASSET	Fixed Asset ID	nnnnnnnn	Fixed Asset ID	Long Integer
RS_FLO_CAP	Flow Capacity	nnnnnn.	Flow Capacity	Double
RS_GPS_DT	GPS Date	mm/dd/yyyy	GPS Date	Date/Time
RS_GPS_FLG	GPS Located		GPS Located	Boolean
RS_ID	Pump Station Rec #	nnnnnnnn	Raw Water Pump Station Record Number	Long Integer
RS_IFREQ	Inspection Freq	nnn	Inspection Freq	Integer
RS_IFRQ_CD	Inspection Freq Units	nnn	Inspection Freq Units	Integer
RS_IFRQ_TY	Inspection Freq Units Text	10x	Inspection Freq Units Text	String
RS_INMAP	In Map Flag		In Map Flag	Boolean
RS_INSP_DT	Date Inspected	mm/dd/yyyy	Date Inspected	Date/Time
RS_INST_DT	Date Installed	mm/dd/yyyy	Date Installed	Date/Time
RS_LOCATE	General Location	100x	General Location	Text
RS_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
RS_MAP_NO	Map Number	15x	Map Number	Text
RS_MAP1_NO	Alt Map Number	15x	Alternate Map Number	Text
RS_MECH_CD	Mechical Cond	nnn	Mechanical Rating	Integer
RS_MECH_TY	Mechical Cond Text	25x	Mechanical Rating Text	Text
RS_MITIGAT	Mitigation	nnnnnnnn.nn	Mitigation	Double
RS_MOD_BY	Last Modified By	25x	Last Modified By	Text
RS_MOD_DT	Last Modified Date	mm/dd/yyyy	Last Modified Date	Date/Time
RS_MOD_TM	Last Modified Time	hh:mm am	Last Modified Time	Date/Time
RS_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
RS_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
RS_NMNT_DT	Next Station Insp	mm/dd/yyyy	Next Station Insp	Date/Time
RS_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
RS_NUMBER	Station Number	30x	Station Number	Text
RS_PA_ID	Plant Rec #	nnnnnnnn	Link to EFPLANT.PA_ID	Long Integer
RS_PARENTOFFLINE	Parent Off-Line Flag		Parent Off-Line Flag	Boolean
RS_PLATE1	Plate 1	30x	Plate 1	Text
RS_PLATE10	Plate 10	30x	Plate 10	Text
RS_PLATE11	Plate 11	30x	Plate 11	Text
RS_PLATE12	Plate 12	30x	Plate 12	Text
RS_PLATE13	Plate 13	30x	Plate 13	Text
RS_PLATE14	Plate 14	30x	Plate 14	Text
RS_PLATE15	Plate 15	30x	Plate 15	Text
RS_PLATE16	Plate 16	30x	Plate 16	Text
RS_PLATE17	Plate 17	30x	Plate 17	Text
RS_PLATE18	Plate 18	30x	Plate 18	Text
RS_PLATE19	Plate 19	30x	Plate 19	Text
RS_PLATE2	Plate 2	30x	Plate 2	Text
RS_PLATE20	Plate 20	30x	Plate 20	Text
RS_PLATE3	Plate 3	30x	Plate 3	Text
RS_PLATE4	Plate 4	30x	Plate 4	Text
RS_PLATE5	Plate 5	30x	Plate 5	Text
RS_PLATE6	Plate 6	30x	Plate 6	Text
RS_PLATE7	Plate 7	30x	Plate 7	Text
RS_PLATE8	Plate 8	30x	Plate 8	Text
RS_PLATE9	Plate 9	30x	Plate 9	Text
RS_POF	Probability of Failure	nnn.nn	Probability of Failure	Double
RS_PP_ID	Process Rec #	nnnnnnnn	Link to EFPLANTP.PP_ID	Long Integer
RS_PRE952_CD	Pre 952 Status		Pre 952 Status	Small Integer
RS_PRE952_TY	Pre 952 Status Text	25x	Pre 952 Status Text	String
RS_PRJ_NO	Project Number	25x	Project Number	Text
RS_PVALUE	Present Value	nnnnnnnnn.nn	Present Value	Double
RS_RCOST	Replacement Cost	nnnnn.nn	Replacement Cost	Double
RS_REPL_DT	Replacement Date	mm/dd/yyyy	Replacement Date	Date/Time
RS_RISK	Risk	nnnn.nn	Risk - COF * POF	Double
RS_RLIFE	Remaining Life	nnnn.nn	Remaining Life	Double
RS_ROWVER			Rowversion for optimistic locking	Date/Time
RS_RP_ID	Link To Pipe	nnnnnnnn	Pipe ID for WTRPIPE.RP_ID	Long Integer
RS_RP_NUMB	Pipe Number	30x	Pipe Number	Text
RS_RVALUE	Replacement Value	nnnnnnnnn.nn	Replacement Value	Double
RS_SRC_CD	GPS Source	nnn	GPS Source	Integer
RS_SRC_TY	GPS Source Text	25x	GPS Source Text	Text
RS_SSYS_CD	Subsystem	10x	Subsystem	String
RS_SSYS_TY	Subsystem Text	60x	Subsystem Text	String
RS_STAT_CD	Status	nnn	Status	Integer
RS_STAT_TY	Status Text	25x	Status Text	Text
RS_STN_NAM	Station Name	30x	Station Name	Text
RS_STRT_CD	Structural Cond	nnn	Structure Rating	Integer
RS_STRT_TY	Structural Cond Text	25x	Structure Rating Text	Text
RS_STYPE_CD	GIS SubType	nnn	GIS SubType	Integer
RS_STYPE_TY	GIS SubType Text	25x	GIS SubType Text	Text
RS_SYS_CD	System	nnn	System	Integer
RS_SYS_TY	System Text	25x	System Text	Text
RS_TAKEOFFLINE	Take Off-Line Flag		Take Off-Line Flag	Boolean
RS_TYPE_CD	Station Type	nnn	Station Type	Integer
RS_TYPE_TY	Station Type Text	25x	Station Type Text	Text
RS_USER1CD	User 1	nnn	User 1	Integer
RS_USER1TY	User 1 Text	25x	User 1 Text	Text
RS_USER2CD	User 2	nnn	User 2	Integer
RS_USER2TY	User 2 Text	25x	User 2 Text	Text
RS_USER3CD	User 3	nnn	User 3	Integer
RS_USER3TY	User 3 Text	25x	User 3 Text	Text
RS_USER4	User 4	30x	User 4	Text
RS_USER5	User 5	30x	User 5	Text
RS_USER6	User 6	30x	User 6	Text
RS_USER7	User 7	-nnnnnnnnn.nn	User 7	Double
RS_USER8	User 8	-nnnnnnnnn.nn	User 8	Double
RS_USER9	User 9	-nnnnnnnnn.nn	User 9	Double
RS_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
RS_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
RS_USER12	User 12	mm/dd/yyyy	User 12	Date/Time
RS_USER13	User 13		User 13	Boolean
RS_USER14	User 14		User 14	Boolean
RS_USER15	User 15		User 15	Boolean
RS_USER16CD	User 16	nnn	User 16	Integer
RS_USER16TY	User 16 Text	50x	User 16 Text	String
RS_USER17CD	User 17	nnn	User 17	Integer
RS_USER17TY	User 17 Text	50x	User 17 Text	String
RS_USER18CD	User 18	nnn	User 18	Integer
RS_USER18TY	User 18 Text	50x	User 18 Text	String
RS_USER19CD	User 19	nnn	User 19	Integer
RS_USER19TY	User 19 Text	50x	User 19 Text	String
RS_USER20CD	User 20	nnn	User 20	Integer
RS_USER20TY	User 20 Text	50x	User 20 Text	String
RS_USER21	User 21	50x	User 21	String
RS_USER22	User 22	50x	User 22	String
RS_USER23	User 23	50x	User 23	String
RS_USER24	User 24	50x	User 24	String
RS_USER25	User 25	50x	User 25	String
RS_USER26	User 26	nnnnnnnn.nn	User 26	Double
RS_USER27	User 27	nnnnnnnn.nn	User 27	Double
RS_USER28	User 28	nnnnnnnn.nn	User 28	Double
RS_USER29	User 29	nnnnnnnn.nn	User 29	Double
RS_USER30	User 30	nnnnnnnn.nn	User 30	Double
RS_USER31	User 31	mm/dd/yyyy hh:mm am	User 31	DateTime
RS_USER32	User 32	mm/dd/yyyy hh:mm am	User 32	DateTime
RS_USER33	User 33	mm/dd/yyyy hh:mm am	User 33	DateTime
RS_USER34	User 34	mm/dd/yyyy hh:mm am	User 34	DateTime
RS_USER35	User 35	mm/dd/yyyy hh:mm am	User 35	DateTime
RS_USER36	User 36		User 36	Boolean
RS_USER37	User 37		User 37	Boolean
RS_USER38	User 38		User 38	Boolean
RS_USER39	User 39		User 39	Boolean
RS_USER40	User 40		User 40	Boolean
RS_WO_COMM	WO Comment	255x	Short WO Comment	Text
RS_X1	X Coordinate	-nnnnnnnnn.nnnnnnnn	X Coordinate	Double
RS_Y1	Y Coordinate	-nnnnnnnnn.nnnnnnnn	Y Coordinate	Double
RS_ZONE_CD	Pressure Zone	nnn	Pressure Zone	Integer
RS_ZONE_TY	Pressure Zone Text	25x	Pressure Zone Text	Text