Configure Flexible Data Recategorization with a New Natural Language

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

For example, assume that for the code list GENDER, data in the table CODE_LIST_DETAIL_DISCRETE for code 1 is available in the following three decode contexts (languages):

Figure 3-1 Original Decode Contexts (Languages)

To configure the same code 1 in the code list GENDER for a new language such as GERMAN (decode context 'ge'):

1. Populate the table CODE_LIST_DETAIL_DISCRETE in Oracle Argus Safety with required values in the GERMAN language

   INSERT INTO CODE_LIST_DETAIL_DISCRETE (CODE_LIST_ID, DECODE_CONTEXT, CODE, DISPLAY_VALUE, PREFERRED, SORT, LAST_UPDATE_TIME, ENTERPRISE_ID) VALUES ('GENDER', 'ge', 1, 'männlich', 0, null, sysdate, 1);

   Figure 3-2 New Decode Contexts (Languages)

   
2. After the Oracle Argus Insight ETL runs, to create an Advanced Condition field which displays the GENDER value in the GERMAN language, 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	Gender German
   TABLE_NAME	V_RPT_CASE
   COLUMN_NAME	GENDER_ID
   JOIN_FIELD	--
   SELECT_TABLE	--
   SELECT_COLUMN	--
   ADV_COND_FIELD	1
   TREE_VIEW	PATIENT:Patient Information
   UNIQUE_FIELD_LABEL	Gender German
   SQL_SELECT	SELECT CODE ID, DISPLAY_VALUE STATUS from DM_CODE_LIST_DETAIL_DISCRETE WHERE CODE_LIST_ID = GENDER AND DECODE_CONTEXT = 'ge'
   FIELD_TYPE	1
   HIDDEN	0
   TYPE_AHEAD	--
   BLINDED_FIELD	--
   CONTROL_TYPE_ID	2
   FIELD_LENGTH	255
   ADDITIONAL_TABLE_LIST	--
   ADDITIONAL_WHERE	--