qm_spec_char_link

qm_spec_id

int32

Y

N

Identify QM specification

char_id

int32

Y

N

Identify characteristic

target

tfloat

N

N

Target value for this characteristic for this QM specification context

lsv

tfloat

N

Y

Lower specification value*

usv

tfloat

N

Y

Upper specification value*

lsv_is_offset

logical

N

N

Is lsv the difference between target and lsl, i.e., lsv is not equal to lower spec limit (lsl) but is an offset Default = No

usv_is_offset

logical

N

N

Is usv the difference between usl and target, i.e., usv is not equal to upper spec limit (usl) but is an offset Default = No

lsv_offset_is_pct

logical

N

N

If lsv is an offset, is it a percent of the target? Default = No

usv_offset_is_pct

logical

N

N

If usv is an offset, is it a percent of the target? Default = No

lsl

tfloat

N

Y

Lower specification limit, maintained automatically from lsv, lsv_is_offset, and possibly lsv_offset_is_pct and target*

usl

tfloat

N

Y

Upper specification limit, maintained automatically from usv, usv_is_offset, and possibly usv_offset_is_pct and target*

lrv

tfloat

N

Y

Lower reasonable value*

urv

tfloat

N

Y

Upper reasonable value*

lrv_is_mult

logical

N

N

Is lrv a multiplier for the difference between the lower spec limits and target, to find offset from target for lrl; if not, lrv = lower reasonable limit (an absolute value) Default = No

urv_is_mult

logical

N

N

Is urv a multiplier for the difference between the upper spec limits and target, to find offset from target for url; if not, urv = upper reasonable limit (an absolute value) Default = No

severity_cd

int32

N

Y

Override char setting of severity

plan_id

int32

N

Y

Override QM_spec choice for sample plan

sample_size_source

int32

N

Y

If type = 1 or 2 (attribute):

0 = fixed

1 = entered

2 = entered but initially copied from the previous value

normal_sample_size

int32

N

Y

If variable or attribute with fixed sample size, the normal number of measurements in a sample

minimum_sample_size

int32

N

Y

The minimum number of measurements in a sample

maximum_sample_size

int32

N

Y

The maximum number of measurements in a sample

cl_source

int32

N

Y

Control limit source:

0 = automatically calculate from data

1 = compute from standard mean and standard deviation values (if variable) or compute from standard p, np average proportion and standard c, u average number per unit values (if attribute)

2 = use preset values

samples_for_cl

int32

N

Y

If cl_source = 0, the maximum number of samples to use for the calculation of control limits.

samples_before_cl

int32

N

Y

If cl_source = 0, the number of samples that must be measured before control limits are calculated.

std_avg

tfloat

N

Y

Only meaningful if cl_source = 1 (may not then be null). If type is variable this is the standard mean; if a binary attribute this is the standard p, np average proportion value; if a counted attribute this is the standard c, u average number per unit value.

std_avg_is_target

int32

N

Y

Only meaningful if cl_source = 1. If not null, used to override the std_avg_is_target setting for the characteristic; allowable values are 0 and 1. If 1 use the target instead of the std_avg value as the standard.

std_deviation

tfloat

N

Y

If variable and cl_source = 1

cl_xbar

tfloat

N

Y

If variable and cl_source = 2, center line for xbar

lcl_xbar

tfloat

N

Y

If variable and cl_source = 2, lower control limit for xbar

ucl_xbar

tfloat

N

Y

If variable and cl_source = 2, upper control limit for xbar

cl_range

tfloat

N

Y

If variable and cl_source = 2, center line for range

lcl_range

tfloat

N

Y

If variable and cl_source = 2, lower control limit for range

ucl_range

tfloat

N

Y

If variable and cl_source = 2, upper control limit for range

cl_sigma

tfloat

N

Y

If variable and cl_source = 2, center line for sigma

lcl_sigma

tfloat

N

Y

If variable and cl_source = 2, lower control limit for sigma

