Configure MEDDRA Field Type
You can configure a field id as MedDRA field type. This field type enables you to open the MedDRA browser from menu. With this browser you can search the following:
- HLGT — High Level Group Term
- HLT — High Level Term
- LLT — Low Level Term
- PT — Preferred Term
- SOC — System Organ Class
To configure the new field ID as MEDDRA field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-5 Configurations for Field Type MEDDRA
Column | Sample Value | Description |
---|---|---|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
FIELD_TYPE_ID |
3 |
MEDDRA |
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
KEY |
SOC_CODE |
Enter the Return Type text. See Table 1-6. This is a mandatory column. |
VALUE |
1 |
Enter the Return Type ID. See Table 1-6. This is a mandatory column. |
Note:
You can also refer to existing field EVENTS > Primary Event > Event SMQ (Narrow), (CMN_FIELDS.Field_ID - 201760627) of SMQ_NARROW field type.
For more information, see: