| patientguid | varchar | References the patient in Admin_Patient. Part of the composite primary key. | {F6A7B8C9-D0E1-2345-FABC-456789012345} | 38 | False |
| organisationguid | varchar | References the practice where the status change occurred. Part of the composite primary key. | {C3D4E5F6-A7B8-9012-CDEF-123456789012} | 38 | False |
| historydate | date | The date of the registration status change event. | 2021-09-14 | 3 | False |
| historytime | time | The time of the registration status change event. | 11:00:00 | 5 | False |
| statusdescription | varchar | The patient’s registration status at this point in time (e.g., Registered, Deducted, Deceased). | Registered | 200 | True |
| patienttypedescription | varchar | The patient type recorded at the time of the event (e.g., Regular, Temporary). | Regular | 30 | False |