R/envvars.R

# ==================================================================== #
# 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")
msberends/certedata documentation built on Nov. 26, 2019, 5:19 a.m.