1 / 60

GGR / RCM database 2007

GGR / RCM database 2007. CBIP BCFI. Ap Dr I. Latour, Dr L. Proost, Dr R. Vander Stichele, Dr J. Van Campen. CBIP Centre Belge d’Information Pharmacothérapeutique www.cbip.be. BCFI Belgisch Centrum voor Farmacotherapeutische Informatie www.bcfi.be. 2. 14 Chapters

neal
Download Presentation

GGR / RCM database 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. GGR / RCM database 2007 CBIP BCFI Ap Dr I. Latour, Dr L. Proost, Dr R. Vander Stichele, Dr J. Van Campen

  2. CBIP Centre Belge d’Information Pharmacothérapeutique www.cbip.be BCFI Belgisch Centrum voor Farmacotherapeutische Informatie www.bcfi.be 2

  3. 14 Chapters 1400 Hierarchical nodes, max 7 levels 3000 VOS/ DCI clusters 2500 Medicinal Products = Brandnames <6000 Medicinal Product Packages <1500 Ingredient names 500 Galenic terms >150 Firms Book contains BCFI Belgisch Centrum voor Farmacotherapeutische Informatie www.bcfi.be 3

  4. 440 pages Yearly updated Structure Content For General Practitionars Pharmacists Students … 100 000 users Site Database Book • 8000 files / 93 Mb • 2-weekly updated • Structure • MP • Free for • Health workers • Students • Every one .. • And .. • NL = FR • Off-line version (plain-html) • PDA (plain –html) • 3 milj hits/mnth (Nl)2 milj hits/mnth (Fr) • 7 tables+ ATC DPP history+ link table => site • 4-weekly updated • For • General Practitionars • Study projects • Medical software • Only Repertory • >300 distribitions 4

  5. 5

  6. 6

  7. 7

  8. Book Database SGML • Site creations • SGML check • Distribution 8

  9. www.BCFI.bewww.CBIP.be 9

  10. Info about database on site 10

  11. Info about database on site 11

  12. Database-tables

  13. Hyr (Hierarchy) MP (Brandname) MPP (Package) SAM (Composition) GGR_LINK (Patient Record => site) ATCDPP Database tables • IR (Firm) / MpEq • GAL (Galenic form) • INNM (Ingredient) 13

  14. Hyr (1400, 7 levels) Hierarchy Introduction & group-posology Database tables 14

  15. Database tables: Hyr.dbf / dbt => Hierarchy , Introduction texts , Posology 15

  16. Database tables: Hyr.dbf/dbt => Hierarchy , Introduction texts , Posology HYR CV MPGRP TITLE • HYR • Dynamic • can change trough deletion or insertion of new branches • HYRCV • Persistent • same HYRCV = same meaning 16 16

  17. Database tables: Hyr.dbf/dbt => Hierarchy , Introduction texts , Posology HYR CV MPGRP TITLE • Chapter • THGRP • THGRP • … (max 6 levels) • MPGRP( = lowest level) 17

  18. Database tables: Hyr.dbf/dbt HYR CV MPGRP TITLE 18

  19. Hyr (1400, 7 levels) MP (2500) Database tables • IR (160) • MPEQ • Medicinal product • Brandname • Firm • WADA / Doping • Equivalents 19

  20. Database tables: MP.dbf / dbt MP: Brandname + Firm + Doping 20

  21. Database relations: HYR - MP MP: Brandname + Firm + Doping 21

  22. Database relations: HYR – MP - IR MP: Brandname + Firm + Doping 22

  23. Database relations: HYR - MP- IR - MPEQ MP: Brandname + Firm + Doping 23

  24. Hyr (1400, 7 levels) MP (2500) MPP ( 5830) Database tables IR (160) / MPEQ GAL (500) • Administratif information on Medicinal Product Packages • MPPCV (CNK) • Prescription label • Galenics • Content • Price • Reimbursement, On Prescription, Hospital use, “Cheap”-status 24

  25. Database tables: MPP.dbf Administratif information on Medicinal Product Packages • Galenics compr. (séc.) • Content 30 x • On prescription status R/ • Soc Sec Reimburseement b • Reference Status • Public Price 7,43 25

  26. Database tables: MPP.dbf Administratif information on Medicinal Product Packages • Galenics amp. i.v. – perf. • Content 10 x 20 ml • On prescription status / • Soc Sec Reimburseement / • Reference Status / • Public Price U.H. 26

  27. Database tables: MPP.dbf Administratif information on Medicinal Product Packages • Galenics flacon perf. • Content 1 x + 2 x 50 ml solv. • On prescription status Rx • Soc Sec Reimburseement / • Reference Status / • Public Price 333.14 27

  28. Database tables: MPP.dbf Content object of MPP • Content Quantity (CQ) 30 • Content Units (CU) x • Content Fluid Quantity (CFQ) • Content Fluid Units (CFU) • Add Quantity (AQ) • Add Units (AU) • Add Fluid Quantity (AFQ) • Add Fluid Units (AFU) • Add type (AType) 28

  29. Database tables: MPP.dbf Content object of MPP • Content Quantity (CQ) 10 • Content Units (CU) x • Content Fluid Quantity (CFQ) 20 • Content Fluid Units (CFU) ml • Add Quantity (AQ) • Add Units (AU) • Add Fluid Quantity (AFQ) • Add Fluid Units (AFU) • Add type (AType) 29

  30. Database tables: MPP.dbf Content object of MPP • Content Quantity (CQ) 1 • Content Units (CU) x • Content Fluid Quantity (CFQ) • Content Fluid Units (CFU) • Add Quantity (AQ) 2 • Add Units (AU) x • Add Fluid Quantity (AFQ) 50 • Add Fluid Units (AFU) ml • Add type (AType) solv. 30

  31. Database relations: MP - MPP 31

  32. Database relations: MP – MPP - GAL 32

  33. Database relations: MP – MPP - GAL 33

  34. Database fields: MPP Reference class = CNK mOno, mUlti, Combi Prescription label Ranking inside MP Name specifier: “TTS: 10” Combi preparations: “6 + 5 + 11” 34

  35. Hyr (1400, 7 levels) MP (2500) MPP ( 5830) SAM (>7000) Database tables • IR (160) / MPEQ • GAL (500) • INNM (1400) • Composition of Medicinal Product Packages • Pharmaceutical Product (PP) info • Ingredient • Strength 35

  36. Database tables: SAM.dbf Composition of Medicinal Product Packages • Ingredient (InCv) “0483” • Quantity (InQ) 2 • Units(InU) mg • To Add (+) or Solved (/) (Add) - • Quantity of Solvent base (InBasQ) - • Units of Solvent base (InBasU) - • InQ2 - • InU2 - • Dim - 36

  37. Database tables: SAM.dbf Composition off Medicinal Product Packages • Ingredient (InCv) “0123” • Quantity (InQ) 5 • Units(InU) mg • To Add (+) or Solved (/) (Add) / • Quantity of Solvent base (InBasQ) 1 • Units of Solvent base (InBasU) ml • InQ2 - • InU2 - • Dim - 37

  38. Database tables: SAM.dbf Composition off Medicinal Product Packages • Ingredient (InCv) “1234” • Quantity (InQ) 250 • Units(InU) - • To Add (+) or Solved (/) (Add) à • Quantity of Solvent base (InBasQ) - • Units of Solvent base (InBasU) - • InQ2 1000 • InU2 UI poudre • Dim - 38

  39. Database tables: SAM.dbf Composition off Medicinal Product Packages • InRank 1 2 • Ingredient (InCv) “0115” “0862” • Quantity (InQ) 250 125 • Units(InU) mg mg • Add (+) or Solved (/) or “à” (Add) - - • Quantity of Solvent Base (InBasQ) - - • Units of Solvent Base (InBasU) - - • Max Ingredient Quantity (InQ2) - - • Max Ingredient Units (InU2) - - • Dim - - 39

  40. Database relations: MPP - SAM 40

  41. Database relations: MPP - SAM 41

  42. Database fields: SAM 42

  43. Hyr (1400, 7 levels) MP (2500) MPP ( 5830) SAM (>7000) GGR_LINK (5830) Database tables • IR (160) / MPEQ • GAL (500) • INNM (1400) 43

  44. Database tables: GGR_Link.dbf 44

  45. Database tables: GGR_Link.dbf 45

  46. Database tables: GGR_Link.dbf 46

  47. Database tables: GGR_Link.dbf 47

  48. Database tables: GGR_Link.dbf 48

  49. Hyr (1400, 7 levels) MP (2500) MPP ( 5830) SAM (>7000) GGR_LINK (5830) ATCDPP (>12000) Database tables • IR (160) / MPEQ • GAL (500) • INNM (1400) 49

  50. Database tables: AtcDpp.dbf ATC code Atc & Dpp history DDD Quantity In Present GGRCM ? DDD Units MppNm Nl (c,50) Mppnm Fr(c,50) Off Market Date Doses Pro Package MppCv = CNK ATC title (English) 50

More Related