Applicable to the EMD-databases of March 2016 and later

• The maximum size of ALL fields of type VARCHAR has been extended to 255.
• All AMB and HOSP fields are no longer used. The AMB fields have always value TRUE, while the HOSP fields have always value FALSE.

• The GALCV primary key (and thus foreign keys in other tables) have been attributed new values. The values for this primary key will however change in each export. Referential integrity between this table and the linked tables is obviously guaranteed, but no foreign keys from external tables should ever refer to this primary key as its values will change with each export.
  These new 'galenic terms' are constructed automatically based on several elements such as route of administration, pharmaceutical form, etc., therefore there is no fixed primary key value for each galenic term.

• The fields LINK2MPG and LINK2PVT contain from now on the full URLs to our website.

• The HYRCV primary key (and thus foreign keys in other tables) have been attributed new values. These new values, however, will remain stable in future.
• The textual contents of the Gecommentarieerd Geneesmiddelen Repertorium / Répertoire Commenté des Médicaments (i.e. the intro and pos fields) are now included in the so-called Markdown format. This format is suited to be readable as plain text and easily convertible towards HTML. For more information, we refer to https://daringfireball.net/projects/markdown/syntax and http://dillinger.io

• The STOFCV primary key (and thus foreign keys in other tables) have been attributed new values. These new values, however, will remain stable in future.

• The MPCV primary key (and thus foreign keys in other tables) have been attributed new values. These new values, however, will remain stable in future.
• The RANK field is no longer used. It's value is always set to false.
• The NOTE and POS fields are no longer used. Their value is always empty. For notes we refer to the MPP table. All notes are from now on specified in the MPP table.
• It is possible that multiple WADA codes delimited by commas are specified in the WADAN and WADAF fields, as multiple WADA codes can be attributed to the same MP.

• The VOLGNR, SPEF, CONTENT and EXCIP fields are no longer used. They are always left empty.
• The SSECR field has now the following definition:
  • Reimbursement categories are represented by values separated by a space (eg. "a4 b4 c4") in case multiple categories are applicable.
  • the values a, b, c, cx and cs represent the resp. reimbursement categories
  • the values b2 and c2 represent a posteriori control (for so-called chapter 2 drugs) in resp. category b and c (without prior approval of the advising practitioner, but with the possibility of a posteriori control)
  • the values a4, b4, c4 en cs4 represent a priori control (for so-called chapter 4 drugs) in resp. category a, b, c and cs (only reimbursed after agreement by the advising practitioner of the insurance institution)
  • value h means reimbursement only in hospitals
  • value J represents the special allowance by the RIZIV/INAMI for contraceptive drugs for women younger than 21 years
  • value aJ means the contraceptive drug is free for women younger than 21 years
  • the value Chr represents the special allowance by the RIZIV/INAMI for certain patients with persisting chronical pain

• Click here to download a changelog document

• Click here to download the description

• Klik hier om de documentatie te downloaden