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

bottleneck_history

  • Last UpdatedNov 20, 2024
  • 1 minute read

The bottleneck_history table records over time which entities constituted the bottleneck for each line.

Field

Datatype

PK

Nulls?

Description

line_id

int32

Y

Y

Identifies the line.

ent_id

int32

Y

N

Identifies the entity that is, or is part of, the bottleneck for the line.

start_time_utc

tdatetime

Y

N

Starting time of the period to which this record applies.

start_time_local

tdatetime

N

N

end_time_utc

tdatetime

N

Y

Ending time of the period to which this record applies.

Null for the current period. If non-null, should equal the start_time_* of the next record for this line.

end_time_local

tdatetime

N

Y

est_prod_rate

tfloat

N

Y

The estimated amount of time per batch, in hours, that is needed to run the job.

last_edit_comment

notes

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

N

N

Unique row identifier, for audit trail.

FK from line_id to line. (Cascade delete)

FK from ent_id to ent. (Cascade delete)

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