Configure CLINICAL_STUDY_LOOKUP Field Type
You can configure a field ID as CLINICAL_STUDY_LOOKUP field type. This field type enables the clinical study lookup menu to open the Clinical Study Lookup browser from menu. With this browser you can search study information for clinical studies based on the following:
- Center ID
- Project ID
- Study ID
To configure the new field ID as CLINICAL_STUDY_LOOKUP field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-17 Configurations for Field Type CLINICAL_STUDY_LOOKUP
| Column | Sample Value | Description |
|---|---|---|
|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
|
FIELD_TYPE_ID |
11 |
CLINICAL_STUDY_LOOKUP |
|
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
|
KEY |
CENTERID |
Enter the Return Type text. See Table 1-18. This is a mandatory column. |
|
VALUE |
1 |
Enter the Return Type ID. See Table 1-18. This is a mandatory column. |
For more information, see: