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:
- Configure SMQ_NARROW Field Type
- Configure SMQ_BROAD Field Type
- Configure MEDDRA Field Type
- Configure WHO Field Type
- Configure COMPANY_DRUG Field Type
- Configure INGREDIENT Field Type
- Configure MINUTES_CALCULATOR Field Type
- Configure LITERATURE Field Type
- Configure EVENT_LICENSE Field Type
- Configure STUDY_DRUG Field Type
- Configure CLINICAL_STUDY_LOOKUP Field Type
- Configure BATCH_LOT_NO Field Type
- Configure INVESTIGATIONAL_DRUG Field Type
- Configure CO_DRUG_CODE_WITH_STUDY Field Type
- Configure DVB Field Type
- Configure GENERIC Field Type
- Configure PATIENT_HISTORY Field Type
- Configure PARTIAL_DATE Field Type
- Configure CLOB Field Type
- Configure PARENT_HISTORY Field Type
Parent topic: Advanced Conditions Extensibility