Navigation:  Integration via database > Published interfaces > Requirement >

RQREQATTRIBUTE - Requirement attribute value

Previous  Top  Next

This import template makes it possible to:

Values to attributes of a requirement. To insert more than one value into a multivalued attribute, repeat all the data and only change the value of the attribute (NMFIELD04).

 

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:

227 – Requirement component code.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

3 – Add the value to the requirement attribute.

NMFIELD01

X

TEXT

50

Requirement ID #.

NMFIELD02

X

TEXT

50

Attribute ID #.

NMFIELD03

X1

TEXT

255

Attribute value.

Standards to enter the hour type data:

hhhh:mm;

NMFIELD04

X

TEXT

50

Reference requirement ID #.

DSFIELD01

 

TEXT

4000

Attribute description.

 

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