Table 11 Electronic medical records for two synthetic background patients.

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...)