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 SoftExpert Training component. |
FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 1 - Create new training; 2 - Edit training; 3 - Edit training; if nonexistent, add a new one. |
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 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 | Comments. |
info
Note
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.