audit_trail

logged_at

datetime

N

N

When entry was logged

user_id

string40

N

N

User doing this insert, update or delete

change_type

int32

N

N

Enumeration of the type of the change this records:

0 = delete

1 = insert

2 = update

table_name

string40

N

N

Table being changed

row_id

int32

N

N

Link to row_id of the original table/row

column_name

string40

N

Y

Column name – only used for updates

old_value

string1700

N

Y

Old value for the given table and column converted to a string if necessary. Only used for updates. May be null for updates also.

new_value

string1700

N

Y

New value for the given table and column converted to a string if necessary. Only used for updates. May be null for updates also.

origin

string40

N

Y

To specify which MES application caused the audit trail entry (e.g., Operator, Supervisor etc). Null for external applications

comments

string254

N

Y

Optional comments field to detail reasons for the user’s action

delete_detail

nvarchar(max)

N

Y

XML string including deleted row’s last values for all fields.

log_id

ID 1

Y

N

Identify audit trail entry