Skip to main content

Advertisement

Table 11 Electronic medical records for two synthetic background patients.

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

A) Analysis Visit Table
AnalysisVisitID Patient ID Visit Count AVFirstVisitID AnalysisVisitDate
72835 60343 1 72835 15JUL2006:18:46:59
5326 62834 1 75326 23JUL2007:19:26:24
(Analysis Visit Table continued...)
AnalysisVisitEndDate AVPatClass AVBirthdate AVAge AVAgeRange
15JUL2006:21:05:04 E 23JUN2002:00:00:00 4 4-11 Years
23AUG2007:18:49:19 E 12SEP1995:00:00:00 11 4-11 Years
(Analysis Visit Table continued...)
AVGender AVRaceCode AVRace AVEthnicGroupCode AVEthnicGroup
F 2106-3 White 2186-5 Not Hispanic or Latino
M 2106-3 White 2186-5 Not Hispanic or Latino
(Analysis Visit Table continued...)
AVDischargeDispCode AVDischargeDisp AVAdmitDate AVDischargeDate
1 Discharged to home or self care (routine discharge) 15JUL2006:20:14:07 15JUL2006:21:07:21
1 Discharged to home or self care (routine discharge) 23AUG2007:16:57:59 23AUG2007:18:03:51
(Analysis Visit Table continued...)
AVDeceasedFlag AVDeceasedDate AVCASummary
   SORE THROAT;|462 |462 LEFT CLAVICULAR PAIN;|810.02|E884.0|786.59
(Analysis Visit Table continued...)
AVBucketSummary AVSubSynSummary AVSynSummary
Emergency - Chief Complaint|Emergency - Final Diagnosis| Emergency - Working Diagnosis Upper_respiratory_infections Respiratory
Emergency-CheifComplaint|Emergency - Final Diagnosis| Emergency - Final Diagnosis| Emergency - Working Diagnosis Falls|Fractures_and_dislocation
B) Clinical Activity Table
AnalysisVisitID CAKeyID PatientID AnalysisVisitDate PatientClass
72835 32096443 60343 15JUL2006:18:46:5 E
72835 32096444 60343 15JUL2006:18:46:59 E
72835 32096445 60343 15JUL2006:18:46:59 E
75326 32106099 62834 23JUL2007:19:26:24 E
75326 32106100 62834 23JUL2007:19:26:24 E
75326 32106101 62834 23JUL2007:19:26:24 E
75326 32106102 62834 23JUL2007:19:26:24 E
(Clinical Activity Table continued...)
ActivityType ActivitySource ActivityCode Activity Text
CC PV2 SORE THROAT;
DX DG1 462 462 ACUTE PHARYNGITIS
DX DG1 462 462 ACUTE PHARYNGITIS
CC PV2 LEFT CLAVICULAR PAIN
DX DG1 810.02 810.02 FX CLAVICLE SHAFT-CLOSED
DX DG1 E884.0 E884.0 FALL FROM PLAYGROUND EQUIPMENT
DX DG1 786.59 786.59 CHEST PAIN NEC
(Clinical Activity Table continued...)
ActivityDate CategoryType AnalysisAge AnalysisAgeUnit AnalysisGender
16JUL2006:10:04:00 Chief Complaint 4 Year F
16JUL2006:15:24:31 Final Diagnosis 4 Year F
16JUL2006:02:34:42 Working Diagnosis 4 Year F
26JUL2007:08:09:45 Chief Complaint 11 Year M
26JUL2007:13:39:56 Final Diagnosis 11 Year M
26JUL2007:19:26:24 Final Diagnosis 11 Year M
26JUL2007:19:26:24 Working Diagnosis 11 Year M
C) Laboratory Orders Table
PatientID AnalysisVisitID LabOrderKeyID ResultHeaderNumber OrderControl
60343 72835 1 NW
(Laboratory Orders Table continued...)
ServiceFacID VisitID AnalysisVisitDate AVServiceFacType PatientClass
45 609251 15JUL2006:00:00 RT E
(Laboratory Orders Table continued...)
OrderNumber FillerOrderNumber DiagnosticService OrderDate BeginDate
440026009 MB 15JUL2006:21:50:03
(Laboratory Orders Table continued...)
OrderedTestCode OrderedTestName OrderedTestCodingSystem OrderedTestCodeLocal
     STTH
(Laboratory Orders Table continued...)
OrderedTestNameLocal SpecimenTypeLocal
Strep Group A Culture (STTH) THT
D) No Laboratory Results for these patients
E) Radiology Orders Table
PatientID AnalysisVisitID RadOrderKeyID ResultHeaderNumber OrderControl
62834 75326 1 NW
(Radiology Orders Table continued...)
ServiceFaciD VisitID AnalysisVisitDate AVServiceFacType PatientClass
245 611742 25JUL2007:19:26:24 RT E
(Radiology Orders Table continued...)
Order Number RadiologyNumber DiagnosticService ReportDate ResultsStatus
440067632 RAD 26JUL2007:19:13:30 P
(Radiology Orders Table continued...)
OrderDate BeginDate OrderedTestNameLocal ReasonforTest
  26JUL2007:21:05:29 DX Clavicle LEFT Trauma
F) Radiology Results Table
PatientiD AnalysisVisitID RadResultKeyID ResultHeaderNumb OrderControl
62834 75326 5887812 1 RE
62834 75326 5887812 1 RE
(Radiology Results Table continued...)
ServiceFacID VisitID AnalysisVisitDate AVServiceFacType PatientClass
245 611742 25JUL2007:19:26:24 RT E
245 611742 25JUL2007:19:26:24 RT E
(Radiology Results Table continued...)
OrderNumber RadiologyNumber DiagnosticService ReportDate ResultStatus
440067632 RAD 27JUL2007:05:42:35 F
440067632 RAD 26JUL2007:20:41:53 F
(Radiology Results Table continued...)
ProcedureDate OrderedTestCodeLocal OrderedTestNameLocal ReasonForTest
26JUL2007:19:41:37 15488740 DX Clavicle LEFT Trauma
26JUL2007:20:39:31 15488740 DX Clavicle LEFT Trauma
(Radiology Results Table continued...)
  1. Some fields have been omitted for clarity; most of the omitted fields are blank.
  2. Impressions
  3. CLINICAL HISTORY: Pain following trauma. Technique: Two views were obtained. Comparison: None. Findings: There is a superiorly apex angulated, nondisplaced fracture of the mid clavicle. No pneumothorax is seen based on the view submitted. IMPRESSION: Nondisplaced fracture of the mid clavicle.
  4. CLINICAL HISTORY: Pain following trauma. Technique: Two views were obtained. Comparison: None. Findings: There is a superiorly apex angulated, nondisplaced fracture of the mid clavicle. No pneumothorax is seen based on the view submitted. IMPRESSION: Nondisplaced fracture of the mid clavicle.