SMQMTR

Storm Water Quality Municipal Email Tracking

Field Name

Caption

Mask

Description

Field Type

LT_BY

Tracked User

25x

Tracked User

String

LT_CRT_BY

Created By

25x

Created By

String

LT_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

LT_DESC

Tracked Description

125x

Tracked Description

String

LT_DT

Tracked Date

mm/dd/yyyy hh:mm am

Tracked Date

DateTime

LT_EMAIL_ID

 

nnnnnnnn

Link to the EMAILQUEUE table

Long Integer

LT_ID

Municipal Tracking Rec #

nnnnnnnn

Auto ID

Long Integer

LT_MOD_BY

Last Modified By

25x

Last Modified By

String

LT_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

LT_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

LT_QM_ID

Municipal Record No

nnnnnnnn

Link to SMQM.QM_ID

Long Integer

LT_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

LT_TM

Tracked Time

mm/dd/yyyy hh:mm am

Tracked Time

DateTime

LT_TRACK

Tracked Item

125x

Tracked Item

String