PKTREEA

Field Name

Caption

Mask

Description

Field Type

TA_AAN

Advanced Assessment Need

Advanced Assessment Need

Boolean

TA_AAND

Advanced Assessment Need Description

250x

Advanced Assessment Need Description

String

TA_ABIOTIC

Abiotic

250x

Abiotic

String

TA_ASPECT

Aspect/Compass Direction

nnnnnnnn.nn

Aspect/Compass Direction

Double

TA_ASSES

Assessor

100x

Assessor

String

TA_BBURLC

Burls Concern

Burls Concern

Boolean

TA_BBURLP

Burls Present

Burls Present

Boolean

TA_BCANKC

Canker Concern

Canker Concern

Boolean

TA_BCANKP

Canker Present

Canker Present

Boolean

TA_BCNH

Cavity/Nest Hole % Circ

nnnnnnnn.nn

Cavity/Nest Hole % Circ

Double

TA_BCONK

Conks

Conks

Boolean

TA_BCONKDES

Conks Description

100x

Conks Description

String

TA_BCRACKS

Cracks

Cracks

Boolean

TA_BCRADESC

Cracks Description

250x

Cracks Description

String

TA_BDMB

Dead/Missing Bark

Dead/Missing Bark

Boolean

TA_BGALLC

Galls Concern

Galls Concern

Boolean

TA_BGALLP

Galls Present

Galls Present

Boolean

TA_BHEART

Heartwood Decay

Heartwood Decay

Boolean

TA_BHEARTD

Heartwood Description

100x

Heartwood Description

String

TA_BHMD

Broken/Hangers Max Dia

nnnnnnnn.nn

Broken/Hangers Max Dia

Double

TA_BHN

Broken/Hangers

nnnnnnnn.nn

Broken/Hangers

Double

TA_BLD

Lightning Damage

Lightning Damage

Boolean

TA_BLOD_CD

Load on Defect

Load on Defect

Small Integer

TA_BLOD_TY

Load on Defect Text

25x

Load on Defect Text

String

TA_BLODDESC

Load on Defect Descr

100x

Load on Defect Descr

String

TA_BLOF_CD

Likeliness of Fail

Likeliness of Fail

Small Integer

TA_BLOF_TY

Likeliness of Fail Text

25x

Likeliness of Fail Text

String

TA_BLOFDESC

Likeliness of Fail Desc

100x

Likeliness of Fail Desc

String

TA_BMAINC

Main Concern

250x

Main Concern

String

TA_BRGROWTH

Response Growth

250x

Response Growth

String

TA_BSAPDAM

Sapwood Damage

Sapwood Damage

Boolean

TA_BSAPDEC

Sapwood Decay

Sapwood Decay

Boolean

TA_CD_CD

Crown Density

5x

Crown Density

String

TA_CD_TY

Crown Density Text

30x

Crown Density Text

String

TA_CDCSH

CD - Compacted

CD - Compacted

Boolean

TA_CDDESC

Describe Soil Condition

250x

Describe Soil Condition

String

TA_CDGC

CD - Saturated

CD - Saturated

Boolean

TA_CDLV

Soil Conditions Limited Volume

Soil Conditions Limited Volume

Boolean

TA_CDRC

CD - Pavement over Roots

CD - Pavement over Roots

Boolean

TA_CDSC

CD - Shallow

CD - Shallow

Boolean

TA_CDSLOPE

CD - Slope %

nnnnnnnn.nn

CD - Slope %

Double

TA_CODOM

Codominant

Codominant

Boolean

TA_CONDESC

Codominant Description

250x

Codominant Description

String

TA_CRT_BY

Created By

25x

Created By

String

TA_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

TA_CSPREAD

Crown Spread

nnnnnnnn.nn

Crown Spread

Double

TA_CWDESC

Describe Weather

250x

Describe Weather

String

TA_CWHR

CW -  Heavy Rain

CW -  Heavy Rain

Boolean

TA_CWI

CW -  Ice

CW -  Ice

Boolean

TA_CWS

CW -  Snow

CW -  Snow

Boolean

TA_CWSW

Common Weather Strong Winds

Common Weather Strong Winds

Boolean

TA_DATA_CD

Data

Data

Small Integer

TA_DATA_TY

Data Text

25x

Data Text

String

TA_DBH

