Reference table of contacts (HCP) containing basic information about doctors and their classification. Used as a source of reference data.
| Field Name | Short Description |
|---|---|
| con_id_key | Technical key of the contact (unique ID) |
| con_id | Contact identifier (CRM ID) |
| con_type | Type of client (e.g., doctor, pharmacist). Linked to the table crm_contacttype_dic |
| con_spec | Contact specialization (e.g., therapist, cardiologist). Linked to the table crm_dictionary_dic |
| con_target | Target group to which the contact belongs. Linked to the table crm_target_dic |
| con_archive | Contact activity flag (“Not in archive” / “In archive”) |
| con_client | Full name of the client |
| con_company_id | Identifier of the company to which the contact belongs (place of work). Linked to the table crm_company_dictionary_v2 |