Nombre | Priority | Structure | Topic | Item | Hints | FoodChain-Lab | Cashmere | TraceAll |
---|---|---|---|---|---|---|---|---|
1 | 0.0 | General questions | ||||||
3 | 1 | 0.2 | General questions | Which features might be interesting for FCL? | Data entry, visualisation, usability | - | "Farm-to-fork traceability | |
4 | 1 | 0.3 | General questions | How many users the tool has? | ? | ? | ? | |
5 | 1 | 0.4 | General questions | How much do you have to pay for the tool? | 0 € | ? | 995$ once (according to capterra.com) | |
6 | 1 | 0.5 | General questions | Is the tool open source, freely available? | Yesdfdf | Not free | No | |
7 | 0.6 | General questions | How do you estimate the useability of the tool? | |||||
8 | 1 | 0.7 | General questions | Platform: Desktop, Web? | Web-based, cloud-based; tablet, phone | Desktop and web | ||
9 | 1 | 0.8 | General questions | How is the installation procedure: effort, security? | ? | ? | ||
10 | PwC_1.0 | PwC - General Information | ||||||
11 | 1 | PwC_1.1 | PwC - General Information | Company name | Cashmere Systems LLC | |||
12 | 1 | PwC_1.2 | PwC - General Information | Company address | "PO BOX 629 | |||
13 | 1 | PwC_1.3 | PwC - General Information | Company webpage | cashmeresystems.com | |||
14 | PwC_1.4 | PwC - General Information | Address of the headquarters of the company | |||||
15 | PwC_1.5 | PwC - General Information | How long has your company been in business? | |||||
16 | PwC_1.6 | PwC - General Information | Name of the food traceability software | Cashmere | ||||
17 | PwC_1.7 | PwC - General Information | Number of years on the market | |||||
18 | PwC_1.8 | PwC - General Information | Number of installations already implemented | |||||
19 | PwC_2.0 | PwC - Other Information | ||||||
20 | PwC_2.1 | PwC - Other Information | Is the software web-based? => 0.7 | |||||
21 | PwC_2.2 | PwC - Other Information | Is the software open source? => 0.5 | |||||
22 | PwC_2.3 | PwC - Other Information | Can the software be integrated with other systems? If yes, please describe the integration functionalities of the software | |||||
23 | 1 | PwC_2.4 | PwC - Other Information | Is the software compliant with EU Regulation (Directive 178/2002)? | FSMA | One step forward and one step backward | ||
24 | 1 | PwC_2.5 | PwC - Other Information | Has this software ever been used by public authorities? If yes, what kind of public authorities were they? | ? | ? | ||
25 | PwC_2.6 | PwC - Other Information | Reference customers using comparable products or services (including contact information) | |||||
26 | 1.0 | Data structure | Tool kann beliebig granlaer erfassen, haengt von Daten im Betrieb an. | |||||
27 | 1.1 | Granularity | Is the system able to handle heterogeneous granularities? Which? How? | |||||
28 | 1.1.1 | Traceable Resource Unit (TRU) | How is the TRU (e.g. package unit) represented in the system? | TRU z.B. Palette -> 3 Pakete auf Palette -> pro Paket x unit, kann FCL nicht | ||||
29 | 2 | 1.1.2 | Spatial | Which spatial resolutions (e.g. processing lines) are supported? | Several production buildings? | raeumlich innerhalb des Betriebes, kann FCL abbilden | All locations are recorded. Example data set contains all locations in one Building. | |
30 | 2 | 1.1.3 | Temporal | Which temporal resolutions (e.g. duration of activities) are supported? | zeitlicher Dauer des Prozesses im Betrieb, kann FCL auf Tagesgenauigkeit = Datum (real), Minuten wird nicht abgefragt | No times | ||
31 | 2 | 1.1.4 | Transformation | Which transformations (e.g. intermediate processing steps) are represented in the system? | Describing an example from the software tested makes understanding easier. | Prozesskette abbilden, macht FoodProcess-Lab, Rezept erfassen, nicht in FCL | Stored recipes describe changes in food composition, food texture and mixing verbally , but there is no split into sub-foods like raw milk -> skim milk + cream. | |
32 | 1.2 | Completeness (tables / variables) | Is the proposed tracing data structure (EFSA 2016) represented in the system? | Completeness EFSA 2016 (DEMOS) Datenstruktur beschrieben | ||||
33 | 1 | 1.2.1 | Food Business Operator | Which characteristics of the FBO are represented in the system? | FBO = Betrieb, in FCL wird erfasst was geliefert wird, keine Unterscheidung in Administration und Processing Plant | Inventory, demand planning | Contains food process chain, items (food, packing material), recipes, products, suppliers, customers, storage | |
34 | 1 | 1.2.2 | Station / Establishment | Which characteristics of the establishment are represented in the system? | Parameter des Betriebs, Basics in FCL (Str, Hausnr, PLZ, Ort, Country, type of Business) | Inventory, demand planning, cost control, CRM, traceability; EDI integration, label printing, scanning integrations | Company name, address, phone, email, website, company-specific prefixes for material, product, recipe, pallet; federal number, license number, province number, location/premise ID | |
35 | 2 | 1.2.3 | Activity / Transformation | Which characteristics of the activity are represented in the system? | Activities in DEMOS Report, e.g. Relabeling, Cooking, Trading etc. Wichtig zu erfassen. In GS1 wird das erfasst, statische und dynamische Daten (tracing, events, activities). In FCL zwei Activities = delivery, delivery2delivery. | |||
36 | 1 | 1.2.4 | Product | Which characteristics of the product are represented in the system? | wie detailiert Produktdaten erfasst werden, FCL siehe Templates | Inventory: Food / beverage name, category, description, weight, expiration date; raw materials, sub-assembly, finished goods | "Food and packing items: Special instructions, shelf life; organic, non-GMO, fair trade, kosher; allergens; supplier, recipes; Std. Cost | |
37 | 1 | 1.2.5 | Lot | Which characteristics of the lot are represented in the system? | Lot: wie 1.2.4, siehe Template | ? | Lot no, product name, date, batch | |
38 | 3 | 1.2.6 | Logistic unit | Which characteristics of the logistic unit are represented in the system? | Logistic Unit TRU ?, nicht in FCL | |||
39 | 3 | 1.2.7 | Traceable Resource Unit - Status | How is the TRU status represented in the system? | TRU Status, nicht in FCL | |||
40 | 2 | 1.2.8 | Register | Which characteristics of relevant registers are represented in the system? | Register?, vielleicht Kataloge, Ontologie? | |||
41 | 1.2.9 | Information Source | Which characteristics of the information source (e.g. time of data collection) are represented in the system? | Information Source, welche Metadaten gibt es, Belege, mit denen nachvollzogen werden kann, welche Quellenangaben, in FCL moeglich | ||||
42 | 1 | 1.2.10 | Sampling Result | Which characteristics of the sampling results are represented in the system? | Sampling Result: Probenname und Ergebnisse, in FCL nicht moeglich | ? | No sampling results recorded | |
43 | 1.3 | Handling of missing values | How is missing information handled? | |||||
44 | 1 | 1.3.1 | Surrogate entries | Does the system allow the use of surrogate information for missing entries? | "surrogate entries, fehlende Daten, erkennt das System missing values? | |||
45 | 1 | 1.3.2 | Vague information | Does the system allow the use of vague information / probabilistic tracing? | nur Erfassungstool oder macht es auch Tracing, wenn dann mit probabilistischen Methoden? FCl: Score ist deterministisch, nichts probabilistisches | ? | Nothing probabilistic | |
46 | 1.4 | Correctness | Which quality control instruments are implemented? | |||||
47 | 1 | 1.4.1 | Catalogues | For which data elements are catalogues provided? | Catalogues: e.g. controlled vocabularies, nicht in FCL | ? | Received goods, inventory, order, items, suppliers, recipes, products, packing plans, customers, units of measurement, reasons for not using ingredients | |
48 | 1 | 1.4.2 | Consistency | How is the internal validity checked? | How is data kept clean? Are there plausibility checks? Mandatory fields? Software documentation is helpful to answer this question. | Plausibilitaetstests, in FCL | ? | "Inspection of received goods: Date, truck door seal, odor, harmful material?, intact load, refrigeration, trailer temperature; accepted/rejected |
49 | 2 | 1.5 | Integration in Logistic Systems | Is the tracing system part of a logistic system? Which additional features exist there? | Transport? innerhalb des Betriebs oder Outsourcing? FCL kann das nicht | |||
50 | 2 | 1.6 | Integration in Enterprise Resource Systems | Is the tracing system part of an ERP system? Which additional features exist there? | eingebunden in ERP? | |||
51 | 1.7 | Data entry | How is the ease of data input / software ergonomics? | Data entry: wie gut koennen Daten erfasst werden | ||||
52 | 1 | 1.7.1 | Guided data input | What are the helping functions for data entry? | e.g. wizzard, nicht in FCL, gut in webapp | Seems as if there are drop-down menus | Catalogues, drop-down menus | |
53 | 1 | 1.7.2 | Stepwise data collection / backward, forward | Does the system support data collection strategies (e.g. backward / forward tracing)? | Import and export of data, especially products, lots, recipes, deliveries | in FCL moeglich | With our tracing reporting tool you can trace starting with a final product down to the purchase orders, and from the purchased item to all of the finished products, work orders, and inventory items. | "Export of trace back / forward is possible in the report section (PDF, Word or Excel). |
54 | 1 | 1.7.3 | Specific for Critical Traceability Points | Is the system adapted to CTE? [Critical Tracking Event: Points where product is moved between premises or is transformed, or is determined to be a point where data capture is] Which food chains are covered? | tool spezifisch fuer bestimmte food chains (Zielgruppen), FCL ist allgemein | ? | Inventory\Cycle count: Location in the company with container IDs | |
55 | 1 | 1.7.4 | Required key data elements | Does the system distinguishes mandatory, recommended, and voluntary information? | Pflichtfelder, recommended etc. teilweise in FCL, sollte hier transparenter und konsistenter sein | ? | Mandatory for new items: Name, shelf life | |
56 | 2.0 | Analytical functions | ||||||
57 | 2.1 | Reconstruction of the food supply chain | How is the total food chain represented in the system? | Reconstruktion der Warenkette | ||||
58 | 1 | 2.1.1 | Data cleaning & consistency | Which data cleaning procedures are implemented? | in FCL: filtern von Doppeleintraegen, wie Datenqualitaet aufrecht erhalten wird | ? | - | |
59 | 1 | 2.1.2 | Evaluation of connections / scoring | How are the connections and complexity (e.g. hot spots) of the food supply chain analysed? | Are data from supplier and outgoing products connected in the system? | in FCL: Scoring | User alerts for low stock, expiration dates, sales orders that need purchases | Supplier, ingredients, product, customer: All can be viewed in a report. If the production of a product is planned because of a customer's order, ingredients in stock and BBD are shown. |
60 | 2 | 2.1.3 | Evaluation of the timing | How is the timing of the material flow analysed? | zeitlicher Materialfluss, e.g. erst rein dann raus, nicht umgekehrt, lange Lagerung; in FCL besser in Webapp, Slider zum zeitlichen Anzeigen des Netzwerkes | |||
61 | 2 | 2.1.4 | Evaluation of the material flow / weight balance | How is the physical material flow (e.g. weight balance) analysed? | Entwicklung von Warengewicht wird beruecksichtigt, moeglich in FCL | |||
62 | 2 | 2.1.5 | Evaluation of contamination | How is the development (e.g. pathogen growth) of the contamination analysed? | Contamination, moeglich in FCL (deterministisch) | |||
63 | 2 | 2.2 | Geographical (GIS) representation | Which GIS features are implemented? | GIS: in FCL | |||
64 | 2 | 2.3 | Probabilistic simulation of the material flow | Does the system allow a probabilistic analysis of the contamination (e.g. likelihood of contamination)? | nicht in FCL, Wahrscheinlichkeit, dass Kontamination stattfindet | |||
65 | 2.4 | Case-control analysis / epidemiological evidence | Does the system support case-control analysis (e.g. likelihood of cases)? | nicht in FCL, wird hier im RKI gemacht | ||||
66 | 2 | 2.5 | Summary / simplifications / reduction | Which strategies to reduce the food supply chain to relevant parts (e.g. CTE) are used? | in FCL z.B. Metaknoten, wird verbessert | |||
67 | PwC_3.0 | Traceability functionalities | ||||||
68 | PwC_3.1 | Traceability functionalities | Does the software support backward and forward traceability? If yes, please provide a brief description of the traceability functionalities of the software. | |||||
69 | PwC_3.2 | Traceability functionalities | Is backward and forward traceability conducted all along the supply chain (from raw material to finish product)? If yes, please provide a brief description. | |||||
70 | PwC_3.3 | Traceability functionalities | Is traceability envisaged also in the intermediary steps of the food and feed supply chain (e.g. storage, logistic)? | |||||
71 | PwC_3.4 | Traceability functionalities | Please give us an overview of your workflow capabilities including the ability to create user-defined workflows. | |||||
72 | PwC_4.0 | Analytic functionalities | ||||||
73 | PwC_4.1 | Analytic functionalities | Please describe your reporting and business intelligence capabilities including both third-party and proprietary tool options. | |||||
74 | PwC_4.2 | Analytic functionalities | Does the analysis include also data visualization? If yes, what kind of envisaged? Please, attach a screenshot of the data visualization if available. | |||||
75 | PwC_4.3 | Analytic functionalities | Is it possible to personalize the reports produced? If yes, please provide a description. | |||||
76 | PwC_5.0 | Communication functionalities | ||||||
77 | 1 | PwC_5.1 | Communication functionalities | Is communication between stakeholders of the entire food and feed supply chain, esp. suppliers and clients, possible within the system? If yes, please provide some information. | ? | Address, phone number and email address of suppliers and customers are stored. | ||
78 | PwC_5.2 | Communication functionalities | How can stakeholders upload data / provide access to data concerning the food and feed supply chain? Are interfaces and data structures standard within the system? If yes, please provide some information. | |||||
79 | PwC_5.3 | Communication functionalities | Please provide a brief description of the data structure concerning the food and feed supply chain | |||||
80 | PwC_5.4 | Communication functionalities | How is the granularity of the traceability included in the data structure of the system? Please provide a brief description. | |||||
81 | 3.0 | Interfaces | ||||||
82 | 3.1 | Use of data catalogues | Which data standards are supported? | "e.g GS1, Datenformate, Exportieren, Importieren, wie werden fehlende Infos behandelt? | ||||
83 | 2 | 3.1.1 | Internal standards | Which internal standards are defined? | ||||
84 | 2 | 3.1.2 | External standards | Which external standards can be used? | ||||
85 | 2 | 3.1.3 | Data enrichment | Are there data enrichment strategies used? | ||||
86 | 3.2 | User management | How is the user management implemented? | Organisation der Sensibilitaet der Daten (user, Betriebe), in FCL zentrale Verwaltung aller Daten | ||||
87 | 1 | 3.2.1 | Interactions with the whole food chain | Which data management strategies (e.g. push, pull, central, decentral) are used? | Central: All data is stored in one database. Decentral: Local data storage, data is merged. Push? | Seems to be central | Central data management | |
88 | 1 | 3.2.2 | Data ownership | How are the data ownership defined? How are data corrections done? | ? | Roles with access and editing rights are defined. | ||
89 | 1 | 3.2.3 | On-time analysis | Allows the system on-time analysis? | Can tracin be done as soon as data is checked? Automatic score calculations? Contrast: Data is in dossiers on paper and needs to be collected from different folders -> needs much more time. | in FCL: sofortige implizite Berechnung des Scores | ? | All available for tracing back and forward; report possible at any time; contains no analysis / tracing module |
90 | 3.3 | Graphical interfaces | Which graphical interfaces are used? | in FCL: GraphView, Map View, Interaktivitaet der Views, Views sind synchronisiert | ||||
91 | 1 | 3.3.1 | Flow diagrams | How is the food chain shown on the graphical interface? | No graphs shown in screenshots on webpage | No graphs, just tables | ||
92 | 1 | 3.3.2 | Maps | How is the physical material flow shown on the graphical interface (e.g. by maps)? | Tables | Tables | ||
93 | 3.4 | Reports | Which reports are supported? | "in FCL: Tabelle und Graphik, Export als Image, Excel | ||||
94 | 2 | 3.4.1 | Different requests / audience | For which requests are specific reports available? | ||||
95 | 2 | 3.4.2 | Interactive | How could the reporting be customized? | ||||
96 | 2 | 3.5 | Connectivity | Which connectivity (e.g. web, file transfer) is supported? | Datenaustauschformate in FCL: XML mit NRW, JSON, Knime Workflow | |||
97 | 3.6 | Support of external devices | Which external devices (e.g. tablets) are supported? | Datenerfassung und Handling mit verschiedenen Devices (PC, Tablet, Handy etc.) |