Navigation:  Integration via database > Published interfaces > Requirement >

RQREVISION - Reference requirements

Previous  Top  Next

This import template makes it possible to insert:

Reference requirements.

 

To insert each one of these respondents, 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:

1 – Insert requirement

NMFIELD01

X

TEXT

50

Requirement ID #

NMFIELD02

X

TEXT

255

Requirement name

NMFIELD03

X

TEXT

255

Requirement type ID #

NMFIELD04

X

TEXT

50

Responsible ID #

NMFIELD05

 

TEXT

50

Responsible team ID #.

NMFIELD06

 

TEXT

255

Requirement source URL

NMFIELD07

 

TEXT

50

Reference document ID #

NMFIELD08

 

TEXT

255

Audit evaluation criterion ID #

NMFIELD09

 

TEXT

255

Default conformity level ID #

NMFIELD10

 

NUMERIC

2

Average value and percentage calculation of the conformity according to:

1 – Lower level requirements;

2 – Lowest level requirements;

NMFIELD101

TEXT

50

Starter user's ID #

DSFIELD01

 

TEXT

4000

Requirement content description

 

X1 - The NMFIELD101 column is required when the requirement revision is done via workflow.