TREEINSP

Tree Inspection

Field Name	Caption	Mask	Description	Field Type
TI_ACT_CD	Activity	nnn	Action	Integer
TI_ACT_TY	Activity Text	25x	Action Text	Text
TI_ATA	Appraised Trunk Area	nnnn	Appraised Trunk Area	Integer
TI_ATD	Appraised Dia	nnn	Appraised Trunk Diameter	Integer
TI_ATI	Trunk Increase	nnn	Appraised Trunk Increase	Integer
TI_BIO_CD	Biological Type	nnn	Biological Type	Integer
TI_BIO_TY	Biological Type Text	25x	Biological Type Text	Text
TI_BIOR_CD	Biorational Agent	nnn	Biorational Agent	Integer
TI_BIOR_TY	Biorational Agent Te	25x	Biorational Agent Text	Text
TI_BRACECD	Bracing Type	nnn	Bracing Type	Integer
TI_BRACETY	Bracing Type Text	25x	Bracing Type Text	Text
TI_BTC	Basic Tree Cost	nnnnn	Basic Tree Cost	Long Integer
TI_CHEM_CD	Chemical Type	nnn	Chemical Type	Integer
TI_CHEM_TY	Chemical Type Text	25x	Chemical Type Text	Text
TI_CLEARCD	Clearance	nnn	Clearance	Integer
TI_CLEARTY	Clearance Text	25x	Clearance Text	Text
TI_CNDFACT	Condition Factor	nnn	Condition Factor	Integer
TI_CNDFCT	Condition Rating	nnn	Condition Factor	Integer
TI_COND_CD	Tree Condition	nnn	Condition	Integer
TI_COND_TY	Tree Condition Text	25x	Condition Text	Text
TI_CRT_BY	Created By	25x	Created By	Text
TI_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
TI_CTBFACT	Contribution Factor	nnn	Contribution Factor	Integer
TI_DIA	Trunk Dia	nnn.n	Trunk Dia	Double
TI_DIFF_CD	Difficulty	nnn	Difficulty	Integer
TI_DIFF_TY	Difficulty Text	25x	Difficulty Text	Text
TI_DISCHCD	Disease Chemical	nnn	Disease Chemical	Integer
TI_DISCHTY	Disease Chemical Tex	25x	Disease Chemical Text	Text
TI_DISEA_C	Diseased Cond	nnn	Diseased Cond	Integer
TI_DISEA_T	Diseased Cond Text	25x	Diseased Cond Text	Text
TI_DISTRCD	Disease Treatment	nnn	Disease Treatment	Integer
TI_DISTRTY	Disease Treatment Te	25x	Disease Treatment Text	Text
TI_DISTYCD	Disease Type	nnn	Disease Type	Integer
TI_DISTYTY	Disease Type Text	25x	Disease Type Text	Text
TI_DOC_FLG	Document Available		Document Available	Boolean
TI_F_B_H	Foliage & Buds Healt	n	Foliage & Buds Health Subtotal	Integer
TI_FERTRCD	Fertilizer Treat	nnn	Fertilizer Treat	Integer
TI_FERTRTY	Fertilizer Treat Tex	25x	Fertilizer Treat Text	Text
TI_FERTYCD	Fertilizer Type	nnn	Fertilizer Type	Integer
TI_FERTYTY	Fertilizer Type Text	25x	Fertilizer Type Text	Text
TI_GSUBT	Grand Subtotal Condi	nn	Grand Subtotal Condition Points	Integer
TI_HEIGHT	Height	nnn.n	Height	Double
TI_ID	Tree Insp Rec #		Auto Number	Long Integer
TI_IMG_FLG			Image Available	Boolean
TI_INSEC_C	Insect Cond	nnn	Insect Cond	Integer
TI_INSEC_T	Insect Cond Text	25x	Insect Cond Text	Text
TI_INSP_CD	Inspected By	5x	Inspected By	Text
TI_INSP_TM	Inspection Time	mm/dd/yyyy hh:mm am	Inspection Time	DateTime
TI_INSP_TY	Inspected By Text	50x	Inspected By Text	Text
TI_INSPCRW	Inspection Crew	30x	Inspection Crew	Text
TI_INSPDT	Inspection Date	mm/dd/yyyy	Inspection Date	Date/Time
TI_INSTRCD	Insect Treatment	nnn	Insect Treatment	Integer
TI_INSTRTY	Insect Treatment Tex	25x	Insect Treatment Text	Text
TI_INSTYCD	Insect Type	nnn	Insect Type	Integer
TI_INSTYTY	Insect Type Text	25x	Insect Type Text	Text
TI_IPC	Installed Plant Cost	nnnnn	Installed Plant Cost	Integer
TI_ITC	Installation Cost	nnnnn	Installation Cost	Integer
TI_LATEST	Most Recent Inspection		Most Recent Inspection	Boolean
TI_LAWN_CD	Lawn Width	nnn	Lawn Width	Integer
TI_LAWN_TY	Lawn Width Text	25x	Lawn Width Text	Text
TI_LOCFACT	Location Factor	nnn	Location Factor	Integer
TI_MAINTREQ	Maint Requested		Maint Requested	Boolean
TI_MISHA_C	Mis-Shaped Cond	nnn	Mis-Shaped Cond	Integer
TI_MISHA_T	Mis-Shaped Cond Text	25x	Mis-Shaped Cond Text	Text
TI_MOD_BY	Last Modified By	25x	Last Modified By	Text
TI_MOD_DT	Last Modified Date	mm/dd/yyyy	Last Modified Date	Date/Time
TI_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
TI_MOIST_C	Moisture Cond	nnn	Moisture Cond	Integer
TI_MOIST_T	Moisture Cond Text	25x	Moisture Cond Text	Text
TI_MOV_FLG			Movie Available	Boolean
TI_MULCH_C	Mulch Cond	nnn	Mulch Cond	Integer
TI_MULCH_T	Mulch Cond Text	25x	Mulch Cond Text	Text
TI_MULCHCD	Mulch Type	nnnn	Mulch Type	Integer
TI_MULCHTY	Mulch Type Text	25x	Mulch Type Text	Text
TI_MULTRCD	Mulch Treat	nnn	Mulch Treat	Integer
TI_MULTRTY	Mulch Treat Text	25x	Mulch Treat Text	Text
TI_NEEDREP	Needs Repair		Needs Repair	Boolean
TI_NEXTDT	Next Inspection	mm/dd/yyyy	Next Inspection	Date/Time
TI_PLAFACT	Placement Factor	nnn	Placement Factor	Integer
TI_PRIORCD	Priority	nnn	Priority	Integer
TI_PRIORTY	Priority Text	25x	Priority Text	Text
TI_PRUNE_C	Pruning Cond	nnn	Pruning Cond	Integer
TI_PRUNE_T	Pruning Cond Text	25x	Pruning Cond Text	Text
TI_RCC	Removal Cost	nnnnn	Removal Cleanup Costs	Integer
TI_RCMAV	Replacement Value	nnnnn	Replacement Cost Method Appraised Value	Long Integer
TI_REPL	Replacement Cost	nnnnn	Replacement Cost	Integer
TI_ROOT_CD	Root Barrier	nnn	Root Barrier	Integer
TI_ROOT_H	Root Health Cond	n	Root Health Condition	Integer
TI_ROOT_S	Root Structural Cond	n	Root Structural Condition	Integer
TI_ROOT_ST	Root Subtotal Cond	n	Root Subtotal Condition	Integer
TI_ROOT_TY	Root Barrier Text	25x	Root Barrier Text	Text
TI_ROWVER			Rowversion for optimistic locking	Date/Time
TI_RQ_ID	Request Rec #	nnnnnnnn	Link to WKREQ.RQ_ID	Long Integer
TI_RTA	Replacement Area	nnn	Replacement Tree Area	Integer
TI_RTD	Replacement Dia	nnn	Replacement Tree Diameter	Integer
TI_SBT_HS	Small Branches/Twigs	n	Small Branches & Twigs Health Subtotal	Integer
TI_SCAF_H	Scaffold Health Cond	n	Scaffold Health Condition	Integer
TI_SCAF_S	Scaffold Structural	n	Scaffold Structural Condition	Integer
TI_SCAF_ST	Scaffold Subtotal Co	n	Scaffold Subtotal Condition	Integer
TI_SITFACT	Site Factor	nnn	Site Factor	Integer
TI_SOIL_C	Soil Cond	nnn	Soil Cond	Integer
TI_SOIL_CD	Soil Treat	nnn	Soil Treat	Integer
TI_SOIL_T	Soil Cond Text	25x	Soil Cond Text	Text
TI_SOIL_TY	Soil Treat Text	25x	Soil Treat Text	Text
TI_SPFACT	Species Factor	nnn	Species Factor	Integer
TI_SPREAD	Crown Spread	nnn.n	Crown Spread	Double
TI_STAKECD	Stake Type	nnn	Stake Type	Integer
TI_STAKETY	Stake Type Text	25x	Stake Type Text	Text
TI_STRUC_C	Structure Cond	nnn	Structure Cond	Integer
TI_STRUC_T	Structure Cond Text	25x	Structure Cond Text	Text
TI_TFMAV	Trunk Form Value	nnnnn	Trunk Formula Method Appraised Value	Long Integer
TI_TITC	Installed Tree Cost	nnnnn	Total Installed Tree Cost	Integer
TI_TR_ID	Tree Rec #	nnnnnnnn	Link to TREE.TR_ID	Long Integer
TI_TRNK_H	Trunk Health Cond	n	Trunk Health Condition	Integer
TI_TRNK_S	Trunk Structurl Cond	n	Trunk Structural Condition	Integer
TI_TRNK_ST	Trunk Subtotal Cond	n	Trunk Subtotal Condition	Integer
TI_TRUNK_C	Trunk Cond	nnn	Trunk Cond	Integer
TI_TRUNK_T	Trunk Cond Text	25x	Trunk Cond Text	Text
TI_TZ_ID	Tree Code Rec #		Link to TREECODES.TZ_ID	Long Integer
TI_UPROBCD	Utility Problems	nnn	Utility Problems	Integer
TI_UPROBTY	Utility Problem Text	25x	Utility Problems Text	Text
TI_USER1CD	User 1	nnn	User 1	Integer
TI_USER1TY	User 1 Text	25x	User 1 Text	Text
TI_USER2CD	User 2	nnn	User 2	Integer
TI_USER2TY	User 2 Text	25x	User 2 Text	Text
TI_USER3CD	User 3	nnn	User 3	Integer
TI_USER3TY	User 3 Text	25x	User 3 Text	Text
TI_USER4	User 4	30x	User 4	Text
TI_USER5	User 5	30x	User 5	Text
TI_USER6	User 6	30x	User 6	Text
TI_USER7	User 7	-nnnnnnnn.nn	User 7	Double
TI_USER8	User 8	-nnnnnnnn.nn	User 8	Double
TI_USER9	User 9	-nnnnnnnn.nn	User 9	Double
TI_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
TI_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
TI_USER12	User 12	mm/dd/yyyy	User 12	Date/Time
TI_USER13	User 13		User 13	Boolean
TI_USER14	User 14		User 14	Boolean
TI_USER15	User 15		User 15	Boolean
TI_USER16CD	User 16	nnn	User 16	Integer
TI_USER16TY	User 16 Text	50x	User 16 Text	String
TI_USER17CD	User 17	nnn	User 17	Integer
TI_USER17TY	User 17 Text	50x	User 17 Text	String
TI_USER18CD	User 18	nnn	User 18	Integer
TI_USER18TY	User 18 Text	50x	User 18 Text	String
TI_USER19CD	User 19	nnn	User 19	Integer
TI_USER19TY	User 19 Text	50x	User 19 Text	String
TI_USER20CD	User 20	nnn	User 20	Integer
TI_USER20TY	User 20 Text	50x	User 20 Text	String
TI_USER21	User 21	50x	User 21	String
TI_USER22	User 22	50x	User 22	String
TI_USER23	User 23	50x	User 23	String
TI_USER24	User 24	50x	User 24	String
TI_USER25	User 25	50x	User 25	String
TI_USER26	User 26	nnnnnnnn.nn	User 26	Double
TI_USER27	User 27	nnnnnnnn.nn	User 27	Double
TI_USER28	User 28	nnnnnnnn.nn	User 28	Double
TI_USER29	User 29	nnnnnnnn.nn	User 29	Double
TI_USER30	User 30	nnnnnnnn.nn	User 30	Double
TI_USER31	User 31	mm/dd/yyyy hh:mm am	User 31	DateTime
TI_USER32	User 32	mm/dd/yyyy hh:mm am	User 32	DateTime
TI_USER33	User 33	mm/dd/yyyy hh:mm am	User 33	DateTime
TI_USER34	User 34	mm/dd/yyyy hh:mm am	User 34	DateTime
TI_USER35	User 35	mm/dd/yyyy hh:mm am	User 35	DateTime
TI_USER36	User 36		User 36	Boolean
TI_USER37	User 37		User 37	Boolean
TI_USER38	User 38		User 38	Boolean
TI_USER39	User 39		User 39	Boolean
TI_USER40	User 40		User 40	Boolean
TI_UTC	Unit Tree Cost	nnnnn	Unit Tree Cost	Integer
TI_WEED_C	Weed Cond	nnn	Weed Cond	Integer
TI_WEED_T	Weed Cond Text	25x	Weed Cond	Text
TI_WHEIGHT	Wire Height	nnn.n	Wire Height	Double
TI_WIRE_CD	Overhead Wire	nnn	Overhead Wire	Integer
TI_WIRE_TY	Overhead Wire Text	25x	Overhead Wire Text	Text
TI_WO_ID	Work Order Rec #	nnnnnnnn	Link to WKORDER.WO_ID	Long Integer