Navigation:  Integration via database > Published interfaces > Performance >

STRMETRIC - Indicator import

Previous  Top  Next

This import template makes it possible to insert:

Indicators to be used in the Scorecard.

 

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

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

X1

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.

 

X1 - Required only for indicators with target (NMFIELD13 = 1).