Diameter

nnnnnnnn.nn

Diameter

Double

TA_DOC_FLG

Document Available

Document Available

Boolean

TA_DTB

Dead Twigs/Branches

Dead Twigs/Branches

Boolean

TA_DTBMD

Dead Twigs/Branches Max Dia

nnnnnnnn.nn

Dead Twigs/Branches Max Dia

Double

TA_DTBPER

Dead Twigs/Branches %

nnnnnnnn.nn

Dead Twigs/Branches %

Double

TA_FAIL

Failure History

250x

Failure History

String

TA_FCHLOR

Foliage Cholrotic %

nnnnnnnn.nn

Foliage Cholrotic %

Double

TA_FND

Foliage - None (Dead)

Foliage - None (Dead)

Boolean

TA_FNECR

Foliage Necrotic %

nnnnnnnn.nn

Foliage Necrotic %

Double

TA_FNORMAL

Foliage Normal %

nnnnnnnn.nn

Foliage Normal %

Double

TA_FNS

Foliage - None (Seasonal)

Foliage - None (Seasonal)

Boolean

TA_HEIGHT

Height

nnnnnnnn.nn

Height

Double

TA_IB_CD

Interior Branches

5x

Interior Branches

String

TA_IB_TY

Interior Branches Text

30x

Interior Branches Text

String

TA_IBARK

Included Bark

Included Bark

Boolean

TA_ID

nnnnnnnn

System assigned ID.

Long Integer

TA_IFREQ

Inspection Frequency

Inspection Frequency

Small Integer

TA_IFRQ_CD

Inspection Frequency Units

Inspection Frequency Units

Small Integer

TA_IFRQ_TY

Inspection Frequency Units Text

10x

Inspection Frequency Units Text

String

TA_ILA

Access

Access

Boolean

TA_ILN

Inspection Limitations - None

Inspection Limitations - None

Boolean

TA_ILO

Other

Other

Boolean

TA_ILODES

Other Description

250x

Other Description

String

TA_ILRCB

Root Collar Buried

Root Collar Buried

Boolean

TA_ILV

Visibility

Visibility

Boolean

TA_ILVI

Vines

Vines

Boolean

TA_INSP_CD

Assessed By

5x

Assessed By

String

TA_INSP_DT

Inspection Date

mm/dd/yyyy hh:mm am

Inspection Date

DateTime

TA_INSP_TM

Inspection Time

mm/dd/yyyy hh:mm am

Inspection Time

DateTime

TA_INSP_TY

Assessed By text

30x

Assessed By text

String

TA_LATEST

Most Recent Inspection

Most Recent Inspection

Boolean

TA_LCR

Live Crown Ratio %

nnnnnnnn.nn

Live Crown Ratio %

Double

TA_LFC

Load Factor Changes

250x

Load Factor Changes

String

TA_MAINTREQ

Maint Requested

Maintenance Requested

Boolean

TA_MEMO1

General Comment

250x

General Comment

String

TA_MOD_BY

Last Modified By

25x

Last Modified By

String

TA_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

TA_MOD_TM

Last Modified Time

mm/dd/yyyy hh:mm am

Last Modified Time

DateTime

TA_NEEDREP

Needs Repair

Needs Repair

Boolean

TA_NEXT_DT

Next Inspection

mm/dd/yyyy hh:mm am

Next Inspection

DateTime

TA_NOTES

Notes

250x

Notes

String

TA_OEB

Overextended Branches

Overextended Branches

Boolean

TA_ORR_CD

Overall Residual Risk

Overall Residual Risk

Small Integer

TA_ORR_TY

Overall Residual Risk Text

25x

Overall Residual Risk Text

String

TA_OTRR_CD

Overall Tree Risk Rating

Overall Tree Risk Rating

Small Integer

TA_OTRR_TY

Overall Tree Risk Rating Text

25x

Overall Tree Risk Rating Text

String

TA_PBF

Previous Branch Failures

Previous Branch Failures

Boolean

TA_PBFDESC

Previous Branch Failures Description

250x

Previous Branch Failures Description

String

TA_PESTS

Pests

250x

Pests

String

TA_PHCC

PH - Crown Cleaned

PH - Crown Cleaned

Boolean

TA_PHFC

PH - Flush Cuts

PH - Flush Cuts

Boolean

