EHI Export Schema
PersonAmendment
Table documenting amendments made to patient records.
| Column Name | Data Type | Constraint Type | Is Nullable |
|---|---|---|---|
| PersonAmendmentId | int | PK | NO |
| PersonId | int | FK | YES |
| DocumentedEncounterId | int | FK | YES |
| AmendmentSourceId | int | FK | YES |
| RequestDate | datetime | YES | |
| RequestText | varchar(max) | YES | |
| AmendmentDecisionId | int | FK | YES |
| DecisionComment | varchar(max) | YES | |
| SigningProviderId | int | FK | YES |
| Signed | datetime | YES | |
| Created | datetime | YES | |
| CreatedBy | varchar(100) | YES | |
| Modified | datetime | YES | |
| ModifiedBy | varchar(100) | YES | |
| Deleted | datetime | YES | |
| DeletedBy | varchar(100) | YES |
