Configure STUDY_DRUG Field Type
You can configure a field ID as STUDY_DRUG field type. This field type enables the Study Drug menu to open the Study Drug Lookup browser from menu. With this browser you can search study drugs. To configure the new field ID as STUDY_DRUG field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-16 Configurations for Field Type STUDY_DRUG
Column | Sample Value | Description |
---|---|---|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
FIELD_TYPE_ID |
10 |
STUDY_DRUG |
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
KEY |
PROD_NAME |
Enter the Return Type text as PROD_NAME. This is a mandatory column. |
VALUE |
NOR |
Enter the Return Type ID as NOR. This is a mandatory column. |
Note:
You can also refer to existing field PRODUCTS > Product Information > Study Drug, (CMN_FIELDS.Field_ID - 203650965) of STUDY_DRUG field type.
Parent topic: Configure CMN_FIELD_CONFIGURATION Table