STRMETRIC - Indicator import
This import template allows inserting:
- Indicators to be used in the Scorecard.
To insert each of these indicators, 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: 138 - Code of the SoftExpert Performance component. |
| FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 2 - Insert indicator. |
| NMFIELD01 | X | TEXT | 50 | Indicator ID #. |
| NMFIELD02 | X | TEXT | 255 | Indicator name. |
| NMFIELD03 | X | TEXT | 50 | Indicator type ID #. |
| NMFIELD04 | X | TEXT | 50 | Measurement unit ID #. |
| NMFIELD05 | NUMERIC | 1 | Number of decimal places. Enter a value between 0 and 8. If it is not entered, it will be considered as 2. | |
| NMFIELD06 | NUMERIC | 2 | Indicator frequency: 1 - Yearly; 2 - Biannual; 3 - Four-month-period; 4 - Quarterly; 5 - Bimonthly; 6 - Monthly (default value); 7 - Bi-weekly; 8 - Weekly; 9 - Daily; 10 - Based on event. | |
| NMFIELD08 | NUMERIC | 1 | Automatic accumulation type: 1 - Total (default value); 2 - Average; 3 - None; 4 - Manual. | |
| NMFIELD09 | NUMERIC | 1 | Frequency for accumulation: 1 - Yearly (default value); 2 - Biannual; 3 - Four-month-period; 4 - Quarterly; 5 - Bimonthly; 6 - Monthly; 7 - Bi-weekly; 8 - Weekly. | |
| NMFIELD10 | NUMERIC | 1 | Number of years for yearly accumulation frequency. | |
| NMFIELD11 | NUMERIC | 1 | Accumulation start period. | |
| NMFIELD12 | X¹ | TEXT | 50 | Range ID #. |
| NMFIELD13 | NUMERIC | 1 | Does the indicator have target? 1 - Yes (default value); 2 - No. | |
| NMFIELD14 | NUMERIC | 1 | Indicates the indicator classification: 1 - Qualitative; 2 - Quantitative (default value); 3 - Quantitative (HH:MM:SS). | |
| NMFIELD15 | NUMERIC | 2 | Indicates the target type of the indicator: 1 - Enter target by measurement frequency (default value); 2 - Enter target by accumulation period. | |
| DSFIELD01 | TEXT | 4000 | Indicator description. |
info
Note:
X¹ - Required only for indicators with target (NMFIELD13 = 1).