New Prod_Rate_History Table (in FI_Data)

line_id

int32

N

Y

Identifies the line.

ent_id

int32

N

N

Identifies the entity.

start_time_utc

tdatetime

N

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 entity, unless the ability for the entity to run jobs was removed.

end_time_local

tdatetime

N

Y

est_prod_rate

tfloat

N

N

Estimated batch rate or time, depending on prod_uom.

prod_uom

int32

N

N

Unit of measure for est_prod_rate:

0 = hours/batch (default)

1 = minutes/batch

2 = seconds/batch

3 = batches/hour

4 = batches/minute

5 = batches/second

batch_size

tfloat

N

N

Standard batch size used for reporting production rate.

std_item_id

string40

N

N

Standard item used for reporting production rate.

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

Y

N

Unique row identifier, for audit trail.