sample

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)

item_id

string40

N

Y

Item from which the sample was generated

wo_id

string40

N

Y

Identify job which the sample was generated

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

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

segment_requirement_id

string80

N

Y

S95 field

segment_response_id

string80

N

Y

S95 field

lot_no

string40

N

Y

Identify lot from which sample was pulled

sublot_no

string40

N

Y

Identify sublot from which sample was pulled

requested_time_utc

tdatetime

N

N

When was sample requested (readied)

requested_time_local

tdatetime

N

N

expiry_time_utc

tdatetime

N

Y

When does sample request expire

expiry_time_local

tdatetime

N

Y

warning_time_utc

tdatetime

N

Y

When does sample request turn to READY WARNING

warning_time_local

tdatetime

N

Y

pulled_by

string40

N

Y

Who pulled the sample

pulled_time_utc

tdatetime

N

Y

When was the sample pulled

pulled_time_local

tdatetime

N

Y

final

logical

N

N

Is editing of any data associated with this sample prohibited? Default = No

finalized_by

string40

N

Y

Who marked the sample as final

finalized_at_utc

tdatetime

N

Y

When was this sample marked as final

finalized_at_local

tdatetime

N

Y

verified_by

string40

N

Y

Who verified the sample

sample_status

int32

N

N

1 = READY – the current time is greater than or equal to the requested time, less than or equal to the expiration time, and if the warning interval is not null, less than the sample requested time plus the warning interval; the sample pulled time is NULL, and there are no results

2 = READY WARNING – the current time is less than or equal to the expiration time, the sample pulled time is NULL, the current time is greater than the sample requested time plus the warning interval (which is not null), and there are no results

3 = MISSED – the current time is greater than the sample expiration time, the sample pulled time is NULL, and there are no results

4 = IN PROGRESS– the current time is greater than or equal to the requested time and less than or equal to the expiration time, there are not yet enough results for at least one characteristic, and either the sample pulled time is NOT NULL or there is at least one result

5 = LATE – the current time is greater than the expiration time, there are not yet enough results for every characteristic, and either the sample pulled time is NOT NULL or there is at least one result

6 = COMPLETE – the time at which the minimum number of original results in the sample was recorded (using the earliest created_at time for each value_no) is less than or equal to the sample expiration time and there are enough results for every characteristic

7 = COMPLETE LATE – the time at which at least one original result in the sample at or below the minimum number was recorded is greater than the expiration time and there are enough results for every characteristic

8 = CANCELED – user decided not to make measurements for this sample

sample_result

int32

N

Y

Null = No data yet (default).

1 = PENDING – some variables and attributes are waiting to be collected and all that have been collected are within normal ranges

2 = GOOD – all variables and attributes were within normal ranges

3 = OOC – at least one variable or attribute was out of SPC control and no variables or attributes were out of spec (even if there are still some results pending).

4 = OOS – at least one variable or attribute was out of spec (even if there are still some results pending). For variable characteristics, this is for individuals.

5 = OOC KEY – at least one variable or attribute with a severity setting of key was out of SPC control and no critical or key variables or attributes were out of spec and no critical variables or attributes were out of control(even if there are still some results pending)

6 = OOS KEY – at least one variable or attribute with a severity setting of key was out of spec and no critical variables or attributes were out of spec or out of control (even if there are still some results pending)

7 = OOC CRITICAL – at least one variable or attribute with a severity setting of critical was out of SPC control and no critical variables or attributes were out of spec (even if there are still some results pending)

8 = OOS CRITICAL – at least one variable or attribute with a severity setting of critical was out of spec (even if there are still some results pending)

priority

int32

N

Y

Priority of measuring this sample

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

notes

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

created_at_utc

tdatetime

N

N

When, in UTC, the record was created.

sample_id

ID 1

Y

N

Unique identifier