oee_exec

ent_id

int32

Y

N

To which entity these values apply

job_ent_id

int32

N

N

ID of entity from which to get production data

util_ent_id

int32

N

N

ID of entity from which to get utilization data

target_perf

float

N

Y

Target performance

current_perf

float

N

Y

This column is not used. The current performance is calculated and returned to the client when requested.

target_qual

float

N

Y

Target quality

current_qual

float

N

Y

This column is not used. The current quality is calculated and returned to the client when requested.

def_prod_rate

float

N

Y

Default production rate or time so OEE can be calculated if item is unknown as in straight monitoring application; must be > 0 if not null

prod_uom

int32

N

N

Unit of measure for def_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

The standard batch size to which the production rate applies. The default value is 1.

std_item_id

string40

N

Y

The ID of the item to which the production rate applies

target_oee

float

N

Y

Target OEE

current_oee

float

N

Y

This column is not used. The current OEE is calculated and returned to the client when requested.

basis

int32

N

N

0=OEE displayed by shift (default)

1=OEE displayed by job

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

Y

Who last changed this record

last_edit_at

tdatetime

N

N

When this record was last changed