ONLINE TRANSACTION DATA FLOW

Español Castellano Portuguese

 
Pharmacy Terminal
Communication Network
VISA Protocol
The Provider (DP/Rx TeleClaim System)
Front End Processor
Adjudicator Processing
Files Used By The Adjudicator
Reports Machine Processing
Database Integrity Between the Adjudicator and the File Server
Month End
Interface End User Applications
This section describes the transaction data flow of a Client Rx (prescription) and how it is handled by the DPRX Teleclaim System.

The discussion will cover a standard TeleClaim configuration:

  • Reports Workstation has its files resident on the file server
  • The adjudicator has copies of its data files locally.
Communication between the Front End Processor, Adjudicator, and Reports Workstation are done by shared communications files on the File Server.

The diagram below, represents the transaction data flow of a client Rx to the Teleclaim system using a communication network (NDC, GCC, Envoy, etc) via an x.25 or a TCP/IP protocol. The only difference between the two network protocols being used (x.25 and TCP/IP) is the equipment interface to the Front End Processor. The x.25 uses an x.25 Packet Assembler/Disassembler (PAD) while the TCP/IP uses a router which could be connected to the internet and has it’s own IP (Internet Protocol) address. The Front End Processor using the x.25 protocol runs on a Windows 98 Operating System and the TCP/IP network based Front End Processor runs on a Windows NT 4.0 Workstation OS.

 

 
Pharmacy Terminal

The client presents his prescription to a pharmacy. The pharmacist then keys in this prescription and other details from the client into his terminal. This data is then transmitted over to a network that processes this claim. Enclosed in the claim is a processor ID which the network uses to route back this claim to the corresponding pharmacy terminal. The processor handles the validation of this claim and sends the result back to the pharmacy. Based on this response, the pharmacist has the option to accept the prescription or reject it.

The format of the claim and its associated response is given by NCPDP (National Council for Prescription Drug Program). The DPRX Teleclaim System accepts version 3A, 3B and 3C of the NCPDP protocol.

 
Communication Network

The network routes the claims received from the pharmacy terminal to a Claims Processor based on the Processor ID embedded in the claim packet. Reponses from the processor are routed back to the initiating pharmacy. DPRX has the ability to install a network for a host system to all pharmacies in the network.

The turn around for this claim should be less than 10 seconds. If the claim takes more than 10 seconds, the network then transmits a Non-acknowledgement to the pharmacy and the pharmacy must try to re-transmit the claim. The actual processing of the claim takes less than 1 second. The claims coming form the pharmacy are sent to the processor via an x.25 or TCP/IP based network. Protocol used by the processor and the network is called the VISA protocol.

 
VISA PROTOCOL

The diagram below represents the VISA Protocol.

  • The network waits for a <ENQ> (Inquire Character) from the provider
  • Upon receipt of a <ENQ>, the network then sends the claim in the format <STX>[MESSAGE]<ETX><LRC>.
  • If the network receives a <NAK> (Non-Acknowledgement) from the provider, it then re-transmits the message in step 2. If the <LRC> calculation obtain by the provider is wrong, the Provider transmits a <NAK>.
  • If a <NAK> is not received, then the packet is a response. The response is the same format as that given in step 2. The <LRC> is verified, if it is OK, then it is sent over the Pharmacy and a <ACK> is transmitted to the Provider. If the <LRC> is bad, a <NAK> is transmitted to the Provider and the network waits for the provider to re-transmit again.
 
THE PROVIDER (DP/Rx TELECLAIM SYSTEM)

The DP/Rx TeleClaim System is an interactive solution for a pharmacy provider. It accomplishes the Online processing of claims via a Network of PC’s. For systems using a Communication Network via x.25, the TeleClaim system starts from the x.25 PAD. For TCP/IP transactions, the ISDN modem/Router is the starting point.

x.25 PAD (Packet Assembler/Disassembler)

Converts the x.25 transmission and de-multiplexes the packet. Each packet is routed over to serial ports which are interfaced to the Front End Processor. The FEP (Front End Processor) has a minimum of 8 serial ports using an 8 port Digiboard.

 
FRONT END PROCESSOR

A dedicated PC that polls the x.25’s serial ports (or listen to it’s TCP/IP port). Waits for an incoming transaction and sends it over to the Adjudicator via the VISA protocol. The incoming transactions are queued in the Front End Processor. The FEP then validates a claim via <LRC> calculation. If the calculation is faulty, the FEP then retransmits a NAK (Non-acknowledgement) to the serial port and back to the communication center. Otherwise, this is a valid claim placed on the FEP (Front End Processor) internal queue to be transmitted to the Adjudicator. This incoming claim that has a format of <STX>[MESSAGE]<ETX><LRC> is appended with a header containing <SOH>’FEP’[ID]<ETB>. The format of the message transmitted over to the Adjudicator is

