FSA MEAT TEST RESULTS DATABASE DRAFT USER MANUAL
Contents
1. FOOD STANDARDS 3 Ge ae AGENCY FSA Meat Test Results Database FSA MEAT TEST RESULTS DATABASE DRAFT USER MANUAL 12 01 2006 Version 1 3 TTPOGUCTION coe tense sce cme eee nse ee oe onc ee cceccouecceceneccsaee EE 2 OTs Be ko CL seen eee ee ee ee ee 2 FAOW WO NOUN oro c ue deen teed E E E E E P E E E E acre asonseos 3 Problems with logging OM u ccccccccccsesssesessssssesesesessesesescssssesesssssscsesessssssesesesssseseseseeseseseseseeseaeseseeseaeees 4 The plant summary home page go5cc02c ocssccnacasvanescsasescueestoasarensesnteenssenmessasavex os 5 The man TEIN 3 fone ec caches cg ne cece cde ne ee ba ces ce bau ee nee ceaennaeceacn ue aneanceeenenens 5 Analyses method data entry cc ccc ccc cece cece cee e ene e eee nee e eee eeeeeeeeeeeeeeees 6 To save your preferences socio cep esse ce aeesec eee eee eeee a snneeeeencncnauis 6 Carcas data ENY ossererrsrts tss Ts INsiE rT IEEsE EEEE SEENE ESSEEN EIEEE te EEEE EREE TEREN 7 Problems with carcase data Cntry u ccccccccccscssssssssessssessssssssesssessssssssesssesssessseseesesesesesessesesesesseseees 8 Surface data CMY ss cc 55 ceca soba cace unt ER ERE EEEE 9 Problems with surface data Cnt ry u cccccccccssssessssssssesssssesssssessssssesesesessssssesessesesesesessesesssesesseseees 10 Salmonella data CNY cons cteas cece tots crnoeueseesacncaenssencadesaeacacs ceouekasenaeniaseeancnes 11 Problems with Salmonella data entry ccccccccccccssssssssssssssss2. RRR ne Saas CEOS SSSA LRR SANSE RRS OSS ANG se ETS SORA Wey RASA SESS SSATLSS PO AVA Time date As you can see the graph shows the TVC trends on carcasses for the plant that is logged in A similar graph for Enterobacteriaceae is also generated below the TVC graph You can see the Enterobacteriaceae graph by scrolling down the screen Favorites Tools Help Ow O DB O Pawn ferme O B X Address http www redmeatdata co uk geotrendcarcases aspx Geometric Mean Enterobacteriaceae Trend for Plant Licence 24680 Mean Log Enterobacteriaceae Log CFU cm2 SESS PS SLES FS SP PS PP PS HP SP SP FP Ph gh S Or FPP Pe oe S Soyer ses KR K FSG Pe SESSI RAA A Ga Y A Time date 14 The information that is displayed on the trend graphs is controlled by the three drop down boxes at the top of the screen You change where the You change where the You change what species graphs begins from by graphs ends making a is shown if your plant making a selection from selection from here processes more than one here carcass type from here om 17 06 2002 Sand tE 15 03 2004 Bnd for spes Al Update Graphs Go to the summary screen After you have made any changes clicking the update graphs button will refresh the graphs to show what has been selected To return to the Carcase Trend Charts page click the Go to summary screen button 15 Ten week rolling Salmonella repor
3. button will return you to the National Comparison Charts page 20 Producing reports of everyone s results Carcasses The carcasses reports relate to both TVC and Enterobacteriaceae because all plants have to test for these As a rule the reports in this section all show two graphs one for each bacterial group The TVC graphs are always drawn above the Enterobacteriaceae You may have to scroll down the screen to see the Enterobacteriaceae graph National Carcase Percentile Summaries The first report in the list shows you a percentile based summary of the national carcase testing results Click on the National Carcase Percentile Summaries link to view this report E http www redmeatdata co uk CarcasePercentiles aspx Microsoft Internet Explorer Bax File Edit View Favorites Tools Help Bak x a A pa Search Jr Favorites 4 62 i amp Ky na Go i Links Address http www redmeatdata co uk CarcasePercentiles aspx Plant Licence Number 24680 Report generated 14 03 2005 11 51 11 Go to the summary screen Percentile carcase TVC UK National Dataset Log Total Viable Count CFU cm2 0 25 03 0 35 04 045 05 055 06G O88 OF 075 08 085 OFF O95 1 Percentile 4 100 A report is shown that will be similar to the one shown above This is a static report you can t change the information that is displayed Remember that you can scroll down to see the E
4. on the go to summary screen button will return you to the National Comparison Charts page 22 Plant carcass percentile comparisons with national data set This report is similar National Carcase Percentile Summaries report except that it is interactive and allows you to compare your plant s results with those from the nationally derived dataset Three groups of data can be shown at any one time Clicking on the drop down boxes allows you to choose The year and also the carcase species that are reported for each of the graphs Go to the summary screen Trend graph 3 is nationally derivedfrom using Cattle f carcases Update Graphs Percentile based comparisons for TVC and Plant Licence 24680 ee Plant 24680 Year2002 Species Pig Plant 24680 Year2004 Species Sheep National data Year 2002 Specles Cattle P Total Viable Count CFU cm2 in The chart legend shows what the different coloured lines correspond to As before the corresponding Enterobacteriaceae chart is drawn below the TVC chart Clicking on the go to summary screen button will return you to the National Comparison Charts page 23 Plant carcass pass fail comparisons with national pass fails This report shows the percentage of acceptable marginal and unacceptable carcasses from your plant as a comparison with the national dataset The report takes the form of a colour coded bar graph similar to
5. swab Not Detected 05 01 2006 Bloggs32126 WV6 8HF Pig Sponge swab Detected 05 01 2006 Bloggs32125 WV6 SHF Pig Sponge swab Not Detected 05 01 2006 Bloggs32124 WV6 SHF Pig Sponge swab Not Detected 05 01 2006 Bloggs32123 WV6 8HF Pig Sponge swab Not Detected sa Done Internet Salmonella test results for red meat carcasses poultry i e chicken and turkey only carcasses ground meat mechanically separated meats and meat products can be entered by clicking on the Salmonella Data Entry option on the main menu For each result that you have fill in each box with your data Helpful information for each box is shown below e Date taken should be entered in the following format dd mm yyyy e Unique identifier A description chosen by the plant that allows the sample to be uniquely identified Most plants would probably use the carcass kill number but anything that is unique and can be used by the plant to identify the carcass is appropriate to use here e Postcode The postcode can be left blank if the Salmonella detection was negative For positive samples the postcode of the source farm whenever possible should be entered here For some sample types e g ground meat the source farm postcode may not be available and the plant postcode should be entered here e The sample source can be selected from the drop down menu e The sample form is the type of sample that was sent for testing to the lab The database ch
6. with national pass fails National mean Salmonella percentage detections NEVV What are percentiles As you can see from the screenshot above there are 8 reports available and they are divided into reports for surfaces and reports for carcasses Before you have a look at any of these reports you may find it worthwhile to refresh your memory about percentiles There is an easy to follow description of what a percentile is available by clicking the button marked What are percentiles circled in red in the diagram above 17 Producing reports of everyone s results Surfaces The surfaces reports all relate only to TVC Enterobacteriaceae have not been included because these are optional and most UK plants do not test for these The first report in the list is a comparison of the plant surface TVC results against the national results To view this report please click on the link at the top of the list marked Plant surface TVC percentile comparisons with national dataset A report is shown that will be similar to the one shown below The blue line and circles which represents the plant s results is above the red line and stars which are the results from all the plants in the country and thus the microbiological numbers reported by the example plant are higher than those reported by the rest of the plants in the country Clicking on the go to summary screen button will return you to the National Comparison Chart
7. you can end your session by returning to the plant summary home page Food Standards Agency Red Meat HACCP Verification Results Microsoft Internet Explorer aax File Edit View Favorites Tools Help O x O FAG Address E http www redmeatdata co FOOD STANDARDS z AGENCY l FSA Red Meat HACCP Database _ gt are logged in as Example Plant Carcases Data Entry fj search Pg Favorites O 2 ee a A x E co Links gt gt Lill rf Surfaces Data Entry Summary overview of your data Carcase Trend Charts You have no cattle results incorporated into the national dataset National Comparison Charts For sheep carcases your dataset runs from 27 06 2002 to 25 02 2004 The total number of your sheep carcases incorporated into the national dataset is 134 Analyses Method Data Entry For pig carcases your dataset runs from 21 06 2002 to 17 03 2004 The total number of your pig carcases incorporated into the national dataset is 284 You have a dataset of 366 for environmental surfaces This dataset runs from 27 06 2002 to 27 04 2004 You have 0 carcase results and 0 surface results pending that will be incorporated into the national dataset during the next update Summary overview of national data There are 11152 cattle 9557 sheep and 7012 pig carcase results in the a national dataset These carcase results have been collected from 77 plants M Done Trusted sit
8. 2005 24 03 2005 14 03 2005 07 03 2005 28 02 2005 24 02 2005 14 02 2005 O7 02 2005 S71 01 2005 24 01 2005 17 01 2005 10 week sum ending 0 1 2 4 5 6 7 8 9 Sum of scaled detections for Saimonella 16 Producing reports of everyone s results The second group of reports relate to national trends in all red meat plants To access these reports click on the button marked National comparison charts on the main menu gt FOOD z STANDARDS AGENCY FSA Meat Test Results Database Home The national comparison charts wh are available from this screen are composed of data collated from all of the plgg S that submit their results to this site However some of Carcases Data Entry the weekly reports show dg for very recent weeks which has been collected from relatively small numbers of planya For this reason weekly reports with dates within the last 2 Surfaces Data Entry months should be jfferpreted cautiously meq fEports are currently available for surfaces Natfpnal Comparison Charts Pfant surface TVC percentile comparisons with national dataset National surface hygiene bandings shown by week Lill Plant surface pass fail comparisons with national pass fails These reports are currently available for carcases National carcase percentile summaries National carcase hygiene bandings shown by week Plant carcase percentile comparisons with national dataset Plant carcase pass fail comparisons
9. amiliarise themselves with the trend analyses systems that are available Feedback about this site both positive and negative is welcomed The demonstration plant data can be accessed using the username 24680 and the password mat su This site requires that your browser is configured to accept session cookies in order to function properly Username Password d Your computer or proxy details will be logged as 88 111 238 118 in the event of any unsucessful login attempt to this site jea Error on page Internet Towards the bottom of the screen are username and password boxes Click on the username box and enter your MHS plant licence number Click on password box and enter your password then click on Submit button Username Password oubmit Using individual plant usernames and passwords are essential for secure access to the site and your data Problems with logging on e The password are case sensitive so ensure that the Caps Lock button on your keyboard is not pressed some keyboards have a little light in the top right hand side that lights up when the Caps Lock is on e The letters o or O can sometimes look similar to the number O zero e Similarly the number 1 can sometime look the same as the letter e Inorder to use the site you need to have your PC set so that it allows session cookies e If you experience problems logging in please conta
10. bic counts or total colony counts e Up to 2006 Enterobacteriaceae are not compulsory on surfaces and if you do not test for Enterobacteriaceae on your surfaces type 0 zero into the appropriate box when entering your results e From Jan 1 2006 environmental surface testing is optional e For any results that are not detectable and reported as lt 10 CFU cm you should use half of the limit of detection when entering these results e g if lt 10 then half 10 to give 5 lt 1 gives 0 5 etc e The website won t allow you to enter values such as lt 10 e If you experience difficulties using the site please send an email to Lesley mappin pwhutchison co uk e If you stay logged into the site longer than 20 minutes without doing anything you will automatically be logged out How to login All usernames and passwords are available by following instructions detailed on the front page of the website alternatively you can use the demonstration plant login details also found on the front page of the website to familiarise yourself with the operation of the site If you use the example plant login details however you will not be able to access some menu options such as entry of plant results Start Internet Explorer or any other web browser and type the web address for the database http www ukmeat org into the address box If you typed the address correctly and have a connection to the internet the FSA on line HACCP database
11. ct Lesley Mappin pwhutchison co uk The plant summary home page If you a successfully logged in you will be shown the main home page for the site The screen will look similar to the picture shown below except your plant details and your plant s results summary will be shown File Edit View Favorites Tools Help ay Qa O MAGD Px ferme O 8 2 a TA Address http www redmeatdata co uk 4598 aspx iv d GO Links Norton AntiVirus A z 3 STANDARDS l AGENCY FSA Meat Test Results Database p ty Home P You are logged in as Example Plant Carcases Data Entry Surfaces Data Entry i p Summary overview of your data Carcase Trend Charts for cattle carcases your dataset runs from 07 11 2004 to 30 07 2005 The National Comparison Charts ptal number of your cattle carcases incorporated into the national dataset is Analyses Method Data Entry r or sheep carcases your dataset runs from 27 06 2002 to 25 02 2004 The p total number of your sheep carcases incorporated into the national dataset is 134 For pig carcases your dataset runs from 21 06 2002 to 17 03 2004 The total number of your pig carcases incorporated into the national dataset is 284 Your Salmonella dataset runs from 02 01 2004 to 28 07 2005 and contains 3086 results YoMave a dataset of 366 for environmental surfaces This dataset runs from 27 06 28Q2 to 27 04 2004 You have 0 carSase results and 0 surface results pending that will be i
12. ecks that sensible choices for sample source and sample form are selected 11 e The test result detected or not detected should be selected from the drop down menu When you have entered your data click on the Submit entered data button If everything has been entered correctly our data will be transferred into the grid towards the bottom of the screen If there are any problems with what has been entered a small message in red will appear next to the appropriate text entry box and give you an indication of the problem To make data entry easier the textboxes will remember what you typed into them e g the date box will remember the date because its likely that you took more than one sample per date Problems with Salmonella data entry e If some of the boxes are left blank a small red message will appear next to the box after you click the submit button The message will explain the problem and ask you to enter appropriate data e The postcode is only required if a positive detection is made e The postcode should be in upper case letters with a space in the middle e If a mistake is made click on correct here link You will be redirected to a screen that looks similar to the one shown below Delete the whole entry by clicking on the delete button DateTaken Delete 05 01 2006 Delete 05 01 2006 Delete 05 01 2006 Delete 05 01 2006 Delete 05 01 2006 Back to data entry Description B
13. ed a lot of data the grid above will present your results as a series of pages You can click the numbers in the lower right hand side of the grid to move backwards through your data if it has been spread across different pages Surface data entry second from the top of the main menu Home Date Taken 23027 fageidescription Please fill this box in Area swabbed fo em Surfaces Data Entry Carcase Trend Charts National Comparison Charts T C result CF Uem Analyses Method Data Entry l Enterobacteracese result CFUem use O if you dont test for enteros submit entered data You can correct errors by clicking here Date Description Area Swabbed TYC CFU cm 2 Enteros CFU cm 25 02 2005 Gut pan 50 54 B 2 02 2005 Sheep saw 50 2a 5 2 02 2005 Hock cutter 20 120 10 Please note that from the 1 January 2006 microbiological testing of surfaces is no longer a statutory requirement If your plant still tests surfaces by microbiological testing you can enter your test results by clicking on the Surfaces Data Entry menu item For each result that you have fill in each box by clicking on it and entering your data Helpful information for each box is shown below e Date taken this has to be entered in the following format dd mm yyyy e Surface description enter where sample was taken from e g saw blade e Area swabbed enter value in cm e TVC values can be entered but must be in CFU cmm e En
14. enter your results unless you have first provided your preferences and saved them See the previous section of this booklet for details of how to do this The screen that is shown above is for a plant that samples by pooled swabbing If you sample by excision or take individual samples from a single carcass the screen may look slightly different If boxes are left blank a small red message will appear next to the box after you click the submit button The message will explain the problem and ask you to enter appropriate data The microbiological results that you enter can be re calculated into a standard format If the values that appear in the grid are different to those you entered this is the most likely reason It probably means you take individual samples and or you sample using the excision method If a mistake is made click on correct here link You will be redirected to a screen that looks similar to the one shown below Since calculations can be made to the results you enter the site has been designed so that can t change single values within each row You should delete the entire row by clicking on its delete button and then re enter your result correctly DateTaken Species T C cm Entero cm Delete 23 02 2005 Cattle a0 la Delete 2402 2005 Cattle 0 5 0 5 Delete 2o 02 2005 Cattle 45 Delete 2of02 2005 Cattle 2 0 5 Delete 230A 00s Cattle 10 Cy Back to data entry Data paging If you have enter
15. es Scroll to the bottom of the page and logout by clicking on the logout here button This will end your secure session with the database Comments and suggestions If you have any general comments niggles about how the database operates or would like to see additional reports added you can let the project team know about it by sending them an email from within the site There is a button towards the bottom of the plant summary home page which allows you send to your message 25
16. esesesessseseseseeees 25 Comments and suggestions cc cece cece cece cece eee ete ene e ence en eeeeeeeseeneeeees 25 Introduction The FSA sponsored meat test results database is a web based facility for meat plant operators in the UK The site provides a way for plant operators to enter their meat and environmental surface microbiology testing results The primary function of the site is to allow the collection of data for research purposes All data that is entered is completely confidential The researchers that manage the site are interested in determining the effect of the 2002 and 2006 HACCP regulations on the microbiology of UK meat plants For those plant operators that participate in the research project summaries of data are made available which show national and individual plant hygiene trends using a variety of analyses methods The website address is www ukmeat org Using the web site Before you start using the database to enter your plant data you should make sure that you read the list of considerations given below e Ensure you have your password and username to hand e Ensure you have data for carcases and or surfaces e All data should be entered in CFU cm colony forming units per square centimetre e If other units are used please convert to CFU cm before entering results onto the database e In this manual and on the web site TVC are used to denote total viable counts also known as total aero
17. from each carcass the data entry screen you use will be different from plants which send 4 individual samples from each carcase To save your preferences You need to first of all provide the answers to three questions namely 1 Carcass sampling method click on the grey arrow to reveal the drop down menu box and click on the method your plant uses to collect carcase samples i e swabbing or excision 2 Carcass analysed by click on the grey arrow to reveal a drop down menu box and click on method used i e pooled or individual 3 Surface sampling method click on the grey arrow to reveal a drop down menu box and click on the method your plant uses to collect surface samples i e swabbing or contact plate Most importantly you need to click on Save my preferences button to save your preferences If you don t click the button the preferences won t be saved You can change your preferences at any time The options on this page must be saved before any data entry can take place for carcasses and surfaces as it determines what data need to be entered Carcase data entry at the top of the main menu ils entry screen only T YOU Sample OY Fooled swab sampling ape taken 23 02 05 Carcase type Cattle z Site Pooled National Comparison Charts Analyses Method Data Entry THC result CFuUsem Carcases Data Entry Surfaces Data Entry Carcase Trend Charts Fr
18. home page will appear The screen should look similar to the screenshot below 7 gt x a A P J B TN i Fie Edit View Favorites Tools Help a aa gt AGENCY eat Test Results Database LX KY AAAA Thank you for visiting this site i Home Carcases Data Entry Information regarding the new testing regulations scheduled for implementation in January 2006 will shortly be made available from www_ukmeat_ org Surfaces Data Entry This database allows the web based entry of microbiological test results as required by the Carcase Trend Charts 2006 meat and meat products testing regulations and provides reports of national and individual plant hygiene trends For further information please contact Mary Howell Meat National Comparison Charts Hygiene and Veterinary Division UK Food Standards Agency who is overseeing the construction of this site Analyses Method Data Entry This database is being developed as part of Food Standards Agency funded research The data contained within this site may be useful to plant operators in the context of their procedures based on HACCP principles but as it is still under development should not replace the current arrangements for reporting microbiological test results to the OVS Lill Plant specific usernames and passwords are available to appropriate plant personnel by contacting Lesley Mappin An Example Plant dataset is available for demonstration purposes so that plant operators can f
19. ierobacteanacege result CP Uren submit entered data You can correct errors by clicking here Date Species Site TWC CFU cm Entero CFU cm 2a 02 2005 Cattle Pooled 90 it 2a02 2005 Cattle Pooled 0 6 0 5 23042005 Cattle Pooled 45 3 23042005 Cattle Pooled 0 5 23042005 Cattle Pooled 10 1 To enter your carcass test results click on Carcases Data Entry on the main menu For each result that you have fill in each box by clicking on it and entering your data Helpful information for each box is shown below e Date taken should be entered in the following format dd mm yyyy e Carcase type click on grey arrow and make the correct species selection e Site should automatically be entered for you each time it is filled in based on the information you provided in the preferences screen e TVC and Enterobacteriaceae values can be entered but must be in CFU cmm e Remember if your results are low enough to be reported as lt 10 CFU cm these should be entered as half the limit of detection i e 5 CFU cm When you have entered your result click on the Submit entered data button Your data will be transferred into the grid towards the bottom of the screen To make data entry easier some of the textboxes will remember what you typed into them e g the date box will remember the date because its likely that you took more than one sample per date Problems with carcase data entry The database will not allow you to
20. ince calculations can be made to the results you enter the site has been designed so that cant change single values within each row You should delete the entire row and re enter your result correctly Date Taken Description Area Swabbed TvVC icm Entero cm Delete 2o 02 2005 Gut pan S0 5d B Delete 230A A005 Sheep saw sil 230 5 Delete 2a 4005 Hock cutter z0 120 10 Back to data entry Data paging If you have entered a lot of data the grid above will present your results as a series of pages You can click the numbers in the lower right hand side of the grid to move backwards through your data if it has been spread across different pages 10 Salmonella data entry third from the top of the main menu Address http www ukmeat org 15759 aspx v Go Links Norton AntiVirus KA X ROOD z awe FSA Meat Test Results Database A Please use this screen only to enter your Salmonella test results Home ses Data Entry Date taken 05 01 06 wes Data Entry nique identifier e g kill number Bloggs32127 C J Salmonella Data Entry pply farm OR meat plant postcode WV6 8HF Lill National Comparison Charts Sample source Pig Analyses Method Data Entry Sample form Sponge swab Result Not Detected Submit entered data You can correct errors by clicking here Date Identifier Postcode Source Sample Type Test Result 05 01 2006 Bloggs32127 WV6 SHF Pig Sponge
21. loggs32127 Bloggs32126 Bloggs32125 Bloggs32124 Bloggs32123 Sample Pig Type Sponge swab Sponge swab Sponge swab Sponge swab Sponge swab Result Not Detected Detected Not Detected Not Detected Not Detected CO e Data paging If you have entered a lot of data the grid above will present your results as a series of pages You can click the numbers in the lower right hand side of the grid to move backwards through your data if it has been spread across different pages 12 Producing reports of your results The reports that the database can produce are split into two main groups The first group are relate only to your plants and show the microbiological trends on your carcasses To show the reports that are available for your plant click on the button marked Carcase trend charts on the main menu Food Standards Agency Red Meat HACCP Verificgtion Results Microsoft Internet Explorer Jeg File Edit View Favorites Tools Help ay Q sex x ad x a A Jo searc Sie Favorites EA A Sa K z L E rel 33 Address http www redmeatdata co uk 5357 asp v d GO Links Norton AntiVirus A FOOD ig a STANDARDS z l AGENCY FSA Meat Test Results Database LA Te Tfe following trend reports are currently available Carcases Data Entry Arithmetic mean carcase trends in your plant eometric mean carcase trends in your plant q NTE sree Rolling geometric mean carcase trends in your pla
22. ncorporated into National dataset during the next update iv Done Internet Start i Sug oaJ aE Wigdo R red meat d E Food Stan CI Qs O BB 07 18 The main menu You can navigate around the site using the main menu which is located on the left hand side of the screen Clicking the Home button will return you the page shown above at any time Analyses method data entry at the bottom of the main menu amp Food Standards Agency Red Meat HACCP Verification Results Microsoft Internet Explorer File Edit View Favorites Tools Help Om O AEG P ke 2 2 a as Address http www redmeatdata co uk 10602 aspx Ra ET Go Links Norton FOOD STANDARDS z AGENCY FSA Meat fest Results Database Home The garcase sampling method is Swabbing m rcases Data En i Carcases Data Entry fnd carcase samples are analysed on a n Pooled M basis Surfaces Data Entry The surface sampling method is Swabbing Carcase Trend Char z Save my preferences amp Andlyses Method Data Entry Before you can begin entering your data the website has to know a few basic facts about your plant and how you take your samples The reason that this information is required is so that the site can present you with data entry screens that are appropriate for your plant For example if you sample carcasses by swabbing and have your laboratory test your results as a single sample
23. nt Analyses Method Data Entry Cumulative sum carcase trends in your plant Weekly Salmonella detections in your plant NEW 10 weekly rolling Salmonella detections in your plant NEVW Carcase trend charts At the time this manual was produced 6 different ways of showing your trends were available Each of these methods has different advantages and disadvantages for different plants A detailed explanation of how each trend is calculated as well as a brief description of the strengths and weaknesses of each method is available online by clicking the 7 2 symbol adjacent to each trend The mathematical method used to generate each trend report is different for each of the different reports However the reports that are generated look similar and the graphs can all be formatted and the information that is displayed are all changed in the same way Clicking on one of the carcase trend reports will show a report the example that follows uses the geometric mean trends The screen should look something like the screenshot below 13 0 0 AAD Dk e B a Plant Licence Number 24680 Report generated 11 03 2005 gt Please enter the dates you want your trend to run from 17 06 2002 M andto 15 03 2004 and for species Update Graphs Ul Geometric Mean TVC Trend for Plant Licence 24680 Mean Log Total Viable Count Log CFU cm2 Sek ksh sks SS PONS SS STS ASA SASAS SAS S22 SS TE xx AS
24. nterobacteriaceae summary graph below Clicking on the go to summary screen button towards the top of the page will return you to the National Comparison Charts page 21 National carcass hygiene bandings shown by week The percentage of carcasses that were acceptable marginal or unacceptable derived from the national carcasses results can also be reported broken down ona week by week basis To view this report click on the National carcass hygiene bandings shown by week link A report similar to the one shown below will be produced Clicking on the drop down boxes allows you to choose The species and also the year that are reported i ye Ge ie ee eee ee a ae mx dit View Favorites Tools Help a t lda Pswn X Plant Licence Number 2468 Report generated 14 03 2005 samed carc se hygiene bands for the Data is derived from the national dataset figures displayed are rounded to the nearest whole number Update graphs National Sheep carcase TVC results grouped by hygiene banding and by week 2ri22004 2012 2004 13412 2004 KEELE 2911 200 2201 2004 1511 2004 08 11 2004 oti i12004 25 10 2004 18 10 2004 110200 04 10 2004 27 09 2004 20 09 2004 13 09 2004 paggigiit a0 08 2004 23 08 2004 As before if you change the year or species that you want to view clicking on the update graphs button will refresh your graph The Enterobacteriaceae summary graph is drawn below the TVC graph Clicking
25. ptable E Unacceptable If you change the year that you want to display clicking on the update graphs button will refresh the graph Clicking on the go to summary screen button will return you to the National Comparison Charts page 19 Plant surface pass fail comparisons with national pass fails This report shows the percentage of surface passes and fails from your plant and how these compare with the national dataset in the form of a colour coded bar graph Clicking on the drop down boxes allows you to choose The year that is shown and what cut off value is used to assess pass or fail Surface pass fa Ns Microsoft Internet Explorer f File Ga Edit View Gx hi gt http www redmeat Faworites Tools Help PY saardi Si Favorites van T s Bs ated 11 03 2905 Address Plant Licence Numbepe 6o5U Report gen The chart uses data fy year and with the pass fail TVC COteftess than or q Gual to 100 CFU E Update graph mparison of plant licence 24680 surface pass fails with the national dataset bed ca 3 t ED Acceptable E Unacceptable 40 Percentage of total surface samples Plant 24680 dataset Mathonal dataset EE Done Trusted sites If you change the year that you want to display or the cut off value clicking on the update graphs button will refresh the graph Clicking on the go to summary screen
26. s page Plant Licence Number 24680 Report generated 11 03 2005 10 48 57 to the summary screen Percentile Total Viable Counts on environmental surfaces for plant 24680 48 24680 dataset National dataset F Log Total Viable Count CFU cm2 03 035 04 045 05 055 06 065 OF 075 08 O85 O8 O95 1 Percentile 100 When interpreting graphs such as these please remember that sometimes microbiological test results from different labs may not be directly comparable because there are differences between the analyses methods and the growth media that different labs use and these can affect the results that are reported 18 National surface hygiene bandings shown by week The percentage of surface passes and fails derived from the national surfaces results can also be reported broken down on a week by week basis Clicking on the drop down box allows you to choose which year is shown Date is derived from the national dataset figures displayed are rounded to nearest whole number Some weeks have significantly more surfaces than others and thus will exert greater influence on annual summaries National surface TVC results grouped by hygiene banding and by week 2rii2 2004 20 12 2004 13 12 2004 OB 2 2004 29 11 2004 22 11 2004 15 11 2004 0811 2004 0711 2004 25 10 2004 18 10 2004 11 10 2004 o4 10 2004 27 09 2004 20 09 2004 13 09 2004 06 09 2004 s0 08 2004 2 08 2004 E done J l 6 Tasted sites E Acce
27. ssssssessssssssessssssssssesesessssesesesssseseseseseacees 12 Producing reports of your results 0 cece ccc eee cee cee cece eee e eee eeceeteeeeeeeeeeeees 13 Carcase trend Charts sseseshsecisestsesexeseseshsicthsiesxsssesiesestststessesllesbyinchsnsl sesasustnseseshsnstiesusesedestsiecbsisesodldechseslsuchs 13 Ten week rolling Salmonella reporting for your plant 0 ccc cece cence cee eees 16 Producing reports of everyone s results 0 ccc cee cece cece ence e cee eeeeeeeeeeeeees 17 Producing reports of everyone s results Surfaces 0c c cece cence cece cee ceeeees 18 National surface hygiene bandings shown by week u cccccccscssssesessssesesssseseesesesesseseseeseseesees 19 Plant surface pass fail comparisons with national pass fail cccccecccsesesseseeseeeseeseene 20 Producing reports of everyone s results Carcasses 0 ccc cece cece eee eeceeeeceeeees 21 National Carcase Percentile Summaries si2 ic ccciecacoeceinda de acindadnnan bean nantes 21 National carcass hygiene bandings shown by week u 0 cccccccsessssssssesesesesscsesesesseseseseeesseseees 22 Plant carcass percentile comparisons with national data Set u cccccesesesesssseseseeeseseees 23 Plant carcass pass fail comparisons with national pass fails 00 00000000000000500005000050 24 How to Logout and end your secure SESSION c ccccccssssessssssesesesesesesesssssscseseses
28. terobacteriaceae values can be entered but must be in CFU cm Enterobacteriaceae are not compulsory on surfaces If you do not test for this class on bacteria on your surfaces type 0 zero into the Enterobacteriaceae result box e For any results that are not detectable e g lt 10 lt 1 use half of the limit of detection see page 2 the section headed using the website When you have entered your results click on the Submit entered data button Your data will be transferred into the grid towards the bottom of the screen To make data entry easier some of the textboxes will remember what you typed into them e g the date box will remember the date because its likely that you took more than one sample per date Problems with surface data entry The database will not allow you to enter your results unless you have first provided your preferences and saved them See the previous section of this booklet for details of how to do this If boxes are left blank a small red message will appear next to the box after you click the submit button The message will explain the problem and ask you to enter appropriate data If Enterobacteriaceae have not been tested for or if Coliforms have been tested instead type 0 zero for not tested If a mistake is made click on correct here link You will be redirected to a screen that looks similar to the one shown below Delete the whole entry click on delete button S
29. the one shown below Clicking on the drop down boxes allows you to choose The year and the species that are shown E Carcase passNgils Microsoft Internet Pxplorer Jol File Edit View Qavorites Tools Help 7 r X p A Fi T Back P a A A Sear i Address hetn mwn redmeXdata co uk CarcaseBar aspx Eo iins a Plant Licence Number 24000 _Rengut generated Luana O0 5 The chart uses data for yer All v addis CP v gt Update raph Chart percentages are subject to rounding so may not always add up to exactly 100 The criteria used for TVC cutoffs are 2000 CFUscm2 for marginal and 20000 CFU cm 2 for unacceptable T or mparison of plant 24680 Pig pass fails with the national dataset for TVC bed Fad oe A Pe r TT Acceptable E Marginal GP Unacceptable 3 E zs E a D a a 8 3 F O _ _ _ Plant 24680 dataset National dataset The criteria used for Enterobacteriaceae cutoffs are 20 CFU cm 2 for marginal and 200 CFU cm 2 for unacceptable E Done Trusted sites The hygiene bandings are different for pigs compared with cattle and sheep The report automatically takes account of these differences and shows what the criteria that have been used are Clicking on the go to summary screen button will return you to the National Comparison Charts page 24 How to Logout and end your secure session Once you have finished using the database
30. ting for your plant At the time of writing there are two reports specifically for your plant which relate to the new Salmonella regulations scheduled to come into force in January 2006 The most useful for your plant will probably be the 10 weekly rolling Salmonella detections in your plant report which is found under the Carcase trend charts button on the main menu This report reflects our current understanding of the new rules which are that each sampling group analysed will comprise of 50 samples These 50 samples will come from 10 consecutive sampling sessions with 5 carcass samples per session and that sampling sessions will be weekly These 50 samples roll i e the samples from week 1 will drop off at week 11 The assessment criteria that we believe will be used are 4 out of 50 for cattle and sheep are unacceptable and 6 out of 50 for pigs are unacceptable An example of a typical 10 weekly rolling Salmonella detections report is shown below The report automatically colours the bars on the chart red when they exceed the unacceptable criteria Raw Salmonella percentages for Cattle during year 2005 The results are grouped by week 25 07 2005 E Detections below limit pass Gp Detections above limit fail 18 07 2005 11 07 2005 04 07 2005 27 06 2005 20 06 2005 J 13 06 2005 4 pe 06 2005 4a 30 05 2005 23 05 2005 16 05 2005 pgV0s 2005 o2 05 2005 JE 25 04 2005 JE 18 04 2005 11 04 2005 J 04 04 2005 28 03
Download Pdf Manuals
Related Search