Encounter

Represents encounter/consultation records in source systems.

Table 1. Encounter
Database Field Name	Field Description	Sensitive Field	Identifiable Field	Field Type	Field Length	Optionality
appointment_id	Appointment associated with consultation	Yes	No	String	an36	O
ctv3_code	The encounter type (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
duration	Duration of encounter in seconds	Yes	No	Decimal	min an1 max an10	O
effective_date	Encounter start time	Yes	No	Timestamp	min an4 max an23	O
end_date	Encounter end time	Yes	No	Timestamp	min an4 max an23	O
id	Persistent record identifier for resource	Yes	No	String	an36	M
location	The coded encounter location	Yes	No	String	min n6 max n18	O
organisation	The NHS Organisation where the encounter occurred	Yes	No	String	an36	O
other_code	The encounter type (See codable concept)	Yes	No	See codable concept	See codable concept	See codable concept
other_code_system	The encounter type (See codable concept)	Yes	No	See codable concept	See codable concept	See codable concept
other_display	The encounter type (See codable concept)	Yes	No	See codable concept	See codable concept	See codable concept
other_expession	The encounter type (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
readv2_code	The encounter type (See codable concept)	Yes	No	See codable concept	See codable concept	O
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 encounter type (See codable concept)	Yes	No	See codable concept	See codable concept	See codable concept
snomed_concept_id	The encounter type (See codable concept)	Yes	No	See codable concept	See codable concept	See codable concept
snomed_description_id	The encounter type (See codable concept)	Yes	No	See codable concept	See codable concept	See codable concept
snomed_expression	The encounter type (See codable concept)	Yes	No	See codable concept	See codable concept	See codable concept
user_selected	The encounter type (See codable concept)	Yes	No	See codable concept	See codable concept	See codable concept