PKIPIPE

Park Irrigation Pipe Inventory

Field Name	Caption	Mask	Description	Field Type
PP_ACTIVE	Active Flag		Active Flag	Boolean
PP_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
PP_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
PP_BEN_DIS	Benefit District #	20x	Benefit District #	String
PP_BR_CD	Default Category Code	10x	Default Category Code	String
PP_BR_TY	Default Category Text	60x	Default Category Text	String
PP_CLAS_CD	Pressure Class	nnn	Pressure Class	Integer
PP_CLAS_TY	Pressure Class Text	25x	Pressure Class Text	String
PP_COF	Consequence of Failure	nnnnnnnn.nn	Consequence of Failure	Double
PP_CRT_BY	Created By	25x	Created By	String
PP_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
PP_DEPTH	Depth	nnnnnnnn.nn	Depth	Double
PP_DIA	Diameter (in)	nnnnnnnn.nn	Diameter (in)	Double
PP_DOC_FLG	Document Available		Document Available	Boolean
PP_ELEV	Elevation (ft)	nnnnnnnn.nn	Elevation (ft)	Double
PP_ELEV1	Alt Elevation (ft)	nnnnnnnn.nn	Alt Elevation (ft)	Double
PP_FASSET	Fixed Asset ID	nnnnnnnn	Fixed Asset ID	Long Integer
PP_FRM_END	From End	30x	From End	String
PP_FTYP_CD	From End Type	nnn	From End Type	Integer
PP_FTYP_TY	From End Type Text	25x	From End Type Text	String
PP_ID	Pipe AutoID	nnnnnnnn	Pipe AutoID	Long Integer
PP_INMAP	In Map Flag		In Map Flag	Boolean
PP_INST_DT	Installation Date	mm/dd/yyyy hh:mm am	Installation Date	DateTime
PP_LENGTH	Length (ft)	nnnnnnnn.nn	Length (ft)	Double
PP_LOC_CD	Location	nnn	Location	Integer
PP_LOC_TY	Location Text	25x	Location Text	String
PP_LOCATE	General Location	100x	General Location	String
PP_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
PP_MANG_CD	Managed By	nnn	Managed By	Integer
PP_MANG_TY	Managed By Text	25x	Managed By Text	String
PP_MAP_NO	Map Number	15x	Map Number	String
PP_MAP1_NO	Alt Map Number	15x	Alt Map Number	String
PP_MAT_CD	Material	nnn	Material	Integer
PP_MAT_TY	Material Text	25x	Material Text	String
PP_MFG_CD	Manufacturer	nnn	Manufacturer	Integer
PP_MFG_TY	Manufacturer Text	25x	Manufacturer Text	String
PP_MITIGAT	Mitigation	nnnnnnnn.nn	Mitigation	Double
PP_MNT_CD	Maint Zone	nnn	Maint Zone	Integer
PP_MNT_TY	Maint Zone Text	25x	Maint Zone Text	String
PP_MOD_BY	Last Modified By	25x	Last Modified By	String
PP_MOD_DT	Last Modified Date	mm/dd/yyyy hh:mm am	Last Modified Date	DateTime
PP_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
PP_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
PP_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
PP_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
PP_NUMBER	Pipe Number	30x	Pipe Number	String
PP_OWNR_CD	Owner	nnn	Owner	Integer
PP_OWNR_TY	Owner Text	25x	Owner Text	String
PP_PK_ID	Park ID	nnnnnnnn	Link to PKPARK.PK_ID	Long Integer
PP_POF	Probability of Failure	nnnnnnnn.nn	Probability of Failure	Double
PP_PVALUE	Present Value	nnnnnnnn.nn	Present Value	Double
PP_RCOST	Replacement Cost	nnnnnnnn.nn	Replacement Cost	Double
PP_REPL_DT	Replacement Date	mm/dd/yyyy hh:mm am	Replacement Date	DateTime
PP_RISK	Risk - COF * POF	nnnnnnnn.nn	Risk - COF * POF	Double
PP_RLIFE	Remaining Life	nnnnnnnn.nn	Remaining Life	Double
PP_ROWVER			Rowversion for optimistic locking	TimeStamp
PP_RVALUE	Replacement Value	nnnnnnnn.nn	Replacement Value	Double
PP_STAT_CD	Status	nnn	Status	Integer
PP_STAT_TY	Status Text	25x	Status Text	String
PP_STYPE_CD	GIS SubType	nnn	GIS SubType	Integer
PP_STYPE_TY	GIS SubType Text	25x	GIS SubType Text	String
PP_SURF_CD	Surface	nnn	Surface	Integer
PP_SURF_TY	Surface Text	25x	Surface Text	String
PP_SYS_CD	System	nnn	System	Integer
PP_SYS_TY	System Text	25x	System Text	String
PP_TO_END	To End	30x	To End	String
PP_TTYP_CD	To End Type	nnn	To End Type	Integer
PP_TTYP_TY	To End Type Text	25x	To End Type Text	String
PP_USER1CD	User 1	nnn	User 1	Integer
PP_USER1TY	User 1 Text	50x	User 1 Text	String
PP_USER2CD	User 2	nnn	User 2	Integer
PP_USER2TY	User 2 Text	50x	User 2 Text	String
PP_USER3CD	User 3	nnn	User 3	Integer
PP_USER3TY	User 3 Text	50x	User 3 Text	String
PP_USER4CD	User 4	nnn	User 4	Integer
PP_USER4TY	User 4 Text	50x	User 4 Text	String
PP_USER5CD	User 5	nnn	User 5	Integer
PP_USER5TY	User 5 Text	50x	User 5 Text	String
PP_USER6	User 6	50x	User 6	String
PP_USER7	User 7	50x	User 7	String
PP_USER8	User 8	50x	User 8	String
PP_USER9	User 9	50x	User 9	String
PP_USER10	User 10	50x	User 10	String
PP_USER11	User 11	nnnnnnnn.nn	User 11	Double
PP_USER12	User 12	nnnnnnnn.nn	User 12	Double
PP_USER13	User 13	nnnnnnnn.nn	User 13	Double
PP_USER14	User 14	nnnnnnnn.nn	User 14	Double
PP_USER15	User 15	nnnnnnnn.nn	User 15	Double
PP_USER16	User 16	mm/dd/yyyy hh:mm am	User 16	DateTime
PP_USER17	User 17	mm/dd/yyyy hh:mm am	User 17	DateTime
PP_USER18	User 18	mm/dd/yyyy hh:mm am	User 18	DateTime
PP_USER19	User 19	mm/dd/yyyy hh:mm am	User 19	DateTime
PP_USER20	User 20	mm/dd/yyyy hh:mm am	User 20	DateTime
PP_USER21	User 21		User 21	Boolean
PP_USER22	User 22		User 22	Boolean
PP_USER23	User 23		User 23	Boolean
PP_USER24	User 24		User 24	Boolean
PP_USER25	User 25		User 25	Boolean
PP_USER26CD	User 26	nnn	User 26	Integer
PP_USER26TY	User 26 Text	50x	User 26 Text	String
PP_USER27CD	User 27	nnn	User 27	Integer
PP_USER27TY	User 27 Text	50x	User 27 Text	String
PP_USER28CD	User 28	nnn	User 28	Integer
PP_USER28TY	User 28 Text	50x	User 28 Text	String
PP_USER29CD	User 29	nnn	User 29	Integer
PP_USER29TY	User 29 Text	50x	User 29 Text	String
PP_USER30CD	User 30	nnn	User 30	Integer
PP_USER30TY	User 30 Text	50x	User 30 Text	String
PP_USER31	User 31	50x	User 31	String
PP_USER32	User 32	50x	User 32	String
PP_USER33	User 33	50x	User 33	String
PP_USER34	User 34	50x	User 34	String
PP_USER35	User 35	50x	User 35	String
PP_USER36	User 36	nnnnnnnn.nn	User 36	Double
PP_USER37	User 37	nnnnnnnn.nn	User 37	Double
PP_USER38	User 38	nnnnnnnn.nn	User 38	Double
PP_USER39	User 39	nnnnnnnn.nn	User 39	Double
PP_USER40	User 40	nnnnnnnn.nn	User 40	Double
PP_USER41	User 41	mm/dd/yyyy hh:mm am	User 41	DateTime
PP_USER42	User 42	mm/dd/yyyy hh:mm am	User 42	DateTime
PP_USER43	User 43	mm/dd/yyyy hh:mm am	User 43	DateTime
PP_USER44	User 44	mm/dd/yyyy hh:mm am	User 44	DateTime
PP_USER45	User 45	mm/dd/yyyy hh:mm am	User 45	DateTime
PP_USER46	User 46		User 46	Boolean
PP_USER47	User 47		User 47	Boolean
PP_USER48	User 48		User 48	Boolean
PP_USER49	User 49		User 49	Boolean
PP_USER50	User 50		User 50	Boolean
PP_WO_COMM	Short Comment	255x	Short Comment	String
PP_X	X Coordinate	nnnnnnnn.nn	X Coordinate	Double
PP_Y	Y Coordinate	nnnnnnnn.nn	Y Coordinate	Double
PP_ZONE_CD	Controller Zone	nnn	Controller Zone	Integer
PP_ZONE_TY	Controller Zone Text	25x	Controller Zone Text	String