Problem

Represents a problem header within source system.

Table 1. Problem

Database Field Name	Field Description	Sensitive Field	Identifiable Field	Field Type	Field Length	Optionality
actual_problem	Utilised where source system 'generates' the problem headers	Yes	No	String	an36	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
id	Persistent record identifier for resource	Yes	No	String	an36	M
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
problem_id	Supports problem hierarchy grouping	Yes	No	String	an36	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
relation	The type of relation to a related problem e.g. nested, combine, evolve	Yes	No	String	min an5 max an12	O
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
significance	Captures significance of problem - major, minor etc.	Yes	No	String	an5	O
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
status	Whether problem is active/inactive etc.	Yes	No	String	min an6 max an8	M
template_id	Links the resource to a template header	Yes	No	String	an36	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