• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
TSB Alfresco Cobrand White tagline

Technology Services Group

  • Home
  • Products
    • Alfresco Enterprise Viewer
    • OpenContent Search
    • OpenContent Case
    • OpenContent Forms
    • OpenMigrate
    • OpenContent Web Services
    • OpenCapture
    • OpenOverlay
  • Solutions
    • Alfresco Content Accelerator for Claims Management
      • Claims Demo Series
    • Alfresco Content Accelerator for Policy & Procedure Management
      • Compliance Demo Series
    • OpenContent Accounts Payable
    • OpenContent Contract Management
    • OpenContent Batch Records
    • OpenContent Government
    • OpenContent Corporate Forms
    • OpenContent Construction Management
    • OpenContent Digital Archive
    • OpenContent Human Resources
    • OpenContent Patient Records
  • Platforms
    • Alfresco Consulting
      • Alfresco Case Study – Canadian Museum of Human Rights
      • Alfresco Case Study – New York Philharmonic
      • Alfresco Case Study – New York Property Insurance Underwriting Association
      • Alfresco Case Study – American Society for Clinical Pathology
      • Alfresco Case Study – American Association of Insurance Services
      • Alfresco Case Study – United Cerebral Palsy
    • HBase
    • DynamoDB
    • OpenText & Documentum Consulting
      • Upgrades – A Well Documented Approach
      • Life Science Solutions
        • Life Sciences Project Sampling
    • Veeva Consulting
    • Ephesoft
    • Workshare
  • Case Studies
    • White Papers
    • 11 Billion Document Migration
    • Learning Zone
    • Digital Asset Collection – Canadian Museum of Human Rights
    • Digital Archive and Retrieval – ASCP
    • Digital Archives – New York Philharmonic
    • Insurance Claim Processing – New York Property Insurance
    • Policy Forms Management with Machine Learning – AAIS
    • Liferay and Alfresco Portal – United Cerebral Palsy of Greater Chicago
  • About
    • Contact Us
  • Blog

Documentum or Alfresco – Quality Manufacturing – Modernizing Controlled Documentation and Batch Records

You are here: Home / Alfresco / Documentum or Alfresco – Quality Manufacturing – Modernizing Controlled Documentation and Batch Records

July 24, 2014

Quality Manufacturers often struggle with attempts to modernize batch records to allow for simple and accurate completion of a batch while capturing relevant quality data.  Typical start-up systems are “too small” relying on paper print-outs, handwritten values with image scanning of completed manufacturing instructions.  To capture any data for trending evaluation, all the handwritten data would have to be entered manually.  Other approaches are often “too big” with every document having to be coded into a Manufacturing Execution System (MES).  One TSG client found a way to combine the user friendly approach of robust Word documents with PDF and other manipulation controls to create a simple, modern approach for capturing data during the process without the need to code in an MES.  This post, along with a an upcoming webinar on July 31st with Alfresco will discuss the problem and solution.

UPDATE: The completed webinar has been uploaded to our Learning Zone for viewing here.

Batch Records – Too Small or Too Big Laboratory Information Systems (LIMs) and Manufacturing Execution Systems (MES) allow for automation of the batch records process through the coding of a batch record to provide for data capture with logic to complete the process accurately.  For a validated system, the requirement of updating code (or configure XML) to process a change can sometimes make the automated system difficult to adjust and almost “too big” for the typical quality manufacturer where the process can change and adjust. On the opposite side, paper based systems that rely on Word documents require intense manual effort to:

  • Identify the correct documents required for a batch
  • Filling in header and footer information for the batch on each of the documents
  • Printing all the documents in a package
  • Filling out the detail in the batch with paper and pen
  • Scanning completed batches back into the system
  • Hand-keying all values

Both approaches struggle on the data capture side, often times relying on database rows and tables to capture values.  With a database approach, adding new values requires not only the additional programming in the LIMS, MES or Data Capture from paper interface, but also the involvement of a DBA to add the database element, causing additional delay.

