Configure CMN_FIELD_CONFIGURATION Table

Oracle Argus Insight supports different field types. The field ID that belongs to one or more field types must be configured in the database table CMN_FIELD_CONFIGURATION.

Note:

One field can belong to one or more field types.

Table 1-2 Oracle Argus Insight Supported Field Types

Field Type ID	Field Type	Description
1	SMQ_NARROW	The field configured as SMQ_NARROW field type identifies cases that are highly likely to represent the condition of interest. Narrow search consists of all PTs that indicate the condition with great certainty. To configure this field type, see Configure SMQ_NARROW Field Type.
2	SMQ_BROAD	The field configured as SMQ_BROAD field type identifies all possible cases, including some that may prove to be of little or no interest on closer inspection. Those are highly likely to represent the condition of interest. Field as SMQ_BROAD field type search includes both the narrow terms and the additional broad terms, often of less-specific nature. To configure this field type, see Configure SMQ_BROAD Field Type.
3	MEDDRA	The field configured as MEDDRA field type enables the MedDRA menu to open MedDRA browser. To configure this field type, see Configure MEDDRA Field Type.
4	WHO	The field configured as WHO field type enables the WHO menu to open WHO Drug browser. To configure this field type, see Configure WHO Field Type.
5	COMPANY_DRUG	The field configured as COMPANY_DRUG field type enables the Company Drug menu to open Product browser. To configure this field type, see Configure COMPANY_DRUG Field Type.
6	INGREDIENT	The field configured as INGREDIENT field type enables the Ingredient menu to open Ingredient browser. To configure this field type, see Configure INGREDIENT Field Type.
7	MINUTES_CALCULATOR	The field configured as MINUTES_CALCULATOR field type enables the Minutes Calculator menu to open Minutes Calculator browser. To configure this field type, see Configure MINUTES_CALCULATOR Field Type.
8	LITERATURE	The field configured as LITERATURE field type enables the Literature menu to open Literature browser. To configure this field type, see Configure LITERATURE Field Type.
9	EVENT_LICENSE	The field configured as EVENT_LICENSE field type enables the Event License menu to open Event License browser. To configure this field type, see Configure EVENT_LICENSE Field Type.
10	STUDY_DRUG	The field configured as STUDY_DRUG field type enables the Study Drug menu to open Product browser. To configure this field type, see Configure STUDY_DRUG Field Type.
11	CLINICAL_STUDY_LOOKUP	The field configured as CLINICAL_STUDY_LOOKUP field type enables the Literature menu to open Clinical Study Lookup browser. To configure this field type, see Configure CLINICAL_STUDY_LOOKUP Field Type.
12	BATCH_LOT_NO	The field configured as BATCH_LOT_NO field type enables the Batch Lot # menu to open Batch/Lot Number browser. To configure this field type, see Configure BATCH_LOT_NO Field Type.
13	INVESTIGATIONAL_DRUG	The field configured as INVESTIGATIONAL_DRUG field type enables the Investigational Drug menu to open Investigational Drug browser. To configure this field type, see Configure INVESTIGATIONAL_DRUG Field Type.
14	CO_DRUG_CODE_WITH_STUDY	The field configured as CO_DRUG_CODE_WITH_STUDY field type enables the Co-Drug Code menu to open Batch/Lot Number browser. To configure this field type, see Configure CO_DRUG_CODE_WITH_STUDY Field Type.
15	DVB	The field configured as DVB field type enables the specific range called Duration Value Bands. To configure this field type, see Configure DVB Field Type.
16	GENERIC	The field configured as GENERIC field type enables the Generic Name menu to open Generic Name browser. To configure this field type, see Configure GENERIC Field Type.
17	PATIENT_HISTORY	The field configured as PATIENT_HISTORY field type is considered as information of the patient. To configure this field type, see Configure PATIENT_HISTORY Field Type.
18	PARTIAL_DATE	The field configured as PARTIAL_DATE field type allows the user to enter the partial date. To configure this field type, see Configure PARTIAL_DATE Field Type.
19	CLOB	The field configured as COLB field type is considered as field with data type CLOB of column configured in CMN_FIELDS.COLUMN_NAME. To configure this field type, see Configure CLOB Field Type.
20	PARENT_HISTORY	The field configured as PARENT_HISTORY field type is considered as information about patient's parent. To configure this field type, see Configure PARENT_HISTORY Field Type.

For more information, see:

Parent topic: Advanced Conditions Extensibility