TA_PHLT

PH - Lion-Tailed

PH - Lion-Tailed

Boolean

TA_PHO

PH - Other

PH - Other

Boolean

TA_PHODES

PH - Other Description

100x

PH - Other Description

String

TA_PHRA

PH - Raised

PH - Raised

Boolean

TA_PHRE

PH - Reduced

PH - Reduced

Boolean

TA_PHT

PH - Thinned

PH - Thinned

Boolean

TA_PHTOP

PH - Topped

PH - Topped

Boolean

TA_PWD

Prevailing Wind Dir

2x

Prevailing Wind Dir

String

TA_RCBNV

Collar Buried Not Vis

Collar Buried Not Vis

Boolean

TA_RCD

Root Collar Depth

nnnnnnnn.nn

Root Collar Depth

Double

TA_RCNH

Cavity/Nest Hole % Circ

nnnnnnnn.nn

Cavity/Nest Hole % Circ

Double

TA_RCONK

Conks/Mushrooms

Conks/Mushrooms

Boolean

TA_RCONKDES

Conks/Mushrooms Description

100x

Conks/Mushrooms Description

String

TA_RCRACKS

Cracks

Cracks

Boolean

TA_RCRADESC

Cracks Description

250x

Cracks Description

String

TA_RCS_CD

Relative Crown Size

5x

Relative Crown Size

String

TA_RCS_TY

Relative Crown Size Text

30x

Relative Crown Size Text

String

TA_RCUT

Roots Cut/Damaged

Roots Cut/Damaged

Boolean

TA_RCUTD

Roots Cut/Damaged Description

nnnnnnnn.nn

Roots Cut/Damaged Description

Double

TA_RDEAD

Root Dead

Root Dead

Boolean

TA_RDECAY

Root Decay

Root Decay

Boolean

TA_RDECAYD

Root Decay Description

100x

Root Decay Description

String

TA_RLOD_CD

Load on Defect

Load on Defect

Small Integer

TA_RLOD_TY

Load on Defect Text

25x

Load on Defect Text

String

TA_RLODDESC

Load on Defect Description

100x

Load on Defect Description

String

TA_RLOF_CD

Likeliness of Fail

Likeliness of Fail

Small Integer

TA_RLOF_TY

Likeliness of Fail Text

25x

Likeliness of Fail Text

String

TA_RLOFDESC

Likeliness of Fail Description

100x

Likeliness of Fail Description

String

TA_RMAINC

Main Concern

250x

Main Concern

String

TA_ROOZE

Root Ooze

Root Ooze

Boolean

TA_ROOZED

Root Ooze Description

100x

Root Ooze Description

String

TA_ROWVER

Rowversion for optimistic locking

TimeStamp

TA_RPL

Root Plate Lifting

Root Plate Lifting

Boolean

TA_RPLD

Root Plate Lifting Description

100x

Root Plate Lifting Description

String

TA_RQ_ID

Link to Request

nnnnnnnn

Link to WKREQ.RQ_ID

Long Integer

TA_RRGROWTH

Response Growth

250x

Response Growth

String

TA_RSG

Root Stem Girdling

Root Stem Girdling

Boolean

TA_RSW

Root Soil Weakness

Root Soil Weakness

Boolean

TA_RSWD

Root Soil Weakness Description

100x

Root Soil Weakness Description

String

TA_SBP

Similar Branches Present

Similar Branches Present

Boolean

TA_SCCSH

SC - Changed Soil Hydro

SC - Changed Soil Hydro

Boolean

TA_SCDESC

Describe Site Changes

250x

Describe Site Changes

String

TA_SCGC

Site Change Grade Change

Site Change Grade Change

Boolean

TA_SCN

Site Changes - None

Site Changes - None

Boolean

TA_SCRC

SC - Root Cuts

SC - Root Cuts

Boolean

TA_SCSC

Site Change Site Clearing

Site Change Site Clearing

Boolean

TA_SFPB

Species Failure Profile - Branches

Species Failure Profile - Branches

Boolean

TA_SFPDES

SFP - Description

250x

SFP - Description

String

TA_SFPR

SFP - Roots

SFP - Roots

Boolean

TA_SFPT

SFP - Trunk

SFP - Trunk

Boolean

TA_SLOPE

Slope

nnnnnnnn.nn

