sample_plan

plan_name

string40

N

N

Name of sample plan for display

plan_desc

string80

N

Y

Description of sample plan

category_id

int32

N

Y

Identify category to which this sample plan belongs

Note: This field is currently not used.

verified_write

logical

N

N

Is operator confirmation of manually entered values required? Default = no.

sample_name

string80

N

N

Defines pattern sample names are to follow; default is"[SamplePlanName][YYYY][MM][DD][####]".

reset_option

int32

N

N

If sample name contains at least one octothorpe (#), what should cause it to go back to 1?

0 (default) = nothing (never resets)

1 = change in local date

Other choices might be added depending on options within the sample_name field.

spare1

string80

N

Y

Use defined by language term 6900

spare2

string80

N

Y

Use defined by language term 6901

spare3

string80

N

Y

Use defined by language term 6902

spare4

string80

N

Y

Use defined by language term 6903

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

plan_id

ID 1

Y

N

Unique identifier