Configure SMQ_NARROW Field Type
You can configure a field id as SMQ_NARROW field type. This field type identifies cases that are highly likely to represent the condition of interest. Narrow search consists of all PTs that indicate the condition with great certainly.
To configure the new field ID as SMQ_NARROW field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-3 Configurations for Field Type SMQ_NARROW
Column | Sample Value | Description |
---|---|---|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
FIELD_TYPE_ID |
1 |
SMQ_NARROW |
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
KEY |
PT/LLT/ADDITIONALWHERE |
This column contains the key as PT, LLT, or ADDITIONALWHERE. One row for each PT (Preffered Term) and LLT (Low Level Term) is mandatory while row with key as ADDITIONALWHERE is optional. |
VALUE |
RPT_EVENT.ART_CODE/RPT_EVENT.INC_CODE/RPT_EVENT.ISPRIMARY = 1 |
If KEY= PT thenAdd <<Table Name>>.<<Column name>> which contains PT code. If KEY= LLT thenAdd <<Table Name>>.<<Column>> name which contains LLT code.If KEY= ADDITIONALWHERE thenIf any additional WHERE condition is required. |
Note:
You can also refer to existing field EVENTS > Primary Event > Event SMQ (Narrow), (CMN_FIELDS.Field_ID - 201760627) of SMQ_NARROW field type.Parent topic: Configure CMN_FIELD_CONFIGURATION Table