cert_audit_log

wo_id

string40

N

Y

Identify work order

oper_id

string40

N

Y

Identify operation

seq_no

int32

N

Y

Identify row in job table

step_no

int32

N

Y

Identify step; null for entire op.

lot_no

string40

N

Y

Identify the lot

sublot_no

string40

N

Y

Identify the sublot

prod_log_id

int32

N

Y

ID row in item_prod

cons_log_id

int32

N

Y

ID row in item_cons

grp_id

int32

N

Y

Identify data log group; null except for signoffs of a data log sample

process_id

string40

N

Y

Identify process whose status is to be changed

process_status

int32

N

Y

Intended status of process:

-1 = Disabled

1 = Experimental

2 = Approved

3 = Certified

active

logical

N

N

Is this record relevant to a pending change? Default = Yes.

cert_name

string40

N

N

Unique name for certification

user_id

string40

N

N

Identify auditor

sign_off_utc

tdatetime

N

N

When audited in UTC

sign_off_local

tdatetime

N

N

When audited in local time

comments

string254

N

Y

Optional comments field when signoff occurs

ref_row_id

bigint64

N

Y

For signoffs related to a step, the row_id of the relevant job_step_data record. For signoffs related to a data log sample, the row_id of the relevant data_log record.

last_edit_comment

notes

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

Y

Who last changed this record

last_edit_at

tdatetime

N

N

When this record was last changed

row_id

ID 1

Y

N

Unique row identifier, for audit trail.