New Sample_To_Go Table (in FI_Data)

ent_id

int32

N

N

Entity at which the sample was generated

sample_name

string80

N

Y

Name of the sample (created according to sample_plan.sample_name)

wo_id

string40

N

Y

Identify job for which the sample was generated, if the QM specification has a context of either item or process and operation

oper_id

string40

N

Y

seq_no

int32

N

Y

context_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

context_oper_id

string40

N

Y

freq_id

int32

N

Y

Sample plan frequency from which the sample was generated

plan_id

int32

N

Y

Sample plan from which the sample was generated

requested_time_utc

tdatetime

N

N

When the sample will be requested (readied)

requested_time_local

tdatetime

N

N

expiry_time_utc

tdatetime

N

Y

When will the sample request expire

expiry_time_local

tdatetime

N

Y

warning_time_utc

tdatetime

N

Y

When will sample request turn to READY WARNING

warning_time_local

tdatetime

N

Y

sample_name_template

string80

N

Y

Same as the sample_name field of the sample_plan table that was used as a template to generate the value in this table's sample_name field. Not returned by ordinary access methods.

sample_name_instance

string80

N

Y

Same as the sample_name field of this table except with the ordinal number (if any) removed. Not returned by ordinary access methods.

current_sample_no

int32

N

Y

The ordinal number portion of the sample name if any. Not returned by ordinary access methods.

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

sample_id

ID 1

Y

N

Unique identifier