Navigation:  Integration via database > Published interfaces > Performance >

STRSCOREACCESSMTR - Insertion of default security for Scorecard indicator

Previous  Top  Next

This import template allows inserting default access security for indicator in a Scorecard record.

 

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:

10 – Insert Scorecard Indicator/Element Security

NMFIELD01

X

TEXT

255

Scorecard ID #

NMFIELD02

X

NUMERIC

2

Access control type:

1 – Team

2 – Department

3 – Department/Position

4 – Position

5 – User

6 – All

NMFIELD03

TEXT

255

Department ID #

NMFIELD04

TEXT

255

Position ID #

NMFIELD05

X3

TEXT

255

User ID # (User ID)

NMFIELD06

x⁴

TEXT

255

Team ID #

NMFIELD07

X

NUMERIC

1

Consider the sub-levels as team members:

1 - Yes;

2 - No (default value).

NMFIELD08

X

TEXT

255

Permission profile ID #.

 

X1 - The field must be filled in if the control type is Department.

X2 - The field must be filled in if the control type is Position.

X3 – The field must be filled in if the control type is User.

X4 - The field must be filled in if the control type is Team.

X5 – At least one of the access securities must be filled out.