New QM_Context Table (in FI_Data_2)

context_ent_id

int32

N

Y

Identify the entity portion of the context.

item_id

string40

N

Y

Identify the item or item category portion of the context. At most one of these 2 fields will be non-null.

item_category_id

int32

N

Y

process_id

string40

N

Y

Identify the process portion of the context.

context_oper_id

string40

N

Y

Identify the operation portion of the context.

ent_id

int32

N

N

The entity where sample is actually being collected.

wo_id

string40

N

Y

Identify the job that caused the item (/ item category) or operation (/ process) portion of the context to be used.

oper_id

string40

N

Y

seq_no

int32

N

Y

is_job_running

int32

N

N

If 3 fields above non-null, is that job currently running? Default = No.

spare1

string1000

N

Y

Use defined by language term ????

spare2

string1000

N

Y

Use defined by language term ????

spare3

string1000

N

Y

Use defined by language term ????

spare4

string1000

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

context_id

ID 0

Y

N

Unique identifier