PKTREEACM

Tree Assessment Mitigation

Field Name

Caption

Mask

Description

Field Type

TE_CRT_BY

Created By

25x

Created By

String

TE_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

TE_ID

Rec #

nnnnnnnn

System assigned ID.

Long Integer

TE_MIT_CD

Mitigation

5x

Mitigation

String

TE_MIT_TY

Mitigation Text

60x

Mitigation Text

String

TE_MITDESC

Mitigation Description

250x

Mitigation Description

String

TE_MITIGNO

Mitigation Number

 

Mitigation Number

Small Integer

TE_MOD_BY

Last Modified By

25x

Last Modified By

String

TE_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

TE_MOD_TM

Last Modified Time

mm/dd/yyyy hh:mm am

Last Modified Time

DateTime

TE_PRIOR_CD

Priority

 

Priority

Small Integer

TE_PRIOR_TY

Priority Text

25x

Priority Text

String

TE_ROWVER

Rowversion for optimistic locking

 

Rowversion for optimistic locking

TimeStamp

TE_RRISK_CD

Residual Risk

 

Residual Risk

Small Integer

TE_RRISK_TY

Residual Risk Text

25x

Residual Risk Text

String

TE_TD_ID

Tree Assessment Category Record #

nnnnnnnn

Link to PKTREEAC.TD_ID

Long Integer