New Stats Table (in FI_Data)

char_id

int32

Y

N

Identify characteristic to which statistics pertain

ent_id

int32

Y

N

Entity to which the statistics apply, as of the most recent sample.

filter_ent_id

int32

N

Y

If not null, statistics are specific to this entity

item_id

string40

N

Y

If not null, statistics are specific to this item

item_category_id

int32

N

Y

This field is unused.

wo_id

string40

N

Y

If not null, statistics are specific to this work order

oper_id

string40

N

Y

If not null, statistics are specific to this operation

process_id

string40

N

Y

If not null, statistics are specific to this process

segment_requirement_id

string80

N

Y

If not null, statistics are specific to this segment requirement

segment_response_id

string80

N

Y

If not null, statistics are specific to this segment response

spare1

string80

N

Y

If not null, statistics are specific to this sample spare1 value

spare2

string80

N

Y

If not null, statistics are specific to this sample spare2 value

spare3

string80

N

Y

If not null, statistics are specific to this sample spare3 value

spare4

string80

N

Y

If not null, statistics are specific to this sample spare4 value

act_percent_out_of_sl

tfloat

N

N

Actual percent out of spec limits; default = 0

cp

tfloat

N

Y

Process capability index based on within-subgroup variability, assuming sample mean is centered at specification midpoint. Null for binary or counted characteristics, and when there are < 2 results.

cpk

tfloat

N

Y

Process capability index based on within-subgroup variability, taking into consideration sample mean. Null for binary or counted characteristics, and when there are < 2 results.

est_sigma

tfloat

N

Y

Estimated sigma (standard deviation estimated from samples based on default chart type if sigma_est = 0 or the same as stddev if sigma_est = 1). Null when there are < 2 results.

max_result_value

tfloat

N

N

Maximum result value; default = 0

mean_result_value

tfloat

N

N

Average (mean) result value; default = 0

min_result_value

tfloat

N

N

Minimum result value; default = 0

mrbar

tfloat

N

Y

Average moving range. Null for binary or counted characteristics, and when there are < 2 results.

msbar

tfloat

N

Y

Average moving standard deviation. Null for binary or counted characteristics, and when there are < 2 results.

pp

tfloat

N

Y

Pp. Null for binary or counted characteristics, and when there are < 2 results.

ppk

tfloat

N

Y

PpK. Null for counted characteristics, and when there are < 2 results.

range

tfloat

N

Y

Largest difference between result values. Null when there are < 2 results.

rbar

tfloat

N

Y

Average result value difference within a sample. Null for binary or counted characteristics, and when there are < 2 results.

num_results

int32

N

N

Number of results; default = 0

std_dev

tfloat

N

Y

Standard deviation estimated from measured population. Null when there are < 2 results.

total

int32

N

N

Number of samples (generally) ; default = 0

spare_tfloat1

tfloat

N

Y

Use defined by language term ????

spare_tfloat 2

tfloat

N

Y

Use defined by language term ????

spare_tfloat 3

tfloat

N

Y

Use defined by language term ????

spare_tfloat 4

tfloat

N

Y

Use defined by language term ????

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