This import template makes it possible to insert:
▪Costs to trainings
To insert each of these items, it is necessary to follow the standard documented below.
Insert/edit
|
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 to where
the integration will be made
129 – Training component code
|
FGOPTION
|
X
|
NUMERIC
|
2
|
12 – Add training cost
|
NMFIELD01
|
X
|
TEXT
|
255
|
Training ID #
|
NMFIELD02
|
X
|
TEXT
|
255
|
ID # of cost type
|
NMFIELD03
|
X
|
TEXT
|
255
|
Type (1 – Fixed, 2 Per participant)
|
NMFIELD04
|
|
TEXT
|
255
|
Planned cost (Required planning)
|
NMFIELD05
|
|
TEXT
|
255
|
Actual cost (Required in execution)
|
DSFIELD01
|
|
TEXT
|
4000
|
Planned description
|
DSFIELD02
|
|
TEXT
|
4000
|
Execution description
|
|