data_log_value

grp_id

int32

Y

N

The ID of the data log group

value_index

int32

Y

N

Identifies which value

value_name

string80

N

N

The name of the value. Used as the column heading for the value.

value_type

int32

N

N

Enumeration of the type of data measured by this data log value, even though it is stored as a string:

0 = string (default)

1 = number

2 = logical

3 = datetime.

May be extended in the future

editable

logical

N

N

Determines whether the data log value can be modified by an operator. This would typically not be true only if the data log value is being entered through scripting and an MES API and an operator should be prevented from entering or changing the value.

cur_value

string80

N

Y

Current value for that value. May be populated from tag or manually – usually before triggering the sample.

spec_id

string40

N

Y

To optionally specify that this data log’s runtime value is sourced from the specified spec_id for the currently running job

meaning

int32

N

Y

Enumeration of the meaning for this value with respect to another value in the same data log group. Default = null = none.

1 = Upper Spec Limit

2 = Lower Spec Limit

3 = Upper Control Limit

4 = Lower Control Limit

5 = Upper Reasonable Limit

6 = Lower Reasonable Limit

7 = Target X

8 = Target R

9 = Target Std Dev

meaning_to_value_index

int32

N

Y

To specify which other value in this data log group the meaning field applies to

spare1

string1000

N

Y

Use defined by language term 2076

spare2

string1000

N

Y

Use defined by language term 2077

spare3

string1000

N

Y

Use defined by language term 2078

spare4

string1000

N

Y

Use defined by language term 2079

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

mod_id

timestamp

N

N

A binary number that increments each time the row is modified.

row_id

ID 1

N

N

Unique row identifier, for audit trail