SITEMAP | HET BCFI | VERANTWOORDELIJKEN | CONTACTEER ONS | LINKS | HELP
BCFI/CBIP  
 

Version dBase III

GGRCMdbfStructure Version 00606

Septembre 2012

Version dBase III/ CSV
Field types: C (Char), N(Numeric),M (Memo), L (Logical), D (Date)
Field Length: Number, including decimal point and decimals
Field Decimals
Structure in both languages is identical.

 

See powerpoint presentation 28 06 2007

Table of contents

Glossary
HYR.dbf/dbt - Hyr.csv
MP.dbf/dbt - MP.csv
Meaning of the WADAN codes
MPP.dbf - Mpp.csv
SAM.dbf - Sam.csv
IR.dbf - Firm.csv
INNM.dbf - Stof.csv
GAL.dbf - Gal.csv
ATCDPP.dbf
GGR_LINK.dbf - Ggr_Link.csv
VMP4Inn dbf/csv/xml
AMPP4Inn dbf/csv/xml
RD4Inn dbf/csv/xml
CODES4Inn dbf/csv/xml

 

Glossary

MP     Medicinal Product
MPP    Medicinal Product Package
MPPCV  Medicinal Product Package Code Value
MPPNM  Medicinal Product Package Name
MPGRP  Medicinal Product Group
THGRP  Therapeutical Group
*CV  Persistent Key, used in a national referencing frame
PP     Pharmaceutical Product
IN     Ingredient
INNM   Ingredient Name

Changed in the last version

Top of Page

table HYR.dbf/dbt -nHyr/fHyr.csv

This table contains the structure of the BCFI repertorium and most of its texts.
Primary Key: HYRCV

