Navigation:  Integration via database > Published interfaces > Risk >

RIRISKATTRIBUTE – Risk attribute value

Previous  Top  Next

This import template makes it possible to insert:

Values to attributes of a risk. To insert more than one value into a multivalued attribute, add another row with the same data and only change the value of the attribute (NMFIELD03).

 

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

Insert

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:

215 – Code of component SE Risk

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

17 – Add the value to the risk attribute.

NMFIELD01

X

TEXT

255

Risk ID #

NMFIELD02

X

TEXT

255

Attribute ID #

NMFIELD03

 

TEXT

255

Attribute value.

Standards to enter the hour type data:

hhhh:mm.

DSFIELD01

 

TEXT

4000

Attribute description.

 

X1 - The NMFIELD03 column is mandatory for all attributes, EXCEPT the ones of the Memo type, where the DSFIELD01 column should be filled in.