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