FieldName Type Len Example Comment, GGR version Nl 2007)
Hyr C 8 "BFCA" 2nd Chapter (=" … BIJ MAAG- EN DARMZIEKTEN")
6th SubSection (="Laxativa"),
3th SubSection (="Osmotische laxativa)"
1st SubSection("Lactitol, lactulose en sorbitol")
Monthly updated
HYR is converted in the printed version to a Numerical equivalent
HyrCV C 5 "00123" Prim Key, persistent. The value of this key doesn' change with every release.
MpGrp L 1 .T. Medicinal Product Group. Eg Lactitol
("BFCAA has MpGrp= .T., meaning this title has a typical font, independent of the depth in the hierarchy.
All MPs belong to one MpGrp.
MpGrp Titles can refer
to an active ingredient ("Lactitol") or
to a particular group ("Associations of betablocker and diureticum")
TI C 110 "Laxativa" Full title , as used in the printed version. No font indications are included
Intro M   "In dit hoofdstuk …"
"Dans ce chapitre ..."

Semi-structured text, in uniform font and style (with bold, italics, subscript and superscript indication) and with some standard replacements:

  • Items are all preceded by a dash
  • Paragraphs are substituted by the #13#10 codes
  • Double quotes ("xyz " were translated in *xyz*
  • URLs and other references are substituted by <I> </I> tags, suggesting "italic" style.
    <B> and </B> are kept alive around text strings to be accentuated.
    cm2 is written as cm<SUP>2</SUP>;
    H2O is written as H<SUB>2</SUB>O;
Pos M   "Posol: 20 g p.d." Windowed Posology comment, following an intro text

A MP (Medicinal Product eg. "IMPORTAL") always belongs to a MP.GRP (Medicinal Product Group eg. "Lactitol").
In some cases (like "COLOFIBER") the MP.GRP-Title is not showed and the title field in the table is empty)

So we have in Chapter 1 (GGR version Nl 2011) the following

Hyr= "A"     MpGrp= .F.  TI= "Cardiovasculair stelsel" ...
Hyr= "AA"    MpGrp= .F.  TI= "Hypertensie"
Hyr= "AAA"   MpGrp= .F.  TI= "Alfa-blokker"
Hyr= "AAAA"  ;MpGrp= .T.  TI= "Prazosine"
The "MpGrp= .T." boolean indicates a static font and style (bold, lowercase, first character uppercase) will be used for showing this title in the printed version.

Top of Page

table MP.dbf/dbt nMp/fMp.csv

This table contains all data conected to an MP
Primary key: MPCV

FieldName Type Len Example Comment
MPCV C 5 "00001" Prim Key persistent. Stays stable from monthly release to release and from year to year.
Use this code for linking with the other tables.
HYRCV C 5 12345 Persistent key, referencing to the HYr table
HYR C 8 "BEA" Redundant, indicates present location in the Hierarchical tree
MPNM C 55 "Lanoxin" Fantasy name of the medicinal product, uppercase/ lowercase
IRCV C 5 Information Responsible code Persistent key, referencing to the Information Responsible name, found in the IR.dbf file. Often producent or distribution responsible firm.
BT L True/False Back Triangle (see site) True= New active ingredient; be carefull; report problems
NOTE M     Full text at MP level. URLs and other references are substituted by tages, suggesting "italic" style.
Also and tags kept alive around text strings to be accentuated.
POS M     Full text at MP level, without layout.
WADAN C 6 "B" Doping code, according to Vlaamse Gemeenschap (WADA) cfr infra
WADAF C 6 "B" Doping code, according to French community (WADA) cfr infra
Rank Int   nbsp Not present in dbf version.
Not filled in. Indicates the order within a HYR
NmCv C 5 "012345" Not present in dbf version.
Not filled in. Links to an internal table with MPNM names
Firm C 50 "MSD" Not present in dbf version.
Not filled in. Presents the firm name
Amb B 1 True Not present in dbf version.
True = existing int the present medication ambulant set
Hosp B 1 False Not present in dbf version.
True= Actif in the actual version of hospital medication set. Now always False

Top of Page

 

Meaning of the WADAN codes
A In alle omstandigheden verboden (let op urinaire drempelwaarde)
B ß-blokkers, verboden bij bepaalde concentratiesporten binnen wedstrijdverband en ten allen tijde verboden bij handboogschieten
B2 Alle ß2-mimetica zijn verboden, behalve salbutamol, salmeterol en frometerol die via inahalatie en overeenkomstig het therapeutisch regime worden gebruikt
C Corticosteroiden, verboden binnen wedstrijdverband behalve bij dermatologisch gebruik
c Opgelet. De sporter moet bij een eventuele dopingcontrole de controle arts op de hoogte brengen
D Diuretica, ten allen tijde verboden
d Opgelet. Product is niet verboden maar kan een positieve doping test opleveren.
DB Bevat diuretica, ten allen tijde verboden
H Ten allen tijde verboden
M Maskerende middelen, ten allen tijde verboden
N Narcotica, verboden binnen wedstrijdverband
O Anti-Oestrogene middelen, ten allen tijde verboden
AO Anti-Oestrogene middelen, ten allen tijde verboden
S Stimulantia, verboden binnen wedstrijdverband

Top of Page

Meaning of the WADAF codes
A Anabolisants, interdits en toutes circonstances
B "ß-bloquants, interdits en compétition pour certains sports de concentration et interdit en toutes circonstances aux tireurs à l'arc
B2 "Tous ß2-mimétiques sont interdits, auf le salbutamol, salmétérol et formétérol administrés par inhalation administrés conformement le schéma thérapeutique recommendé
C Corticostéroïdes, interdits en compétition, sauf en usage dermatologique
c Attention. Le sportif doit avertir le médecin controlôleur lors d'un contrôle antidopage éventuel
D Diurétiques, interdits en toutes circonstances
d Attention. Produit qui n'est pas interdit mais peut donner un contrôle antidopage positif
DB Contient diurétiques, interdits en toutes circonstances
H Interdit en toutes circonstances
M Agents masquants, interdits en toutes circonstances
N Narcotiques, interdits en compétition
O Anti-estrogènes, interdits en toutes circonstances
AO Anti-estrogènes, interdits en toutes circonstances
S Stimulants, interdits en compétition

Top of Page

table MPP.dbf nMpp/fMpp.csv

Contains all administrative information of each MPP
Primary key: MPPCV

FieldName Type Len Example Comment
HYR C 8   Link Hyr.dbf table
HYRCV C 5 "00123" Link to Hyr.dbf table
OGC_R/ OGC C 1 "B" Indicates the state in the Belgian Reimbursement by Reference System (RRS)
"A" means "Original compound, public price not lowered to RRS treshold"
"B" means "Original compound, public price lowered to RRS treshold", cheap
"C" means "Copy product, cheap
"G" means "Generic product, cheap
"W" means "Orphans"
"Y" means "Not included in the RRS"
"Z" means "Not included in the RRS, but ATC4 alternatives exist"
"Y" and "Z" labeled states are till now handled in the same manner
empty: "No reimbursement by RIZIV/INAMI
MPCV C 5 "01234" Medicinal Product Code, referencing to MP.dbf table, persistent version
MPPCV C 7 "1234567" Prim Key persistent. Medicinal Product Package Code Value, in Belgium identical to the CNK
OUC C 1 "O" O= Mono Ingredient MPP (eg "Lanitop")
U= Multi Ingredient MPP (eg ‘Zestoretic")
C= Combined Multi Ingredient MPP (eg "Binordiol")
MPPNM C 70 "LANOXIN compr 60x .0125mg" Medicinal Product Package Name or Prescription name, identifying the Medicinal Product Package in human language, can be use for prescription purposes
VLGNR/VolgNr N 2 1 Ranking within an Medicinal Product set
GALCV C 5 "00107" Galenic code, referencing to GAL.dbf, persistent version
SPEF C 15 "TTS 5:" Medicinal Product Specifier used in some MPPNM (eg "NITRODERM TTS 5:…")
CQ N 4 30 Content Quantity
CU C 1 "x" Content Units
CFQ N 9 200 Content Fluid Quantity
CFU C 20 "ml" Content Fluid Units, but also used for "doses", bulk units "g"
AQ N 1 Not yet used Content Quantity to Add cfr "MAXI B", "Humegon",
AU C 1 Not yet used Content Units to Add
AFQ N 3 2 Content Fluid Quantity to add
AFU C 2 "ml" Content Fluid Units to add
ATYPE C 12 "solv;" Type of part to add eg "solvens"
CMUCOMB C 20 I + II+ III Full string, used eg.in "Trinordiol"
LAW C 1 "R" "R" if "on prescription"
SSECR C 9 B! Social Security Reimbursement code (// RIZIV/INAMI indication)
PUPR N 8,2   Public Price, in Euro
USE C 1 "H" Restricted to "Hospital use"
NOTE C 190   Note on this MPP
POS C 190   Posology comment
Content C 50 2 x 250 ml Content of a package, described in "human" language. Build based on field cQ, CU, CFQ, cFU
GalNm_ C 50 comp. (deelb.) Indication for the galenic term (Full name found in GAL.dbf table using GalCV field)
Index N 10,2   Amount of eurocent, paid by non-OMNIO patients for one unit (one tablet, 1 ml, 1 amp, 1 gr). Order of presentation in the "Comparatif Price Tables"
RemA C 8,2 "H" Amount paid by patients without OMNIO state ("active patients"), in &euro
RemW C 8,2 12,50 Amount paid by patients with OMNIO/WIGW state, in €
RVos C 5 "01234" Code field meant as link to VOS/DCI tabel. This table will contain all necesaary info for prescriptions based on ingredientnames. Only available in CSV format
BT L True/False Back Traingle (see site) True= New active ingredient; be carefull; report problems
InnCnk C 7 "8123456" Official CNK code for this VOS group. Always starting with "8"
Gdkp C 1 Field not present in dbf; field not filled in CSV export
Strtype C 1 Field not present in dbf; field not filled in CSV export
StrVos C <100/td> Field not present in dbf; field not filled in CSV export
During C 30 Field not present in dbf; field not filled in CSV export
CRemA C 12 Field not present in dbf; field not filled in CSV export
CRemW C 12 Field not present in dbf; field not filled in CSV export
fNoemer Real Field not present in dbf; field not filled in CSV export
cIndex C 20 Field not present in dbf; field not filled in CSV export
HyrNode C 8 Field not present in dbf; field not filled in CSV export
Applic C 20 Field not present in dbf; field not filled in CSV export
StofMx i Field not present in dbf; field not filled in CSV export
Novos_Gal C 1 Field not present in dbf; field not filled in CSV export
AdSolv C Field not present in dbf; field not filled in CSV export
Excip C 30 ArgAsp Hulpstoffen met Erkende Werking / Excipients à effet notoire
Cheapest B 1 True RIZIV code "Cheapest= True"
Amb B 1 True True= Actif in the actual version of Ambulant medication set. Till now not used
Hosp B 1 False True= Actif in the actual version of hospital medication set. Now always False

Top of Page

table SAM.dbf nsam/fSam.csv

"Sam.dbf" is used for presentation off the MPP compositon
Primary key= MPPCV+ INRANK

FieldName Type Len Example Comment
HYR C 8 "ABA" Cfr HYR.dbf (redundant, but kept for clarity)
HYRCV C 5 "00123" Cfr HYR.dbf (redundant, but kept for clarity)
MPCV C 5 "01234" Cfr MPP.dbf (redundant, but kept for clarity)
MPPCV C 7 "1234567" Cfr MPP.dbf table
MPPNM_ C 35 "LANOXIN compr 60x .0125mg" Indication for the prescription name, identifying the MPP in human language
Redundant.
For full version, see MPP.dbf
PPID C 4 "II" "Pharmaceutical Product" Identifier
"Pharmaceutical Product" concept only used in the case of Combined Multi Ingredient Medicinal Products (eg "Trinordiol")
PPQ N 2 10 Quantity of units of this PP combination
PPGAL C 30 transderm syst farmaceutical form for this application phasis
INRANK N 2 1 Ranking of the ingredient in a MPP-formula
INCV C 4 "1234" Old link to INNM table. Obsolete. Kept for backward compatibility
StofCV C 5 "12345" Link tot INNM table
DIM C 20   Eg MP "Spongostan"
INX C 2 empty
INQ N 12,3 1.25 Quantity of ingredient
INU C 20 "mg" Units of Ingredient quantity
ADD C 1 "+","/" "/"= Separator for counter/enumerators
eg in "Nysconitrine 6x 25mg/1 ml"
"+" indicates the existance off a separate solvent eg "Clamoxyl IM"
INBASQ N 9   "1" in Nyscontrine amp
INBASU C 15   "ml" in Nysconitrin amp
INQ2 N 9,3   Eg MP "Factor VII"
INU2 C 2   Eg MP "Factor VII"
Stof C 120   Indicate the ingredient (redundant with content in INNM table)
NVos C 80 True Field not present in dbf; field not filled in CSV export
Amb B 1 True True= Present in the actual version of ambulant medication set
Hosp B 1 False True= Actif in the actual version of hospital medication set. Now always False

Top of Page

table IR.dbf - nFirm/fFirm.csv

Shows the Information Responsibles (Fabricants, Distributors)
Primary key= IRCV
Previous dbf DEL-field has been substituted by the AMB and HOSP field

FieldName Type Len Example Comment
IRCV C 5 "12345" Cfr. MP.dbf table, persistent code
NIRNM C 45 "Rode Kruis" Information Responsible Name (can be the Marketing holder, Producent of ingredient, Producent of MPP, Licence Holder). Flemish Name
FIRNM C 45 "Croix Rouge" Information Responsible Name (can be the Marketing holder, Producent of ingredient, Producent of MPP, Licence Holder). French term.
Pip L 1 True True = Parallel import firm
Amb B 1 True True= present in the actual version of ambulant medication set
Hosp B 1 False True= Actif in the actual version of hospital medication set. Now always False

Top of Page

table InNm.dbf - nStof/fStof.csv

Contains active ingredient information
Primary key= StofCV
Previous dbf DEL-field has been substituted by the AMB and HOSP field

FieldName Type Len Example Comment
StofCV C 5 "12345" Primary key, Cfr SAM.dbf
INCV C 4 "1234" To be avoided, will disappear; use StofCV instead;
Backward compatible with previous versions. Can contain empty fields due to new ingredients
NINNM C 80 "splitted inactivated virusses" Ingredient Name, Flemish Name
FINNM C 80 "splitted inactivated virusses" Ingredient Name, French Name
NBASE C 60 "basic term of this active ingredient"
NINNMX C 110 "generated on cells of chicken embryos" Extra information on the ingredient eg in "Fluvirin", Flemish Text
NSaltEstr C 60 "Hydrochoride" Salt or Estr
FBASE C 60 "basic term of this active ingredient"
FINNMX C 110 "generated on cells of chicken embryos" Extra information on the ingredient eg in "Fluvirin", French Text
FSaltEstr C 60 "Chlorhydrate" Salt or Estr
Amb B 1 True Actif in the actual version of Ambulant medication set
Hosp B 1 False Not used

Top of Page

table Gal.dbf nGal/fGal.csv

Contains Galenic form information
Primary key= GALCV
Previous dbf DEL-field has been substituted by the AMB and HOSP field

FieldName Type Len Example Comment
GalCv C 5 "01234" Prim key
NGalNM C 77 "Compr. (deelb.)"  
FGalNM C 77 "Compr. (séc.)"  
Amb B 1 True True= NOT present in the actual version of ambulant medication set
Hosp B 1 False Not used

Top of Page

ATCDPP.dbf

Contains ATC information on MPP of last 5 years

FieldName Type Len Example Comment
MPPCV C 7 "1234567" In Belgium identical on CNK. Also old MPPCVs are included.Prim Key
NMPPNM C 50 "Witte kruis bruistabl. 16" Name of Medicinal Product Package. Also old MPPNMs are included. For full flemish names off actual medication, see MPP.dbf.
FMPPNM C 50 "Croix blanche compr eff 16 " Name of Medicinal Product Package. Also old MPPNMs are included. For full french names off actual medication, see MPP.dbf.
ATC C 7 M 01 A E 12 ATCcode (5 levels, 7 characters), monthly updated
DDD N 12,3 4 Defined Daily Dose, quantity, yearly updated by the WHO
DDU C 2 "mg" DDD units, yearly updated by the WHO
DPP N 12,3 "33,333" Doses Pro Package, monthly updated
ATCNM_E C 50 "Furosemide" Title off the ATC-arm English
ATCNM_N C 50 "Furosemide" Title off the ATC-arm Nederlands
ATCNM_F C 50 "Furosemide" Title off the ATC-arm French
OffMrkt C 8 "20001231" Format YYYYMMDD, date of disappearance from the Belgian market
GGRCM Logical True True means, present in the actual version

Top of Page

GGR_LINK.dbf

Contains information for hyperlinking to the BCFI /CBIP Site
For more explanation and examples, see Download tag; line "GGRLINK"

FieldName Type Len Example Comment
MPPCV C 7 Medicinal Product Package Code Value Prim Key. cfr MPP.dbf
MPPNM_ C 35 Indication of the Medicinal Product Package Name, short version cfr MPP.dbf
LINK2PVT C 30 PTN_FHACA.cfm#subMPG1436 Link to a specific position on the Price Comparison Tables (PCT) on the Site www.BCFI.be or www.CBIP.be
e.g. use this link to reach the PCT for "betahistinedihydrochloride 16mg"
Full string
for BCFI => "http://www.bcfi.be/GGR/PrijsTbl/ "+ GGR_LINK->Link2PVT or
for CBIP => "http://www.cbip.be/GGR/PrijsTbl/ "+ GGR_LINK->Link2PVT
This value can be different for both languages
LINK2MPG C 30 MPG_FHC.cfm#MP_1274 Link to a specific position on the Medicinal Product Group pages (MPG) on the Site www.BCFI.be or www.CBIP.be
e.g. use this link to reach the page off MP "betaserc"
Full string
for BCFI => "http://www.bcfi.be/GGR/MPG/ "+ GGR_LINK->Link2MPG or
for CBIP => "http://www.cbip.be/GGR/MPG/ "+ GGR_LINK->Link2MPG
This value is the same in both languages

Top of Page

VMP4Inn

Contains details concerning the INN groups
(VMP= Virtual Medicinal Product)

FieldName CSV/XML FieldName dbf Type Width Description
Inngroup_CV Inn_CV Char 5 Unique identification this INN-Group
InnGroup_CNK Inn_Cnk Char 7 National Id INN-group
INNGroup_NL INN_NL Char 140 Name VMP-Group Dutch
INNGroup_FR INN_Fr Char 140 Name VMP-Group French
Administration_entity_value AdminVal Float   Number of INNGROUP administration Units
Administration_entity_unit_NL AdminNL Char 70 Administration form in Signatura of INN prescription
Administration_entity_unit_FR AdminFR Char 70 Administration form in Signatura of INN prescription
NoINNPrescrib NoInn Logical   If set to ‘True’, this INN-group is excluded from INN prescribing
NoSwitch NoSwitch Logical   Caveat: if set to ‘True’, the selector of products from the INN-group must consider that changing the Medicinal Product Packages can cause clinical problems
Cave_Rd CaveRd Logical   Caveat: if set to ‘True’, the selector of products from the VMP group must take into account differences in route of administration (oral, rectal, ..) in this INN-group
CaveAlt_Release CaveAlt Logical   Caveat: the selector of products from the INN-group must take into account differences in “altered release” (Slow, Retard, Immediate onset) in this INN-group
CaveCrush CaveCrsh Logical   Caveat: the selector of products from the INN-group must take into account differences in crushability within this INN-group
CaveExip CaveExp Logical   Caveat: the selector of products from the INN-group must take into account differences in the vehiculum within this INN-group
CaveVehiculum CaveVeh Logical   Caveat: the selector of products from the INN-group must take into account differences in the vehiculum within this INN-group
CaveEC CaveEC Logical   aveat: the selector of products from the INN-group must take into account differences in the “Enteric coating” within this INN-group
CaveDivide CaveDiv Logical   Caveat: the selector of products from the INN-group must take into account differences in the “Divisibility” within this INN-group
InfoTool InfoTool Logical   Info: more than one Tools necessary for administration underlying Medicinal Product Packages exist
VTMterm1_Nl VTM1_NL Char 100 VTM_Term_NL (most important)
VTMterm2_Nl VTM2_NL Char 100 VTM_Term_NL (second most important)
VTMterm3_Nl VTM3_NL Char 100 VTM_Term_NL
VTMterm1_Fr VTM1_FR Char 100 VTM_Term_FR (most important)
VTMterm2_Fr VTM2_FR Char 100 VTM_Term_FR (second most important)
VTMterm3_Fr VTM3_FR Char 100 VTM_Term_FR
Strength1_Nl Str1_NL Char 25 Strength of VMP_term1_NL(nominator)
Strength2_Nl Str2_NL Char 25 Strength of VMP_term2_NL(nominator)
Strength3_Nl Str3_NL Char 25 Strength of VMP_term3_NL(nominator)
DeNom_Nl DeNom_Nl Char 20 Denominator for Strength
Strength1_Fr Str1_FR Char 25 Strength of VMP_term1_FR(nominator)
Strength2_Fr Str2_FR Char 25 Strength of VMP_term2_FR(nominator)
Strength3_Fr Str3_FR Char 25 Strength of VMP_term3_FR(nominator)
DeNom_Fr DeNom_Fr Char 20 Denominator for Strength
Applic_Nl Appl_Nl Char 70 How to applicate (NL)
Applic_Fr Appl_Fr Char 70 How to applicate (FR)
Applic_Code Applic Char 2 Code for Application (see Codes2Inn)
Adminroute_NL Road_NL Char 70 Route of administration (NL)
Adminroute_Fr Road_FR Char 70 Route of administration (FR)
Adminroute Road Char 2 Code for Route of administration (see Codes2Inn)
Combination Combin Logical   “TRUE” if this INN-group consists of a combination of therapeutic moieties
SEQ SEQ Logical   “TRUE” if this INN-group consists of a combination of therapeutic moieties, to be applicated sequentially (e.g.anticonceptional pills
Join Join Logical   The VMP-group consists of a combination of therapeutic moieties, to be applicated joined, without sequence (e.g. Revitalose)
Plus3 Plus3 Logical   “TRUE” if this INN-group group consists of more than 3 therapeutic moeities. Only the 3 most important therapeutic moeities are mentioned
CreaDate CreaDatm char 4 Format YYMM: month and year of creation of INN-Group
EndDate EndDatm char 4 Format YYMM: month and year of finding that NO Medicinal Product Package, belonging to this INN-Group, exists
VTM_CV VTMCV char 5 Code for this VTM group
Error Error char 4 Temporary field
Hyr_CV Hyr_CV char 5 Format 99999. Code of the hierarchy of the INN-Group in the internal classification system of the BCPI-repertory, stably linked to the INN-Group
Hyr Hyr char 8 Indication of the node in the actual hierarchical ranking. Present for compatibility.Becomes Obsolete. See HyrNode
HyrNode HyrNode char 10 Indication of the node in the actual hierarchical ranking (identical to HYR: added because of consistency with future SAM-concepts)

Top of Page

AMPP4Inn

Contains INN related information for every present AMPP (Actual Medicinal Product Packages)

FieldName CSV/XML FieldName dbf Type Width Description
MPPCV MPPCV Char 7 Unique Code of Medicinal Product Package (See MPP table). In Belgium: equivalent to CNK
MPP_NL MPP_NL Char 70 Name Medicinal Product Package Dutch
MPP_FR MPP_FR Char 70 Name Medicinal Product Package French
INNGroup_CV Inn_CV Char 5 Unique identification VMP-Group
INNGroup_CNK Inn_CNK Char 8 National Id INN-group
Alt_release Alt_rel Char 3 Altered release (see Codes4Inn)
Vehiculum Veh Char 3 Vehiculum (see Codes4Inn)
Divide Divide Char 3 Divisible (see Codes4Inn)
Soluble Soluble Char 3 Solid to Liquid (see Codes4Inn)
Enteric_Coated EC Char 3 Enteric coated (see Codes4Inn)
Device Device Char 3 Specified device (see Codes4Inn)
Crush Crush Char 3 Crush
Aero Aero Char 3 Code for Aerosol type
Aero Aero Char 3 Code for Aerosol type
AdmRoad Road Char 20 Code for Routes of administration (one or many, see Codes4Inn)
Alt_release_Nl Alt_Nl Char 70 Altered release-Description Dutch
Alt_release_Fr Alt_FR Char 70 Altered release-Description French
Vehiculum_Nl Vehic_Nl Char 70 Vehiculum-description Dutch
Vehiculum_FR Vehic_FR Char 70 Vehiculum-description French
Soluble_Nl Soluble_Nl Char 70 Soluble-Description Dutch
Soluble_FR Soluble_FR Char 70 Soluble-Description French
Enteric_Coated_Nl EC_Nl Char 70 Enteric Coated-Description Dutch
Enteric_Coated_Fr EC_FR Char 70 Enteric Coated-Description French
Device_Nl Devic_Nl Char 70 Device-Description Dutch
Device_FR Devic_FR Char 70 Device-Description French
Crush_Nl Crush_Nl Char 50 Crushable -Description Dutch
Crush_FR Crush_FR Char 50 Crushable-Description French
Aero_Nl Aero_Nl Char 50 Type of Aerosol Dutch
Aero_Fr Aero_FR Char 50 Type of Aerosol French
AdmRoad_NL ROAD_NL Char 50 Route of Administration Dutch (see Codes4Inn)
AdmRoad_Fr ROAD_FR Char 50 Route of Administration French (see Codes4Inn)
Source Source Char 4 Off Market format YYMM
Hyr Hyr Char 8 Indication of the Hierarchical Node
HyrCV HyrCV Char 5 Internal code
HyrNode HyrNode Char 10 Indication of the node in the actual hierarchical ranking (identical to HYR: added because of consistency with future SAM-concepts)

Top of Page

RD4Inn

Contains the RD (Route of Administration) codes for every INN
Added for ease of acces to the one-or-many ROAD alternatives when application= "Inj."

FieldName CSV/XML FieldName dbf Type Width Description
InnGroup_Cnk Inn_Cnk Char 7 INNCnk for the INN group
InnGroup_NL Inn_NL Char 140 Name of the INNgroup
RD RD Char 1 Code for one Route of Administration. When more than one route of Administration is possible, the record is repeated and de RD code is adapted
Permits to scan a INNgroup for possible routes of administration
Road Road Char 20 All routes of administration (coded). For meaning of the codes see Codes4Inn table
Adminroute_Nl Route_Nl Char 70 Description of an administration route in Dutch

Top of Page

Codes4Inn

Contains INN related codes and their meaning

FieldName CSV/XML FieldName dbf Type Width Description
Table Table Char 50 Table name
Field Field Char 100 Field name
Mnemo Mnemo Char 50 Mnemotechnical tip
Value Value Char 5 Used code
Nl Nl Char 70 Description in Dutch
Fr Fr Char 70 Description in French
Comment Comment Char 70 Comment

Top of Page