Table 10.
Electronic medical records for two synthetic tularemia inject patients.
| 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...) | |||||
Some fields have been omitted for clarity; most of the omitted fields are blank.
Impressions
PA AND LATERAL VIEWS OF CHEST Findings: Multiple parenchymal infiltrates seen bilaterally. There are bilateral pleural effusions
PA AND LATERAL VIEWS OF CHEST Findings: Multiple parenchymal infiltrates seen bilaterally. There are bilateral pleural effusions
PA AND LATERAL VIEWS OF CHEST Findings: Multiple parenchymal infiltrates seen bilaterally. There are bilateral pleural effusions