job_event

event_time_utc

tdatetime

N

N

Timestamp of job event in UTC

event_time_local

tdatetime

N

N

Timestamp of job event in local time

wo_id

string40

N

Y

Identify work order

oper_id

string40

N

Y

Identify operation

seq_no

int32

N

Y

Identify job table row

step_no

int32

N

Y

Optionally identify the job step for this event

event_type

string40

N

Y

Optional user defined string field to categorize job events. "AddCons", "AddProd", "CertSignoff", "Equipment Actual", "JobNotes", "JobStateChanged", "Material Consumable Actual", "Material Consumed Actual", "Material Produced Actual", "Personnel Actual", "Production Data", "ReclassifyCons", "ReclassifyProd", "SpecChanged", "StepCompleted", "UnattendedSPCAcknowledgement" , and "WONotes" reserved for internal use.

ent_id

int32

N

Y

Optional entity related to this event if applicable.

bom_pos

int32

N

Y

Optional bom_pos related to this event if applicable

lot_no

string40

N

Y

Optional lot_no related to this event if applicable

sublot_no

string40

N

Y

Optional sublot_no related to this event if applicable

item_id

string40

N

Y

Optional item related to this event if applicable

cert_name

string40

N

Y

Optional certification related to this event if applicable

done_by_user_id

string40

N

Y

Optional user who performed an action for this event if applicable

checked_by_user_id

string40

N

Y

Optional user who checked an action for this event if applicable

source_row_id

int32

N

Y

Optional row in the item_prod or item_cons table to which this event relates if any

spec_id

string40

N

Y

Optional spec to which this event relates if any.

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

subsegment_id

string80

N

Y

S95 subsegment ID

quantity

tfloat

N

Y

Transaction quantity

comments

string254

N

Y

Optional comments for this event if required.

value1

string80

N

Y

Spare field for this event if required.

value2

string80

N

Y

Spare field for this event if required.

value3

string80

N

Y

Spare field for this event if required.

value4

string80

N

Y

Spare field for this event if required.

value5

string80

N

Y

Spare field for this event if required.

value6

string80

N

Y

Spare field for this event if required.

value7

string80

N

Y

Spare field for this event if required.

value8

string80

N

Y

Spare field for this event if required.

value9

string80

N

Y

Spare field for this event if required.

value10

string80

N

Y

Spare field for this event if required.

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 identifier for row (a job event)