<SOH>’FEP’[ID]<ETB><STX>[MESSAGE]<ETX><LRC>

The Adjudicator replies in the same format (its reply is stored in the message).

Transmission between the Front End Processor and Adjudicator is done through Shared Files on the FILE SERVER. The Operating System environment variable ‘FEPPATH’ points to the location of the files ‘CLAIM.FEP’ (claims written by the Front End Processor) and ‘REPLY.FEP’ (reply written by the Adjudicator).

The Front End Processor serves also as a bridge with the Reports Machine Workstations in the update of the Adjudicator’s local database. The Reports Machine transmits a TeleClaim "update record packet" via a file called "INQUIRY.FEP". The location of the file is given by the Operating System environment variable called ‘FEPPATH’. The Front End Processor searches for this file on the network during the scanning of its serial ports and puts this packet in its queue. The adjudicator, upon receipt of this packet updates a database record and sends its response back to the Front End Processor. The FEP writes out its response in ‘INQREPLY.FEP’. For a list of Adjudicator local databases which are updated, please refer to the ‘Adjudicator Processing’.

 
ADJUDICATOR PROCESSING

The adjudicator is a dedicated PC that processes the claim (from the Front End Processor) and update record packets (sent by the Reports Machine) from the Front End Processor. These transactions are all done via shared files on the FILE SERVER: ‘CLAIM.FEP’ and ‘REPLY.FEP’. The location of these files is given in the Operating

System environment variable named ‘FEPPATH’.

Hierarchical Levels in DP/Rx Adjudication of Claims

To have a better understanding of how the DP/Rx Adjudicator processes claims, a diagram is provided below that illustrates the different hierarchical conventions that DP/Rx uses in processing claims:

The member is the smallest element in the hierarchy and represents the Pharmacy customer whose Rx we are given to process. It is a sub-element of the hierarchy GROUP that is a sub-member of the hierarchy ACCOUNT. The largest member in the hierarchy is the CLIENT. Note, that a PLAN (a method for processing a CLAIM Member Rx) is attached at the GROUP level, but a PLAN may be used at virtually any level from clients down to individual members.
 
Files used by the Adjudicator

The current version of the Adjudicator uses local files in validating and processing claims. This ensures faster processing speed. The claims process today and their results are written on a shared file "TODAY.LOG" in the directory TRANSACT on the File Server. The Reports machine uses "TODAY.LOG" in querying today’s claims. 

The table below lists the directories, that the Adjudicator uses on its local drive.

Adjudicator Local Dir Description
\LASTMTH Holds last month files for safety
\MASTFILE Adjudicator Master Files
\PROGRAMS Adjudicator Programs(*.exe, *.bat)
\PROGRAMS\OLD Previous release of \PROGRAMS
\TRANSACT Real time Transaction Files
 
The next table outlines the files that are in the \LASTMTH directory of the Adjudicator
Files on \LASTMTH (Adjudicator) Description
DURFILE & DURFILE.IDX DUR conflicts
LOG.ZIP Log file in Chronological order
MONTHEND Month End Date File
ONLDTL & ONLDTL.IDX Paid Claims File
 
The contents of the Adjudicators \MASTFILE directory
Files on \MASTFILE on Adjudicator Description
Accounts & Accounts.idx Accounts Master File
Adjdrug & Adjdrug.idx Drug Master File
Altprice & Altprice.idx Alternate Price File by GPI
Carrier & Carrier.idx Insurance Carrier Master File
Chain & Chain.idx Drug Chain Master File
Client & Client.idx

Client Master File

Contract & Contract.idx Contract File for Plan/Pharmacy File
Doctor & Doctor.idx Doctor (Prescriber) Master File
Family & Family.idx Count of members in each family
Future & Future.idx Future changes to member groups
Group & Group.idx Group Master File
Groupwc & Groupwc.idx Workers Comp Group Master File
Mac and Mac.idx MAC prices for standard (POS) plans
Macdmr & Macdmr.idx MAC Prices for DMR Plans
Macmail & Macmail.idx MAC Prices for Mail order Plans
Macspl & Macspl.idx Doctor Specialty Drug Limitations File
Medicaid & Medicaid.idx Medicaid Pricing File by State
Member & Member.idx Member Master File
Oldprice & Oldprice.idx Old Drug Prices for Older Claims
Pharmacy & Pharmacy.idx Pharmacy Master File
Pharmacy & Pharmacy.idx Pharmacy Master File
Plan & Plan.idx Plan Design for Standard (POS)
Plandmr & Plandmr.idx Plan Design for DMR Plans
Plangpi & Plangpi.idx Plan Exceptions for Standard (POS)
Plangpid & Plangpid.idx Plan Exceptions for DMR Plans
Plangpim & Plangpim.idx Plan Exceptions for Mail Order Plans
Planmail & Planmail.idx Plan Design for Mail Order
Prefered & Prefered.idx Prefered Drugs (NDC Lockout)
Runcntrl Customer Profile
Security & Security.idx Security File
 