Slope

Double

TA_TABRC

Abnormal Bark

Abnormal Bark

Boolean

TA_TABRCDD

Abnormal Bark Desc

100x

Abnormal Bark Desc

String

TA_TBURLC

Burls Concern

Burls Concern

Boolean

TA_TBURLP

Burls Present

Burls Present

Boolean

TA_TCANKC

Canker Concern

Canker Concern

Boolean

TA_TCANKP

Canker Present

Canker Present

Boolean

TA_TCLEAN

Corrected Lean Descr

250x

Corrected Lean Descr

String

TA_TCNH

Cavity/Nest Hole % Circ

nnnnnnnn.nn

Cavity/Nest Hole % Circ

Double

TA_TCNHD

Cavity/Nest Hole Depth

nnnnnnnn.nn

Cavity/Nest Hole Depth

Double

TA_TCODOM

Codominant Stems

Codominant Stems

Boolean

TA_TCODOMD

Codominant Stems Descr

100x

Codominant Stems Descr

String

TA_TCONK

Conks/Mushrooms

Conks/Mushrooms

Boolean

TA_TCONKDES

Conks/Mush Description

100x

Conks/Mush Description

String

TA_TCRACKS

Cracks

Cracks

Boolean

TA_TCRADESC

Cracks - Description

250x

Cracks - Description

String

TA_TDMB

Dead/Missing Bark

Dead/Missing Bark

Boolean

TA_TFRAME

Failure Time Frame

nnnnnnnn.nn

Failure Time Frame

Double

TA_TGALLC

Galls Concern

Galls Concern

Boolean

TA_TGALLP

Galls Present

Galls Present

Boolean

TA_THEART

Heartwood Decay

Heartwood Decay

Boolean

TA_THEARTD

Heartwood Description

100x

Heartwood Description

String

TA_TIB

Included Bark

Included Bark

Boolean

TA_TLD

Lightning Damage

Lightning Damage

Boolean

TA_TLEAN

Trunk Lean (angle)

nnnnnnnn.nn

Trunk Lean (angle)

Double

TA_TLOD_CD

Load on Defect

Load on Defect

Small Integer

TA_TLOD_TY

Load on Defect Text

25x

Load on Defect Text

String

TA_TLODDESC

Load on Defect Description

100x

Load on Defect Description

String

TA_TLOF_CD

Likeliness of Fail

Likeliness of Fail

Small Integer

TA_TLOF_TY

Likeliness of Fail Text

25x

Likeliness of Fail Text

String

TA_TLOFDESC

Likeliness of Fail Description

100x

Likeliness of Fail Description

String

TA_TMAINC

Main Concern

250x

Main Concern

String

TA_TOOLS

Tools Used

250x

Tools Used

String

TA_TOP_CD

Topography

Topography

Small Integer

TA_TOP_TY

Topography Text

25x

Topography Text

String

TA_TPTAPER

Poor Taper

Poor Taper

Boolean

TA_TR_ID

Tree Record #

nnnnnnnn

Link to TREE.TR_ID

Long Integer

TA_TRGROWTH

Response Growth

250x

Response Growth

String

TA_TSAPDAM

Sapwood Damage

Sapwood Damage

Boolean

TA_TSAPDEC

Sapwood Decay

Sapwood Decay

Boolean

TA_TSAPO

Sap Ooze

Sap Ooze

Boolean

TA_UC

Unbalanced Crown

Unbalanced Crown

Boolean

TA_USER1CD

User 1

User 1

Small Integer

TA_USER1TY

User 1 Text

50x

User 1 Text

String

TA_USER2CD

User 2

User 2

Small Integer

TA_USER2TY

User 2 Text

50x

User 2 Text

String

TA_USER3CD

User 3

User 3

Small Integer

TA_USER3TY

User 3 Text

50x

User 3 Text

String

TA_USER4CD

User 4

User 4

Small Integer

TA_USER4TY

User 4 Text

50x

User 4 Text

String

TA_USER5CD

User 5

User 5

Small Integer

TA_USER5TY

User 5 Text

50x

User 5 Text

String

TA_USER6

User 6

50x

User 6

String

TA_USER7

User 7

50x

User 7

String

TA_USER8

User 8

50x

User 8

String

TA_USER9

User 9

50x

User 9

String

TA_USER10

