New Bottleneck_History Table (in FI_Data)

line_id

int32

Y

N

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

last_edit_comment

string254

N

Y

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 0

N

N

Unique row identifier, for audit trail.