Navigation:  Integration via database > Published interfaces > Performance >

STRDELSCOREACCESSMTR - Deletion of default security for Scorecard indicator/element

Previous  Top  Next

This import template enables to delete the default access security for Scorecard indicator/element.

 

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:

11 – Delete Scorecard Indicator/Element 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 Indicator/Element security records.

NMFIELD03

TEXT

255

Department ID #

NMFIELD04

TEXT

255

Position ID #

NMFIELD05

TEXT

255

User ID # (User ID)

NMFIELD06

x⁴

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.

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