A reference table of CRM users containing information about medical representatives, their managers, geography, business directions, positions, and activity status.
| Field Name | Description |
|---|---|
| email of the medical representative (if missing — "NoEmailData") | |
| Employee | full name of the medical representative |
| isonwork_id | technical field indicating work status: 0 — active, 1 — inactive identifier of work status |
| isonwork_name | text value of status: Active or Not active |
| mr_city_id | identifier of the medical representative’s city |
| mr_city_name | name of the medical representative’s city |
| mr_id | unique identifier of the medical representative |
| mr_id_hco | unique identifier of the HCO |
| mr_id_ppf | PPF identifier |
| Position | position name |
| position_id | position identifier |
| rm_id | unique identifier of the regional manager |
| Supervisor | full name of the regional manager |