Exception Resolving System

1
Exception Resolving System

• MAHI DATABASE FRAMEWORK
• CS 551
• FALL02
• -SANJEEV NAGARADDI
• -DIKSHA AGARWAL
• -PAMAJA NEELAM
• -SONAL PATIDAR

2
Why the need for our web service?

• The Shawnee Mission Health System admits
  thousands of patients each day for various
  medical concerns. One of the branches of this
  health system is the Mid America Heart Institute
  (MAHI), which deals with people who suffer from
  some cardiac ailment. Each night a proprietary
  application known as the Star Enterprise System
  FTPs an ASCII document that contains admission
  information about patients to intermediary
  systems that will eventually store this
  information in a clinical repository.
• In this nightly batch processing of Admission
  data from the enterprise systems it is possible
  for exceptions to occur preventing the creation
  of patient or admission data in the Clinical
  Explorer database.

3
A Snapshot from the Exception file
ltexception exception_text"Data for 'patient'
entity differs between incoming record and
database record!" record_number"11"
exception_code"5" entity_type"patient"gt-
ltentity record_number"11"gt  ltlname
quoted_type"true" uses_table"patient"gtAINSWORTHlt
/lnamegt   ltfname quoted_type"true"
uses_table"patient"gtBETTYlt/fnamegt   ltmiddle
quoted_type"true" uses_table"patient"gtJOlt/middle
gt   ltcpi quoted_type"true" uses_table"patient_xr
ef" xref_id_type"312"gt00648910lt/cpigt   ltadm_date
quoted_type"true" uses_table"admit"gt07/30/2002lt/
adm_dategt   ltdob quoted_type"true"
uses_table"patient"gt11/17/1925lt/dobgt   ltsex
uses_table"patient"gt1650lt/sexgt   ltrace
uses_table"patient"gt360lt/racegt   ltadm_dx
quoted_type"true" uses_table"admit"gtV76.12-SCREE
N MAMMOGRAM NEClt/adm_dxgt   ltmrno
quoted_type"true" uses_table"patient_xref"
xref_id_type"311"gt0000006545lt/mrnogt   ltssn
quoted_type"true" uses_table"patient"gt494209227lt
/ssngt   ltcontact_type uses_table"contact"gt44lt/con
tact_typegt   ltaddress1 quoted_type"true"
uses_table"contact"gt7411 W 101ST
TERRACElt/address1gt   ltcity quoted_type"true"
uses_table"contact"gtSHAWNEE MISSIONlt/citygt  
ltstate_province_id uses_table"contact"gtKSlt/state_
province_idgt   ltpostal_code quoted_type"true"
uses_table"contact"gt66212lt/postal_codegt  
ltptacctno quoted_type"true" uses_table"admit"gt02
21100638lt/ptacctnogt   lthosp_location_id
uses_table"admit"gt6lt/hosp_location_idgt  
lt/entitygt- ltdatabase_recordgt  ltpatient_idgt349205lt/
patient_idgt   ltlegacyidgt56387lt/legacyidgt  
ltlnamegtAINSWORTHlt/lnamegt   ltfnamegtBETTYlt/fnamegt  
ltmiddlegtJlt/middlegt   ltsexgt1650lt/sexgt  
ltracegt360lt/racegt   ltssngt493300290lt/ssngt  
ltdobgt5/8/1930lt/dobgt   ltcompletegt0lt/completegt  
ltusernamegtdbolt/usernamegt   ltmodify_timegt2/1/2001lt/
modify_timegt   lt/database_recordgt
4
A Snapshot from Exception Files
ltexception exception_text"Entity record matches
more than 1 'patient' record in database!"
record_number"27" exception_code"1"
entity_type"patient"gt- ltentity
record_number"27"gt  ltlname quoted_type"true"
uses_table"patient"gtANDERSONlt/lnamegt   ltfname
quoted_type"true" uses_table"patient"gtCAMYLAlt/fn
amegt   ltcpi quoted_type"true" uses_table"patient
_xref" xref_id_type"312"gt01464644lt/cpigt  
ltadm_date quoted_type"true" uses_table"admit"gt07
/30/2002lt/adm_dategt   ltdob quoted_type"true"
uses_table"patient"gt01/25/1979lt/dobgt   ltsex
uses_table"patient"gt1650lt/sexgt   ltrace
uses_table"patient"gt360lt/racegt   ltmrno
quoted_type"true" uses_table"patient_xref"
xref_id_type"311"gt0001314600lt/mrnogt   ltssn
quoted_type"true" uses_table"patient"gt508119412lt
/ssngt   ltcontact_type uses_table"contact"gt44lt/con
tact_typegt   ltaddress1 quoted_type"true"
uses_table"contact"gt195 SE 51 RDlt/address1gt  
ltcity quoted_type"true" uses_table"contact"gtWARR
ENSBURGlt/citygt   ltstate_province_id
uses_table"contact"gtMOlt/state_province_idgt  
ltpostal_code quoted_type"true"
uses_table"contact"gt64093lt/postal_codegt  
ltptacctno quoted_type"true" uses_table"admit"gt02
21100716lt/ptacctnogt   lthosp_location_id
uses_table"admit"gt2lt/hosp_location_idgt  
lt/entitygt- ltmatchesgt- ltentitiesgt  ltentity
weight"1095" entity_id"18433" /gt   ltentity
weight"1095" entity_id"132576" /gt  
lt/entitiesgt  ltentity_countgt2lt/entity_countgt  
lt/matchesgt  lt/exceptiongt
5
Why the need for our web service?cont..

