New Characteristic Table (in FI_Data_2)

char_name

string40

N

N

Name of characteristic for display

char_desc

string80

N

Y

Description of characteristic

type

int32

N

N

0 (default) = variable

1 = binary attribute

2 = counted attribute

uom_id

int32

N

N

Identify unit of measure for this characteristic

severity_cd

int32

N

N

0 = Unused (language term 6939, not available for data entry)

1 = Not Monitored (language term 6940, control rule violations not checked)

2 (Default) = Non-Key (language term 6941)

3 = Key (language term 6942)

4 = Critical (language term 6943).Starting with v4.5 may not be > 1 if type is not 0 (variable).

default_chart

int32

N

N

2 = Xbar + Range

3 = Xbar + Sigma

5 (default) = IX + MR

7 = MA + Range

8 = MA + Sigma

16 = p

17 = np

18 = u

19 = c

20 = DPMO (coding per QI Analyst)

automated_coll

logical

N

N

Is this characteristic to be collected automatically? Default = no

time_interval

int32

N

Y

If number of results per sample > 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

num_decimals

int32

N

N

The number of decimals to display. Default = 0.

sample_size_source

int32

N

Y

If type = 1 or 2 (attribute):

0 = fixed (default)

1 = entered

2 = entered but copied from the previous value

normal_sample_size

int32

N

N

If variable or attribute with fixed sample size, the normal number of measurements in a sample; default = 1. If variable and normal_sample_size = 1, then data is not grouped.

minimum_sample_size

int32

N

N

The minimum number of measurements in a sample; default = 1

maximum_sample_size

int32

N

Y

The maximum number of measurements in a sample

num_defect_opp

int32

N

Y

If counted attribute, the number of defect opportunities per piece

mov_avg_span

int32

N

Y

Number of results to average for moving average charts; minimum = 2

sigma_est

int32

N

Y

If variable:

0 = use tables

1 = use std. dev.

trend_limits

logical

N

N

If variable, trend x-bar and IX limits Default = yes

use_std_err

logical

N

N

If trend_limits = yes, use standard error of regression as sigma estimate Default = no

cl_source

int32

N

Y

Control limit source:

0 = automatically calculate from data (default)

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. 0 (default) = use all

samples_before_cl

int32

N

N

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

std_avg

tfloat

N

Y

Only meaningful if cl_source = 1. 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

logical

N

N

Only meaningful if cl_source = 1. If yes (default) use the target instead of the std_avg value as the standard.

std_deviation

tfloat

N

Y

If variable and cl_source = 1, the standard deviation value

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

fit_test

int32

N

Y

If variable, test to use for goodness of fit 0 = Shapiro-Wilk, 1 = Kolmogorov-Smirnov, 2 = Chi-Square, 3 = none

hist_capability_sigma

int32

N

Y

0 = estimate using R-Bar

1 = estimate using S-Bar

2 = use within-group variation

filter_by_ent_id

logical

N

N

Should default dataset be limited by ent_id of current/last sample? Default = No

filter_by_item_id

logical

N

N

Should default dataset be limited by item_id of current/last sample? Default = No

filter_by_wo_id

logical

N

N

Should default dataset be limited by wo_id of current/last sample? Default = No

filter_by_oper_id

logical

N

N

Should default dataset be limited by oper_id of current/last sample? Default = No

filter_by_process_id

logical

N

N

Should default dataset be limited by process_id of current/last sample? Default = No

filter_by_segment
_req_id

logical

N

N

Should default dataset be limited by segment_requirement _id of current/last sample? Default = No

filter_by_segment
_resp_id

logical

N

N

Should default dataset be limited by segment_response _id of current/last sample? Default = No

filter_by_spare1

logical

N

N

Should default dataset be limited by the values in the spare1 field of current/last sample? Displayed by Language term 7509. Default = No

filter_by_spare2

logical

N

N

Should default dataset be limited by the values in the spare2 field of current/last sample? Displayed by Language term 7510. Default = No

filter_by_spare3

logical

N

N

Should default dataset be limited by the values in the spare3 field of current/last sample? Displayed by Language term 7511. Default = No

filter_by_spare4

logical

N

N

Should default dataset be limited by the values in the spare4 field of current/last sample? Displayed by Language term 7512. Default = No

spare1

string80

N

Y

Use defined by language term 7090

spare2

string80

N

Y

Use defined by language term 7091

spare3

string80

N

Y

Use defined by language term 7092

spare4

string80

N

Y

Use defined by language term 7093

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

char_id

ID 0

Y

N

Unique identifier