RISCONTROLANALYSIS - Control

This import template allows inserting:

• Control: Controls defined to ensure compliance and risk mitigation.

For the insertion of each one of these items, the standard documented below must be followed.

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	Code of the system for which the integration will be performed: 215 - Code of the SoftExpert Risk component.
FGOPTION	X	NUMERIC	2	Code of the operation to be performed: 20 - Insert control
NMFIELD01	X	TEXT	50	Control library ID #.
NMFIELD02	X	TEXT	50	Plan ID #.
NMFIELD03	X	TEXT	50	Responsible party ID #.
NMFIELD04		TEXT	50	Responsible team ID #.
NMFIELD05		TEXT	50	ID #.
NMFIELD06		TEXT	50	Upper element ID #.
NMFIELD07		TEXT	255	Automation type: 1 - Automatic; 2 - Semiautomatic; 3 - Manual.
NMFIELD08		NUMERIC	10	Characteristic: 1 - Detective; 2 - Preventive; 3 - Detective + Preventive; 4 - Customized in general parameters; 5 - Customized in general parameters; 6 - Customized in general parameters.
NMFIELD09		NUMERIC	10	Frequency: 1 - Based on event; 2 - Daily; 3 - Weekly; 4 - Monthly; 5 - Quarterly; 6 - Biannual; 7 - Yearly; 8 - Biweekly; 9 - Customized in the general parameters; 10 - Customized in the general parameters; 11 - Customized in the general parameters.
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	Cost.
DSFIELD01		TEXT	4000	Description.