RQMAPPINGANALYSIS - Map requirement
This import template allows:
- Mapping requirements by business unit, department4, item, supplier, supply, asset, and waste.
To insert each of these items, the standard documented below must be followed.
Insert
| Column | Required | Type | Precision | Description |
|---|---|---|---|---|
| OIDINTERFACE | X | TEXT | 32 | Primary key - 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 | Code of the system for which the integration will be performed: 227 - Code of the SoftExpert Requirement component. |
| FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 7 - Map by business unit. |
| NMFIELD01 | X | TEXT | 50 | Requirement mapping ID # |
| NMFIELD02 | X | TEXT | 50 | Requirement ID # |
| NMFIELD03 | X¹ | NUMERIC | 50 | Department ID # |
| NMFIELD04 | NUMERIC | 2 | Applicable: 1 - Yes; 2 - No. | |
| NMFIELD05 | NUMERIC | 2 | Value implemented Data input standard: • Values between 0 and 10 | |
| NMFIELD06 | TEXT | 50 | Criterion 1 ID # | |
| NMFIELD07 | NUMERIC | 2 | Criterion 1 value | |
| NMFIELD08 | TEXT | 50 | Criterion 2 ID # | |
| NMFIELD09 | NUMERIC | 2 | Criterion 2 value | |
| NMFIELD10 | TEXT | 50 | Criterion 3 ID # | |
| NMFIELD11 | NUMERIC | 2 | Criterion 3 value | |
| NMFIELD12 | TEXT | 50 | Criterion 4 ID # | |
| NMFIELD13 | NUMERIC | 2 | Criterion 4 value | |
| NMFIELD14 | TEXT | 50 | Criterion 5 ID # | |
| NMFIELD15 | NUMERIC | 2 | Criterion 5 value | |
| DSFIELD01 | TEXT | 4000 | Explanation. |
info
Note:
- ¹ - To evaluate requirements with "Quantitative" evaluation method, the "Criterion ID #" and "Criterion value" fields must be completed.
- ² - To evaluate requirements with "Simple listing" evaluation method, only the
"Criterion value" (
NMFIELD06) must be entered. - ³ - Only standard formulas are supported for importing requirement evaluation. It is not possible to import using customized formulas.
- ⁴ - For requirement mapping by business unit and department, only one department can be mapped.
tip
Examples of standard formulas:
CRITERIONOPERATION('Add';'With weight')
CRITERIONOPERATION('Multiply';'Without weight')
CRITERION('001';'Value')
CRITERION('001';'Weight')