The content of the Adjudicators \TRANSACT directory are as follows:
Files of \TRANSACT of Adjudicator Description
Authfile & Authfile.idx Old Style Prior Authorization File
Average Average Adjudication Time by Day
Backup.log Result of Last Adjudicator Backup
Benefits & Benefits.idx Member Benefits File for Deductible/CAP/Out of Pocket
Details & Details.idx Current Paid Claim File (Auxiliary)
Dmraddr & Dmraddr.idx Direct Member Reimbursement Address File
Durfiles & Durfiles.idx DUR Conflict Messages
Fills & Fills.idx Fills History File by Patient and Medication
Lifetime & Lifetime.idx Lifetime/Annual Accrual file by Patient and Medication
Onldtl & Onldtl.idx Current Month Paid Claim File
Online.log

Current Month Chronological Log File of Claims

Preauth & Preauth.idx Prior Authorization File
Transact Next Available Claim Number
Vtoc Volume Table of Contents for Adjudicator
 
The Adjudicator Claims processing is divided into 2 modules. These are: the "Main Adjudication" module (that validates the incoming claims) and the "DUR" module (which determines if there is a DUR conflict). The incoming claim is first processed by the "Main Adjudication" module. If this is a valid claim, then the response is computed based on the contents of the PLAN database. The reply is then passed to the "DUR" module. The result is then written to the shared file "REPLY.FEP". The Front End Processor then routes this to the X.25 PAD or the TCP/IP component. This response in then routed to the Network (NDC, ENVOY), and then back to the initiating Pharmacy.

The following table represents the Adjudicator transactions that are available to the Reports Machine. These modules were included in the system to enable the Teleclaim user to update the Adjudicator Master file online. The usual update procedure is that the File Server Master files are updated by the Reports Machine Workstation. These Master files are copied over to the Adjudicator Local Drive at Midnight (refer to Daily Cycle Procedure).

Online Transactions for the Adjudicator from the Reports Machine

  • Maintain Member File
  • Maintain Drug File
  • Maintain Preferred Drug File
  • Maintain Client File
  • Maintain Group File
  • Maintain Group Workers Comp
  • Maintain Chain File
  • Maintain Pharmacy File
  • Maintain Physician File
  • Maintain Account File
  • Maintain Prior Authorization File
  • Maintain Benefits Adjustment File
  • Maintain Plan File
  • Process Manual Claims
Reports Machine Processing

The reports machine workstation has the following capabilities:

  • Used by the Help Desk in inquiring claims
  • Inquiry and Maintenance of the files in the File Server and the Adjudicator
  • Generation of reports to produce statistical or financial report. Reports are first spooled to disk and a separate a Teleclaim program allows the user to view the report, print it out on paper or on a tape or CD.
  • Financial Processing
  • The ability to produce checks to pharmacies and/or members based on the incoming claims.
  • Conversion of Master Files to SDF files. As added functionality, the user is provided an option to export the TeleClaim Master and/or Transaction files into SDF (Standard Data File Format) this allows the user the ability to import data on his or her favorite database or spreadsheet package.
  • DUR Drug Utilization retrospective analysis. Reports and analysis of Client’s Historic data. Includes drug interaction. Drug usage summary, etc.
The following table gives the list of directories that are resident of the File Server which the Reports Machine uses.
Reports Machine Directories Resident on the File Server Description
\ADJUD Used for holding Midnight Swap files
\DAILY Used for Holding Daily Export Files
\EXPORT Exported Master & Transaction Files
\HISTORY Claims History (May reside in a different Drive)
\INQUIRY Claims Inquiry (May be on a Different Physical Drive)
\MASTERS Master files that do not go to the Adjudicator
\MASTFILE Master Files which go to the Adjudicator
\PRINTDIR Holds Files for Printing
\TRANSACT Holds Transaction Files
\TRANSIMP Holds Sample files for SIMPLAN
\WORKFILE Holds Temporary Work files and Deletes most of them after JOB ENDS
 

Table below list Files contained in the \TRANSACT directory. These are only used by the Reports Workstation. Please note that files in \TRANSACT directory in the Adjudicator are also present in the File Servers \TRANSACT Directory.

