RISCONTROLLIBRARY - Control library

This import template allows inserting control libraries.

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	Primary key - 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: 10 - Insert.
NMFIELD01	X	TEXT	50	ID #.
NMFIELD02	X	TEXT	255	Name.
NMFIELD03	X	TEXT	50	Control type ID #.
NMFIELD04		TEXT	50	Responsible party ID #.
NMFIELD05		TEXT	50	Responsible team ID #.
NMFIELD06	X¹	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	X¹	NUMERIC	2	Automation type: 1 - Automatic; 2 - Semiautomatic; 3 - Manual.
NMFIELD10	X¹	NUMERIC	2	Characteristic: 1 - Detective; 2 - Preventive; 3 - Detective + Preventive; 4 - Customized in general parameters; 5 - Customized in general parameters; 6 - Customized in general parameters.
NMFIELD11	X¹	NUMERIC	2	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.
NMFIELD12		TEXT	50	Procedure ID #.
NMFIELD13		NUMERIC	2	Icon ID #.
NMFIELD14	X¹	TEXT	50	Evaluation method ID #.
DSFIELD01		TEXT	4000	Description.
DSFIELD02		TEXT	4000	Procedure description.
DSFIELD03		TEXT	4000	Attributes. Example: identifier_of_attribute1=value_of_attribute1; identifier_of_attribute2=value_of_attribute2; identifier_of_attribute3=value_of_attribute3. Example with a multivalued attribute: identifier_of_attribute1=value1_of_attribute1, value2_of_attribute1, value3_of_attribute1. Note: For attributes with a numeric value, the decimal place separator must be ".". For date fields, the value must have the “Y-M-D” (Year-Month-Day) format.

info

X¹ - Mandatory if it is configured in the general parameters.