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​
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 | Code of the system for which the integration will be performed: 153 - Code of the SoftExpert Administration component. |
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 #.* |
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.​
Column | Required | Type | Precision | Description |
---|---|---|---|---|
CDINTERFACE | 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 | Code of the system for which the integration will be performed: 153 - Code of the SoftExpert Administration component. |
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 |
---|---|---|---|---|
CDINTERFACE | 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 | Code of the system for which the integration will be performed: 153 - Code of the SoftExpert Administration component. |
FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 11 - Delete department. |
NMFIELD01 | X | TEXT | 255 | Department ID #. |