This import template enables to insert/edit:
▪Data of a department; ▪Relationship between department and position.
To insert each of these items, it is necessary to follow the standard documented below.
Insert department
|
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:
153 - Code of component SoftExpert Administration.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
9 - Insert department.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Department ID #.
|
NMFIELD02
|
X
|
TEXT
|
255
|
Department name.
|
NMFIELD03
|
|
TEXT
|
255
|
Upper level department ID #.*
|
NMFIELD04
|
|
TEXT
|
255
|
Upper level business unit ID #.*
|
Insert/delete relationship between department and position
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
X
|
NUMERIC
|
10
|
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:
153 - Code of component SoftExpert Administration.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
10 - Insert relationship between Department and Position;
12 - Delete relationship between Department and Position.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Department ID #.
|
NMFIELD02
|
X
|
TEXT
|
255
|
Position ID #.
|
Delete department
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
X
|
NUMERIC
|
10
|
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:
153 - Code of component SoftExpert Administration.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
11 - Delete department.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Department ID #.
|
|