Skip to main content
Version: 2.2.1

ADMDEP - Department data import

This import template allows inserting/editing:

  • Department data.
  • Relationship between department and position.

For the insertion of each one of these items, the standard documented below must be followed.

Insert department​

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXTEXT32Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
153 - Code of the SoftExpert Administration component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
9 - Insert department.
NMFIELD01XTEXT255Department ID #.
NMFIELD02XTEXT255Department name.
NMFIELD03TEXT255Upper level department ID #.*
NMFIELD04TEXT255Upper level business unit ID #.*
info

Note:

To define an upper level Department or Business unit, fill in only the NMFIELD03 or NMFIELD04 field.

Insert/delete relationship between department and position.​

ColumnRequiredTypePrecisionDescription
CDINTERFACEXNUMERIC10Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
153 - Code of the SoftExpert Administration component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
10 - Insert relationship between Department and Position;
12 - Delete relationship between Department and Position.
NMFIELD01XTEXT255Department ID #.
NMFIELD02XTEXT255Position ID #.

Delete department​

ColumnRequiredTypePrecisionDescription
CDINTERFACEXNUMERIC10Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
153 - Code of the SoftExpert Administration component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
11 - Delete department.
NMFIELD01XTEXT255Department ID #.