Editing Data Dictionary: Open PHMEV: complete database on hospital prescriptions for drugs delivered in the community

{{forresearchers}}
Go back to [[Open PHMEV: complete database on hospital prescriptions for drugs delivered in the community (France)]] page.

Source: [https://www.assurance-maladie.ameli.fr/etudes-et-donnees/open-phmev-base-complete Click here to learn more in "Methodological details"].

{| class="wikitable"
! Medicament
|-
| ATC1
| Main Anatomical Group
|-
| L_ATC1
| Label ATC1
|-
| ATC2
| Therapeutic Subgroup
|-
| L_ATC2
| Label ATC2
|-
| ATC3
| Pharmacological Subgroup
|-
| L_ATC3
| Label ATC3
|-
| ATC4
| Chemical Subgroup
|-
| L_ATC4
| Label ATC4
|-
| ATC5
| Chemical Substance Subgroup
|-
| L_ATC5
| Label ATC5
|-
| CIP13
| 
|-
| L_CIP13
| Label CIP13
|-
| TOP_GEN
| Top Generic/Biosimilar/Reference Brand
|-
| GEN_NUM
| Generic Group
|}

{| class="wikitable"
! Beneficiary
|-
| AGE
| Age Group
|-
| SEXE
| Sex
|}


{| class="wikitable"
! Prescribing Establishment
|-
| categorie_jur
| Establishment Category (1st nomenclature)
|-
| categorie_jur_rgt
| Establishment Category (2nd nomenclature)
|-
| code_postal
| Postal Code
|-
| region_etb
| Establishment Location Region for AP-HP and Red Cross; Managing Establishment's Location Region otherwise
|-
| etb_rgt
| AP-HP and Red Cross Geographic Finess number; Legal Finess number otherwise
|-
| nom_etb
| Establishment Name
|-
| raison_sociale_etb
| Company Name
|-
| nom_ville
| City Name
|-
| nom_voie
| Street Name
|-
| numero_voie
| Street Number
|-
| top_etb_age
| Top Establishment Based on Age Group Availability: 0 no; 1 yes
|-
| top_etb_sexe
| Top Establishment Based on Sex Availability: 0 no; 1 yes
|}

{| class="wikitable"
! Indicators
|-
| BOITES
| Number of Boxes
|-
| REM
| Amount Reimbursed
|-
| BSE
| Reimbursable Amount
|}