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 |