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.