Job_Event
- Last UpdatedDec 18, 2018
- 1 minute read
-
Change "wo_id", "oper_id", "seq_no" from not nullable to nullable.
-
Add 6 new reserved event_type values, "Equipment Actual", "Material Consumable Actual", "Material Consumed Actual", "Material Produced Actual", "Personnel Actual", and "Production Data".
-
Add "genealogy_id" (string 254, nullable), "segment_requirement_id", "segment_response_id", and "subsegment_id" (all string80, nullable), and "quantity" (tfloat, nullable) before "comments" to allow these PEM or S95 attributes to be recorded from the OCO. (Use Cases 1336 and 1337)
-
Remove the foreign key from "wo_id", "oper_id", "seq_no" to the job table.