TRASSOC - Participant evaluation and/or association

This import template allows inserting/editing:

• Training participant evaluations.
• Participant association with trainings.

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

Insert/Edit

Column	Required	Type	Precision	Description
OIDINTERFACE	X	TEXT	32	Primary key - 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
FGOPTION	X	NUMERIC	2	4 - Evaluates participant; if they are not associated, they will be associated with the training. 5 - Only evaluates participant.
NMFIELD01	X	TEXT	255	Training ID #.
NMFIELD02	X	TEXT	255	User ID or external user e-mail
NMFIELD03		TEXT	255	ID # of the effectiveness evaluation appraiser.
NMFIELD04		TEXT	255	Pre-training evaluation score.
NMFIELD05		TEXT	255	Training evaluation score.
NMFIELD06		TEXT	255	Reaction evaluation score.
NMFIELD07		TEXT	255	Post-training evaluation score.
NMFIELD08		TEXT	255	Training evaluation frequency.
NMFIELD09		TEXT	255	Training evaluation result (1- Passed / 2 - Failed).
NMFIELD10		TEXT	255	Post-training evaluation result (1 - Passed / 2 - Failed).
NMFIELD11		TEXT	255	Effectiveness evaluation result (1- Passed / 2 - Failed).
NMFIELD12		TEXT	255	Participant start date.
NMFIELD13		TEXT	255	Participant end date.
DSFIELD01		TEXT	4000	Pre-training evaluation description.
DSFIELD02		TEXT	4000	Training evaluation description.
DSFIELD03		TEXT	4000	Reaction evaluation description.
DSFIELD04		TEXT	4000	Post-training evaluation description.
DSFIELD05		TEXT	4000	Effectiveness evaluation description.