PKART

Park Art Inventory

Field Name	Caption	Mask	Description	Field Type
AR_ACQ_CD	Acquired	nnn	Acquired	Integer
AR_ACQ_TY	Acquired Text	25x	Acquired Text	String
AR_ACTIVE	Active Flag		Active Flag	Boolean
AR_ADR_B2	Street Post Building No	8x	Street Post Building No	String
AR_ADR_B22	Street Post Building No 2	8x	Street Post Building No 2	String
AR_ADR_BDG	Address	nnnnnnnn	Address	Long Integer
AR_ADR_DIR	Street Direction	2x	Street Direction	String
AR_ADR_PT	Street Prefix Type	5x	Street Prefix Type	String
AR_ADR_SFX	Street Suffix	5x	Street Suffix	String
AR_ADR_STR	Street Name	50x	Street Name	String
AR_ADR_TY	Street Type	5x	Street Type	String
AR_ADR2_PT	Street 2 Prefix Type	5x	Street 2 Prefix Type	String
AR_ADRBDG2	Address 2	nnnnnnnn	Address 2	Long Integer
AR_ADRDIR2	Address2 Direction	2x	Address2 Direction	String
AR_ADRSFX2	Street Suffix 2	5x	Street Suffix 2	String
AR_ADRSTR2	Street Name 2	50x	Street Name 2	String
AR_ADRTY2	Street Type 2	5x	Street Type 2	String
AR_ARTIST	Artist or Artists	255x	Artist or Artists	String
AR_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
AR_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
AR_BASE_CD	Base Code	nnn	Base Code	Integer
AR_BASE_TY	Base Text	25x	Base Text	String
AR_BR_CD	Category	10x	Category	String
AR_BR_TY	Category Text	60x	Category Text	String
AR_CITY_CD	City	nnn	City	Integer
AR_CITY_TY	City Text	50x	City Text	String
AR_COF	Consequence of Failure	nnnnnnnn.nn	Consequence of Failure	Double
AR_CRT_BY	Created By	25x	Created By	String
AR_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
AR_DEPTH	Depth	nnnnnnnn.nn	Depth	Double
AR_DESC	Description	255x	Description	String
AR_DOC_FLG	Document Available		Document Available	Boolean
AR_DRAWNO	Drawing Number	30x	Drawing Number	String
AR_DVALUE	Dollar Value	nnnnnnnn.nn	Dollar Value	Double
AR_ELEV	Elevation or Z Coordinate	nnnnnnnn.nn	Elevation or Z Coordinate	Double
AR_FASSET	Fixed Asset ID	nnnnnnnn	Fixed Asset ID	Long Integer
AR_FINANCE	Finance Codes	30x	Finance Codes	String
AR_GPS	GPS Flag		GPS Flag	Boolean
AR_HEIGHT	Height	nnnnnnnn.nn	Height	Double
AR_ID	Art Rec #	nnnnnnnn	AutoID; number for record index	Long Integer
AR_IFREQ	Inspection Freq	nnn	Inspection Freq	Integer
AR_IFRQ_CD	Inspection Freq Units	nnn	Inspection Freq Units	Integer
AR_IFRQ_TY	Inspection Freq Units Text	10x	Inspection Freq Units Text	String
AR_INMAP	In Map Flag		In Map Flag	Boolean
AR_INSP_DT	Last Inspection	mm/dd/yyyy hh:mm am	Last Inspection	DateTime
AR_INST_DT	Installation Date	mm/dd/yyyy hh:mm am	Installation Date	DateTime
AR_INSURED	Insured		Insured	Boolean
AR_LIFEEXP	Life Expectancy	nnn	Life Expectancy	Integer
AR_LITE_CD	Lighting	nnn	Lighting	Integer
AR_LITE_TY	Lighting Text	25x	Lighting Text	String
AR_LOCATION	Location	255x	Location	String
AR_LSTC_CD	Last Condition Code	nnn	Last Condition Code	Integer
AR_LSTC_TY	Last Condition Text	25x	Last Condition Text	String
AR_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
AR_MAIN_CD	Maintained By Code	nnn	Maintained By Code	Integer
AR_MAIN_TY	Maintained By Text	25x	Maintained By Text	String
AR_MAPNO	Map Number	30x	Map Number	String
AR_MITIGAT	Mitigation	nnnnnnnn.nn	Mitigation	Double
AR_MOD_BY	Last Modified By	25x	Last Modified By	String
AR_MOD_DT	Last Modified Date	mm/dd/yyyy hh:mm am	Last Modified Date	DateTime
AR_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
AR_MOUNTCD	Mounting Code	nnn	Mounting Code	Integer
AR_MOUNTTY	Mounting Text	25x	Mounting Text	String
AR_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
AR_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
AR_NAME	Art Name	100x	Art Name	String
AR_NEXTDT	Next Inspection Date	mm/dd/yyyy hh:mm am	Next Inspection Date	DateTime
AR_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
AR_NUMBER	Alt Art ID	20x	Alt Art ID	String
AR_OWN_CD	Owner Code	nnn	Owner Code	Integer
AR_OWN_TY	Owner Type	25x	Owner Type	String
AR_PK_ID	Park ID	nnnnnnnn	Link to PKPARK.PK_ID	Long Integer
AR_POF	Probability of Failure	nnnnnnnn.nn	Probability of Failure	Double
AR_PPRICE	Purchase Price	nnnnnnnn.nn	Purchase Price	Double
AR_PURC_DT	Purchase Date	mm/dd/yyyy hh:mm am	Purchase Date	DateTime
AR_PVALUE	Present Value	nnnnnnnn.nn	Present Value	Double
AR_RCOST	Replacement Cost	nnnnnnnn.nn	Replacement Cost	Double
AR_REPL_DT	Replacement Date	mm/dd/yyyy hh:mm am	Replacement Date	DateTime
AR_RISK	Risk - COF * POF	nnnnnnnn.nn	Risk - COF * POF	Double
AR_RLIFE	Remaining Life	nnnnnnnn.nn	Remaining Life	Double
AR_ROWVER			Rowversion for optimistic locking	TimeStamp
AR_RVALUE	Replacement Value	nnnnnnnn.nn	Replacement Value	Double
AR_ST_ID	Structure ID	nnnnnnnn	Structure ID	Long Integer
AR_STAT_CD	Status	nnn	Status	Integer
AR_STAT_TY	Status Text	25x	Status Text	String
AR_STYPE_CD	GIS SubType	nnn	GIS SubType	Integer
AR_STYPE_TY	GIS SubType Text	25x	GIS SubType Text	String
AR_TYPE_CD	Type Code	12x	Type Code	String
AR_TYPE_TY	Type Text	60x	Type Text	String
AR_USER1CD	User 1	nnn	User 1	Integer
AR_USER1TY	User 1 Text	50x	User 1 Text	String
AR_USER2CD	User 2	nnn	User 2	Integer
AR_USER2TY	User 2 Text	50x	User 2 Text	String
AR_USER3CD	User 3	nnn	User 3	Integer
AR_USER3TY	User 3 Text	50x	User 3 Text	String
AR_USER4CD	User 4	nnn	User 4	Integer
AR_USER4TY	User 4 Text	50x	User 4 Text	String
AR_USER5CD	User 5	nnn	User 5	Integer
AR_USER5TY	User 5 Text	50x	User 5 Text	String
AR_USER6	User 6	50x	User 6	String
AR_USER7	User 7	50x	User 7	String
AR_USER8	User 8	50x	User 8	String
AR_USER9	User 9	50x	User 9	String
AR_USER10	User 10	50x	User 10	String
AR_USER11	User 11	nnnnnnnn.nn	User 11	Double
AR_USER12	User 12	nnnnnnnn.nn	User 12	Double
AR_USER13	User 13	nnnnnnnn.nn	User 13	Double
AR_USER14	User 14	nnnnnnnn.nn	User 14	Double
AR_USER15	User 15	nnnnnnnn.nn	User 15	Double
AR_USER16	User 16	mm/dd/yyyy hh:mm am	User 16	DateTime
AR_USER17	User 17	mm/dd/yyyy hh:mm am	User 17	DateTime
AR_USER18	User 18	mm/dd/yyyy hh:mm am	User 18	DateTime
AR_USER19	User 19	mm/dd/yyyy hh:mm am	User 19	DateTime
AR_USER20	User 20	mm/dd/yyyy hh:mm am	User 20	DateTime
AR_USER21	User 21		User 21	Boolean
AR_USER22	User 22		User 22	Boolean
AR_USER23	User 23		User 23	Boolean
AR_USER24	User 24		User 24	Boolean
AR_USER25	User 25		User 25	Boolean
AR_USER26CD	User 26	nnn	User 26	Integer
AR_USER26TY	User 26 Text	50x	User 26 Text	String
AR_USER27CD	User 27	nnn	User 27	Integer
AR_USER27TY	User 27 Text	50x	User 27 Text	String
AR_USER28CD	User 28	nnn	User 28	Integer
AR_USER28TY	User 28 Text	50x	User 28 Text	String
AR_USER29CD	User 29	nnn	User 29	Integer
AR_USER29TY	User 29 Text	50x	User 29 Text	String
AR_USER30CD	User 30	nnn	User 30	Integer
AR_USER30TY	User 30 Text	50x	User 30 Text	String
AR_USER31	User 31	50x	User 31	String
AR_USER32	User 32	50x	User 32	String
AR_USER33	User 33	50x	User 33	String
AR_USER34	User 34	50x	User 34	String
AR_USER35	User 35	50x	User 35	String
AR_USER36	User 36	nnnnnnnn.nn	User 36	Double
AR_USER37	User 37	nnnnnnnn.nn	User 37	Double
AR_USER38	User 38	nnnnnnnn.nn	User 38	Double
AR_USER39	User 39	nnnnnnnn.nn	User 39	Double
AR_USER40	User 40	nnnnnnnn.nn	User 40	Double
AR_USER41	User 41	mm/dd/yyyy hh:mm am	User 41	DateTime
AR_USER42	User 42	mm/dd/yyyy hh:mm am	User 42	DateTime
AR_USER43	User 43	mm/dd/yyyy hh:mm am	User 43	DateTime
AR_USER44	User 44	mm/dd/yyyy hh:mm am	User 44	DateTime
AR_USER45	User 45	mm/dd/yyyy hh:mm am	User 45	DateTime
AR_USER46	User 46		User 46	Boolean
AR_USER47	User 47		User 47	Boolean
AR_USER48	User 48		User 48	Boolean
AR_USER49	User 49		User 49	Boolean
AR_USER50	User 50		User 50	Boolean
AR_WEIGHT	Weight	nnnnnnnn.nn	Weight	Double
AR_WIDTH	Width	nnnnnnnn.nn	Width	Double
AR_WO_COMM		255x	Short Work Order Comment Field	String
AR_X	X Coordinate	nnnnnnnn.nn	X Coordinate	Double
AR_Y	Y Coordinate	nnnnnnnn.nn	Y Coordinate	Double