Files on \TRANSACT used by the Reports Work Station and resident on the File Server Description
ADJSAVE. and ADJSAVE.IDX Prior Adjustment file from last financial run
ADJUST and ADJUST.IDX Adjustment file for Financial Adjustments
CARDFILE File with New Members for MEMBER card creation
CLIYTD. and CLIYTD.IDX Year to Date client Statistics
FINDTL. and FINDTL.IDX Financial Accrual file
FINDTLSV. and FINDTLSV.IDX Prior Financial File from Last Financial Run
GRPYTD. And GRPYTD.IDX Year to date group statistics
ME.LOG Prior month chronological LOG FILE of CLAIMS
MEDTL. and MEDTL.IDX Prior month paid claim file
MEDTLS. And MEDTLS.IDX Prior Month Paid Claim File (Auxiliary)
 
Table below shows Files in the \TRANSIMP directory that are only used by the Reports Workstation.
CLAIM Sample Claim
CLAIM.SIM Sample Claim for SIMPLAN
TRANSACT Transaction Number file from SIMPLAN
 
Note that the contents of the MASTFILE directory are the same as that of the Adjudicator.Table below lists Files contained in the \MASTERS directory. These are only used by the Reports Workstation.
Files on \MASTERS used by the Reports Work Station and resident on the File Server DESCRIPTION
ADDRESS and ADDRESS.IDX Address file for MEMBERS.
ALTPR. and ALTPR.IDX Alternate Price file for Inquiries
DOCNAME. and DOCNAME.IDX Doctor by Name browse file.
DRUGEXTR. Drug Extract of MEDISPAN Updates
GENERICS. and GENERICS.IDX

Drugs with Mandated Generic Prices

GPI. and GPI.IDX Medispan GPI Name Browse
MFGR. and MFGR.IDX Manufacturer by Name Browse File.
PHARMZIP. and PHARMZIP.IDX Pharmacy by ZIP Code File Browser.
 
Table below lists Files in the \INQUIRY directory that are only used by the Reports Workstation.
Files on \INQUIRY used by the Reports Work Station and resident on the File Server Description
CHECKS. and CHECKS.IDX Check numbers for Claims where Checks were Printed
LOGyymm Claim Inquiry file by year and Month. Note that the format of the file name is <LOG><YY><MM> where <YY> is a 2 digit year and <MM> is a 2 digit month.
LOGMyymm. and LOGMyymm .IDX Claim Finder file by Member Year & Month
MEMBERC. and MEMBERC.IDX Claim Finder file by Member Current Month
ONLINE.LOG Claim Inquiry file Current Month
 
Table below lists Files contained in the \HISTORY directory. These are only used by the Reports Workstation.
Files on \HISTORY used by the Reports Work Station and resident on the File Server Description
DETLmmyy. Paid Claim File for each Month and Year. The format of the filename is <DETL><MM><YY> where mm is a 2 digit month and YY is a 2 digit year.
DTLSmmyy. and DTLSmmyy.IDX Optional Claim Info for Month & Year
 
Database Integrity between the Adjudicator and The File Server.

Daily Cycle
The following Diagram illustrates the Daily Nightly Cycle initiated at 12:00 p.m. by the Adjudicator.

At 12:00 P.M. the Adjudicator begins to copy all the contents of the directory \MASTFILE on the File Server to its Local Drive. It then copies all files in Directory \TRANSACT from the Adjudicator’s Local file to the \ADJUD directory on the File Server. Upon completion, it then creates a file \ADJUD\READY. This file \ADJUD\READY is used by a Reports Machine Workstation to commence copying all files from the ‘ADJUD directory to \TRANSACT in the File Server. Upon completion of the transfer process the Reports Machine Workstation then creates the previous day file for inquiry. Upon creation of the file \ADJUD\READY the Adjudicator has an option to back up all its files on tape and then commences processing of on line claims. Upon Completion of the Reports Machine Processing, it is advised that the Network administrator uses its own File Server backup utility to commence backing up all the File Server files.

 
Month End

The month end cycle first initiates a daily cycle. At the start of a new month, claims are archived to the \HISTORY and \INQUIRY directory. Note also, that the online detail files stored in the Adjudicators \TRANSACT directory, are copied to the \lastmth direcoory, then purged signaling the beginning of a new month. This enables faster processing in the Adjudicator machine.

 
Interface End User Applications

The TeleClaim System provides an export utility program that translates its databases into formats used by other Database(Oracle, Sybase, dBase, etc.) or Spreadsheet applications (Excel, Lotus, etc). This allows the users to create their own ad hoc reports and/or produce their own graphs.

 
 

This document is not for general publication. The recipient is strictly prohibited from reproducing or distributing the contents without prior written consent of DP/Rx Corp, 28047 Dorothy Drive, Suite 200, Agoura Hills, CA 91301. Phone (818) 865-0099.

Send mail to contact_us@dprx.com with questions or comments about this web site.

Copyright © 1996-2001 DP/Rx corporation.