EHI Export Schema
EncounterFinding
Table documenting findings from patient encounters.
| Column Name | Data Type | Constraint Type | Is Nullable |
|---|---|---|---|
| EncounterFindingId | int | PK | NO |
| EncounterId | int | FK | YES |
| FindingId | int | FK | YES |
| FindingText | varchar(500) | YES | |
| UnitsText | varchar(50) | YES | |
| PeriodStart | datetime | YES | |
| FindingActionId | int | FK | YES |
| Comments | varchar(max) | YES | |
| Created | datetime | YES | |
| CreatedBy | varchar(100) | YES | |
| Modified | datetime | YES | |
| ModifiedBy | varchar(100) | YES | |
| Deleted | datetime | YES | |
| DeletedBy | varchar(100) | YES | |
| AbnormalDismissed | datetime | YES | |
| AbnormalDismissedBy | varchar(100) | YES | |
| SmartObservationId | varchar(100) | YES | |
| SmartObservationVersion | varchar(128) | YES | |
| SmartObservationIdentifierSystem | varchar(128) | YES | |
| SmartObservationIdentifierValue | varchar(128) | YES |
