Navigation:  Integration via database > Published interfaces > Performance >

STRDELSCORECARDACCESS - Deletion of Scorecard security

Previous  Top  Next

This import template enables to delete the Scorecard access security.

 

To insert each one of these items in the spreadsheet, 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:

138 – Code of component SE Performance

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

9 – Delete Scorecard Security

NMFIELD01

X

TEXT

255

Scorecard ID #

NMFIELD02

 

NUMERIC

2

Access type:

1 – Team

2 – Department

3 – Department/Position

4 – Position

5 – User

6 – All

If this field is left blank (null), then the system will delete all Scorecard security records.

NMFIELD03

TEXT

255

Department ID #

NMFIELD04

TEXT

255

Position ID #

NMFIELD05

TEXT

255

User ID # (User ID)

NMFIELD06

X4

TEXT

255

Team ID #

 

X¹ – Field must be filled out if the access type is Department.

X² – Field must be filled out if the access type is Position.

X³ – Field must be filled out if the access type is User.

X4 – Field must be filled out if the access type is Team.