WTCPSTN

Recycled Pump Station Inventory

Field Name	Caption	Mask	Description	Field Type
CS_ADR_B2	Street Post Bldg No	8x	Street Post Building No	Text
CS_ADR_BDG	Building No	nnnnnn	Address	Long Integer
CS_ADR_DIR	Address	2x	Street Direction	Text
CS_ADR_PT	Street Prefix Type	5x	Street Prefix	Text
CS_ADR_SFX	Street Suffix	5x	Street Suffix	Text
CS_ADR_STR	Street Name	50x	Street Name	Text
CS_ADR_TY	Street Type	5x	Street Type	Text
CS_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
CS_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
CS_BL_ID	Building Rec #	nnnnnnnn	Link to EFBLDG.BL_ID	Long Integer
CS_BL_NAME	Building Name	40x	Building Name	Text
CS_BL_NUMB	Building ID	20x	Building ID	Text
CS_BR_CD	Default WO Cat	10x	Default Category Code	Text
CS_BR_TY	Default WO Cat Text	60x	Default Category Text	Text
CS_CITY_CD			Facility	Integer
CS_CITY_TY		50x	Facility Text	Text
CS_COF	Consequence of Failure	nnnn.nn	Consequence of Failure	Double
CS_CP_ID	Pipe Rec Number	nnnnnnnn	Link to WTCPIPE.CP_ID	Long Integer
CS_CP_NUMB	Pipe Number	30x	Pipe Number	Text
CS_CRT_BY	Created By	25x	Created By	Text
CS_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
CS_DOC_FLG	Document Available		Doc Available	Boolean
CS_ELEC_CD	Electrical Cond	nnn	Electrical Rating	Integer
CS_ELEC_TY	Electrical Cond Text	25x	Electrical Rating Text	Text
CS_FASSET	Fixed Asset ID	nnnnnnnn	Fixed Asset ID	Long Integer
CS_FLO_CAP	Flow Capacity	nnnnnn.	Flow Capacity	Double
CS_GPS_DT	GPS Date	mm/dd/yyyy	GPS Date	Date/Time
CS_GPS_FLG	GPS Located		GPS Located	Boolean
CS_ID	Pump Station Rec #	nnnnnnnn	Raw Water Pump Station Record Number	Long Integer
CS_IFREQ	Inspection Freq	nnn	Inspection Freq	Integer
CS_IFRQ_CD	Inspection Freq Units	nnn	Inspection Freq Units	Integer
CS_IFRQ_TY	Inspection Freq Units Text	10x	Inspection Freq Units Text	String
CS_INMAP	In Map Flag		In Map Flag	Boolean
CS_INSP_DT	Date Inspected	mm/dd/yyyy	Date Inspected	Date/Time
CS_INST_DT	Date Installed	mm/dd/yyyy	Date Installed	Date/Time
CS_LOCATE	General Location	100x	General Location	Text
CS_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
CS_MAP_NO	Map Number	15x	Map Number	Text
CS_MAP1_NO	Alt Map Number	15x	Alternate Map Number	Text
CS_MECH_CD	Mechical Cond	nnn	Mechanical Rating	Integer
CS_MECH_TY	Mechical Cond Text	25x	Mechanical Rating Text	Text
CS_MITIGAT	Mitigation	nnnnnnnn.nn	Mitigation	Double
CS_MOD_BY	Last Modified By	25x	Last Modified By	Text
CS_MOD_DT	Last Modified Date	mm/dd/yyyy	Last Modified Date	Date/Time
CS_MOD_TM	Last Modified Time	hh:mm am	Last Modified Time	Date/Time
CS_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
CS_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
CS_NMNT_DT	Next Station Insp	mm/dd/yyyy	Next Station Insp	Date/Time
CS_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
CS_NUMBER	Station Number	30x	Station Number	Text
CS_PA_ID	Plant Rec #	nnnnnnnn	Link to EFPLANT.PA_ID	Long Integer
CS_PARENTOFFLINE	Parent Off-Line Flag		Parent Off-Line Flag	Boolean
CS_PLATE1	Plate 1	30x	Plate 1	Text
CS_PLATE10	Plate 10	30x	Plate 10	Text
CS_PLATE11	Plate 11	30x	Plate 11	Text
CS_PLATE12	Plate 12	30x	Plate 12	Text
CS_PLATE13	Plate 13	30x	Plate 13	Text
CS_PLATE14	Plate 14	30x	Plate 14	Text
CS_PLATE15	Plate 15	30x	Plate 15	Text
CS_PLATE16	Plate 16	30x	Plate 16	Text
CS_PLATE17	Plate 17	30x	Plate 17	Text
CS_PLATE18	Plate 18	30x	Plate 18	Text
CS_PLATE19	Plate 19	30x	Plate 19	Text
CS_PLATE2	Plate 2	30x	Plate 2	Text
CS_PLATE20	Plate 20	30x	Plate 20	Text
CS_PLATE3	Plate 3	30x	Plate 3	Text
CS_PLATE4	Plate 4	30x	Plate 4	Text
CS_PLATE5	Plate 5	30x	Plate 5	Text
CS_PLATE6	Plate 6	30x	Plate 6	Text
CS_PLATE7	Plate 7	30x	Plate 7	Text
CS_PLATE8	Plate 8	30x	Plate 8	Text
CS_PLATE9	Plate 9	30x	Plate 9	Text
CS_POF	Probability of Failure	nnn.nn	Probability of Failure	Double
CS_PP_ID	Process Rec #	nnnnnnnn	Link to EFPLANTP.PP_ID	Long Integer
CS_PRE952_CD	Pre 952 Status		Pre 952 Status	Small Integer
CS_PRE952_TY	Pre 952 Status Text	25x	Pre 952 Status Text	String
CS_PRJ_NO	Project Number	25x	Project Number	Text
CS_PVALUE	Present Value	nnnnnnnnn.nn	Present Value	Double
CS_RCOST	Replacement Cost	nnnnn.nn	Replacement Cost	Double
CS_REPL_DT	Replacement Date	mm/dd/yyyy	Replacement Date	Date/Time
CS_RISK	Risk	nnnn.nn	Risk = COF * POF * Mitigation	Double
CS_RLIFE	Remaining Life	nnnn.nn	Remaining Life	Double
CS_ROWVER			Rowversion for optimistic locking	Date/Time
CS_RVALUE	Replacement Value	nnnnnnnnn.nn	Replacement Value	Double
CS_SRC_CD	GPS Source	nnn	GPS Source	Integer
CS_SRC_TY	GPS Source Text	25x	GPS Source Text	Text
CS_STAT_CD	Status	nnn	Status	Integer
CS_STAT_TY	Status Text	25x	Status Text	Text
CS_STN_NAM	Station Name	30x	Station Name	Text
CS_STRT_CD	Structural Cond	nnn	Structure Rating	Integer
CS_STRT_TY	Structural Cond Text	25x	Structure Rating Text	Text
CS_STYPE_CD	GIS SubType	nnn	GIS SubType	Integer
CS_STYPE_TY	GIS SubType Text	25x	GIS SubType Text	Text
CS_SYS_CD	System	nnn	System	Integer
CS_SYS_TY	System Text	25x	System Text	Text
CS_TAKEOFFLINE	Take Off-Line Flag		Take Off-Line Flag	Boolean
CS_TYPE_CD	Station Type	nnn	Station Type	Integer
CS_TYPE_TY	Station Type Text	25x	Station Type Text	Text
CS_USER1CD	User 1	nnn	User 1	Integer
CS_USER1TY	User 1 Text	25x	User 1 Text	Text
CS_USER2CD	User 2	nnn	User 2	Integer
CS_USER2TY	User 2 Text	25x	User 2 Text	Text
CS_USER3CD	User 3	nnn	User 3	Integer
CS_USER3TY	User 3 Text	25x	User 3 Text	Text
CS_USER4	User 4	30x	User 4	Text
CS_USER5	User 5	30x	User 5	Text
CS_USER6	User 6	30x	User 6	Text
CS_USER7	User 7	-nnnnnnnnn.nn	User 7	Double
CS_USER8	User 8	-nnnnnnnnn.nn	User 8	Double
CS_USER9	User 9	-nnnnnnnnn.nn	User 9	Double
CS_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
CS_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
CS_USER12	User 12	mm/dd/yyyy	User 12	Date/Time
CS_USER13	User 13		User 13	Boolean
CS_USER14	User 14		User 14	Boolean
CS_USER15	User 15		User 15	Boolean
CS_USER16CD	User 16	nnn	User 16	Integer
CS_USER16TY	User 16 Text	50x	User 16 Text	String
CS_USER17CD	User 17	nnn	User 17	Integer
CS_USER17TY	User 17 Text	50x	User 17 Text	String
CS_USER18CD	User 18	nnn	User 18	Integer
CS_USER18TY	User 18 Text	50x	User 18 Text	String
CS_USER19CD	User 19	nnn	User 19	Integer
CS_USER19TY	User 19 Text	50x	User 19 Text	String
CS_USER20CD	User 20	nnn	User 20	Integer
CS_USER20TY	User 20 Text	50x	User 20 Text	String
CS_USER21	User 21	50x	User 21	String
CS_USER22	User 22	50x	User 22	String
CS_USER23	User 23	50x	User 23	String
CS_USER24	User 24	50x	User 24	String
CS_USER25	User 25	50x	User 25	String
CS_USER26	User 26	nnnnnnnn.nn	User 26	Double
CS_USER27	User 27	nnnnnnnn.nn	User 27	Double
CS_USER28	User 28	nnnnnnnn.nn	User 28	Double
CS_USER29	User 29	nnnnnnnn.nn	User 29	Double
CS_USER30	User 30	nnnnnnnn.nn	User 30	Double
CS_USER31	User 31	mm/dd/yyyy hh:mm am	User 31	DateTime
CS_USER32	User 32	mm/dd/yyyy hh:mm am	User 32	DateTime
CS_USER33	User 33	mm/dd/yyyy hh:mm am	User 33	DateTime
CS_USER34	User 34	mm/dd/yyyy hh:mm am	User 34	DateTime
CS_USER35	User 35	mm/dd/yyyy hh:mm am	User 35	DateTime
CS_USER36	User 36		User 36	Boolean
CS_USER37	User 37		User 37	Boolean
CS_USER38	User 38		User 38	Boolean
CS_USER39	User 39		User 39	Boolean
CS_USER40	User 40		User 40	Boolean
CS_WO_COMM	WO Comment	255x	Short WO Comment	Text
CS_X1	X Coordinate	-nnnnnnnnn.nnnnnnnn	X Coordinate	Double
CS_Y1	Y Coordinate	-nnnnnnnnn.nnnnnnnn	Y Coordinate	Double
CS_ZONE_CD	Pressure Zone	nnn	Pressure Zone	Integer
CS_ZONE_TY	Pressure Zone Text	25x	Pressure Zone Text	Text