| patientguid | varchar | References the patient whose registration was modified. Part of the composite primary key. | {F6A7B8C9-D0E1-2345-FABC-456789012345} | 38 | False |
| organisationguid | varchar | References the practice where the event occurred. Part of the composite primary key. | {C3D4E5F6-A7B8-9012-CDEF-123456789012} | 38 | False |
| modifieddate | date | The date the registration change was processed. | 2022-07-05 | 3 | False |
| modifiedtime | time | The time the registration change was processed. | 11:00:00 | 5 | False |
| userinroleguid | varchar | References the staff member who processed the registration change. | {G7H8I9J0-K1L2-3456-MNOP-567890123456} | 38 | True |
| modetype | varchar | The type of registration action (e.g., New Registration, Deduction, Transfer In). | Delete | 100 | False |