qm_spec

qm_spec_name

string40

N

N

Name of specification for display

qm_spec_desc

string80

N

Y

Description of specification

edit_level

int32

N

N

Privilege level required to edit this record; default = 1

ver_id

string40

N

N

Version of this specification

start_eff_utc

tsmalldatetime

N

N

When does this version of this specification become effective, without seconds (default = current date, hour, and minute)

start_eff_local

tsmalldatetime

N

N

end_eff_utc

tsmalldatetime

N

Y

When does this version of this specification cease to be effective (null = when there is a qm_spec record with the same name but a later start_eff date; i.e., when this one is superseded)

end_eff_local

tsmalldatetime

N

Y

ent_id

int32

N

Y

Entity or entity class to which this specification applies

item_ id

string40

N

Y

Item to which this specification applies; if not null, item_category_id must be null

item_category_id

int32

N

Y

Item category to which this specification applies; if not null, item_id must be null

process_id

string40

N

Y

Process and operation to which this specification applies; either both must be null or both non-null

oper_id

string40

N

Y

category_id

int32

N

N

Category to which this specification belongs (initially, will default to 0)

plan_id

int32

N

Y

Default sample plan for this specification

num_pts_per_page

int32

N

Y

Default number of points per page for chart

display_seq

int32

N

N

The order in which to display the QM specification within a sample

spare1

string80

N

Y

Use defined by language term 7173

spare2

string80

N

Y

Use defined by language term 7174

spare3

string80

N

Y

Use defined by language term 7175

spare4

string80

N

Y

Use defined by language term 7176

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

qm_spec_id

ID 1

Y

N

Unique identifier