Navigation:  Integration via database > Published interfaces > FMEA >

FMEFCTRL – Failure control import

 Previous  Top  Next

This import template enables to insert/edit:

▪Failure control data.

 

To add/edit each of these items, the standard documented below must be followed.

Insert/Edit

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:

132 – FMEA component code.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

18 - Insert failure control; if it already exists, it edits the existing failure control.

NMFIELD01

X

TEXT

255

Failure control ID #.

NMFIELD02

X

TEXT

255

Failure control name.

NMFIELD03

X

TEXT

255

FMEA type:

1 – Project;

2 – Process.

DSFIELD01

 

TEXT

4000

Failure control description.

 

 

Example of failure control insertion/editing:

INSERT INTO DIINTERFACE (OIDINTERFACE, CDISOSYSTEM, FGOPTION, NMFIELD01, NMFIELD02, NMFIELD03, DSFIELD01) VALUES (‘Sequential code’, 132, 18, ‘FailureControlId’, ‘Failure control name’, ‘1’, ‘Description’);