data_log

grp_id

int32

N

N

The ID of the data log group

ent_id

int32

N

Y

The ID of the entity from which data came

sample_time_utc

tdatetime2

N

N

When sample was first taken in UTC

sample_time_local

tdatetime2

N

N

When sample was first taken in local time

wo_id

string40

N

Y

Identify work order

oper_id

string40

N

Y

Identify operation

seq_no

int32

N

Y

Identify sequence number in job table

step_no

int32

N

Y

Identify step within job

item_id

string40

N

Y

To which item data applied

lot_no

string40

N

Y

To which lot data applied

sublot_no

string40

N

Y

To which sublot data applied

shift_id

int32

N

N

Identify Shift

shift_start_utc

tdatetime

N

N

When shift started in UTC

shift_start_local

tdatetime

N

N

When shift started in local time

genealogy_id

string254

N

Y

PEM intra-segment genealogy ID

segment_requirement_
id

string80

N

Y

S95 segment requirement ID

segment_response_id

string80

N

Y

S95 segment response ID

value1 to value64

string80

N

Y

Values to be logged

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

created_at_utc

tdatetime

N

N

When this record was created, in UTC

created_at_local

tdatetime

N

N

When this record was created, in the local time of the entity

row_id

bigint64

Y

N

Unique row identifier, for audit trail.