| observationguid | varchar | Unique identifier for the observation. Part of the composite primary key. | {N4O5P6Q7-R8S9-0123-TUVW-234567890123} | 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 clinical date of the observation. | 2025-01-08 | 3 | True |
| effectivedateprecision | varchar | The precision of the effective date (e.g., YMD = Year/Month/Day). | YMD | 100 | False |
| entereddate | date | The date the observation was entered into EMIS Web. | 2025-01-08 | 3 | False |
| enteredtime | time | The time the observation was entered into EMIS Web. | 11:00:00 | 5 | True |
| clinicianuserinroleguid | varchar | References the clinician who recorded the observation. | {G7H8I9J0-K1L2-3456-MNOP-567890123456} | 38 | False |
| enteredbyuserinroleguid | varchar | References the staff member who entered the record. | {G7H8I9J0-K1L2-3456-MNOP-567890123456} | 38 | False |
| parentobservationguid | varchar | References a parent observation for hierarchical coded entries. | {O5P6Q7R8-S9T0-1234-UVWX-345678901234} | 38 | False |
| codeid | bigint | References the clinical code in Coding_ClinicalCode. | 284596015 | 8 | False |
| problemguid | varchar | References an associated problem in CareRecord_Problem. | {P6Q7R8S9-T0U1-2345-VWXY-456789012345} | 38 | True |
| consultationguid | varchar | References the parent consultation in CareRecord_Consultation. | {L2M3N4O5-P6Q7-8901-RSTU-012345678901} | 38 | True |
| associatedtext | xml | Freetext up to 8000 characters. | 1 letter | | True |
| value | decimal | The numeric value for result observations. | 135 | 9 | True |
| numericunit | varchar | Unit of measure for the numeric value. | 10*9/L | 60 | True |
| observationtype | varchar | Classifies the type of observation (e.g., Allergy, Immunisation, Test Result). | Observation | 20 | True |
| originalterm | varchar | The clinical term as originally entered by the clinician. | Height and weight | 8000 | True |
| numericrangelow | decimal | Lower bound of the reference range for the numeric value. | 31.00 | 9 | True |
| numericrangehigh | decimal | Upper bound of the reference range for the numeric value. | 31.00 | 9 | True |
| documentguid | varchar | References an associated document, if applicable. | {D4E5F6A7-B8C9-0123-DEFA-234567890123} | 38 | True |
| qualifiers | varchar | Qualifier codes providing additional clinical context. | Left sided | 8000 | True |
| abnormal | boolean | Indicates whether the result is flagged as abnormal. | true | 1 | False |
| abnormalreason | varchar | Description of why the result is considered abnormal. | LO | 50 | True |
| episode | varchar | Episodicity of the observation (e.g., First, Review, Update). | First | 10 | False |
| deleted | boolean | Indicates whether the record is deleted. Always false in this BulkView. | false | 1 | False |
| isconfidential | boolean | Indicates whether the observation is marked as confidential. | false | 1 | False |
| numericoperator | varchar | Comparison operator for the numeric value (e.g., =, >, <). | > | | True |