Skip to main content

Advertisement

Table 10 Electronic medical records for two synthetic tularemia inject patients.

From: Data-driven approach for creating synthetic electronic medical records

A) Analysis Visit Table
Analysis Visit ID Patient ID Analysis Visit Date Analysis Visit End Date AVPatClass  
536919 214973 03AUG2006:05:27:01 03AUG 2006:05:7:01 E  
536120 210042 18AUG2006:07:49:21 27AUG2006:18:00:33 O  
( Analysis Visit Table continued...)  
AVBirthdate AVStandardAge AVAgeRange AVGender AVRaceCode AVRace
25AUG1981:00:00:00 25 20-49 Male 2106-3 White
03JUN1957:00:00:00 47 20-49 Female 2106-3 White
(Analysis Visit Table continued...)
AVEthnicGroupCode AVEthnicGroup AVDischarge Disp Code AVDischargeDisp
2186-5 Not Hispanic or Latino 1 Discharged to home or self care (routine discharge)
2186-5 Not Hispanic or Latino 1 Discharged to home or self care (routine discharge)
(Analysis Visit Table continued...)
AVDischargeDate AVPOC AVPOCDate AVDeceaseFlag AVAdmissionTypeCode
04AUG2006:05:37:50 ER 03AUG2006:05:27:01   E
20AUG2006:01:24:37 RA3 19AUG2006:02:41:11   E
(Analysis Visit Table continued...)
AVCASummary AVBucketSummary AVSubSynSummary AVSynSummary
FEVER,OTHER FLULIKE SYMPTOMS; |Emergency - Chief Complaint| |Fever |Influenza-like illness| |Fever|Respiratory
780.6 FEVER; 786.2 COUGH;COUG AND FEVER |Outpatient - Final Diagnosis|Outpatient - Reason for Visit|Outpatient - Working Diagnosis |Cough|Fever| |Respiratory|Fever|
B) Clinical Activity Table
AnalysisVisitID PatientID AnalysisVIsitDate PatientClass ActivityType ActivitySource
536919 214973 03AUG2006:05:27:01 E CC PV2
536120 210042 18AUG2006:07:49:21 O CC PV2
536120 210042 18AUG2006:07:49:21 O DX DG1
536120 210042 18AUG2006:07:49:21 O DX DG1
536120 210042 18AUG2006:07:49:21 O DX DG1
(Clinical Activity Table continued...)
ActivityCode ActivityText ActivityDate ActivityStatus SourceType
  FEVER OTHER FLU LIKE SYMPTOMS 03AUG2006:05:27:01   Hospital
  COUG AND FEVER 18AUG2006:07:49:21   Hospital
786.2 786.2 COUGH 18AUG2006:07:49:21 F Hospital
780.6 780.6 FEVER 18AUG2006:07:49:21 F Hospital
786.2 786.2 COUGH 18AUG2006:07:49:21 A Hospital
(Clinical Activity Table continued...)
CategoryType EffectiveBeginDate EffectiveEndDate AnalysisAge AnalysisAgeUnit
Chief Complaint 03AUG2006:06:18:51 03AUG2006:05:27:01 25 Year
Reason For Visit 18AUG2006:22:04:34 18AUG2006:07:49:23 47 Year
Final Diagnosis 27AUG2006:10:31:30 27AUG2006:03:32:34 47 Year
Final Diagnosis 27AUG2006:19:47:07 18AUG2006:07:49:21 47 Year
Final Diagnosis 27AUG2006:17:57:09 18AUG2006:07:49:21 47 Year
(Clinical Activity Table continued...)
AnalysisGender SubSynBitmapText SynBitmapText SubSynIncBitmapText
Male |Fever|Influenza-like Illness| |Fever|Respiratory| |Fever|Influenza-like Illness|
Female |Cough|Fever| |Respiratory|Fever| |Cough|Fever|
Female |Cough| |Respiratory| |Cough||
Female |Fever| |Fever| |Fever|
Female |Respiratory| |Respiratory| |Cough|
(Clinical Activity Table continued...)
SubSynIncBitmapRules SynIncBitmapText SynIncBitmapRules
|566|4749| |Fever|Respiratory| |2324|3309|
|296|566| |Respiratory|Fever| |3298|2324|
|2165| |Respiratory| |2885|
C) There are no laboratory orders for these two patients.
D There are no laboratory results for these two patients.
E) Radiology Order Table
PatientID AnalysisVisitID OrderControl AnalysisVisitDate AVServicFacType
210042 536120 NW 18AUG2006:07:49:21 RT
(Radiology Orders continued...)
PatientClass Order Number DiagnosticService ReportDate Results Status
O 44404327 RAD 19AUG2006:03:01:01 P
(Radiology Orders continued...)
BeginDate OrderedTestCodeLocal Ordered TestNameLocal ReasonForTest
19AUG2006:03:01:01 15488699 DX Chest 2 View COUGH AND FEVER
F) Radiology Results Table
PatientID AnalysisVisitID RadResultKeyID ResultHeaderNumber AnalysisVisitDate
210042 536120   1 18AUG2006:07:49:21
210042 536120   1 18AUG2006:07:49:21
210042 536120   1 18AUG2006:07:49:21
(Radiology Results continued...)
AVServiceFacType PatientClass Order Number Diagnostic Service ReportDate Results Status
RT O 444004327 RAD 19AUG2006:06:06:32 P
RT O 444004327 RAD 19AUG2006:06:55:41 F
RT O 444004327 RAD 19AUG2006:08:59:32 F
(Radiology Results continued...)
ProcedureDate OrderedTestCodeLocal OrderedTestNameLocal ReasonForTest
18AUG2006:14:01:40 15488699 DX Chest 2 View COUGH AND FEVER
18AUG2006:10:32:15 15488699 DX Chest 2 View COUGH AND FEVER
18AUG2006:11:15:24 15488699 DX Chest 2 View COUGH AND FEVER
(RadiologyResults continued...)
  1. Some fields have been omitted for clarity; most of the omitted fields are blank.
  2. Impressions
  3. PA AND LATERAL VIEWS OF CHEST Findings: Multiple parenchymal infiltrates seen bilaterally. There are bilateral pleural effusions
  4. PA AND LATERAL VIEWS OF CHEST Findings: Multiple parenchymal infiltrates seen bilaterally. There are bilateral pleural effusions
  5. PA AND LATERAL VIEWS OF CHEST Findings: Multiple parenchymal infiltrates seen bilaterally. There are bilateral pleural effusions