Navigation:  Integration via database > Published interfaces > Risk >

RISCONTROL – Control

Previous  Top  Next

This import template makes it possible to insert:

Controls.

 

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:

215 – Code of component SE Risk

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

10 – Insert control

NMFIELD01

X

TEXT

50

Control ID #

NMFIELD02

X

TEXT

255

Control name

NMFIELD03

X

TEXT

50

Control type ID #

NMFIELD04

 

TEXT

50

Responsible ID #

NMFIELD05

 

TEXT

50

Responsible team ID #.

NMFIELD06

 

NUMERIC

2

Implementation:

1 – Not implemented;

2 – Partly implemented;

3 – Completely implemented.

NMFIELD07

 

TEXT

255

Implementation date

NMFIELD08

 

NUMERIC

2

Relevant:

1 – Yes;

2 – No.

NMFIELD09

 

NUMERIC

2

Automation type:

1 - Automatic;

2 - Semiautomatic;

3 - Manual.

NMFIELD10

 

NUMERIC

2

Control characteristic:

1 – Detective;

2 – Preventive;

3 - Detective + Preventive.

NMFIELD11

 

NUMERIC

2

Control frequency:

1 - Based on event;

2 – Daily;

3 - Weekly;

4 - Monthly;

5 - Quarterly;

6 - Biannual;

7 - Yearly;

8 - Biweekly.

NMFIELD12

 

TEXT

50

Procedure ID #

NMFIELD13

X

NUMERIC

2

Control icon ID #

NMFIELD14

 

TEXT

50

Evaluation method ID #

DSFIELD01

 

TEXT

4000

Control description

DSFIELD02

 

TEXT

4000

Procedure description