# ==================================================================== #
# TITLE #
# Tools for Data Analysis at Certe #
# #
# AUTHORS #
# Berends MS (m.berends@certe.nl) #
# Meijer BC (b.meijer@certe.nl) #
# Hassing EEA (e.hassing@certe.nl) #
# #
# COPYRIGHT #
# (c) 2019 Certe Medische diagnostiek & advies - https://www.certe.nl #
# #
# LICENCE #
# This R package is free software; you can redistribute it and/or #
# modify it under the terms of the GNU General Public License #
# version 2.0, as published by the Free Software Foundation. #
# This R package is distributed in the hope that it will be useful, #
# but WITHOUT ANY WARRANTY; without even the implied warranty of #
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the #
# GNU General Public License for more details. #
# ==================================================================== #
#' Lijst met \code{certedb}-tabellen
#'
#' Dit is een \code{list} met alle tabelvelden die in de \code{where} van \code{certedb}-functies gebruikt kan worden.
#' @usage db$...
#' @format \code{list}
#' @export
#' @examples
#' postcodelijst <- c("1234AA", "1234BB")
#' certedb_getmmb(2017,
#' 2018,
#' where(db$a.postcode %in% postcodelijst),
#' only_show_query = TRUE)
db <- list(`aanvr.*` = "aanvr.*",
aanvr.aanvragercode = "aanvr.aanvragercode",
aanvr.aanvragergroepcode = "aanvr.aanvragergroepcode",
aanvr.aanvragergroepnaam = "aanvr.aanvragergroepnaam",
aanvr.aanvragertype = "aanvr.aanvragertype",
aanvr.zorglijn = "aanvr.zorglijn",
aanvr.kortenaam = "aanvr.kortenaam",
aanvr.langenaam = "aanvr.langenaam",
aanvr.artsnaam = "aanvr.artsnaam",
aanvr.postcode = "aanvr.postcode",
aanvr.plaatsnaam = "aanvr.plaatsnaam",
aanvr.provincie = "aanvr.provincie",
aanvr.instelling = "aanvr.instelling",
aanvr.specialisme = "aanvr.specialisme",
aanvr.specialisme_hoofdgroep = "aanvr.specialisme_hoofdgroep",
aanvr.klinisch_soort = "aanvr.klinisch_soort",
aanvr.zkhlocatie = "aanvr.zkhlocatie",
aanvr.zkhafdeling = "aanvr.zkhafdeling",
aanvr.is_poli = "aanvr.is_poli",
aanvr.is_seh = "aanvr.is_seh",
aanvr.is_klinisch = "aanvr.is_klinisch",
aanvr.is_ic = "aanvr.is_ic",
aanvr.is_bwc = "aanvr.is_bwc",
aanvr.adherentiegebied = "aanvr.adherentiegebied",
aanvr.is_vervallen = "aanvr.is_vervallen",
`beh.*` = "beh.*",
beh.aanvragercode = "beh.aanvragercode",
beh.aanvragergroepcode = "beh.aanvragergroepcode",
beh.aanvragergroepnaam = "beh.aanvragergroepnaam",
beh.aanvragertype = "beh.aanvragertype",
beh.zorglijn = "beh.zorglijn",
beh.kortenaam = "beh.kortenaam",
beh.langenaam = "beh.langenaam",
beh.artsnaam = "beh.artsnaam",
beh.postcode = "beh.postcode",
beh.plaatsnaam = "beh.plaatsnaam",
beh.provincie = "beh.provincie",
beh.instelling = "beh.instelling",
beh.specialisme = "beh.specialisme",
beh.specialisme_hoofdgroep = "beh.specialisme_hoofdgroep",
beh.klinisch_soort = "beh.klinisch_soort",
beh.zkhlocatie = "beh.zkhlocatie",
beh.zkhafdeling = "beh.zkhafdeling",
beh.is_poli = "beh.is_poli",
beh.is_seh = "beh.is_seh",
beh.is_klinisch = "beh.is_klinisch",
beh.is_ic = "beh.is_ic",
beh.is_bwc = "beh.is_bwc",
beh.adherentiegebied = "beh.adherentiegebied",
beh.is_vervallen = "beh.is_vervallen",
`b.*` = "b.*",
b.bacteriecode = "b.bacteriecode",
b.bacteriecode_oud = "b.bacteriecode_oud",
b.systeemcode = "b.systeemcode",
b.familie = "b.familie",
b.genus = "b.genus",
b.species = "b.species",
b.subspecies = "b.subspecies",
b.code_genus = "b.code_genus",
b.code_species = "b.code_species",
b.code_subspecies = "b.code_subspecies",
b.volledigenaam = "b.volledigenaam",
b.soort_mo = "b.soort_mo",
b.groep_mo = "b.groep_mo",
b.aeroob_anaeroob = "b.aeroob_anaeroob",
b.pathogeen_urinekweek = "b.pathogeen_urinekweek",
b.pathogeen_bloedkweek = "b.pathogeen_bloedkweek",
b.pathogeen_bloedkweek_bacterie = "b.pathogeen_bloedkweek_bacterie",
`d.*` = "d.*",
d.ordernr_testcode_mtrlcode = "d.ordernr_testcode_mtrlcode",
d.ordernr = "d.ordernr",
d.testcode = "d.testcode",
d.aanmaakdatum_test = "d.aanmaakdatum_test",
d.aanmaakdatumtijd_test = "d.aanmaakdatumtijd_test",
d.usr = "d.usr",
`dlt.*` = "dlt.*",
dlt.ordernr_testcode_mtrlcode = "dlt.ordernr_testcode_mtrlcode",
dlt.ordernr = "dlt.ordernr",
dlt.ontvangstdatum = "dlt.ontvangstdatum",
dlt.ontvangstdatumtijd = "dlt.ontvangstdatumtijd",
dlt.transport_gehad = "dlt.transport_gehad",
dlt.indoos_datumtijd = "dlt.indoos_datumtijd",
dlt.uitdoos_datumtijd = "dlt.uitdoos_datumtijd",
dlt.aanvul_datumtijd = "dlt.aanvul_datumtijd",
dlt.modbac_datumtijd = "dlt.modbac_datumtijd",
dlt.modvir_datumtijd = "dlt.modvir_datumtijd",
dlt.modserpre_datumtijd = "dlt.modserpre_datumtijd",
dlt.modser_datumtijd = "dlt.modser_datumtijd",
dlt.modtb_datumtijd = "dlt.modtb_datumtijd",
dlt.val1_1e = "dlt.val1_1e",
dlt.val1_usr_1e = "dlt.val1_usr_1e",
dlt.val2_1e = "dlt.val2_1e",
dlt.val2_usr_1e = "dlt.val2_usr_1e",
dlt.aut_1e = "dlt.aut_1e",
dlt.aut_usr_1e = "dlt.aut_usr_1e",
dlt.rpt_1e = "dlt.rpt_1e",
dlt.val1_def = "dlt.val1_def",
dlt.val1_usr_def = "dlt.val1_usr_def",
dlt.val2_def = "dlt.val2_def",
dlt.val2_usr_def = "dlt.val2_usr_def",
dlt.aut_def = "dlt.aut_def",
dlt.aut_usr_def = "dlt.aut_usr_def",
dlt.rpt_def = "dlt.rpt_def",
`g.*` = "g.*",
g.ordernr = "g.ordernr",
g.plaveisel_epitheelcellen = "g.plaveisel_epitheelcellen",
g.leukocyten = "g.leukocyten",
g.erytrocyten = "g.erytrocyten",
g.mondflora = "g.mondflora",
g.mengflora = "g.mengflora",
g.fecale_flora = "g.fecale_flora",
g.positieve_kokken = "g.positieve_kokken",
g.positieve_kokken_in_trosjes = "g.positieve_kokken_in_trosjes",
g.positieve_kokken_in_ketens = "g.positieve_kokken_in_ketens",
g.positieve_kokken_in_duplo = "g.positieve_kokken_in_duplo",
g.negatieve_kokken = "g.negatieve_kokken",
g.negatieve_staven = "g.negatieve_staven",
g.negatieve_staafjes = "g.negatieve_staafjes",
g.positieve_staven = "g.positieve_staven",
g.positieve_staafjes = "g.positieve_staafjes",
g.gistcellen = "g.gistcellen",
g.cellen = "g.cellen",
g.bacterien = "g.bacterien",
`i.*` = "i.*",
i.ordernr_testcode_mtrlcode_stam = "i.ordernr_testcode_mtrlcode_stam",
i.ordernr_testcode_mtrlcode = "i.ordernr_testcode_mtrlcode",
i.stam = "i.stam",
i.ordernr = "i.ordernr",
i.ontvangstdatum = "i.ontvangstdatum",
i.patid = "i.patid",
i.instelling = "i.instelling",
i.afdeling = "i.afdeling",
i.artscode = "i.artscode",
i.testcode = "i.testcode",
i.mtrlcode = "i.mtrlcode",
i.fam_gen_spp = "i.fam_gen_spp",
i.bacteriecode = "i.bacteriecode",
i.ab_commentaar = "i.ab_commentaar",
i.esbl_interpr = "i.esbl_interpr",
i.bevat_brmo = "i.bevat_brmo",
i.eerste_brmo_ooit = "i.eerste_brmo_ooit",
i.eerste_isolaat = "i.eerste_isolaat",
i.eerste_isolaat_gewogen = "i.eerste_isolaat_gewogen",
i.is_esbl = "i.is_esbl",
i.is_mrsa = "i.is_mrsa",
i.is_qare = "i.is_qare",
i.is_cre = "i.is_cre",
i.is_cra = "i.is_cra",
i.is_crab = "i.is_crab",
i.is_mrpa = "i.is_mrpa",
i.is_qara = "i.is_qara",
i.is_crs = "i.is_crs",
i.is_vre = "i.is_vre",
i.is_pvre = "i.is_pvre",
i.is_prsp = "i.is_prsp",
i.is_vrsp = "i.is_vrsp",
i.moxa = "i.moxa",
i.peni = "i.peni",
i.bepe = "i.bepe",
i.oxac = "i.oxac",
i.clox = "i.clox",
i.meti = "i.meti",
i.amox = "i.amox",
i.amcl = "i.amcl",
i.ampi = "i.ampi",
i.amsu = "i.amsu",
i.azlo = "i.azlo",
i.pipe = "i.pipe",
i.pita = "i.pita",
i.tazo = "i.tazo",
i.tica = "i.tica",
i.ticl = "i.ticl",
i.cfra = "i.cfra",
i.cfix = "i.cfix",
i.cfac = "i.cfac",
i.cfal = "i.cfal",
i.czol = "i.czol",
i.cfep = "i.cfep",
i.cfur = "i.cfur",
i.cfam = "i.cfam",
i.cfox = "i.cfox",
i.cfsc = "i.cfsc",
i.cfot = "i.cfot",
i.cfpo = "i.cfpo",
i.cfta = "i.cfta",
i.cftr = "i.cftr",
i.cfsu = "i.cfsu",
i.cefa = "i.cefa",
i.gent = "i.gent",
i.gehl = "i.gehl",
i.tobr = "i.tobr",
i.neti = "i.neti",
i.amik = "i.amik",
i.kana = "i.kana",
i.neom = "i.neom",
i.siso = "i.siso",
i.sulf = "i.sulf",
i.trim = "i.trim",
i.trsu = "i.trsu",
i.nitr = "i.nitr",
i.fosf = "i.fosf",
i.line = "i.line",
i.tsta = "i.tsta",
i.nali = "i.nali",
i.cnox = "i.cnox",
i.pizu = "i.pizu",
i.norf = "i.norf",
i.lome = "i.lome",
i.cipr = "i.cipr",
i.moxi = "i.moxi",
i.levo = "i.levo",
i.oflo = "i.oflo",
i.vanc = "i.vanc",
i.teic = "i.teic",
i.tetr = "i.tetr",
i.tige = "i.tige",
i.doxy = "i.doxy",
i.eryt = "i.eryt",
i.qida = "i.qida",
i.azit = "i.azit",
i.imip = "i.imip",
i.mero = "i.mero",
i.mino = "i.mino",
i.aztr = "i.aztr",
i.chlo = "i.chlo",
i.poly = "i.poly",
i.baci = "i.baci",
i.coli = "i.coli",
i.roxi = "i.roxi",
i.linc = "i.linc",
i.mupi = "i.mupi",
i.spec = "i.spec",
i.dapt = "i.dapt",
i.novo = "i.novo",
i.clin = "i.clin",
i.incl = "i.incl",
i.metr = "i.metr",
i.inh = "i.inh",
i.rifa = "i.rifa",
i.pyra = "i.pyra",
i.etha = "i.etha",
i.stre = "i.stre",
i.sthl = "i.sthl",
i.cycl = "i.cycl",
i.prot = "i.prot",
i.clof = "i.clof",
i.clar = "i.clar",
i.rifb = "i.rifb",
i.ansa = "i.ansa",
i.ethi = "i.ethi",
i.thio = "i.thio",
i.amph = "i.amph",
i.fluz = "i.fluz",
i.fluo = "i.fluo",
i.5flu = "i.5flu",
i.itra = "i.itra",
i.vori = "i.vori",
i.keto = "i.keto",
i.mico = "i.mico",
i.nyst = "i.nyst",
i.fusi = "i.fusi",
i.econ = "i.econ",
i.clot = "i.clot",
i.casp = "i.casp",
i.anid = "i.anid",
i.posa = "i.posa",
i.xtz = "i.xtz",
i.xtzl = "i.xtzl",
i.xct = "i.xct",
i.xctl = "i.xctl",
i.xpm = "i.xpm",
i.xpml = "i.xpml",
`i_mic.*` = "i_mic.*",
i_mic.ordernr_testcode_mtrlcode_stam = "i_mic.ordernr_testcode_mtrlcode_stam",
i_mic.ordernr = "i_mic.ordernr",
i_mic.bacteriecode = "i_mic.bacteriecode",
i_mic.moxa_mic = "i_mic.moxa_mic",
i_mic.peni_mic = "i_mic.peni_mic",
i_mic.bepe_mic = "i_mic.bepe_mic",
i_mic.oxac_mic = "i_mic.oxac_mic",
i_mic.clox_mic = "i_mic.clox_mic",
i_mic.meti_mic = "i_mic.meti_mic",
i_mic.amox_mic = "i_mic.amox_mic",
i_mic.amcl_mic = "i_mic.amcl_mic",
i_mic.ampi_mic = "i_mic.ampi_mic",
i_mic.amsu_mic = "i_mic.amsu_mic",
i_mic.azlo_mic = "i_mic.azlo_mic",
i_mic.pipe_mic = "i_mic.pipe_mic",
i_mic.pita_mic = "i_mic.pita_mic",
i_mic.tazo_mic = "i_mic.tazo_mic",
i_mic.tica_mic = "i_mic.tica_mic",
i_mic.ticl_mic = "i_mic.ticl_mic",
i_mic.cfra_mic = "i_mic.cfra_mic",
i_mic.cfix_mic = "i_mic.cfix_mic",
i_mic.cfac_mic = "i_mic.cfac_mic",
i_mic.cfal_mic = "i_mic.cfal_mic",
i_mic.czol_mic = "i_mic.czol_mic",
i_mic.cfep_mic = "i_mic.cfep_mic",
i_mic.cfur_mic = "i_mic.cfur_mic",
i_mic.cfam_mic = "i_mic.cfam_mic",
i_mic.cfox_mic = "i_mic.cfox_mic",
i_mic.cfsc_mic = "i_mic.cfsc_mic",
i_mic.cfot_mic = "i_mic.cfot_mic",
i_mic.cfpo_mic = "i_mic.cfpo_mic",
i_mic.cfta_mic = "i_mic.cfta_mic",
i_mic.cftr_mic = "i_mic.cftr_mic",
i_mic.cfsu_mic = "i_mic.cfsu_mic",
i_mic.cefa_mic = "i_mic.cefa_mic",
i_mic.gent_mic = "i_mic.gent_mic",
i_mic.gehl_mic = "i_mic.gehl_mic",
i_mic.tobr_mic = "i_mic.tobr_mic",
i_mic.neti_mic = "i_mic.neti_mic",
i_mic.amik_mic = "i_mic.amik_mic",
i_mic.kana_mic = "i_mic.kana_mic",
i_mic.neom_mic = "i_mic.neom_mic",
i_mic.siso_mic = "i_mic.siso_mic",
i_mic.sulf_mic = "i_mic.sulf_mic",
i_mic.trim_mic = "i_mic.trim_mic",
i_mic.trsu_mic = "i_mic.trsu_mic",
i_mic.nitr_mic = "i_mic.nitr_mic",
i_mic.fosf_mic = "i_mic.fosf_mic",
i_mic.line_mic = "i_mic.line_mic",
i_mic.tsta_mic = "i_mic.tsta_mic",
i_mic.nali_mic = "i_mic.nali_mic",
i_mic.cnox_mic = "i_mic.cnox_mic",
i_mic.pizu_mic = "i_mic.pizu_mic",
i_mic.norf_mic = "i_mic.norf_mic",
i_mic.lome_mic = "i_mic.lome_mic",
i_mic.cipr_mic = "i_mic.cipr_mic",
i_mic.moxi_mic = "i_mic.moxi_mic",
i_mic.levo_mic = "i_mic.levo_mic",
i_mic.oflo_mic = "i_mic.oflo_mic",
i_mic.vanc_mic = "i_mic.vanc_mic",
i_mic.teic_mic = "i_mic.teic_mic",
i_mic.tetr_mic = "i_mic.tetr_mic",
i_mic.tige_mic = "i_mic.tige_mic",
i_mic.doxy_mic = "i_mic.doxy_mic",
i_mic.eryt_mic = "i_mic.eryt_mic",
i_mic.qida_mic = "i_mic.qida_mic",
i_mic.azit_mic = "i_mic.azit_mic",
i_mic.imip_mic = "i_mic.imip_mic",
i_mic.mero_mic = "i_mic.mero_mic",
i_mic.mino_mic = "i_mic.mino_mic",
i_mic.aztr_mic = "i_mic.aztr_mic",
i_mic.chlo_mic = "i_mic.chlo_mic",
i_mic.poly_mic = "i_mic.poly_mic",
i_mic.baci_mic = "i_mic.baci_mic",
i_mic.coli_mic = "i_mic.coli_mic",
i_mic.roxi_mic = "i_mic.roxi_mic",
i_mic.linc_mic = "i_mic.linc_mic",
i_mic.mupi_mic = "i_mic.mupi_mic",
i_mic.spec_mic = "i_mic.spec_mic",
i_mic.dapt_mic = "i_mic.dapt_mic",
i_mic.novo_mic = "i_mic.novo_mic",
i_mic.clin_mic = "i_mic.clin_mic",
i_mic.incl_mic = "i_mic.incl_mic",
i_mic.metr_mic = "i_mic.metr_mic",
i_mic.inh_mic = "i_mic.inh_mic",
i_mic.rifa_mic = "i_mic.rifa_mic",
i_mic.pyra_mic = "i_mic.pyra_mic",
i_mic.etha_mic = "i_mic.etha_mic",
i_mic.stre_mic = "i_mic.stre_mic",
i_mic.sthl_mic = "i_mic.sthl_mic",
i_mic.cycl_mic = "i_mic.cycl_mic",
i_mic.prot_mic = "i_mic.prot_mic",
i_mic.clof_mic = "i_mic.clof_mic",
i_mic.clar_mic = "i_mic.clar_mic",
i_mic.rifb_mic = "i_mic.rifb_mic",
i_mic.ansa_mic = "i_mic.ansa_mic",
i_mic.ethi_mic = "i_mic.ethi_mic",
i_mic.thio_mic = "i_mic.thio_mic",
i_mic.amph_mic = "i_mic.amph_mic",
i_mic.fluz_mic = "i_mic.fluz_mic",
i_mic.fluo_mic = "i_mic.fluo_mic",
i_mic.5flu_mic = "i_mic.5flu_mic",
i_mic.itra_mic = "i_mic.itra_mic",
i_mic.vori_mic = "i_mic.vori_mic",
i_mic.keto_mic = "i_mic.keto_mic",
i_mic.mico_mic = "i_mic.mico_mic",
i_mic.nyst_mic = "i_mic.nyst_mic",
i_mic.fusi_mic = "i_mic.fusi_mic",
i_mic.econ_mic = "i_mic.econ_mic",
i_mic.clot_mic = "i_mic.clot_mic",
i_mic.casp_mic = "i_mic.casp_mic",
i_mic.anid_mic = "i_mic.anid_mic",
i_mic.posa_mic = "i_mic.posa_mic",
`l_instelling.*` = "l_instelling.*",
l_instelling.instelling = "l_instelling.instelling",
l_instelling.zorglijn = "l_instelling.zorglijn",
l_instelling.naam = "l_instelling.naam",
l_instelling.noord_zuid = "l_instelling.noord_zuid",
l_instelling.cu_sd = "l_instelling.cu_sd",
l_instelling.cu_sd_naam = "l_instelling.cu_sd_naam",
l_instelling.aanvr_instelling = "l_instelling.aanvr_instelling",
l_instelling.zkhgroep = "l_instelling.zkhgroep",
l_instelling.zkhgroep_locatie = "l_instelling.zkhgroep_locatie",
l_instelling.zkhgroep_code2015 = "l_instelling.zkhgroep_code2015",
l_instelling.zkhgroep_code = "l_instelling.zkhgroep_code",
`l_ontvangst.*` = "l_ontvangst.*",
l_ontvangst.instelling = "l_ontvangst.instelling",
l_ontvangst.zorglijn = "l_ontvangst.zorglijn",
l_ontvangst.naam = "l_ontvangst.naam",
l_ontvangst.noord_zuid = "l_ontvangst.noord_zuid",
l_ontvangst.cu_sd = "l_ontvangst.cu_sd",
l_ontvangst.cu_sd_naam = "l_ontvangst.cu_sd_naam",
l_ontvangst.aanvr_instelling = "l_ontvangst.aanvr_instelling",
l_ontvangst.zkhgroep = "l_ontvangst.zkhgroep",
l_ontvangst.zkhgroep_locatie = "l_ontvangst.zkhgroep_locatie",
l_ontvangst.zkhgroep_code2015 = "l_ontvangst.zkhgroep_code2015",
l_ontvangst.zkhgroep_code = "l_ontvangst.zkhgroep_code",
`l_uitvoer.*` = "l_uitvoer.*",
l_uitvoer.instelling = "l_uitvoer.instelling",
l_uitvoer.zorglijn = "l_uitvoer.zorglijn",
l_uitvoer.naam = "l_uitvoer.naam",
l_uitvoer.noord_zuid = "l_uitvoer.noord_zuid",
l_uitvoer.cu_sd = "l_uitvoer.cu_sd",
l_uitvoer.cu_sd_naam = "l_uitvoer.cu_sd_naam",
l_uitvoer.aanvr_instelling = "l_uitvoer.aanvr_instelling",
l_uitvoer.zkhgroep = "l_uitvoer.zkhgroep",
l_uitvoer.zkhgroep_locatie = "l_uitvoer.zkhgroep_locatie",
l_uitvoer.zkhgroep_code2015 = "l_uitvoer.zkhgroep_code2015",
l_uitvoer.zkhgroep_code = "l_uitvoer.zkhgroep_code",
`m.*` = "m.*",
m.mtrlcode = "m.mtrlcode",
m.mtrlnaam = "m.kortenaam AS mtrlnaam",
m.mtrlgroep = "m.mtrlgroep",
m.subtype1 = "m.subtype1",
m.subtype2 = "m.subtype2",
m.groep_sub1 = "m.groep_sub1",
m.groep_sub1_sub2 = "m.groep_sub1_sub2",
m.primair_steriel = "m.primair_steriel",
m.oudenaam = "m.oudenaam",
`o.*` = "o.*",
o.ordernr = "o.ordernr",
o.ontvangstdatum = "o.ontvangstdatum",
o.ontvangsttijd = "o.ontvangsttijd",
o.ontvangstdatumtijd = "o.ontvangstdatumtijd",
o.afnamedatum = "o.afnamedatum",
o.afnametijd = "o.afnametijd",
o.afnamedatumtijd = "o.afnamedatumtijd",
o.patidnb = "o.patidnb",
o.srtinstelling = "o.srtinstelling",
o.instelling = "o.instelling",
o.extpat_fileid = "o.extpat_fileid",
o.extpatidnb = "o.extpatidnb",
o.aanvrager = "o.aanvrager",
o.behandelaar = "o.behandelaar",
o.is_ic = "o.is_ic",
o.recsitenb = "o.recsitenb",
o.leeftijd = "o.leeftijd",
o.zwanger = "o.zwanger",
o.refext = "o.refext",
o.opmintern = "o.opmintern",
o.klingegevens = "o.klingegevens",
o.opmrapport = "o.opmrapport",
`p.*` = "p.*",
p.patidnb = "p.patidnb",
p.anoniem = "p.anoniem",
p.geslachtsnaam = "p.geslachtsnaam",
p.mansnaam = "p.mansnaam",
p.voornaam = "p.voornaam",
p.voorletters = "p.voorletters",
p.geboortedatum = "p.geboortedatum",
p.geslacht = "p.geslacht",
p.bsn = "p.bsn",
p.postcode = "p.postcode",
p.plaats = "p.plaats",
p.provincie = "p.provincie",
`pat.*` = "pat.*",
pat.patidnb = "pat.patidnb",
pat.patid = "pat.patid",
pat.patnaam = "pat.patnaam",
pat.patgeboortedatum = "pat.patgeboortedatum",
pat.patgeslacht = "pat.patgeslacht",
`r.*` = "r.*",
r.ordernr = "r.ordernr",
r.mtrlcode = "r.mtrlcode",
r.matgroep = "r.matgroep",
r.anamc = "r.anamc",
r.resteller = "r.resteller",
r.stamteller = "r.stamteller",
r.rescode = "r.rescode",
r.rescom = "r.rescom",
r.restekst = "r.restekst",
r.res_st = "r.res_st",
r.edtfmtnb = "r.edtfmtnb",
r.tar_ind = "r.tar_ind",
r.raw = "r.raw",
r.rawres = "r.rawres",
r.auto = "r.auto",
r.autocom = "r.autocom",
r.eesi = "r.eesi",
r.eess = "r.eess",
r.uitvafd = "r.uitvafd",
r.mc_comab = "r.mc_comab",
r.esbl_interpr = "r.esbl_interpr",
r.IsVitekAB = "r.IsVitekAB",
r.div_class = "r.div_class",
r.aerob_typ = "r.aerob_typ",
r.famnb = "r.famnb",
r.genrnb = "r.genrnb",
r.espnb = "r.espnb",
r.sespnb = "r.sespnb",
r.absnb = "r.absnb",
r.mc_tarnb = "r.mc_tarnb",
r.steril_typ = "r.steril_typ",
`t.*` = "t.*",
t.testcode = "t.testcode",
t.testnaam = "t.testnaam",
t.oudegroep = "t.oudegroep",
t.testgroep = "t.testgroep",
t.uitvoerende_afdeling = "t.uitvoerende_afdeling",
t.kweek_type = "t.kweek_type",
t.pcr_type = "t.pcr_type",
t.apparaat = "t.apparaat",
`u.*` = "u.*",
u.ordernr = "u.ordernr",
u.testcode = "u.testcode",
u.mtrlcode = "u.mtrlcode",
u.stam = "u.stam",
u.ordernr_testcode_mtrlcode = "u.ordernr_testcode_mtrlcode",
u.ordernr_testcode_mtrlcode_stam = "u.ordernr_testcode_mtrlcode_stam",
u.uitslag = "u.uitslag",
u.uitslag_tekst = "u.uitslag_tekst",
u.uitslag_int = "u.uitslag_int",
u.groeidichtheid = "u.groeidichtheid",
u.ct_waarde = "u.ct_waarde",
u.uitslag_commentaar = "u.uitslag_commentaar",
u.bacteriecode = "u.bacteriecode",
u.uitvafd = "u.uitvafd",
u.res_status = "u.res_status",
u.is_verricht = "u.is_verricht",
u.is_echte_patient = "u.is_echte_patient")
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.