esquef,
Our auditor did what he called a "traceability exercise on steroids" which required us to have every record from start to finish and then these records had to be presented to the auditor by a spokesperson from each department responsible for the records. In other words, starting with your ingredients you had to show record of the approved supplier of each ingredient, the inspection of the receipt of each ingredient, lot numbers of ingredients, etc. and the same goes for the packaging materials. For all the equipment used in the manufacturing/packaging process for the product/lot being "traced", we were required to show all sanitation records of cleaning that equipment as well as all preventive or demand maintenance performed on that equipment to prove those programs are operating efficiently. QA must show any monitoring records/tests performed on the product, proof of product release, etc. Production had to show record of lot tracking of ingredients, packaging, etc. and then all pallet reports of finished product. Finally, shipping showed the records of distribution and records of inspections done to product and trailers prior to loading. (Oh and I forgot to include the proof of the label review for the products selected.)
Not only did this exercise show many aspects of our SQF record control, but also showed that our "spokespeople" from each department knew their role and commitment to our SQF system. Our auditor was kind enough to warn us about this exercise during the SQF Document Audit so that gave us time to do a couple practice runs of the exercise to get the employees comfortable and confident for the real thing during the Facility Audit.
Since the certification audit, I have implemented this "traceability exercise on steroids" as a SQF Systems Audit that we perform internally each quarter to help improve and keep everyone on their toes. It sounds like a lot of work and it is at first but after you go through it a few times you will learn that it is worth the effort and time you put into it as it is an extremely valuable tool to pinpoint any loopholes you may have - which in turn we must correct and of course record the corrections (which shows continuous improvement!).