QC Scheduler - Intranet Application

(c) sartori-software.com 2009

Introduction 
The QC Scheduler is an Intra- or Internet based application, that allows worldwide recording, planning, managing and reporting of Pharmaceutical Product Filling and Packaging Lots/ Batches for Quality Control purposes.

Products throughput intervals can be defined to survey the production pipeline in order to fulfill your company's Quality Control needs.

The software aids Sales Managers to forecast the readiness of Product Lots for delivery.

Different Security Levels allow different access to the data stored.

An Import Software allows to gather data periodically from freely configurable 3rd party systems e.g. LIMS (Laboratory Information Management System), SAP, Oracle etc.


The application functionality can be summarized as follows

  • Define Production Locations and Products
  • Access enable Users to the QC Scheduler Application
  • Record, manage an report Production and Packaging Lots QC - Status
  • Document and Report Product Lot deliveries worldwide

 

Application Overview

   

With QC Scheduler following data can be easily managed, maintained and reported

 

QC Scheduler Data Model

 

 

System Requirements
Webserver: Apache, IIS or similar
Database Server: MS SQL Server 2000 or later
Client:
Any modern Webbrowser such as Firefox, Internet Explorer etc.

 

 

Products and Locations

Products Add and Manage Product information such as Code, Name and Type. Production Lots can be linked to Products  
Locations Add and Manage Production Locations for Lot and Package Tracking

 

 

Product - and Packaging Lots
Production Lots Add and Manage Production Lots, Destination Countries and Authorities as well as release dates - and production delay information if any.

Packaging Lots For each Production Lot as many Packaging lots as needed can be added, managed and reported. 

 

 

Search & Report
Different Search and Reporting Functions to give other views on the QC tracking process are implemented. Search and Reporting Functionalities can be easily adapted and new functions can be created by administrators.

 

User Management  & Security
Application Users Personnel Data: Personal Information, Contact Information and Application Access Permission
Access Control and Data Access Rules Access Control Data defines the Security Matrix for Data access by Persons . Restrictions on data Level (e.g. On Certain Lot Numbers) can be user-defined.

 

 

Audit Trail and Access Logging
AuditTrail Audit Trail of Changes in the QC Scheduler Database   

 

(c) sartori-software.com 2009