Configure Flexible Data Recategorization with a New Custom Language

You can configure a code list display value in a new Custom language for an already existing code in Oracle Argus Safety.

For example, assume that for the code list CAUSALITY, the following data is available in the table CODE_LIST_DETAIL_DISCRETE for 'en' decode context (English language):

Table 3-2 Original Display Values

CODE_LIST_ID	DECODE_CONTEXT	CODE	DISPLAY_VALUE	PREFERRED	SORT	LAST_UPDATE_TIME	ENTERPRISE_ID
CAUSALITY	en	1	Definitely Not	0	(null)	9-Jul-13	1
CAUSALITY	en	2	Unlikely	0	(null)	9-Jul-13	1
CAUSALITY	en	3	Possible	0	(null)	9-Jul-13	1
CAUSALITY	en	4	Probable	0	(null)	9-Jul-13	1
CAUSALITY	en	5	Highly Probable	0	(null)	9-Jul-13	1
CAUSALITY	en	6	Definite	0	(null)	9-Jul-13	1

To configure the same code list CAUSALITY for the custom values Related and Unrelated, which are used as buckets or categories to group the already existing values:

1. Add a new language such as CUSTOM (decode context CUSTOM) by populating the table CODE_LIST_DETAIL_DISCRETE in Argus Safety with required values in the CUSTOM language.

   INSERT INTO CODE_LIST_DETAIL_DISCRETE (CODE_LIST_ID, DECODE_CONTEXT, CODE, DISPLAY_VALUE, PREFERRED, SORT, LAST_UPDATE_TIME, ENTERPRISE_ID) VALUES ('CAUSALITY', 'CUSTOM', 1, 'Related', 0, null, sysdate, 1);

   Table 3-3 New Display Values

   CODE_LIST_ID	DECODE_CONTEXT	CODE	DISPLAY_VALUE	PREFERRED	SORT	LAST_UPDATE_TIME	ENTERPRISE_ID
   CAUSALITY	en	1	Definitely Not	0	(null)	9-Jul-13	1
   CAUSALITY	en	2	Unlikely	0	(null)	9-Jul-13	1
   CAUSALITY	en	3	Possible	0	(null)	9-Jul-13	1
   CAUSALITY	en	4	Probable	0	(null)	9-Jul-13	1
   CAUSALITY	en	5	Highly Probable	0	(null)	9-Jul-13	1
   CAUSALITY	en	6	Definite	0	(null)	9-Jul-13	1
   CAUSALITY	CUSTOM	1	Unrelated	0	(null)	9-Jul-13	1
   CAUSALITY	CUSTOM	2	Unrelated	0	(null)	9-Jul-13	1
   CAUSALITY	CUSTOM	3	Related	0	(null)	9-Jul-13	1
   CAUSALITY	CUSTOM	4	Related	0	(null)	9-Jul-13	1
   CAUSALITY	CUSTOM	5	Related	0	(null)	9-Jul-13	1
   CAUSALITY	CUSTOM	6	Related	0	(null)	9-Jul-13	1

2. After the Oracle Argus Insight ETL runs, to create an Advanced Condition field which displays custom CAUSALITY values, add a new row in the CMN_FIELDS table in Oracle Argus Insight with values similar to the example shown below:

   Column	Value
   ENTERPRISE_ID	1
   FIELD_ID	New field ID that must be unique and must be in the following range: For customers: 30000000 - 39999999 For partners: 40000000 - 49999999 All other IDs are reserved for Oracle.
   FIELD_LABEL	Custom Reported Causality
   TABLE_NAME	RPT_EVENT_ASSESS
   COLUMN_NAME	RPT_CAUSALITY_ID
   JOIN_FIELD	--
   SELECT_TABLE	--
   SELECT_COLUMN	--
   ADV_COND_FIELD	1
   TREE_VIEW	ANALYSIS:Case Assessment
   UNIQUE_FIELD_LABEL	Custom Reported Causality
   SQL_SELECT	SELECT DISTINCT DISPLAY_VALUE ID, DISPLAY_VALUE STATUS FROM DM_CODE_LIST_DETAIL_DISCRETE WHERE CODE_LIST_ID = 'CAUSALITY' AND DECODE_CONTEXT = ' CUSTOM'
   FIELD_TYPE	1
   HIDDEN	0
   TYPE_AHEAD	--
   BLINDED_FIELD	--
   CONTROL_TYPE_ID	2
   FIELD_LENGTH	255
   ADDITIONAL_TABLE_LIST	--
   ADDITIONAL_WHERE	--

3. Now, insert a new row to the table CMN_COMPLEXFIELDS_CONFIGURATION.

   Column	Value
   ENTERPRISE_ID	3
   FIELD_ID	<Same Field ID as in the CMN_FIELDS table>
   OPERATOR	equal to
   SORT_ORDER	1
   REQ_TABLE_LIST	--
   WHERE_QUERY	RPT_EVENT_ASSESS.RPT_CAUSALITY_ID IN (SELECT CODE FROM DM_CODE_LIST_DETAIL_DISCRETE WHERE DISPLAY_VALUE = 'PARAM_VALUE' AND CODE_LIST_ID = 'CAUSALITY' AND DECODE_CONTEXT = 'CUSTOM')