•  A query component was proposed that would query
  these exception files when a query by the user
  returns no rows against the database.
• Our component would locate a record in the
  exception files which is in XML format.
• The entity data within the exception file will be
  extracted and reformatted into another XML file
  format, which is used for data recovery in the
  Clinical Explorer UI.
• This file is then bound to a form in the UI
  allowing the user to create the entity in the
  database.
•  

6
 
7
(No Transcript)
8
Exception Resolving System
Exception Resolving System
Exception Resolving System
9
Exception Resolving System
Forwarding
Receiving
Advanced search
search request
Query - Mahi DB
initiated
more than zero matches
returned
zero matches returned
returning results to
searching
clinical explorer
exception files
no match found
gt1 match found
exactly one match found
returning recovery file to
returning null string
receiving choice
clinical explorer
to clinical explorer
of node
returning results to
clinical explorer
receving confirmation
for deleting node
Deleting
the node
10
Exception Resolving System
Totally new patient no matches found in the
database or Exception Files
1 Advanced Search
2 Find Entity in DB
Clinical Explorer
MahiExWebService
MahiDBWebService
3 Return zero matches
8 Return null string
4 Find in exception files
7 Pass null string
MahiExFileResolver
5 Search in exception files
6 Return zero matches
ExFilesDirectory
11
Exception Resolving System
No matches found in the Database but a single
match found in exception files
2 Find Entity in DB
1 Advanced Search
Clinical Explorer
MahiExWebService
MahiDBWebService
3 Return Zero matches
8 Pass Recovery File
4Find in Exception Files
7 Recovery File
MahiExFileResolver
5 Search in Exception Files
6 Return Single Record
ExFilesDirectory
12
Exception Resolving System
No matches found in the database but more than
one found in exception files  
1 Advanced Search
Clinical Explorer
MahiExWebService
2 Find Entity in DB


MahiDBWebService
8 Pass all matches
9 Pass selected choice
3 Return zero matches
12 Pass recovery file
13 Send delete confirmation
 
10 Pass selected choice
4 Find in exception files
11 Pass recovery file
7 Pass all matches
14 Perform Delete
 
MahiExFileResolver
15 Delete the node
5 Search in exception files
6 Return all matches
ExFilesDirectory
13
Exception Resolving System
One or more match found in the Database
1
Advanced Search
2 Find Entity in DB
4 Pass all matches
3 Return all matches  
  Clinical Explorer
 
  MahiExWebService
  MahiDBWebService
14
Exception Resolving SystemClass Diagram