| |
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
table HYR.dbf/dbt -nHyr/fHyr.csv
This table contains the structure of the BCFI repertorium and most of its texts.
Primary Key: HYRCV
| 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.
table MP.dbf/dbt nMp/fMp.csv
This table contains all data conected to an MP
Primary key: MPCV
| 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 |
| 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 |
| 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 |
table MPP.dbf nMpp/fMpp.csv
Contains all administrative information of each MPP
Primary key: MPPCV
| 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 |
table SAM.dbf nsam/fSam.csv
"Sam.dbf" is used for presentation off the MPP compositon
Primary key= MPPCV+ INRANK
| 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 |
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
| 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 |
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
| 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 |
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
| 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 |
ATCDPP.dbf
Contains ATC information on MPP of last 5 years
| 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 |
GGR_LINK.dbf
Contains information for hyperlinking to the BCFI /CBIP Site
For more explanation and examples, see Download tag; line "GGRLINK"
| 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 |
VMP4Inn
Contains details concerning the INN groups
(VMP= Virtual Medicinal Product)
| 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) |
AMPP4Inn
Contains INN related information for every present AMPP (Actual Medicinal Product Packages)
| 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) |
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."
| 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 |
Codes4Inn
Contains INN related codes and their meaning
| 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 |
|
|
|
