Navigation:  Integration via database > Published interfaces > Training >

TRPRESENCELIST - Attendance list import

Previous  Top  Next

This import template enables to insert/edit:

Attendances in the attendance list of a training

 

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

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

14 – Adds/edit the attendance of an employee in a training

NMFIELD01

X

TEXT

255

Training ID #

NMFIELD02

X

TEXT

255

User ID or external user e-mail.

NMFIELD03

X

TEXT

255

Training occurrence date

NMFIELD04

X

NUMERIC

50

Participant attended the training [1 - Yes; 2 - No]

NMFIELD05

 

TEXT

255

Shift ID # (required if the training has shifts).