Base comprehensive table of medical organizations (HCO). Contains essential information about region, city, company type, address, name, and affiliation with a network or corporation. Used for building coverage dashboards and analyzing HCO structure.
| Field Name | Short Description |
|---|---|
| City | City name. Linked to the table crm_city_dic |
| city_id | City identifier. Linked to the table crm_city_dic |
| com_Archive | Activity flag (“Not archive” / “Archive”) |
| com_CODE | Main organization code |
| com_code net | Network name (if the company belongs to a network). Linked to the table crm_company_dictionary_v2 |
| com_code point | Point code (internal CRM code) |
| com_isPharmacy | Type of location: pharmacy (“Point of sales”) or other (“Other”) |
| com_MAIN_ORG | Main organization / corporation to which the company belongs. Linked to the table crm_company_dictionary_v2 |
| com_NAME | Company name |
| com_NET | Network name (if the company belongs to a network). Linked to the table crm_company_dictionary_v2 |
| com_UR_NAME | Legal name of the network or corporation |
| com_Address | Organization address |
| CRM_company_id | CRM organization identifier |
| Region | Region name. Linked to the table crm_region_dic |
| region_id | Region identifier. Linked to the table crm_region_dic |
| Type | Company type (pharmacy, hospital, other). Linked to the table crm_companytype_dic |