New QM_Spec Table (in FI_Data_2)

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

tdatetime

N

N

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

start_eff_local

tdatetime

N

N

end_eff_utc

tdatetime

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

tdatetime

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, then 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

spare1

string80

N

Y

Use defined by language term ????

spare2

string80

N

Y

Use defined by language term ????

spare3

string80

N

Y

Use defined by language term ????

spare4

string80

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

qm_spec_id

ID 0

Y

N

Unique identifier