New Sample_Char_Link Table (in FI_Large)

sample_id

int32

Y

N

Identify the sample

char_id

int32

Y

N

Identify the characteristic

qm_spec_id

int32

N

Y

Specification from which the sample was generated

note

notes

N

Y

Text note about this sample for this characteristic

cause_id

int32

N

Y

Identify cause for this characteristic of this sample

control_move

logical

N

N

Was there a change to an environmental factor for this sample that would render old control limits obsolete? Default = No

ignore_sample

logical

N

N

Should this sample be ignored when calculating statistics and control rule violations for this characteristic? Default = No

equipment

string80

N

Y

Equipment used to make the measurements for this characteristic for this sample

standard_dev

tfloat

N

Y

The sample standard deviation for this characteristic if variable; else null.

mean

tfloat

N

Y

The sample mean for this characteristic if variable; else the same as result.result_value.

range

tfloat

N

Y

The sample range for this characteristic if variable; else null.

act_sample_size

int

N

N

The actual sample (subgroup) size; for variable characteristics, the number of results in the sample for this characteristic that are not superseded. Default = 0.

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