SMQIVC

Field Name

Caption

Mask

Description

Field Type

UA_CACTION

Corrective Action

20x

Corrective Action

String

UA_COMP

Completed

Completed

Boolean

UA_COMP_DT

Completed Date

mm/dd/yyyy hh:mm am

Completed Date

DateTime

UA_CRT_BY

Created By

25x

Created By

String

UA_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

UA_DDESC

Detailed Description

999x

Detailed Description

String

UA_DESC

Corrective Actionn Description

999x

Corrective Actionn Description

String

UA_DOC_FLG

Document Flag

Document Flag

Boolean

UA_DUE_DT

Due Date

mm/dd/yyyy hh:mm am

Due Date

DateTime

UA_ID

Industrial Violation Corrective Action Record Number

nnnnnnnn

Industrial Violation Corrective Action Record Number

Long Integer

UA_MOD_BY

Last Modified By

25x

Last Modified By

String

UA_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

UA_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

UA_NOT_DT

Notification Date

mm/dd/yyyy hh:mm am

Notification Date

DateTime

UA_NOTES

Notes

254x

Notes

String

UA_QI_ID

Industrial Rec No

nnnnnnnn

Link to SMQI.QI_ID

Long Integer

UA_ROWVER

Rowversion for optimistic locking

TimeStamp

UA_UV_ID

Industrial Inspection Violation Record No

nnnnnnnn

Link to SMQIV.UV_ID

Long Integer