Utility Locate - Damage done to Others
Field Name |
Caption |
Mask |
Description |
Field Type |
UD_CD_MM |
COD - Mis Marked |
|
Cause of Damage - Mis Marked |
Boolean |
UD_CD_NM |
COD - Not Marked |
|
Cause of Damage - Not Marked |
Boolean |
UD_CD_OTH |
COD - Other |
|
Cause of Damage - Other |
Boolean |
UD_COORD |
Coordinator Comments |
254x |
Text field for the coordinator to use to document the damage |
Text |
UD_CRT_BY |
Created By |
25x |
Created By |
Text |
UD_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
UD_DAMAGE |
Crew Damage Comments |
254x |
Text field for the crews to use to explain why the damage happened |
Text |
UD_DAMG_DT |
Utility Damage Date |
mm/dd/yyyy |
Utility Damaged Date - as reported by the crew |
Date/Time |
UD_DAMG_TM |
Utility Damage Time |
hh:mm am |
Utility Damaged Time - as reported by the crew |
Date/Time |
UD_DOC_FLG |
Document Available |
|
Doc Available |
Boolean |
UD_DTNUMB |
Damage Ticket # |
15x |
Damage Ticket Number |
Text |
UD_EMPD_CD |
Empl Causing Damage |
20x |
Employee # of Employee Causing Damage |
Text |
UD_EMPD_TY |
Empl Causing Damage Name |
40x |
Employee Name of Employee Causing Damage |
Text |
UD_EMPR_CD |
Empl Report Damage |
20x |
Employee # of Employee Reporting Damage |
Text |
UD_EMPR_TY |
Empl Report Damage Name |
40x |
Employee Name of Employee Reporting Damage |
Text |
UD_EQPD_CD |
Equip Causing Damage |
20x |
Equipment Code of Equipment Causing Damage |
Text |
UD_EQPD_TY |
Equip Causing Damage Text |
50x |
Equipment Description of Equipment Causing Damage |
Text |
UD_ID |
Utility Damage Rec # |
nnnnnnnn |
Witness Record Number |
Long Integer |
UD_MAIN_CD |
Main Damaged |
nnnn |
Main Damaged |
Integer |
UD_MAIN_TY |
Main Damaged Text |
25x |
Main Damaged Text |
Text |
UD_MEMB_CD |
Utility Damaged |
nnnn |
Utility Damaged |
Integer |
UD_MEMB_TY |
Utility Damaged Text |
50x |
Utility Damaged Text |
Text |
UD_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
UD_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
UD_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
UD_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
UD_TOLD_CD |
Tool Causing Damage |
10x |
Tool Causing Damage |
Text |
UD_TOLD_TY |
Tool Causing Damage Text |
50x |
Tool Causing Damage Text |
Text |
UD_UCONT |
Utility Contact Name |
100x |
Name of Person for the Utility that was contacted |
Text |
UD_UPC_DT |
UPC Contacted Date |
mm/dd/yyyy |
UPC Contacted Date |
Date/Time |
UD_UPC_TM |
UPC Contacted Time |
hh:mm am |
UPC Contacted Time |
Date/Time |
UD_UT_ID |
Utility Loc Rec # |
nnnnnnnn |
Long Integer |
|
UD_UTIL_DT |
Utility Contacted Date |
mm/dd/yyyy |
Utility Contacted Date |
Date/Time |
UD_UTIL_TM |
Utility Contacted Time |
hh:mm am |
Utility Contacted Time |
Date/Time |