Medication

Represents medication records in source systems.

Table 1. Medication

Database Field Name	Field Description	Sensitive Field	Identifiable Field	Field Type	Field Length	Optionality
agency	Identifies the source of the medication - in or out of practice	Yes	No	String	min an27 max an34	M
authorisation_id	Provides the link between a medication issue and it's authorisation	Yes	No	String	an36	O
ctv3_code	The product/substance being prescribed. 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
dose	The dosage instructions associated with the prescription	Yes	No	String	min an1 max an256	O
dose_structured	The dosage instruction in structured dose form as XML encoded JSON. Encodes the Medication Request/dosage Instruction element and contents	Yes	No	String	min an1 max an1024	O
duration	The expected supply duration	Yes	No	Decimal	min an1 max an10	O
duration_uom	The Ucum UoM for the supply duration	Yes	No	String	min an1 max an32	O
effective_date	The start date for an authorisation or issue date of a medication	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
eps_id	The Electonic Prescription Service (EPS) Prescription identifier	Yes	No	String	an36	O
id	Persistent record identifier for resource	Yes	No	String	an36	M
intent	Distinguishes between authorisation and issue. 'plan' signals authorisation. 'order' = issue	Yes	No	String	min an4 max an5	M
number_authorised	For a repeat authorisation the number of issues authorised	Yes	No	Decimal	min an1 max an10	O
other_code	The product/substance being prescribed. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
other_code_system	The product/substance being prescribed. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
other_display	The product/substance being prescribed. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
other_expession	The product/substance being prescribed. 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 prescriber - the clinician attributed to the prescription issue or authorisation	Yes	No	String	an36	M
quantity	The quantity of the medication prescribed	Yes	No	Decimal	min an1 max an10	O
readv2_code	The product/substance being prescribed. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
reason_ref	Reference to an observation resource providing the coded reason the medication was prescribed	Yes	No	String	an36	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
reimburse_type	The type of prescription from re-imbursement perspective. Because the vocabulary values are not mutually exclusive e.g. a medication could be private and personally administered, the field accepts a colon seprated list of codes from the specified vocabulary	Yes	No	String	min an1 max an1024	O
review_date	GP system generated review date for medication authorisation	Yes	No	Timestamp	min an4 max an23	O
rubric	The product/substance being prescribed. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
snomed_concept_id	The product/substance being prescribed. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
snomed_description_id	The product/substance being prescribed. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
snomed_expression	The product/substance being prescribed. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
status	The status of the medication - used primarily to identify the status of repeat authorisations	Yes	No	String	min an6 max an8	M
stop_ctv3_code	The coded reason for stopping the medication. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
stop_date	The date the medication was stopped or discontinued	Yes	No	Timestamp	min an4 max an23	O
stop_other_code	The coded reason for stopping the medication. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
stop_other_code_system	The coded reason for stopping the medication. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
stop_other_display	The coded reason for stopping the medication. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
stop_other_expession	The coded reason for stopping the medication. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
stop_readv2_code	The coded reason for stopping the medication. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
stop_rubric	The coded reason for stopping the medication. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
stop_snomed_concept_id	The coded reason for stopping the medication. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
stop_snomed_description_id	The coded reason for stopping the medication. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
stop_snomed_expression	The coded reason for stopping the medication. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept
stop_user_selected	The coded reason for stopping the medication. 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
type	Explicitly identifies the prescription type e.g. acute, repeat, prescribed elsewhere etc.	Yes	No	String	man an5 max an17	M
uom	The unit of measure associated with the prescribed quantity	Yes	No	String	min an1 max an32	O
uom_dmd	The SNOMED CT DM+D Unit of measure associated with the prescribed quantity	Yes	No	String	min n6 max n18	O
user_selected	The product/substance being prescribed. See codable concept	Yes	No	See codable concept	See codable concept	See codable concept