Batch Records – a document approach Struggling with the too big and too small approaches, TSG’s client decided to explore ways to leverage a document approach.  With a document approach:

  • Authors can edit/change/approve manufacturing instructions in familiar Word formats consistent with document change process.
  • Batch data values could be entered across and consistently within the batch
  • Execution values could be captured electronically for trending evaluation

This process leverages document centric technology to flip from a ‘system’ driven approach to a ‘document’ driven approach Putting the authors in charge of their own documents gives them the agility to change their own process and documents rather than requiring a large IT project when new data needs to be collected.  For an example, let’s say the business would like to capture a temperature value for a given batch both to check that it is in a specified range but also for trending information.  For this new approach:

  1. User identifies in a document where to add the temperature capture.  User adds a table element “Temperature of active ingredient at 10 minutes between 98 and 101.5” and adds a data-field “TEMP10” to the document.
  2. The user would fill out a normal change request with the document to get the document approved.
  3. Once approved, the next batch would include the approved document.
  4. The system combines multiple documents within the batch filling substituting header information, page numbers, and other data fields in the individual documents consistently across all documents.  See a demonstration of this capability in our Learning Zone.
  5. For online filling, the system looks in each document and prompts users, when processing that document, to fill out values online.  The system would recognize the additional TEMP10 field and prompt the user to complete the field.
  6. The field would be rendered in the document (field substitution in Word and then rendered to PDF) for the user to verify and signoff.
  7. The data for the TEMP10 would be stored and available for trending information.

Summary Implementing batch records for quality manufacturing doesn’t have to be either a too big, LIMS or MES, solution or a too small, paper and data entry.  Focusing on the document allows clients to leverage document change control to quickly change documents, automate batch record functions while still providing for capture of data. Join us for a webinar On July 31st with Alfresco: Compliant Laboratory Information Management Systems – a Modern Approach Leveraging Alfresco.

UPDATE: The completed webinar has been uploaded to our Learning Zone for viewing here.

Filed Under: Alfresco, Documentum, OpenContent Forms, OpenContent Management Suite

Reader Interactions

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Search

Related Posts

  • Document Review and Approval – Why Form AND Workflow are so important
  • Documentum and Alfresco – Salesforce Integration for Contract Management
  • Documentum – Top Tips for 2016
  • HotDocs – Document Creation for Documentum, Alfresco and Hadoop
  • Documentum or Alfresco – TSG Government Solution
  • Next Generation ECMS – Architecture Thoughts
  • Documentum and Alfresco BPM – Activiti and Active Wizard 5.0
  • Documentum – EMC World/Momentum 2013 – TSG Recap
  • Documentum, SharePoint, Alfresco – Document Control for Life Sciences
  • Documentum and Alfresco Solutions – Compliance Solution for Regulated Industries – Demo Series

Recent Posts

  • Alfresco Content Accelerator and Alfresco Enterprise Viewer – Improving User Collaboration Efficiency
  • Alfresco Content Accelerator – Document Notification Distribution Lists
  • Alfresco Webinar – Productivity Anywhere: How modern claim and policy document processing can help the new work-from-home normal succeed
  • Alfresco – Viewing Annotations on Versions
  • Alfresco Content Accelerator – Collaboration Enhancements
stacks-of-paper

11 BILLION DOCUMENT
BENCHMARK
OVERVIEW

Learn how TSG was able to leverage DynamoDB, S3, ElasticSearch & AWS to successfully migrate 11 Billion documents.

Download White Paper

Footer

Search

Contact

22 West Washington St
5th Floor
Chicago, IL 60602

inquiry@tsgrp.com

312.372.7777

Copyright © 2023 · Technology Services Group, Inc. · Log in

This website uses cookies to improve your experience. Please accept this site's cookies, but you can opt-out if you wish. Privacy Policy ACCEPT | Cookie settings
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT