EHI Export Schema
PersonProblem
Table documenting problems identified in patients.
| Column Name | Data Type | Constraint Type | Is Nullable |
|---|---|---|---|
| PersonProblemId | int | PK | NO |
| PersonId | int | FK | NO |
| ClinicalConceptId | int | NO | |
| ProblemStatusId | int | FK | NO |
| ProblemOutcomeId | int | FK | YES |
| Onset | datetime | YES | |
| Noted | datetime | YES | |
| Resolved | datetime | YES | |
| Created | datetime | NO | |
| CreatedBy | varchar(100) | NO | |
| Modified | datetime | NO | |
| ModifiedBy | varchar(100) | NO | |
| Deleted | datetime | YES | |
| DeletedBy | varchar(100) | YES | |
| PersonCarePlanId | int | FK | YES |
| Location | varchar(max) | YES | |
| CommonName | varchar(150) | YES | |
| ClinicalConceptDescription | varchar(500) | YES | |
| DiagnosisCodes | varchar(100) | YES | |
| SmartConditionIdentifier | varchar(128) | YES | |
| CarePlanModelId | int | FK | YES |
| InternalDrFirstId | varchar(50) | YES | |
| ExternalId | bigint | YES | |
| ProblemAlternateId | int | YES | |
| CurrentPresentOnAdmission | bit | YES | |
| ReactivatedDate | datetime | YES |
