Navigation:  Integration via database > Published interfaces > SPC >

SPCSAMPCHANGESTATUS – Sample status update

Previous  Top  Next

This import template enables to edit:

Status of the sample of a collection;

 

To insert each of these items, it is necessary to follow the standard documented below.

Change sample status

Column

Required

Type

Precision

Description

OIDINTERFACE

X

TEXT

32

Sequential code - Identifies an item to be imported into SoftExpert Suite.

FGIMPORT

X

NUMERIC

2

Import status:

1 - New;

2 - In progress;

3 - Finished;

4 - Error.

CDISOSYSTEM

X

NUMERIC

10

System code where the integration will be performed to:

116 - Code of component SoftExpert SPC.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

9 - Change the status of a collection sample.

NMFIELD01

X

TEXT

255

Collection ID #.

NMFIELD02

X

TEXT

255

Characteristic ID #.

NMFIELD03

X

TEXT

255

Sample ID #.