Navigation:  Integration via database > Published interfaces > Performance >

STRDELVALUES - Delete indicator values

Previous  Top  Next

This import template makes it possible to:

Delete indicator values.

 

To perform this action, it is necessary to follow the standard documented below.

Deletion

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:

15 – Delete values from indicators.

 

NMFIELD01

X

TEXT

50

Scorecard indicator ID #.

NMFIELD02

X

TEXT

50

ID of the user with import permission in the scorecard or target and/or measurement permission in the indicator.

 

NMFIELD03

X1

TEXT

2

For daily indicator, the target/measurement day must be entered, from 1 to 31.

For weekly indicators, the number of the week of the month of the target/measurement must be entered, from 1 to 5;

For biweekly indicators, the number of the fortnight of the month of the target/measurement must be entered, 1 or 2;

For indicators with other frequencies, it must remain empty.

NMFIELD04

X2

TEXT

2

For daily, weekly, biweekly or monthly indicator, the number of the month must be entered, from 1 to 12;

For bimonthly indicators, the number of the bimester of the target/measurement must be entered, from 1 to 6;

For quarterly indicators, the number of the quarter of the target/measurement must be entered, from 1 to 4;

For four-month-period indicators, the number of the four-month-period of the target/measurement must be entered, from 1 to 3;

For biannual indicators, the number of the semester of the target/measurement must be entered, 1 or 2;

For yearly indicator, it must remain empty.

 

NMFIELD05

X

TEXT

4

Target/measurement year with 4 digits.

E.g.: 2020.

NMFIELD06

X3

TEXT

50

Period ID #. Only for indicators with "Based on event" frequency.

NMFIELD07

 

NUMERIC

1

Delete target value?

1 - Yes;

2 - No (default).

NMFIELD08

 

NUMERIC

1

Delete measurement value?

1 - Yes;

2 - No (default).

NMFIELD09

 

NUMERIC

1

Delete accumulated target value?

1 - Yes;

2 - No (default).

NMFIELD10

 

NUMERIC

1

Delete accumulated measurement value?

1 - Yes;

2 - No (default).

NMFIELD11

 

NUMERIC

1

Delete additional field 1 value?

1 - Yes;

2 - No (default).

NMFIELD12

 

NUMERIC

1

Delete additional field 2 value?

1 - Yes;

2 - No (default).

NMFIELD13

 

NUMERIC

1

Delete additional field 3 value?

1 - Yes;

2 - No (default).

NMFIELD14

 

NUMERIC

1

Delete additional field value 1 accumulated?

1 - Yes;

2 - No (default).

NMFIELD15

 

NUMERIC

1

Delete additional field value 2 accumulated?

1 - Yes;

2 - No (default).

NMFIELD16

 

NUMERIC

1

Delete additional field value 3 accumulated?

1- Yes;

2 - No (default).

 

X1 - The field must be filled in if the indicator entered has "Daily", "Weekly" or "Biweekly" frequency.

X2 - The field must be filled in if the indicator entered has a frequency different from "Yearly".

X3 - The field must be filled in if the indicator entered has "Based on event" frequency.