Navigation:  Integration via database > Published interfaces > Asset >

ASTSECU - Asset type security import

Previous  Top  Next

This import template enables to insert/edit/delete:

Security data of the asset type.

 

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

Insert security data of the asset type

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:

109 - Code of component SoftExpert Asset.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

12 - Insert security control for the asset type.

NMFIELD01

X

TEXT

255

Asset type ID #.

NMFIELD02

X

TEXT

255

Permission group type:

1 - Team;

2 - Department;

3 - Department/Position;

4 - Position;

5 - User;

6 - All.

NMFIELD03

X

TEXT

255

Control to add:

1 - Yes;

2 - No.

NMFIELD04

 

X

TEXT

255

Control to edit:

1 - Yes;

2 - No.

NMFIELD05

X

TEXT

255

Control to delete:

1 - Yes;

2 - No.

NMFIELD06

X

TEXT

255

Security data control:

1 - Yes;

2 - No.

NMFIELD07

X

TEXT

255

Control to list:

1 - Yes;

2 - No.

NMFIELD08

X

TEXT

255

Control to view:

1 - Yes;

2 - No.

NMFIELD09

X

TEXT

255

Permission:

1 - Allow;

2 - Deny.

NMFIELD10

TEXT

255

Access type ID #.

Example: If the type is by user, it will be the user ID. If the type is by department, it will be the department ID #.

NMFIELD11

TEXT

255

Position ID #. This field will only be used if the type is by department and position. That way, the department will go in the NMFIELD10 field and the position, in this one.

 

X1 - Required when NMFIELD02 is different from 6;

X² - Required when NMFIELD02 is equal to 4.