EHI Export Schema
EncounterDocument
Table containing documents generated during patient encounters.
| Column Name | Data Type | Constraint Type | Is Nullable |
|---|---|---|---|
| EncounterDocumentId | int | PK | NO |
| EncounterId | int | FK | NO |
| DocumentTypeId | int | FK | NO |
| DocumentVersion | int | NO | |
| DocumentAdded | datetime | YES | |
| DocumentContent | varchar(max) | YES | |
| Created | datetime | YES | |
| CreatedBy | varchar(100) | YES | |
| Modified | datetime | YES | |
| ModifiedBy | varchar(100) | YES | |
| Deleted | datetime | YES | |
| DeletedBy | varchar(100) | YES | |
| RecipientId | int | FK | YES |
| SenderId | int | FK | YES |
| DocumentTitle | varchar(100) | YES | |
| DocumentFinalized | datetime | YES | |
| RecipientName | varchar(200) | YES | |
| RecipientFax | varchar(100) | YES | |
| EncounterOrderTrakOrderId | int | FK | YES |
| SetId | int | YES |
