Navigation:  Integration via database > Published interfaces > Competence >

CPTREG - Competence

Previous  Top  Next

This import template enables to insert, edit, and delete:

Competencies

 

In order to add, edit and delete each of these items, it is necessary to follow the standard documented below.

Add/edit/delete data

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:

171 - Competence component code.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

1 - Addition/edition of competencies;

2 - Deletion of competencies.

NMFIELD01

X

TEXT

255

Competence ID # (for deletions, only this field is required).

NMFIELD02

X

TEXT

255

Competence name.

NMFIELD03

X

TEXT

255

Competence type ID #.

NMFIELD04

X

TEXT

255

Proficiency scale ID #.

NMFIELD05

X

TEXT

255

Proficiency scale revision number.

DSFIELD01

 

TEXT

4000

Competence description.