Table 11.
Electronic medical records for two synthetic background patients.
| 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...) | ||||
Some fields have been omitted for clarity; most of the omitted fields are blank.
Impressions
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.
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.