Enterprise batch records: Data collection

A commonly asked question about enterprise batch records is how do you get data into them? Many devices can be recruited for this, and once they are set up the benefits reap themselves.


I’ve talked before about enterprise batch records and I’ve received a good bit of feedback on the topic. Much thanks to everyone that’s shared their thoughts and ideas on the subject. One of the questions that I get a lot is about how you get all that data into the enterprise batch records. So, I thought I’d spend a little time talking about data collection.

When someone asks me about getting data into the enterprise batch records, the first thing I tell them is that they’re right. It’s a big chore getting all the data into the enterprise batch records, and the enterprise batch records are only as valuable as the data that they contain. So, it’s not easy getting the data into the enterprise batch records, and it’s going to take a variety of data collection tools and techniques to get all the data you want in the enterprise batch records.

Barcode scanners should be used extensively on the shop floor. This is especially true for material movements, material production, and material consumption. All industries are different, but the idea of having some type of barcode label on all materials that come out of or go into inventory just makes sense. It doesn’t matter whether it’s raw materials, work-in-progress (WIP) materials, or finished goods. A barcode label on the materials makes everything a lot easier.

At the very least, the materials can be scanned in and out of inventory, and can be scanned when materials are produced and when they are consumed. The materials can also be scanned when cycle counts or physical inventories are performed. And all of this information—especially the production and consumption information—can all go automatically into the enterprise batch records.

Like barcode scanners, there are a lot of other handheld devices that can be used to collect data on the shop floor and feed the enterprise batch records. For example, in many industries it’s necessary to record the temperature of the product at various stages of the manufacturing process, and even to manually confirm the temperature with certain checks. In these cases, using a handheld temperature probe attached to a small handheld wireless device is a simple and easy solution. And these devices can feed this data automatically into the enterprise batch records very easily.

Of course, data can and should be collected automatically from any and all systems that are out on the shop floor. Whether it be programmable logic controllers (PLCs), distributed control systems (DCSs), human-machine interfaces (HMIs), supervisory controls and data acquisitions (SCADAs), or even manufacturing execution systems (MESs), it really makes sense to collect as much of this data as automatically as possible, and feed it directly into the enterprise batch records. And, if you don’t need or don’t want to duplicate the data that’s stored long term (like in an MES) you can just link the enterprise batch records to the data and achieve the same result. And if you have one or more historians out there, then by all means link to that data or, if you need to, summarize the data and include the summary information in the enterprise batch records. And finally, you should also be able to automatically collect data from any external systems that you might have.

In some instances you may need to have some manual data collection going on as well. It may be old school, but electronic forms still make a lot of sense for data collection. The electronic forms can be implemented on a variety of devices, such as terminals, laptops, tablets, or smart phones. You may not have thought about the idea of everyone on the shop floor having a smart phone and entering manufacturing data into it, but it’s really pretty easy, it’s pretty cheap, and it makes a lot of sense. Regardless, whether it’s a PC, tablet, or smart phone, there are a lot of ways to get the data and feed it into the enterprise batch records.

One concept that makes all this work doing data collection a whole lot easier is workflow management. Workflow management is simply the idea of managing the tasks or steps in a process in a particular order and/or at a particular time. What it means for data collection is that workflow management can specify where and when the data is collected. It can also guide the operators through their data collection steps (even on tablets or smart phones) and it can ensure that all the data gets into the enterprise batch records, and if there’s data that’s missing or steps that were missed it can flag that as well. All in all, it’s a powerful concept for directing the data collection efforts to make all the data gets collected when it should be.

Hopefully that gives you some ideas about data collection and enterprise batch records. Enterprise batch records are only as valuable as the data you put in them. And, that can make data collection seem like a daunting task. But, it’s really not that hard. You can use tools like historians, barcode scanners, handheld devices, and even tablets and smart phones to make it all a lot easier. And you can use workflow management to manage how and when it’s all done. So, in the end, all the data goes into the enterprise batch records and that’s what makes it all worthwhile.

Thanks for letting me tell you about enterprise batch records and data collection. Until next time, good luck and have fun.

This post was written by John Clemons. John is the Director of Manufacturing IT at MAVERICK Technologies, a leading automation solutions provider offering industrial automation, strategic manufacturing, and enterprise integration services for the process industries. MAVERICK delivers expertise and consulting in a wide variety of areas including industrial automation controls, distributed control systems, manufacturing execution systems, operational strategy, business process optimization and more.

No comments
The Engineers' Choice Awards highlight some of the best new control, instrumentation and automation products as chosen by...
Each year, a panel of Control Engineering editors and industry expert judges select the System Integrator of the Year Award winners.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
Learn how to increase device reliability in harsh environments and decrease unplanned system downtime.
This eGuide contains a series of articles and videos that considers theoretical and practical; immediate needs and a look into the future.
Learn how to create value with re-use; gain productivity with lean automation and connectivity, and optimize panel design and construction.
Go deep: Automation tackles offshore oil challenges; Ethernet advice; Wireless robotics; Product exclusives; Digital edition exclusives
Lost in the gray scale? How to get effective HMIs; Best practices: Integrate old and new wireless systems; Smart software, networks; Service provider certifications
Fixing PID: Part 2: Tweaking controller strategy; Machine safety networks; Salary survey and career advice; Smart I/O architecture; Product exclusives
The Ask Control Engineering blog covers all aspects of automation, including motors, drives, sensors, motion control, machine control, and embedded systems.
Look at the basics of industrial wireless technologies, wireless concepts, wireless standards, and wireless best practices with Daniel E. Capano of Diversified Technical Services Inc.
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
This is a blog from the trenches – written by engineers who are implementing and upgrading control systems every day across every industry.
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.

Find and connect with the most suitable service provider for your unique application. Start searching the Global System Integrator Database Now!

Case Study Database

Case Study Database

Get more exposure for your case study by uploading it to the Control Engineering case study database, where end-users can identify relevant solutions and explore what the experts are doing to effectively implement a variety of technology and productivity related projects.

These case studies provide examples of how knowledgeable solution providers have used technology, processes and people to create effective and successful implementations in real-world situations. Case studies can be completed by filling out a simple online form where you can outline the project title, abstract, and full story in 1500 words or less; upload photos, videos and a logo.

Click here to visit the Case Study Database and upload your case study.