Navigation:  Integration via database > Published interfaces > Administration >

ADMTEAMASSOC - Associate a department, position, or user with a team

Previous  Top  Next

This import template enables to insert/delete:

Association between a team and a department, position, or user

 

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 - Code of component SoftExpert Administration.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

34 – Associate (department, user, position) with a team;

35 – Remove existing association.

NMFIELD01

X

TEXT

255

Team ID # (required field for deletion).

NMFIELD02

X

TEXT

255

Create team with:

1 – Departments;

2 – Users;

3 – Positions.

(required field for deletion)

NMFIELD03

X

TEXT

255

ID # of the (departments, users, positions) that will be associated (separated by “,”). Example: “User1”, “User2”, “User3”.

(required field for deletion)