User 10

50x

User 10

String

TA_USER11

User 11

nnnnnnnn.nn

User 11

Double

TA_USER12

User 12

nnnnnnnn.nn

User 12

Double

TA_USER13

User 13

nnnnnnnn.nn

User 13

Double

TA_USER14

User 14

nnnnnnnn.nn

User 14

Double

TA_USER15

User 15

nnnnnnnn.nn

User 15

Double

TA_USER16

User 16

mm/dd/yyyy hh:mm am

User 16

DateTime

TA_USER17

User 17

mm/dd/yyyy hh:mm am

User 17

DateTime

TA_USER18

User 18

mm/dd/yyyy hh:mm am

User 18

DateTime

TA_USER19

User 19

mm/dd/yyyy hh:mm am

User 19

DateTime

TA_USER20

User 20

mm/dd/yyyy hh:mm am

User 20

DateTime

TA_USER21

User 21

User 21

Boolean

TA_USER22

User 22

User 22

Boolean

TA_USER23

User 23

User 23

Boolean

TA_USER24

User 24

User 24

Boolean

TA_USER25

User 25

User 25

Boolean

TA_USER26CD

User 26

User 26

Small Integer

TA_USER26TY

User 26 Text

50x

User 26 Text

String

TA_USER27CD

User 27

User 27

Small Integer

TA_USER27TY

User 27 Text

50x

User 27 Text

String

TA_USER28CD

User 28

User 28

Small Integer

TA_USER28TY

User 28 Text

50x

User 28 Text

String

TA_USER29CD

User 29

User 29

Small Integer

TA_USER29TY

User 29 Text

50x

User 29 Text

String

TA_USER30CD

User 30

User 30

Small Integer

TA_USER30TY

User 30 Text

50x

User 30 Text

String

TA_USER31

User 31

50x

User 31

String

TA_USER32

User 32

50x

User 32

String

TA_USER33

User 33

50x

User 33

String

TA_USER34

User 34

50x

User 34

String

TA_USER35

User 35

50x

User 35

String

TA_USER36

User 36

nnnnnnnn.nn

User 36

Double

TA_USER37

User 37

nnnnnnnn.nn

User 37

Double

TA_USER38

User 38

nnnnnnnn.nn

User 38

Double

TA_USER39

User 39

nnnnnnnn.nn

User 39

Double

TA_USER40

User 40

nnnnnnnn.nn

User 40

Double

TA_USER41

User 41

mm/dd/yyyy hh:mm am

User 41

DateTime

TA_USER42

User 42

mm/dd/yyyy hh:mm am

User 42

DateTime

TA_USER43

User 43

mm/dd/yyyy hh:mm am

User 43

DateTime

TA_USER44

User 44

mm/dd/yyyy hh:mm am

User 44

DateTime

TA_USER45

User 45

mm/dd/yyyy hh:mm am

User 45

DateTime

TA_USER46

User 46

User 46

Boolean

TA_USER47

User 47

User 47

Boolean

TA_USER48

User 48

User 48

Boolean

TA_USER49

User 49

User 49

Boolean

TA_USER50

User 50

User 50

Boolean

TA_VIGOR_CD

Vigor

5x

Vigor

String

TA_VIGOR_TY

Vigor Text

30x

Vigor Text

String

TA_VMM

Vines/Mistletoe/Moss

Vines/Mistletoe/Moss

Boolean

TA_VMMDES

Vines/Mistletoe/Moss - Description

100x

Vines/Mistletoe/Moss - Description

String

TA_WA

Weak Attachments

Weak Attachments

Boolean

TA_WADESC

Weak Attachments Description

250x

Weak Attachments Description

String

TA_WEDES

WE - Description

250x

WE - Description

String

TA_WEF

WE - Full

WE - Full

Boolean

TA_WEFUN

WE - Wind Funneling

WE - Wind Funneling

Boolean

TA_WEPA

WE - Partial

WE - Partial

Boolean

TA_WEPR

Wind Exposure - Protected

Wind Exposure - Protected

Boolean

TA_WO_ID

Work Order Rec #

nnnnnnnn

Link to WKORDER.WO_ID

Long Integer

TA_WP_CD

Work Priority

Work Priority

Small Integer

TA_WP_TY

Work Priority Text

25x

Work Priority Text

String