Tabel

Pesticid_DK_2004_2020


Beskrivelse ?

Data fra Fødevarestyrelsens kontrolanalyser for pesticider i fødevarer 2004-2020. Filens struktur er en delmængde af EFSA's datamodel SSD2 til og med variablen evalInfo_com. Den resterende del af filen indeholder variable, der er brugt af DTU Fødevareinstituttet til fx rapportering (proginfo_EUCP er dog også en del af SSD2). Variable fra og med progLegalRef_NAME indeholder oversættelser af SSD2-koder.

Størrelse (Antal rækker) ?

8660051

Indhold (Kolonner/variable) ?

Navn Indhold
resId Identification code of an analytical result (a row of the data table) in the transmitted file. The result identification code must be maintained at organisation level and it will be used in further updated/deletion operation from the senders.
localOrgId Unique identification of the local or regional or national organisation (Competent Authority or company affiliate) requesting the analysis.
localOrgCountry Country where the local organisation is placed. (ISO 3166-1-alpha-2).
progId Unique identification code of the programme or project for which the sampling unit was taken.
progLegalRef Reference to the legislation for the programme defined by programme code. Reference to the legislation on what to sample, how to evaluate the sample etc.
sampStrategy Sampling strategy describe how the sample was selected (ref. EUROSTAT - Typology of sampling strategy performed in the programme or project identified by programme code (e.g. objective and selective sampling)).
progType Indicate the type of programme for which the samples have been collected (National, EU programme, Total diet study, Control and eradication programme).
sampMethod Reference to the method for sampling (e.g. EU legislation).
sampler Define which organisation (private or public) is performing the sample.
sampPoint Point, in the food chain, where the sample was taken. (See Doc. ESTAT/F5/ES/155 “Data dictionary of activities of the establishments”).
sampEventId Unique identification of the sampling event. The entity representing the sampling unit extracted at certain time from the sampled population, whose chemical or microbiological properties are the target of the sampling.
sampUnitType Define the type of sampling unit taken in this event: a batch, an animal, a flock, a herd, etc.
sampId Identification code of the sample taken.
repCountry The country the reported data refer to (ISO 3166-1-alpha-2).
sampCountry Country where the sample was taken for laboratory testing (ISO 3166-1-alpha-2).
repYear The year the reported data refer to.
sampY Year of sampling. In case the sampling has been performed over a period of time the start date (as year) of sampling should be reported.
sampM Month of sampling. In case the sampling has been performed over a period of time the start date (as month) of sampling should be reported.
sampD Day of sampling. In case the sampling has been performed over a period of time the start date (as day) of sampling should be reported.
sampMatType Type of sample taken (food/feed/animal..)
sampMatCode Description of the sample taken characteristics using the FoodEx2 catalogue.
sampMatCode_packmat Packaging-material
sampMatText Description of the sample taken characteristics using free text.
origCountry Country of origin of the sample taken (ISO 3166-1-alpha-2 country code).
sampMatInfo_prodY Year of production
sampMatInfo_prodM Month of production
sampMatInfo_prodD Day of production
sampMatInfo_expiryY Year of expiry
sampMatInfo_expiryM Month of expiry
sampMatInfo_expiryD Day of expiry
analysisY Year when the analysis was completed.
analysisM Month when the analysis was completed.
analysisD Day when the analysis was completed.
labId Identification code of the laboratory (National laboratory code if available). This code should be nationally unique and consistent through all data domain transmissions.
labAccred The accreditation status of the laboratory and its reference procedure.
labCountry Country where the laboratory is located (ISO 3166-1-alpha-2).
paramType Define if the parameter reported is an individual residue/ analyte, a summed residue definition or part of a summed residue definition.
paramCode Encoding of the parameter/ analyte according to the PARAM catalogue.
paramText Description of the parameter/ analyte using free text.
anMethRefId Identifier for the method used in the laboratory.
anMethRefCode When validated methods are used, the official reference code should be provided.
anMethType Type of analytical method used.
anMethCode Encoding of the method or instrument used from the ANLYMD catalogue.
anMethText Description of the method or instrument using free text, particularly if ‘other’ was reported for ‘Analytical method code’.
accredProc The accreditation status of the analytical method used and its reference procedure.
resUnit Unit of measurement for the values reported in resOD, resLOQ, resVal, resValUncert, evalLowLimit.
resLOD Limit of detection expressed in the unit specified by the element ‘Result unit’.
resLOQ Limit of quantification expressed in the unit specified by the element ‘Result unit’.
resVal The result of the analytical measure expressed in the unit specified by the element ‘Result unit’.
exprResPerc_fatPerc Fedtprocent (målt eller tildelt via tabelopslag)
exprResType Code to describe how the result has been expressed: whole weight, fat weight, dry weight, etc.
resQualValue This field should be completed only if the result value is qualitative e.g. positive/ present or negative/ absent. In this case the element ‘Result value’ should be left blank.
resType Indicate the type of result, whether it could be quantified/determined or not.
resValUncert Indicate the expanded uncertainty value (usually 95% confidence interval) associated with the measurement expressed in the unit reported in the field ‘Result unit’.
resInfo_com Additional specific information and comments on the result section depending on specific requirements of the different data collection domains.
evalLowLimit Report the reference or legal limit, limit or cut-off value for the parameter/analyte for the relevant matrix or the lower level of three-class evaluation limit analyte. It is expressed in the unit specified by the element “Result unit”.
evalLimitType Type of legal limit used to evaluate the result. ML, MRPL, MRL, action limit, cut-off value etc.
evalCode Evaluation of the result. If the result exceeds a limit specified above or contains the evaluation on Sampling Event, Sample Taken, or Sample Analysed as indicated by evalLowLimit (N.01).
actTakenCode Describe any follow-up actions taken as a result higher than the legal limit.
evalInfo_sampTkAsses SampleTaken assessment
evalInfo_resAsses Result assessment
evalInfo_conclusion Conclusion of follow-up investigation
evalInfo_com Additional specific information and comments on the evaluation section depending on specific requirements of the different data collection domains.
Projekt_Titel Fødevarestyrelsens projekttitel, (projektnummer fremgår af progId)
Produkt_ID Fødevarestyrelsens produktidentifikation, oversættes til FoodEx2vare_Name
FoodEx2vare_Name Oversættelse af FoodEx2 kode
UKvareOKO Fødevarenavn der anvendes i DTU rapporter, engelsk oversættelse
DKvareOKO Fødevarenavn der anvendes i DTU rapporter
KombiVare LIMS vareart (Produktbeskrivelse|Behandling1|Behandling2|Behandling3)
prodCode Produkt kode jvf MATRIX-katalog
OKO Information om økologi
DKland Landenavn der anvendes i DTU rapporter
UKland Landenavn der anvendes i DTU rapporter, engelsk oversættelse
Eustatus Eustatus (oprindelsesland i EU/oprindelsesland ikke i EU)
Parameter_ID Fødevarestyrelsens stofnavn
DKstof Stofnavn, brugt i DTU-rapporter
Referencemetode_Officiel Officiel referencemetode anvendt i analysemetoden
proginfo_EUCP Angiver, om prøven er en del af Eu's koordineret pesticidkontrol
Dato_Oracle Indsættes ved modtagelse fra Fødevarestyrelsens laboratoriedatasysytem
progLegalRef_NAME Tekst til progLegalRef
sampStrategy_NAME Tekst til sampStrategy
progType_NAME Tekst til progType
sampMethod_NAME Tekst til sampMethod
sampler_NAME Tekst til sampler
sampPoint_NAME Tekst til sampPoint
sampUnitType_NAME Tekst til sampUnitType
sampMatType_NAME Tekst til sampMatType
labAccred_NAME Tekst til labAccred
paramType_NAME Tekst til paramType
paramCode_NAME Tekst til paramCode
anMethRefCode_NAME Tekst til anMethRefCode
anMethType_NAME Tekst til anMethType
anMethCode_NAME Tekst til anMethCode
accredProc_NAME Tekst til accredProc
exprResType_NAME Tekst til exprResType
resType_NAME Tekst til resType
evalLimitType_NAME Tekst til evalLimitType
evalCode_NAME Tekst til evalCode
actTakenCode_NAME Tekst til actTakenCode
evalInfo_sampTkAsses_NAME Tekst til evalInfo_sampTkAsses
evalInfo_resAsses_NAME Tekst til evalInfo_resAsses
Produkt_ID_NAME Tekst til Produkt_ID
prodCode_NAME Tekst til prodCode
proginfo_EUCP_Name Tekst til proginfo_EUCP