TRREG - Training registration
This import template allows inserting/editing:
- Trainings.
For the insertion of each one of these items, the standard documented below must be followed.
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 | Code of the system for which the integration will be performed: 129 - Code of the Training component. |
| FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 1 - Creates new training; 2 - Edits training; 3 - Edits training; if there is none, a new one will be added. |
| NMFIELD01 | X¹ | TEXT | 255 | Training ID #. |
| NMFIELD02 | TEXT | 255 | Training name. | |
| NMFIELD03 | X² | TEXT | 255 | Course ID #. |
| NMFIELD04 | TEXT | 255 | Training status [1 - Planning, 5 - Execution, 8 - Finished]. | |
| NMFIELD05 | X² | 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 - External]. | |
| NMFIELD10 | TEXT | 255 | Educational entity ID #. | |
| NMFIELD11 | TEXT | 255 | Support staff. | |
| NMFIELD12 | X³ | TEXT | 255 | Planned start date. |
| NMFIELD13 | X³ | TEXT | 255 | Planned end date. |
| NMFIELD14 | TEXT | 255 | Planned workload (Number of minutes). | |
| NMFIELD15 | X⁴ | TEXT | 255 | Actual start date. |
| NMFIELD16 | TEXT | 255 | Actual end date. | |
| NMFIELD17 | TEXT | 255 | Actual workload (Number of minutes). | |
| NMFIELD18 | TEXT | 255 | Signature on training certificate. | |
| NMFIELD19 | X | TEXT | 255 | Record user ID. |
| DSFIELD01 | TEXT | 4000 | Participant's ID (internal user) or e-mail (external user). 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's 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, identify the revision # using the "|" separator. For example: Object|00;Object|01. | |
| DSFIELD04 | TEXT | 4000 | Objective. | |
| DSFIELD05 | TEXT | 4000 | Comment. |
info
Note:
- ¹ - It will be required for editing.
- ² - It will be required for creation.
- ³ - It will be required in the case of training planning creation.
- ⁴ - It will be required in the case of training execution creation.