Clark Consulting Group L.L.C. a privately held corporation. A firm dedicated to Automation Software development and consulting services.

CCG offers the PHACS WCS/WMS Pharmaceutical Factory Automation Software, development tools and consulting expertise to the Automation Software community. CCG was formed in 1990 and is headquartered in Carrollton Texas. CCG specializes in Windows, Window/NT and Embedded Processor development.

PHACS

PHarmaceutical Automation Control System

The PHACS HL-7 Input Processor Module is a standalone NT/2000 Service that retrieves CMOP, NMOP, VISTA, DOD compatible pharmaceutical  HL-7 text file(s), creates backup of file(s) and populates ODBC Database tables with Batched Customer Order Information. Individual Populated DB Tables Include: Batch Master, Batch Notes, Order Splits, Order Details, Product Notes, and (PMI) Patient Medical Information Index. Includes Client User Interface to service. Mutli-Language Support Available Upon Request. Available with Multi-Language support.

Note: The PHACS HL-7 Input Processor Module can be modified to support a variety of delimited text file input for use with other host systems and maintain compatibility with CCG products and other ANSI ASC X12N EDI standards.

The PHACS HL-7 Output Processor Module is a standalone NT/2000 Service that utilizes ODBC Database Order Information and creates CMOP, NMOP, VISTA, DOD compatible pharmaceutical  HL-7 text file(s) and places the text in a defined location for transmittal to a host system Includes Client User Interface to service. Mutli-Language Support Available Upon Request.

Note: The PHACS HL-7 Output Processor Module can be modified to support a variety of delimited text file output for use with other host systems and maintain compatibility with CCG products

 The HL-7 Input/Output Processor includes:

• HL-7 Input Processor Module

• HL-7 Output Processor Module

Making your system CMOP, NMOP, VISTA, DOD  HL-7 compatible.

The PHACS Order Allocation Module is capable of taking Individual Customer Orders and Allocating those orders based upon available inventory. In addition to simple inventory allocation, this module also has the ability to calculate volumetric data and item count to merge multiple orders into single container, conveyable plant orders. Inventory tables can be CCG ODBC/SQL or, optionally customer provided external Database Tables. The Order Allocation Module consists of an NT/2000 Service and Client UI.

The PHACS Order Input Processing System consists of the:

• PHACS HL-7 Input Processor Module

• PHACS HL-7 Output Processor Module

• PHACS Order Allocation Module

HL-7 IP App Notes (PDF)

HL-7 OP App Notes (PDF)

Order Allocation App Notes (PDF)

The PHACS Order Processing System provides conveyable orders to a host system. Orders are requested from the PHACS Order Processing System via Ethernet. A complete set of programs is provided for all Order Processing functions.

PHACS Order Processing System Functions:

• HL-7 Input/Output Processing

• Inventory based Order Allocation

• Conveyable container cubing (Volumetric and quantity)

• Marry Orders to a conveyable container ID

• Place orders on hold.

• Priority level release of orders to floor automation.

• Cancel Orders

• Reallocation

• Manage Back-Orders

• Import/Export Outsourcing

• View order filter based upon status

• Drill down capability to view order details

• Drill down capability to view Prescription Vial Information

Note: Currently the Order Processing System requires the PHACS Order Input Processing System and cannot be sold separately.

Order Maint Screen

Order Detail Screen

Script Vials Screen

The PHACS Receiving Workstation Module allows the host system to receive inventory transparently. Items can be received into customer defined "zones". These zones can be dispensable or non-dispensable locations. The operator is provided with a zone specific put-away list to aid in replenishment Multiple receiving stations can be linked together. Requires a handheld scanner and a laser printer for put-away list printing.

Note: An optional Database interface is available to transfer received item data and zone information to and from a host database allowing the Receiving Workstation Module to operate in a stand-alone configuration.

Recv 1 Screen Recv 2 Screen

PutAway

The PHACS Manual Picking Module allows the interactive manual picking and prescription labeling of pharmaceutical items with optional pharmacist verification. Color Code order item status aid the operator in determining individual item status. The Manual Picking Module is designed to use Intermec® label printers by default but can be configured to use Zebra type printers as well. Configurable modes of operation are possible, allowing the software to act as a manual pick station only, a labeling station only, a controlled substance station only, or a bulk item pick only station. Requires a handheld scanner and label printer.

