Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

rework_process_usage

  • Last UpdatedNov 20, 2024
  • 2 minute read

The rework_process_usage table specifies rework behavior for a given item reason and rework code, and optionally a given manufacturing process and manufactured item. This includes which rework process to use, the maximum number of times rework is permitted for a particular group of production, and if rework is part of the original work order, the point at which the reworked material re-enters the normal routing.

Field

Datatype

PK

Nulls?

Description

reas_cd

int32

N

N

Reason entered for item, which necessitates rework

orig_rework_cd

string40

N

N

Rework code of the job(s) from which rework originates

orig_process_id

string40

N

Y

ID of the process of the work order from which rework originates; null (default) if rework requirements not differentiated by process

item_id

string40

N

Y

Identify item produced; null (default) if rework requirements not differentiated by item

rework_process_id

string40

N

N

Identify set of rework operations to be done

max_times_rework

int32

N

Y

How many times the smallest identifiable group of production may be reworked for this; null (default) if no limit.

reentry_rework_cd

string40

N

Y

Rework code of the next downstream job to which the material is to be returned once reworked, if rework is part of the original work order. If null (default), it is the very next job.

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

N

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)

FK from reas_cd to item_reas. (Cascade delete)

FK from orig_process_id to process. (Cascade delete)

FK from item_id to item. (Cascade delete)

FK from rework_process_id to process. (Cascade delete implemented by SP)

reas_cd, orig_rework_cd, orig_process_id, item_id is UK.

TitleResults for “How to create a CRG?”Also Available in