Configure SMQ_BROAD Field Type

You can configure a field ID as SMQ_BROAD field type. This field type identifies all possible cases, including some that may prove to be of little or no interest on closer inspection. Those are highly likely to represent the condition of interest. This field type search includes both the narrow terms and additional broad terms, often of less-specific nature.

To configure the new field ID as SMQ_BROAD field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:

Table 1-4 Configurations for Field Type SMQ_BROAD

Column	Sample Value	Description
ENTERPRISE_ID	3	Current Enterprise ID
FIELD_TYPE_ID	2	SMQ_BROAD
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 and LLT is mandatory while row with key as ADDITIONALWHERE is optional.
VALUE	RPT_EVENT.ART_CODE/RPT_EVENT.INC_COD/RPT_EVENT.ISPRIMARY = 1	If KEY= PT then Add <<Table Name>>.<<Column name>> which contains PT code. If KEY= LLT then Add <<Table Name>>.<<Column>> name which contains LLT code. If KEY= ADDITIONALWHERE then If any additional WHERE condition is required.

Note:

You can also refer to existing field EVENTS > Primary Event > Event SMQ (Broad), (CMN_FIELDS.Field_ID - 201760628) of SMQ_NARROW field type.