Problem Link

Linkage between record entries and problems. A record entry may be linked to more than one problem.

Table 1. Problem_link

Database Field Name	Field Description	Sensitive Field	Identifiable Field	Field Type	Field Length	Optionality
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
event_id	Reference to the record entry which is linked to the problem	Yes	No	String	an36	M
id	Persistent record identifier for resource	Yes	No	String	an36	M
patient_id_deid	NHS number DE-IDENTIFIED	Yes	No	String	an200	M
problem_id	References the problem record to which the record entry is linked	Yes	No	String	an36	M
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