New Sample_Plan Table (in FI_Data_2)

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

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 may be added depending on options within the sample_name field.

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

plan_id

ID 0

Y

N

Unique identifier