This import template makes it possible to insert:
▪Elements in Scorecard. The elements can be configured according to the customer's need. Examples: objectives, perspectives, condition, department, etc.
To insert each of these elements, 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
|
3
|
Code of the operation to be performed:
3 - Insert scorecard element.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Scorecard element ID #.
|
NMFIELD02
|
|
TEXT
|
255
|
Scorecard upper level element ID #.
|
NMFIELD03
|
X
|
TEXT
|
255
|
Element ID #.
|
NMFIELD04
|
X
|
TEXT
|
255
|
Scorecard ID #
|
NMFIELD05
|
|
TEXT
|
255
|
Range ID #. Uses the scorecard range by default.
|
NMFIELD06
|
|
NUMERIC
|
2
|
Evaluate element?
1 - Yes (Default Calculation) (Default);
2 - No;
3 - Yes (Max calculation=100; Min=0).
|
NMFIELD09
|
|
NUMERIC
|
10
|
View order.
|
NMFIELD10
|
|
NUMERIC
|
10
|
Element weight value if no value is reported, it will be considered weight 1.00.
|
NMFIELD11
|
X
|
TEXT
|
255
|
User ID responsible for executing the import of the record.
|
|