PKINODE

Park Irrigation Node Inventory

Field Name	Caption	Mask	Description	Field Type
ND_ACTIVE	Active Flag		Active Flag	Boolean
ND_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
ND_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
ND_BR_CD	Default Category Code	10x	Default Category Code	String
ND_BR_TY	Default Category Text	60x	Default Category Text	String
ND_COF	Consequence of Failure	nnnnnnnn.nn	Consequence of Failure	Double
ND_CRT_BY	Created By	25x	Created By	String
ND_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
ND_DESCR	Description	100x	Description	String
ND_DOC_FLG	Document Available		Document Available	Boolean
ND_EASEMNT	In Easement		In Easement	Boolean
ND_ELEV	Elevation (ft)	nnnnnnnn.nn	Elevation (ft)	Double
ND_ELEV1	Alt Elevation (ft)	nnnnnnnn.nn	Alt Elevation (ft)	Double
ND_FASSET	Fixed Asset ID	nnnnnnnn	Fixed Asset ID	Long Integer
ND_GPS_DT	GPS Date	mm/dd/yyyy hh:mm am	GPS Date	DateTime
ND_GPS_FLG	GPS Located		GPS Located	Boolean
ND_ID	Node AutoID	nnnnnnnn	Node AutoID	Long Integer
ND_INMAP	In Map Flag		In Map Flag	Boolean
ND_INST_DT	Installation Date	mm/dd/yyyy hh:mm am	Installation Date	DateTime
ND_LOCATE	General Location	100x	General Location	String
ND_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
ND_MANG_CD	Managed By	nnn	Managed By	Integer
ND_MANG_TY	Managed By Text	25x	Managed By Text	String
ND_MAP_NO	Map Number	15x	Map Number	String
ND_MAP1_NO	Alt Map Number	15x	Alt Map Number	String
ND_MDL_NO	Model Number	25x	Model Number	String
ND_MFG_CD	Manufacturer	nnn	Manufacturer	Integer
ND_MFG_TY	Manufacturer Text	25x	Manufacturer Text	String
ND_MITIGAT	Mitigation	nnnnnnnn.nn	Mitigation	Double
ND_MOD_BY	Last Modified By	25x	Last Modified By	String
ND_MOD_DT	Last Modified Date	mm/dd/yyyy hh:mm am	Last Modified Date	DateTime
ND_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
ND_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
ND_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
ND_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
ND_NUMBER	Node Number	30x	Node Number	String
ND_OWN_CD	Owned By	nnn	Owned By	Integer
ND_OWN_TY	Owned By Text	25x	Owned By Text	String
ND_PK_ID	Park ID	nnnnnnnn	Link to PKPARK.PK_ID	Long Integer
ND_POF	Probability of Failure	nnnnnnnn.nn	Probability of Failure	Double
ND_PVALUE	Present Value	nnnnnnnn.nn	Present Value	Double
ND_RCOST	Replacement Cost	nnnnnnnn.nn	Replacement Cost	Double
ND_REPL_DT	Replacement Date	mm/dd/yyyy hh:mm am	Replacement Date	DateTime
ND_RISK	Risk - COF * POF	nnnnnnnn.nn	Risk - COF * POF	Double
ND_RLIFE	Remaining Life	nnnnnnnn.nn	Remaining Life	Double
ND_ROWVER	Rowversion for optimistic locking		Rowversion for optimistic locking	TimeStamp
ND_RVALUE	Replacement Value	nnnnnnnn.nn	Replacement Value	Double
ND_SERL_NO	Serial Number	25x	Serial Number	String
ND_SIZE	Size (in)	nnnnnnnn.nn	Size (in)	Double
ND_SRC_CD	GPS Source	nnn	GPS Source	Integer
ND_SRC_TY	GPS Source Text	25x	GPS Source Text	String
ND_STAT_CD	Status	nnn	Status	Integer
ND_STAT_TY	Status Text	25x	Status Text	String
ND_STYPE_CD	GIS SubType	nnn	GIS SubType	Integer
ND_STYPE_TY	GIS SubType Text	25x	GIS SubType Text	String
ND_SYS_CD	System	nnn	System	Integer
ND_SYS_TY	System Text	25x	System Text	String
ND_TYPE_CD	Type	nnn	Type	Integer
ND_TYPE_TY	Type Text	25x	Type Text	String
ND_USER1CD	User 1	nnn	User 1	Integer
ND_USER1TY	User 1 Text	50x	User 1 Text	String
ND_USER2CD	User 2	nnn	User 2	Integer
ND_USER2TY	User 2 Text	50x	User 2 Text	String
ND_USER3CD	User 3	nnn	User 3	Integer
ND_USER3TY	User 3 Text	50x	User 3 Text	String
ND_USER4CD	User 4	nnn	User 4	Integer
ND_USER4TY	User 4 Text	50x	User 4 Text	String
ND_USER5CD	User 5	nnn	User 5	Integer
ND_USER5TY	User 5 Text	50x	User 5 Text	String
ND_USER6	User 6	50x	User 6	String
ND_USER7	User 7	50x	User 7	String
ND_USER8	User 8	50x	User 8	String
ND_USER9	User 9	50x	User 9	String
ND_USER10	User 10	50x	User 10	String
ND_USER11	User 11	nnnnnnnn.nn	User 11	Double
ND_USER12	User 12	nnnnnnnn.nn	User 12	Double
ND_USER13	User 13	nnnnnnnn.nn	User 13	Double
ND_USER14	User 14	nnnnnnnn.nn	User 14	Double
ND_USER15	User 15	nnnnnnnn.nn	User 15	Double
ND_USER16	User 16	mm/dd/yyyy hh:mm am	User 16	DateTime
ND_USER17	User 17	mm/dd/yyyy hh:mm am	User 17	DateTime
ND_USER18	User 18	mm/dd/yyyy hh:mm am	User 18	DateTime
ND_USER19	User 19	mm/dd/yyyy hh:mm am	User 19	DateTime
ND_USER20	User 20	mm/dd/yyyy hh:mm am	User 20	DateTime
ND_USER21	User 21		User 21	Boolean
ND_USER22	User 22		User 22	Boolean
ND_USER23	User 23		User 23	Boolean
ND_USER24	User 24		User 24	Boolean
ND_USER25	User 25		User 25	Boolean
ND_USER26CD	User 26	nnn	User 26	Integer
ND_USER26TY	User 26 Text	50x	User 26 Text	String
ND_USER27CD	User 27	nnn	User 27	Integer
ND_USER27TY	User 27 Text	50x	User 27 Text	String
ND_USER28CD	User 28	nnn	User 28	Integer
ND_USER28TY	User 28 Text	50x	User 28 Text	String
ND_USER29CD	User 29	nnn	User 29	Integer
ND_USER29TY	User 29 Text	50x	User 29 Text	String
ND_USER30CD	User 30	nnn	User 30	Integer
ND_USER30TY	User 30 Text	50x	User 30 Text	String
ND_USER31	User 31	50x	User 31	String
ND_USER32	User 32	50x	User 32	String
ND_USER33	User 33	50x	User 33	String
ND_USER34	User 34	50x	User 34	String
ND_USER35	User 35	50x	User 35	String
ND_USER36	User 36	nnnnnnnn.nn	User 36	Double
ND_USER37	User 37	nnnnnnnn.nn	User 37	Double
ND_USER38	User 38	nnnnnnnn.nn	User 38	Double
ND_USER39	User 39	nnnnnnnn.nn	User 39	Double
ND_USER40	User 40	nnnnnnnn.nn	User 40	Double
ND_USER41	User 41	mm/dd/yyyy hh:mm am	User 41	DateTime
ND_USER42	User 42	mm/dd/yyyy hh:mm am	User 42	DateTime
ND_USER43	User 43	mm/dd/yyyy hh:mm am	User 43	DateTime
ND_USER44	User 44	mm/dd/yyyy hh:mm am	User 44	DateTime
ND_USER45	User 45	mm/dd/yyyy hh:mm am	User 45	DateTime
ND_USER46	User 46		User 46	Boolean
ND_USER47	User 47		User 47	Boolean
ND_USER48	User 48		User 48	Boolean
ND_USER49	User 49		User 49	Boolean
ND_USER50	User 50		User 50	Boolean
ND_WO_COMM	Short Comment	255x	Short Comment	String
ND_X1	X Coordinate	nnnnnnnn.nn	X Coordinate	Double
ND_Y1	Y Coordinate	nnnnnnnn.nn	Y Coordinate	Double
ND_ZONE_CD	Controller Zone	nnn	Controller Zone	Integer
ND_ZONE_TY	Controller Zone Text	25x	Controller Zone Text	String