Base comprehensive table of all contacts (HCP), containing information about doctors: full name, specialization, workplace, region, city, address, and archive status. Used as the main source of reference data for HCP.
| Field Name | Short Description |
|---|---|
| doc_crm_id | Unique doctor identifier (CRM ID). Used as a key in all supporting tables: crm_hcp_all_base_targetspec, crm_hcp_all_base_contactcategory, crm_hcp_all_base_tasklastmonth, crm_hcp_all_base_tasklastyear |
| doc_name | Full name of the specialist |
| com_name | Name of the company (HCO) where the doctor works. Linked to the table crm_hco_all_base (field CRM_company_id) |
| doc_main_spec | Specialization identifier |
| doc_region_id | Region identifier |
| doc_city_id | City identifier |
| city_name | City name (reference field from info_city) |
| doc_postcode | Postal code |
| doc_address | Address |
| Archive | Specialist status (active / archived) |
| archive_reason | Name of the archive reason |
| archive_reason_id | Identifier of the archive reason |
| doc_external_id | External key (for integrations) |
| doc_morion_id | MORION specialist identifier |
| doc_serverid | Technical server identifier |
| Region | Region name (reference field from info_region) |
| Spec | Specialization name |
| spec_id | Specialization identifier (duplicates doc_main_spec) |