Storm Water Quality Construction Site Email Tracking
Field Name |
Caption |
Mask |
Description |
Field Type |
HT_BY |
Tracked User |
25x |
Tracked User |
String |
HT_CRT_BY |
Created By |
25x |
Created By |
String |
HT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
HT_DESC |
Tracked Description |
125x |
Tracked Description |
String |
HT_DT |
Tracked Date |
mm/dd/yyyy hh:mm am |
Tracked Date |
DateTime |
HT_EMAIL_ID |
|
nnnnnnnn |
Link to the EMAILQUEUE table |
Long Integer |
HT_ID |
Construction Site Tracking Rec # |
nnnnnnnn |
Auto ID |
Long Integer |
HT_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
HT_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
HT_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
HT_QS_ID |
Construction Site Record No |
nnnnnnnn |
Long Integer |
|
HT_ROWVER |
|
|
Rowversion for optimistic locking |
TimeStamp |
HT_TM |
Tracked Time |
mm/dd/yyyy hh:mm am |
Tracked Time |
DateTime |
HT_TRACK |
Tracked Item |
125x |
Tracked Item |
String |