Skip to main content

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