SMQMVC

Field Name

Caption

Mask

Description

Field Type

LA_CACTION

Corrective Action

20x

Corrective Action

String

LA_COMP

Completed

Completed

Boolean

LA_COMP_DT

Completed Date

mm/dd/yyyy hh:mm am

Completed Date

DateTime

LA_CRT_BY

Created By

25x

Created By

String

LA_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

LA_DDESC

Detailed Description

999x

Detailed Description

String

LA_DESC

Corrective Actionn Description

999x

Corrective Actionn Description

String

LA_DOC_FLG

Document Flag

Document Flag

Boolean

LA_DUE_DT

Due Date

mm/dd/yyyy hh:mm am

Due Date

DateTime

LA_ID

Municipal Violation Corrective Action Record Number

nnnnnnnn

Auto ID

Long Integer

LA_LV_ID

Municipal Violation Record No

nnnnnnnn

Link to SMQMV.LV_ID

Long Integer

LA_MOD_BY

Last Modified By

25x

Last Modified By

String

LA_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

LA_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

LA_NOT_DT

Notification Date

mm/dd/yyyy hh:mm am

Notification Date

DateTime

LA_NOTES

Notes

254x

Notes

String

LA_QM_ID

Municipal Rec No

nnnnnnnn

Link to SMQM.QM_ID

Long Integer

LA_ROWVER

Rowversion for optimistic locking

TimeStamp