Tree Risk Assessment Target
Field Name |
Caption |
Mask |
Description |
Field Type |
TB_CRT_BY |
Created By |
25x |
Created By |
String |
TB_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
TB_DOC_FLG |
Document Flag |
|
Document Flag |
Boolean |
TB_ID |
Rec # |
nnnnnnnn |
System generated ID. |
Long Integer |
TB_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
TB_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
TB_MOD_TM |
Last Modified Time |
mm/dd/yyyy hh:mm am |
Last Modified Time |
DateTime |
TB_OR_CD |
Occupancy Rate |
|
Occupancy Rate |
Small Integer |
TB_OR_TY |
Occupancy Rate Text |
50x |
Occupancy Rate Text |
String |
TB_PTMT |
Practical to Move Target? |
|
Practical to Move Target? |
Boolean |
TB_ROWVER |
|
|
Rowversion for optimistic locking |
TimeStamp |
TB_RP |
Restriction Practical? |
|
Restriction Practical? |
Boolean |
TB_TA_ID |
Tree Record Assessment # |
nnnnnnnn |
Long Integer |
|
TB_TARGDESC |
Target Description |
100x |
Target Description |
String |
TB_TARGETNO |
Target Number |
|
Target Number |
Small Integer |
TB_TZ_CD |
Target Zone |
|
Target Zone |
Small Integer |
TB_TZ_TY |
Target Zone Text |
50x |
Target Zone Text |
String |