Insert/edit
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
X
|
TEXT
|
32
|
ID of the user with import permission in the scorecard or target and/or measurement permission in the indicator.
|
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:
6 – Insert/Edit values.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Scorecard indicator ID #.
|
NMFIELD02
|
X
|
TEXT
|
255
|
ID of the user with import permission in the scorecard or target and/or measurement permission in the indicator.
|
NMFIELD03
|
X1
|
TEXT
|
255
|
For daily or based on event indicators, 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
|
255
|
For daily, weekly, biweekly, monthly or based on event indicators, 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 indicators, it must remain empty;
|
NMFIELD05
|
X
|
TEXT
|
255
|
Target/measurement year with 4 digits. E.g.: 2020
|
NMFIELD06
|
|
TEXT
|
255
|
Target weight. If it is not entered, the default weight of the indicator will be considered.
|
NMFIELD07
|
|
TEXT
|
255
|
Enter if the period will be checked as not applicable:
1 – Check period as not applicable.
2 – Do not check. (Default value).
|
NMFIELD08
|
|
TEXT
|
255
|
Target value³.
|
NMFIELD09
|
|
TEXT
|
255
|
Measurement value³.
|
NMFIELD10
|
|
TEXT
|
255
|
Accumulated target value³.
|
NMFIELD11
|
|
TEXT
|
255
|
Accumulated measurement value³.
|
NMFIELD12
|
|
TEXT
|
255
|
Value³ of additional field 1.
|
NMFIELD13
|
|
TEXT
|
255
|
Value³ of additional field 2.
|
NMFIELD14
|
|
TEXT
|
255
|
Value³ of additional field 3.
|
NMFIELD16
|
|
TEXT
|
255
|
Additional field value³ 1 accumulated.
|
NMFIELD17
|
|
TEXT
|
255
|
Additional field value³ 2 accumulated.
|
NMFIELD18
|
|
TEXT
|
255
|
Additional field value³ 3 accumulated.
|
NMFIELD19
|
|
TEXT
|
50
|
Comment/explanation title for the period.
|
DSFIELD01
|
|
TEXT
|
4000
|
Comment/explanation description for the period.
|