EHI Export Schema
PersonProblemAncestor
Table tracing the typed lineage of patient problems: merge, reactivation, and superseded (diagnosis-change) links via ProblemAncestorTypeId.
| Column Name | Data Type | Constraint Type | Is Nullable |
|---|---|---|---|
| PersonProblemAncestorId | int | PK | NO |
| PersonProblemId | int | FK | NO |
| AncestorProblemId | int | FK | YES |
| Created | datetime | YES | |
| CreatedBy | varchar(100) | YES | |
| Modified | datetime | YES | |
| ModifiedBy | varchar(100) | YES | |
| Deleted | datetime | YES | |
| DeletedBy | varchar(100) | YES | |
| ProblemAncestorTypeId | int | FK | YES |
| EncounterId | int | FK | YES |
