Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

last_sample_no

  • Last UpdatedNov 12, 2024
  • 1 minute read

The last_sample_no table records the last ordinal number used for the name of a sample for a given template and instance. This is an internally-maintained table not directly modified via user actions.

Field

Datatype

PK

Nulls?

Description

sample_name_template

string80

Y

N

Same as the sample_name field of the sample_plan table that was used as a template to generate a sample name.

sample_name_instance

int32

Y

N

The name of the last sample (not including sample_to_go records) generated using this template, without the ordinal number. If the sample name consists of nothing but the ordinal number, a hyphen (0x2D) is used here.

current_sample_no

int32

N

N

The last ordinal number used to name a sample (not including sample_to_go records)

last_edit_at

tdatetime

N

N

When this record was last changed

TitleResults for “How to create a CRG?”Also Available in