Configure INVESTIGATIONAL_DRUG Field Type
You can configure a field ID as INVESTIGATIONAL_DRUG field type. This field type enables the Investigational Drug menu to open the Investigational Drug browser from menu. With this browser you can search and select investigational drug. To configure the new field ID as INVESTIGATIONAL_DRUG field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-20 Configurations for Field Type INVESTIGATIONAL_DRUG
Column | Sample Value | Description |
---|---|---|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
FIELD_TYPE_ID |
13 |
INVESTIGATIONAL_DRUG |
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
KEY |
NULL |
Enter Return type text as NULL. |
VALUE |
NULL |
Enter the Return Type ID as NULL. |
Note:
You can also refer to existing field PRODUCTS > Product Information > Investigational Drug, (CMN_FIELDS.Field_ID - 203610883) of INVESTIGATIONAL_DRUG field type.Parent topic: Configure CMN_FIELD_CONFIGURATION Table