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:
129 – Training component code.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
1 – Creates a new training;
2 – Edits training;
3 - Edits training; if nonexistent, adds a new one
|
NMFIELD01
|
X1
|
TEXT
|
255
|
Training ID #.
|
NMFIELD02
|
|
TEXT
|
255
|
Training name
|
NMFIELD03
|
X2
|
TEXT
|
255
|
Course ID #
|
NMFIELD04
|
|
TEXT
|
255
|
Training status [1 - Planning, 5 - Execution, 8 - Finished].
|
NMFIELD05
|
X2
|
TEXT
|
255
|
Training type [1 - Collective; 2 - Individual].
|
NMFIELD06
|
|
TEXT
|
255
|
Training configuration ID #.
|
NMFIELD07
|
|
TEXT
|
255
|
Planning control team ID #.
|
NMFIELD08
|
|
TEXT
|
255
|
Execution control team ID #.
|
NMFIELD09
|
|
TEXT
|
255
|
Location type [1 - Internal; 2 - Third-party].
|
NMFIELD10
|
|
TEXT
|
255
|
ID # of educational entity
|
NMFIELD11
|
|
TEXT
|
255
|
Support staff.
|
NMFIELD12
|
X3
|
TEXT
|
255
|
Planned start date.
|
NMFIELD13
|
X3
|
TEXT
|
255
|
Planned end date.
|
NMFIELD14
|
|
TEXT
|
255
|
Planned workload (Number of minutes).
|
NMFIELD15
|
X4
|
TEXT
|
255
|
Actual start date.
|
NMFIELD16
|
|
TEXT
|
255
|
Actual end date.
|
NMFIELD17
|
|
TEXT
|
255
|
Actual workload (Number of minutes).
|
NMFIELD18
|
|
TEXT
|
255
|
Signature on the training certificate.
|
DSFIELD01
|
|
TEXT
|
4000
|
User ID or external user e-mail. To add more than one participant, use the ";" separator. For example: ID/E-mail;ID/E-mail;ID/E-mail. If you wish to enter the participant's score, use the "|" separator. For example: ID/E-mail| Score;ID/E-mail|Score. If you wish to enter the participant's score and attendance, use the "|" separator. For example: ID/E-mail|Score|Attendance;ID/E-mail|Score|Attendance.
|
DSFIELD02
|
|
TEXT
|
4000
|
Instructor ID # or third-party instructor name. To add more than one participant, use the ";" separator. For example: ID/Name;ID/Name. If you wish to define that the instructor will have control in the training, enter the number "1" after the ID, using the "|" separator. For example: ID/Name|1;ID/Name|1.
|
DSFIELD03
|
|
TEXT
|
4000
|
Document ID #. To add more than one object, use the ";" separator. For example: Object;Object. To specify the revision, it is necessary to identify the revision #; use the "|" separator. For example: Object|00;Object|01.
|
DSFIELD04
|
|
TEXT
|
4000
|
Objective.
|
DSFIELD05
|
|
TEXT
|
4000
|
Comments.
|