The table contains data on the interaction of companies (HCO — Healthcare Organizations) with products within completed tasks (visits). It is used to analyze visit results, monitor plan execution, and store additional attributes.
| Field Name | Short Description |
|---|---|
| control_flag1 | Flag indicating the presence of the product on the display shelf (yes/no) |
| control_flag2 | Product availability |
| control_flag3 | Logical (boolean) flags reflecting additional control parameters (e.g., whether material was shown, whether the brand was mentioned, whether the result was confirmed) |
| control_flag4 | Logical (boolean) flags reflecting additional control parameters (e.g., whether material was shown, whether the brand was mentioned, whether the result was confirmed) |
| control_flag5 | Logical (boolean) flags reflecting additional control parameters (e.g., whether material was shown, whether the brand was mentioned, whether the result was confirmed) |
| control_float1 | Number of product packs in stock |
| control_float2 | Product price |
| control_float3 | Floating-point numeric indicators (e.g., percentages, amounts) |
| control_int1 | Number of packs in the order |
| control_int2 | Integer numeric indicators that can be used for additional metrics (e.g., number of packs, number of mentions) |
| control_int3 | Integer numeric indicators that can be used for additional metrics (e.g., number of packs, number of mentions) |
| control_prep_id | Product identifier linked to the table crm_preparation_dic |
| control_str1 | Text fields for storing additional descriptions or parameters |
| control_str1 | Text fields for storing additional descriptions or parameters |
| control_str1 | Text fields for storing additional descriptions or parameters |
| control_task_id | Task (visit) identifier to which the record belongs, linked to the table crm_task_fact_csv |