RISRISK - Risk

This import template allows inserting:

• Risk: Uncertainty events that may negatively affect the organization's capacity to reach its goals.

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: 19 - Insert risk.
NMFIELD01	X	TEXT	50	Risk library ID #.
NMFIELD02	X	TEXT	50	Plan ID #.
NMFIELD03	X	TEXT	50	Responsible party ID #.
NMFIELD04		TEXT	50	Responsible team ID #.
NMFIELD05		TEXT	50	Risk ID #.
NMFIELD06		TEXT	50	Upper element ID #.
NMFIELD07		TEXT	255	Next evaluation date.
NMFIELD08		NUMERIC	10	Execution deadline.
NMFIELD09		NUMERIC	10	Treatment ID #.
NMFIELD10		TEXT	50	Measurement unit ID #.
NMFIELD11		NUMERIC	10	Other losses.
NMFIELD12		NUMERIC	10	Appetite value.
NMFIELD13		NUMERIC	10	Tolerance value.
DSFIELD01		TEXT	4000	Description.
DSFIELD02		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.