- Extensibility Guide
- Code List Extensibility
- Configure Flexible Data Recategorization with a New Natural Language
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)
![Original Decode Contexts (Languages) Original Decode Contexts (Languages)](img/originaldecodecontext.jpg)
To configure the same code 1 in the code list GENDER for a new language such as GERMAN (decode context 'ge'):
- 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)
- 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
--
Parent topic: Code List Extensibility