Utility Locate Contacts
Field Name |
Caption |
Mask |
Description |
Field Type |
UC_CALLNO |
Contact Number |
nnn |
Call No |
Integer |
UC_CRT_BY |
Created By |
25x |
Created By |
Text |
UC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
UC_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
UC_EMAIL |
150x |
Text |
||
UC_FNAME |
Name |
40x |
First Name |
Text |
UC_ID |
AutoNumber |
nnnnnnnn |
Record # |
Long Integer |
UC_LNAME |
Last Name |
40x |
Last Name |
Text |
UC_MB_ID |
Member Rec # |
nnnnnnnn |
Link to WKUTILMB |
Long Integer |
UC_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
UC_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Date Modified |
Date/Time |
UC_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
UC_NAM_MI |
Middle Initial |
1x |
Name, Middle Initial |
Text |
UC_NAM_SAL |
Salutation |
6x |
Name, Salutation |
Text |
UC_NAM_SFX |
Name Suffix |
5x |
Name, Suffix (Jr., III) |
Text |
UC_NAMTYP_CD |
Name Type |
nnnn |
Name Type Code |
Integer |
UC_NAMTYP_TY |
Name Type Text |
30x |
Name Type Text |
Text |
UC_NOTES |
Notes |
255x |
Notes |
String |
UC_PHONE |
Phone |
25x |
Phone |
Text |
UC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |