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:
20 – Insert control analysis
|
NMFIELD01
|
X
|
TEXT
|
50
|
Control ID #
|
NMFIELD02
|
X
|
TEXT
|
50
|
Risk plan ID #
|
NMFIELD03
|
X
|
TEXT
|
50
|
Responsible ID #
|
NMFIELD04
|
|
TEXT
|
50
|
Responsible team ID #.
|
NMFIELD05
|
|
TEXT
|
50
|
Control analysis ID #
|
NMFIELD06
|
|
TEXT
|
50
|
Element ID # superior to the control analysis
|
NMFIELD07
|
|
TEXT
|
255
|
Automation type:
1 – Automatic;
2 – Semiautomatic;
3 – Manual.
|
NMFIELD08
|
|
NUMERIC
|
10
|
Control characteristic:
1 – Detective;
2 – Preventive.
|
NMFIELD09
|
|
NUMERIC
|
10
|
Control frequency:
1 - Based on event;
2 – Daily;
3 - Weekly;
4 - Monthly;
5 - Quarterly;
6 - Biannual;
7 - Yearly.
|
NMFIELD10
|
|
NUMERIC
|
10
|
Implementation:
1 – Not implemented;
2 – Partly implemented;
3 – Completely implemented.
|
NMFIELD11
|
|
TEXT
|
255
|
Implementation date
|
NMFIELD12
|
|
TEXT
|
255
|
Next evaluation date
|
NMFIELD13
|
|
NUMERIC
|
10
|
Execution deadline
|
NMFIELD14
|
|
TEXT
|
50
|
Measurement unit ID #
|
NMFIELD15
|
|
NUMERIC
|
255
|
Controls cost
|
DSFIELD01
|
|
TEXT
|
4000
|
Control analysis description
|
