| ONLINE
TRANSACTION DATA FLOW |
|
Español Castellano Portuguese
|
|
|
|
| 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. |
| |
|