| diaryguid | varchar | Unique identifier for the diary entry. Part of the composite primary key. | {M3N4O5P6-Q7R8-9012-STUV-123456789012} | 38 | False |
| patientguid | varchar | References the patient in Admin_Patient. | {F6A7B8C9-D0E1-2345-FABC-456789012345} | 38 | False |
| organisationguid | varchar | References the practice in Admin_Organisation. | {C3D4E5F6-A7B8-9012-CDEF-123456789012} | 38 | False |
| effectivedate | date | The date the diary action is due or was recorded. | 2025-06-01 | 3 | True |
| effectivedateprecision | varchar | The precision of the effective date (e.g., YMD = Year/Month/Day). | YMD | 100 | True |
| entereddate | date | The date the diary record was created in EMIS Web. | 2025-03-10 | 3 | True |
| enteredtime | time | The time the diary record was created in EMIS Web. | 11:00:00 | 5 | True |
| clinicianuserinroleguid | varchar | References the clinician responsible for the diary action. | {G7H8I9J0-K1L2-3456-MNOP-567890123456} | 38 | True |
| enteredbyuserinroleguid | varchar | References the staff member who entered the record. | {G7H8I9J0-K1L2-3456-MNOP-567890123456} | 38 | True |
| codeid | bigint | References the clinical code for this diary entry in Coding_ClinicalCode. | 284596015 | 8 | False |
| originalterm | varchar | The clinical term as originally entered by the clinician. | Asthma Review | 200 | False |
| durationterm | varchar | Duration term associated with the diary entry, if applicable. | 3 months | 50 | True |
| locationtypedescription | varchar | Location type associated with the diary entry, if applicable. | G.P.Surgery | 50 | True |
| deleted | boolean | Indicates whether the record is deleted. Always false in this BulkView. | false | 1 | False |
| isconfidential | boolean | Indicates whether the diary entry is marked as confidential. | false | 1 | True |
| isactive | boolean | Indicates whether the diary entry is currently active. | true | 1 | False |
| iscomplete | boolean | Indicates whether the diary action has been completed. | false | 1 | False |
| consultationguid | varchar | References the parent consultation in CareRecord_Consultation. | {L2M3N4O5-P6Q7-8901-RSTU-012345678901} | 38 | True |
| associatedtext | varchar | Free text limited to 8000 characters. Available if the sharing agreement has freetext configured. | Admin tag | 8000 | True |