Configure CO_DRUG_CODE_WITH_STUDY Field Type
You can configure a field ID as CO_DRUG_CODE_WITH_STUDY field type. This field type enables the Co-Drug Code w Study menu to open the Co-Drug Code w Study browser from menu. With this browser you can search and select co-drug code with study. To configure the new field ID as CO_DRUG_CODE_WITH_STUDY field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-21 Configurations for Field Type CO_DRUG_CODE_WITH_STUDY
Column | Sample Value | Description |
---|---|---|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
FIELD_TYPE_ID |
14 |
CO_DRUG_CODE_WITH_STUDY |
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
KEY |
NULL |
Enter key as NULL |
VALUE |
NULL |
Enter the value as NULL |
Note:
You can also refer to existing field PRODUCTS > Product Drug/Vaccine > Co-Drug Code w Study, (CMN_FIELDS.Field_ID - 203650861) of CO_DRUG_CODE_WITH_STUDY field type.Parent topic: Configure CMN_FIELD_CONFIGURATION Table