Navigation:  Integration via database > Published interfaces > Administration >

ADMATRPROFVL - Employee profile attribute value

Previous  Top  Next

This import template enables to insert/edit:

Values of the employee profile attributes

 

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

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

System code where the integration will be performed to:

153

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

26 – Inserts the value for an attribute. If existent, edits it

 

NMFIELD01

X

TEXT

255

Employee ID #

NMFIELD02

X

TEXT

255

Attribute ID #

NMFIELD03

 

TEXT

255

Attribute value.

DSFIELD01

 

TEXT

4000

Attribute value (Non-discrete, memo)