ucl_sigma

tfloat

N

Y

If variable and cl_source = 2, upper control limit for sigma

cl_ix

tfloat

N

Y

If variable and cl_source = 2, center line for individual x

lcl_ix

tfloat

N

Y

If variable and cl_source = 2, lower control limit for individual x

ucl_ix

tfloat

N

Y

If variable and cl_source = 2, upper control limit for individual x

cl_imr

tfloat

N

Y

If variable and cl_source = 2, center line for individual moving range

lcl_imr

tfloat

N

Y

If variable and cl_source = 2, lower control limit for individual moving range

ucl_imr

tfloat

N

Y

If variable and cl_source = 2, upper control limit for individual moving range

cl_ma

tfloat

N

Y

If variable and cl_source = 2, center line for moving average

lcl_ma

tfloat

N

Y

If variable and cl_source = 2, lower control limit for moving average

ucl_ma

tfloat

N

Y

If variable and cl_source = 2, upper control limit for moving average

cl_mr

tfloat

N

Y

If variable and cl_source = 2, center line for moving range

lcl_mr

tfloat

N

Y

If variable and cl_source = 2, lower control limit for moving range

ucl_mr

tfloat

N

Y

If variable and cl_source = 2, upper control limit for moving range

cl_ms

tfloat

N

Y

If variable and cl_source = 2, center line for moving sigma

lcl_ms

tfloat

N

Y

If variable and cl_source = 2, lower control limit for moving sigma

ucl_ms

tfloat

N

Y

If variable and cl_source = 2, upper control limit for moving sigma

cl_p

tfloat

N

Y

If attribute and cl_source = 2, center line for p, expressed as a decimal fraction (e.g., 5% would be stored as 0.05)

lcl_p

tfloat

N

Y

If attribute and cl_source = 2, lower control limit for p, expressed as a decimal fraction

ucl_p

tfloat

N

Y

If attribute and cl_source = 2, upper control limit for p, expressed as a decimal fraction

cl_np

tfloat

N

Y

If attribute and cl_source = 2, center line for np

lcl_np

tfloat

N

Y

If attribute and cl_source = 2, lower control limit for np

ucl_np

tfloat

N

Y

If attribute and cl_source = 2, upper control limit for np

cl_c

tfloat

N

Y

If attribute and cl_source = 2, center line for c

lcl_c

tfloat

N

Y

If attribute and cl_source = 2, lower control limit for c

ucl_c

tfloat

N

Y

If attribute and cl_source = 2, upper control limit for c

cl_u

tfloat

N

Y

If attribute and cl_source = 2, center line for u, in defects per unit

lcl_u

tfloat

N

Y

If attribute and cl_source = 2, lower control limit for u, in defects per unit

ucl_u

tfloat

N

Y

If attribute and cl_source = 2, upper control limit for u, in defects per unit

default_chart

int32

N

Y

If not null, override value in char table:

2 = Xbar + Range

3 = Xbar + Sigma

5 = IX + MR

7 = MA + Range

8 = MA + Sigma

16 = p

17 = np

18 = u

19 = c

20 = DPMO (coding per QI Analyst)

automated_coll

int32

N

N

Is this characteristic to be collected automatically?

0 = No

1 = Yes

2 = Use characteristic setting (default)

Note: This field is an integer datatype because in this table there is a third value (2) and so that it is nullable. The same field in the Characteristic table is a Boolean because in that table there are only two valid values (0 and 1) and it is non‑nullable.

time_interval

int32

N

Y

If sample size > 1 and automated_coll is Yes, the interval between measurements. Note this is a default for the characteristic, which can be overridden independently at each SRO.

time_int_unit

int32

N

Y

0 = seconds

1 = minutes

2 = hours

display_seq

int32

N

N

The order in which to display the characteristic within the QM specification

last_edit_comment

string254

N

Y

Reserved for internal use to indicate 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 1

N

N

Unique row identifier