Logosw Statistics Category Mapping¶
Overview¶
The Logosw practice management software produces statistics reports that group dental
procedures into 17 categories. This document describes how to reproduce that classification
from the data we import (the procedure table).
Key finding: The classification is primarily based on ccam_grouping
(CCAM_REGROUPEMENT), with consultation codes always extracted to their own category.
Only 3 groupings (ASC, TDS, ADC) require code-level disambiguation.
Verified against Logosw reports for: - Dentist RG, February 2026 (12/12 categories exact match) - Dentist SD, January 2025 (12/12 non-zero categories exact match)
Procedure table fields¶
| Field | Column in Logosw | Role |
|---|---|---|
type |
TYPE | Treatment plan/visit context (single letter: S, X, R, C, F...). NOT used for statistics classification. |
ccam_code |
COTATION | The billing/nomenclature code (e.g. HBJD001, HBLD634). Used for code-level disambiguation within mixed groupings. |
ccam_grouping |
CCAM_REGROUPEMENT | Treatment plan grouping code (e.g. SDE, AXI, END). Primary axis for statistics classification. |
Classification rules¶
Rule 1: Extract consultations by ccam_code (always, regardless of grouping)¶
The following codes are always classified as Consultations, no matter which
ccam_grouping they belong to:
Rule 2: Map ccam_grouping to Logosw category¶
After extracting consultations, the remaining (treatment) acts are classified by
their ccam_grouping:
| ccam_grouping | Logosw category | Notes |
|---|---|---|
| SDE | Soins conservateurs | Obturations (HBMD*), but see Rule 3 for HBFD010 |
| PF0, PF1, PFC, PFM | Protheses fixes | Couronnes, bridges on natural teeth |
| CZ0, CZ1 | Protheses fixes | Couronnes zircone |
| IC0, IC1, ICO | Protheses fixes | Inlay core |
| IN1, INO | Protheses fixes | Inlay/onlay |
| CT0, CT1 | Protheses fixes | Couronnes transitoires |
| CM0 | Protheses fixes | Couronnes metal |
| RPN | Protheses fixes | Depose couronne/bridge, rescellement |
| PDT | Protheses fixes | Couronnes transitoires (prothese dentaire transitoire) |
| BR1 | Protheses fixes | Bridge |
| RF0 | Protheses fixes | Changement facettes |
| PA0, PA1, PAM | Protheses amovibles | Protheses a chassis metallique, plaque resine |
| PT0 | Protheses amovibles | Protheses transitoires plaque resine |
| RA0 | Protheses amovibles | Reparation prothese amovible |
| RE1 | Protheses amovibles | Reparation/ajout sur amovible a chassis |
| RS0 | Protheses amovibles | Reparation prothese resine |
| ASC | Chirurgie | Mixed - see Rule 3 |
| AXI | Prophylaxie | Detartrage (HBJD001/0011) |
| END | Endodontie | Pulpectomie, traitement canalaire |
| AID | Radiographie | Panoramique, retro-alveolaire, cone beam |
| IMP | Impl. chirurgicale + Impl. prothetique | Split by code - see Rule 3 |
| ADM | Occlusodontie | Appareillage de protection, gouttiere occlusale |
| TDS | Non classes / Parodontologie | Mixed - see Rule 3 |
| ADC | Varies | Mixed - see Rule 3 |
| None | Non classes | Legacy/unmapped |
Rule 3: Code-level disambiguation for mixed groupings¶
ASC (Chirurgie + others)¶
| ccam_code pattern | Logosw category |
|---|---|
| HBGD* (avulsions) | Chirurgie |
| HBMA006 (osteoplastie alveole) | Chirurgie |
| YYYY183 (prise en charge handicap) | Chirurgie |
| GBBA* (sinuslift / comblement de sinus) | Implantologie chirurgicale |
| HBMA004 (ROG - regeneration osseuse guidee) | Parodontologie |
IMP (Implantologie chirurgicale + prothetique)¶
| ccam_code pattern | Logosw category |
|---|---|
| LBLD* (pose d'implant) | Implantologie chirurgicale |
| GBBA* (sinuslift, if present) | Implantologie chirurgicale |
| HBLD012, HBLD017, HBLD021 (infrastructure coronaire sur implant) | Implantologie prothetique |
| HBLD418 (couronne implantoportee) | Implantologie prothetique |
TDS (Non classes + Parodontologie)¶
| ccam_code pattern | Logosw category |
|---|---|
| HBGB006 (surfacage radiculaire) | Non classes |
| HBJA* (assainissement parodontal) | Parodontologie |
| HBQD001 (maintenance parodontale) | Parodontologie (likely, to confirm) |
ADC (grab-bag, mostly practice 1)¶
| ccam_code pattern | Logosw category |
|---|---|
| HAFA015 (exerese lesion muqueuse) | Parodontologie |
| Other codes | Classify by code nature (to confirm with more data) |
SDE exception¶
| ccam_code | Logosw category | Notes |
|---|---|---|
| HBFD010 (coiffage pulpaire) | Chirurgie | Inferred from RG Feb 2026 numbers, not yet confirmed with Logosw code extract |
The 17 Logosw categories¶
- Soins conservateurs
- Protheses fixes
- Protheses amovibles
- Protheses maxillo-faciales (no data observed)
- Chirurgie
- ODF (no data observed for mapped dentists)
- Consultations
- Prophylaxie
- Endodontie
- Radiographie
- Parodontologie
- Implantologie (no data observed as standalone)
- Implantologie chirurgicale
- Implantologie prothetique
- Occlusodontie
- Esthetique (no data observed)
- Non classes
Known data quality issues¶
- Some procedures in our database are not in the Logosw report (observed: 16 extra acts for SD Jan 2025, mostly generic "Pose d'implant" LBLD entries at lower fees). These may be sub-acts, unvalidated acts, or planning entries.
- Some acts have mismatched names vs codes (e.g. HBGB006 labeled "Infrastructure coronaire sur implant", HBLD364 labeled "Infrastructure coronaires sur implants"). The code is authoritative, not the name.
is_ccamfield is always false in the database, even for valid CCAM codes.
Legacy codes not yet mapped¶
The following legacy (non-CCAM) codes appear in significant volumes but have not been verified against Logosw reports: Z6, Z15, Z21, Z35, SC12, SC15, HN, SPR50, TO* (semestre, surveillance, etc.). These are mostly in older data or specific practices (LE, SD). Their classification likely follows the same ccam_grouping-based logic.
ADI grouping¶
ADI is a legacy grouping used only at practice 1, last seen March 2024. It contains a complete mix of all act types (20k total acts). Classification would require code-level mapping similar to TDS/ADC.