Observation

Represents record entries in the source system mapped to Observation resources and is the default record type for all source record content which is not mapped to a more specific resource type. Despite the name, the catch all nature of the Observation resources means that this resource type will carry a range of coded content and will not be restricted to 'observables'.

Table 1. Observation
Database Field Name	Field Description	Sensitive Field	Identifiable Field	Field Type	Field Length	Optionality
comparator	Result comparator for VALUE 1	Yes	No	String	min an1 max an2	O
ctv3_code	The main clinical code recorded against the source record entry. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
deletion_flag	Flag specifying that the source record entry has been deleted and receiving systems should logically delete the corresponding record	Yes	No	Boolean	min an4 max an5	O
effective_date	The user modifiable most clinically significant date for the record entry.	Yes	No	Timestamp	min an4 max an23	O
encounter_id	The encounter within which the source record entry was made or pertains to	Yes	No	String	an36	O
end_date	Provides any explicit end date associated with the source record entry	Yes	No	Timestamp	min an4 max an23	O
episodicity	The condition episodicity - first, etc.	Yes	No	String	min an3 max an6	O
id	Persistent record identifier for resource	Yes	No	String	an36	M
interpretation_code	The abnormality indicator for the result	Yes	No	String	min an1 max an32	O
is_template_header	Flags that the source record is a template header	Yes	No	Boolean	min an4 max an5	O
other_code	The main clinical code recorded against the source record entry. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
other_code_system	The main clinical code recorded against the source record entry. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
other_display	The main clinical code recorded against the source record entry. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
other_expession	The main clinical code recorded against the source record entry. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
patient_id_deid	NHS number DE-IDENTIFIED	Yes	No	String	an200	O
practitioner_id	The clinical attribution of the record entry	Yes	No	String	an36	M
range_lower	The lower value of the reference range used to determine abnormality of a test result	Yes	No	Decimal	min an1 max an10	O
range_upper	The upper value of the reference range used to determine abnormality of a test result	Yes	No	Decimal	min an1 max an10	O
readv2_code	The main clinical code recorded against the source record entry. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
recorded_date	The source system audit trail timestamp of when the source record was created, amended or deleted	Yes	No	Timestamp	min an4 max an23	M
registration_id	The unique supplier generated persistent technical key for the registration	Yes	No	String	an36	M
rubric	The main clinical code recorded against the source record entry. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
snomed_concept_id	The main clinical code recorded against the source record entry. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
snomed_description_id	The main clinical code recorded against the source record entry. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
snomed_expression	The main clinical code recorded against the source record entry. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
template_id	Links the resource to a template header	Yes	No	String	an36	O
uom	The unit of measure associated with the recorded values	Yes	No	String	min an1 max an32	O
uom_ucum	The ucum unit of measure associated with the recorded values	Yes	No	String	min an1 max an32	O
user_selected	The main clinical code recorded against the source record entry. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
value_ctv3_code	Represent secondary code associated with observation - allows generic means of representing post coordinated expressions. See codable concept	Yes	No	See codable concept	See codable concept	O
value_date	A date value associated with the code distinct from the clinically relevant time or end date	Yes	No	Timestamp	min an4 max an23	O
value_other_code	Represent secondary code associated with observation - allows generic means of representing post coordinated expressions. See codable concept	Yes	No	See codable concept	See codable concept	O
value_other_code_system	Represent secondary code associated with observation - allows generic means of representing post coordinated expressions. See codable concept	Yes	No	See codable concept	See codable concept	O
value_other_display	Represent secondary code associated with observation - allows generic means of representing post coordinated expressions. See codable concept	Yes	No	See codable concept	See codable concept	O
value_other_expession	Represent secondary code associated with observation - allows generic means of representing post coordinated expressions. See codable concept	Yes	No	See codable concept	See codable concept	O
value_pq_1	The value associated with the observation	Yes	No	Decimal	min an1 max an10	O
value_pq_2	Second value associated with the observation	Yes	No	Decimal	min an1 max an10	O
value_readv2_code	Represent secondary code associated with observation - allows generic means of representing post coordinated expressions. See codable concept	Yes	No	See codable concept	See codable concept	O
value_rubric	Represent secondary code associated with observation - allows generic means of representing post coordinated expressions. See codable concept	Yes	No	See codable concept	See codable concept	O
value_snomed_concept_id	Represent secondary code associated with observation - allows generic means of representing post coordinated expressions. See codable concept	Yes	No	See codable concept	See codable concept	O
value_snomed_description_id	Represent secondary code associated with observation - allows generic means of representing post coordinated expressions. See codable concept	Yes	No	See codable concept	See codable concept	O
value_snomed_expression	Represent secondary code associated with observation - allows generic means of representing post coordinated expressions. See codable concept	Yes	No	See codable concept	See codable concept	O
value_string	Non free text string value associated with the coded record entry. See codable concept	Yes	No	See codable concept	See codable concept	O
value_user_selected	Represent secondary code associated with observation - allows generic means of representing post coordinated expressions. See codable concept	Yes	No	See codable concept	See codable concept	O