HCP consists of the following tables:
| Table Name | Description |
|---|---|
| crm_calendar_v2 | A calendar table that contains a list of dates broken down by days, months, working/non-working days, and country. It is used as a calendar reference in Power BI for aggregations and date filtering. |
| crm_userdirection_csv | A reference table that shows the correspondence between medical representatives and business directions in the CRM. |
| crm_user_dictionary_csv | A reference table of CRM users containing information about medical representatives, their managers, geography, business directions, positions, and activity status. |
| crm_company_dictionary_v2_csv | A reference table of companies (HCO) that contains basic information about medical organizations, their classification, addresses, identifiers, and additional business attributes. It is used as the main data source for building organization reports in the CRM Basic Dashboard. |
| crm_responsible | A technical reference table used to display the text value of Ownership; contains only one record. |
| crm_owner_v2_csv | The table contains information about the relationship between CRM users (responsible persons) and clients (HCP/HCO). It is used to determine employee responsibility for contacts and companies. |
| crm_task_fact_v2_csv | The main fact table of visits (tasks) in the CRM. It contains all information about completed and planned tasks of representatives — both for contacts and companies. It serves as the central table for most dashboard tabs. |