Note: An optional Database interface is available to transfer picked item data and order information to and from a host database allowing the Manual Picking Workstation Module to operate in a stand-alone configuration.

Manual Pick 1 Manual Pick 2

The PHACS Manual Packing Module allows the interactive manual packing and  of pharmaceutical items Color Code order item status aid the operator in determining individual item status. If an item requires pharmacist verification and it has not been verified the item is not allowed to be packed. This module prints full packing documentation and package labels. Requires a handheld scanner a label printer and a document printer.

The Manual Packing Module is designed to use Intermec® Label printers by default but can be configured to use Zebra type printers as well. The Packing operation video below represents a typical packing station setup with two printers, one for PMI documentation and the other for package labels. CCG also authors custom software for Intermec® Label printers.

Note: An optional Database interface is available to transfer packed item data and completed order information to and from a host database allowing the Manual Packing Workstation Module to operate in a stand-alone configuration.

Packing

Packing Operation Video

The PHACS Order Verification Workstation Module allows the verification of product prior to packing operations. Images of the actual product are displayed from the database to the user as an additional means of positive identification. Requires a handheld scanner.

Note: An optional Database interface is available to transfer verification data and updated item picture information to and from a host database. Allowing the Order Verification Workstation Module to operate in a stand-alone configuration.

OV1

OV2

OV3

OV4

The PHACS Bulk Inventory Control Module allows bulk inventory to be received (from the PHACS system or a host system) and create smaller units of inventory into machine dispensable units for use within a dispensing machine. NDC/NDF and Lot Number Tracking is maintained in the database and printed on a label that can be applied to the smaller inventory package. Using available NDDF data, NDC's differing only in received pack-size can be combined into one traceable package. Requires a handheld/tabletop scanner and label printer.

Note: An optional Database interface is available to transfer inventory data  to and from a host database allowing the PHACS Bulk Inventory Control Module to operate in a stand-alone configuration.

Bulk Inv1

Bulk Inv2

The PHACS Custom Report Generator  Module makes generating reports from any ODBC data source a snap. Cleverly engineered to allow real-time extraction of data with user parameters. Reports are generated as web-enable html files. Your reports can be shared and published directly to the internet. Never design a report again. Users can define their own filters and comparisons. Each user logging into the Report Generator uses a "short list" of just the reports and parameters useful to that user. PHACS Custom Report Generator  Module comes with all the standard Pharmaceutical reports expected for Receiving, Cost reporting, Inventory, Lot Storage, Product Maintenance, Operation Events and even specialized reports for prescriptions fill and packing rates and operator productivity.

Report1

Report2

Report3

• Receiving
• Order Manual Entry/HL-7 Automated Input
• Inventory Management
• Order Maintenance
• Order Allocation
• Manual Product Picking/Labeling Software Station
• Manual Verification Software Station
• Manual Packing Software Station
• Host Order Update
• System Parameters
• User Security/Maintenance
• Custom Report Generator

• 2 Encoder Inputs (Absolute or Incremental)
• Up to 82 Sort Lane Scanner inputs (Ethernet)
• 2 Induction Control Scanner Inputs (Ethernet)
• 2 10/100 Ethernet Ports
• Web-Enabled configuration (Built in Web Server)
• Control Up to 80 Individual Diverts simultaneously
• Automatic calibration feature for hardware maintenance
• Multiple Diverter Type Support. Pusher, Shoe, Popup, Tilt

Coyote Sorter

Sorting Video 1

Right Angle Divert

Multiple Diverts

The CCG User Security Software allows you to fully integrate user validation and maintain security records with a software-only solution. Designed primarily to maintain hundreds of records keeping all personnel data including facial images and fingerprint biometrics. The system can group different types of users in user defined groups with different security levels. Operates as a standalone software module or can be interfaced to your system through the use of a DLL call.

Security1

Security2

The CCG Smart Fingerprint Module allows you to fully integrate fingerprint biometrics to your security solution. The fingerprint module can be used to validate workstation access (instead of username/passwords) and/or interface to physical devices such as doors, gates and security turnstiles. The Fingerprint module features 8 TTL level outputs and 8 TTL level inputs that can be programmed based upon the fingerprints module state. Simply put you can unlock a door or sound an alarm based upon validating a fingerprint.

Security Hardware

Complete integrated Security solution includes:

• CCG Fingerprint Module

• CCG User Security Software

Security1

Security2