SMQSVC

Field Name

Caption

Mask

Description

Field Type

HA_CACTION

Corrective Action

20x

Corrective Action

String

HA_COMP

Completed

Completed

Boolean

HA_COMP_DT

Completed Date

mm/dd/yyyy hh:mm am

Completed Date

DateTime

HA_CRT_BY

Created By

25x

Created By

String

HA_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

HA_DDESC

Detailed Description

999x

Detailed Description

String

HA_DESC

Corrective Actionn Description

999x

Corrective Actionn Description

String

HA_DOC_FLG

Document Flag

Document Flag

Boolean

HA_DUE_DT

Due Date

mm/dd/yyyy hh:mm am

Due Date

DateTime

HA_HV_ID

Construction Site Inspection Violation Record No

nnnnnnnn

Link to SMQSV.HV_ID

Long Integer

HA_ID

Violation Corrective Action Record Number

nnnnnnnn

Violation Corrective Action Record Number

Long Integer

HA_MOD_BY

Last Modified By

25x

Last Modified By

String

HA_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

HA_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

HA_NOT_DT

Notification Date

mm/dd/yyyy hh:mm am

Notification Date

DateTime

HA_NOTES

Notes

254x

Notes

String

HA_QS_ID

Construction Site Rec No

nnnnnnnn

Link to SMQS.QS_ID

Long Integer

HA_ROWVER

Rowversion for optimistic locking

TimeStamp