Navigation:  Integration via database > Published interfaces > Training >

TRCOURSEREG - Course

Previous  Top  Next

This import template enables to insert/edit:

Courses

 

To insert each of these items, it is necessary to follow the standard documented below.

Insert/edit

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:

6 – Inserts a new course

7 – Edits an existing course

NMFIELD01

X

TEXT

255

Course type ID #

NMFIELD02

X

TEXT

255

Course ID # (When editing is the only required field)

NMFIELD03

X

TEXT

255

Name of course

NMFIELD04

 

TEXT

255

Default configuration name

NMFIELD05

X

TEXT

255

Usage (1 - Training; 2 - Employee profile, 3 - Both)

NMFIELD06

X

TEXT

255

Workload

NMFIELD07

X

TEXT

255

Workload type (1 - Fixed; 2 - Variable)

NMFIELD08

 

TEXT

255

Pre-training evaluation test template ID #

NMFIELD09

 

TEXT

255

ID # of the responsible team for completing pre-training evaluation

NMFIELD10

 

TEXT

255

Training evaluation test template ID #

NMFIELD11

 

TEXT

255

ID # of the responsible team for completing training evaluation

NMFIELD12

 

TEXT

255

ID # of the survey template of reaction evaluation

NMFIELD13

 

TEXT

255

ID # of the responsible team for completing the reaction evaluation survey

NMFIELD14

 

TEXT

255

Post-training evaluation test template ID #

NMFIELD15

 

TEXT

255

ID # of the responsible team for completing post-training evaluation

NMFIELD16

 

TEXT

255

ID # of the survey template of participant effectiveness evaluation

NMFIELD17

 

TEXT

255

ID # of the responsible team for completing the participant effectiveness evaluation survey

NMFIELD18

 

TEXT

255

Make content available to the training participants (1 – Yes; 2 – No)

Note: The E-learning configurations can only be set if the course has a content, that is, it is not possible to add information through insertion, only by editing an existing course.

NMFIELD19

 

TEXT

255

Maintain access for participants after content execution. (1 – Yes; 2 – No)

NMFIELD20

 

TEXT

255

Require participants to access the training content before sending it to the next step (1 – Yes; 2 – No)

NMFIELD21

 

TEXT

255

Automate the training flow when finishing the content execution (1 – Yes; 2 – No)

NMFIELD22

 

TEXT

255

Deadline frequency amount for content access

NMFIELD23

 

TEXT

255

Deadline frequency for content access (1 - Day; 2 - Week; 3 - Month; 4 - Year)

NMFIELD24

 

TEXT

255

Block content access after the deadline expires (1 – Yes; 2 – No)

NMFIELD25

 

TEXT

255

End access to content on time (1 - Yes; 2 - No)

NMFIELD26

 

TEXT

255

Course revision date

NMFIELD27

X

TEXT

255

User ID #

DSFIELD01

 

TEXT

4000

Course objective

DSFIELD02

 

TEXT

4000

Course description