Schema

Column Name	Data Type	Description	Example	Max Length	Is Null
observationguid	varchar	Unique identifier for the problem observation, shared with CareRecord_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
parentproblemobservationguid	varchar	References a parent problem observation, enabling hierarchical problem relationships.	{O5P6Q7R8-S9T0-1234-UVWX-345678901234}	38	True
deleted	boolean	Indicates whether the record is deleted. Always false in this BulkView.	false	1	True
comment	varchar	Free-text clinician notes about the problem.	Patient reports symptoms worsening	8000	True
enddate	date	The date the problem was resolved or closed. Null if still active.	2024-08-01	3	True
enddateprecision	varchar	The precision of the end date (e.g., YMD = Year/Month/Day).	YMD	100	False
expectedduration	smallint	The anticipated duration of the condition in days.	28	2	False
lastreviewdate	date	The date the problem was last reviewed by a clinician.	2025-01-15	3	True
lastreviewdateprecision	varchar	The precision of the last review date (e.g., YMD = Year/Month/Day).	YMD	100	True
lastreviewuserinroleguid	varchar	References the clinician who last reviewed this problem.	{G7H8I9J0-K1L2-3456-MNOP-567890123456}	38	True
parentproblemrelationship	varchar	Describes the relationship to the parent problem (e.g., Cause Of, Complication Of).	Grouped	20	True
problemstatusdescription	varchar	The current status of the problem (e.g., Active, Inactive, Resolved).	Active Problem	50	False
significancedescription	varchar	The clinical significance of the problem (e.g., Significant, Minor).	Minor Problem	20	False