Schema

Column Name	Data Type	Description
nms_id	integer	Auto incrementing primary key for the NMS record.
organisation	varchar	An organisation is synonymous with a pharmacy and is also known as the RXid.
nms_guid	varchar	Unique identifier across other systems.
date_nms_added	timestamp	The date and time when the NMS record was added.
date_nms_modified	timestamp	The date and time when the NMS record was last modified.
patient_id	integer	Foreign key to the patient record linked to the NMS.
unique_patient_id	varchar	Unique identifier for patient across systems.
patient_full_name	varchar	Full patient name derived from patient demographics.
patient_age	integer	Patient age at model date, based on birth date and death date where applicable.
patient_nhs_number	varchar	NHS number. 10-digit number like 3347775786 or 334-777-5786.
patient_home_number	varchar	Home contact details of patient.
patient_mobile_number	varchar	Mobile contact details of patient.
pharmacist_id	integer	Foreign key to the pharmacist who did the initial stage.
prescription_id	integer	Foreign key to the prescription linked to the NMS.
declined	boolean	Marks the NMS record as declined.
region_ids	varchar	Comma-separated region identifiers derived from NMS drugs and pharmacy region mapping.
nms_item_name	varchar	Aggregated item name list for NMS drugs.
decline_pharmacist_id	integer	Pharmacist identifier for who declined the NMS.
escaped	boolean	Marks the NMS record as escaped.
asthma_copd	boolean	Asthma and COPD flag.
diabetes	boolean	Diabetes flag.
antiplatelet_anticoagulant_therapy	boolean	Antiplatelet or anticoagulant therapy flag.
hypertension	boolean	Hypertension flag.
engagement_non_provided	boolean	Patient engagement stage non-provided flag.
engagement_diet	boolean	Patient engagement stage diet flag.
engagement_physical_activity	boolean	Patient engagement stage physical activity flag.
engagement_sexual_health	boolean	Patient engagement stage sexual health flag.
engagement_weight_management	boolean	Patient engagement stage weight management flag.
engagement_smoking	boolean	Patient engagement stage smoking flag.
engagement_alcohol	boolean	Patient engagement stage alcohol flag.
engagement_pharmacist_id	integer	Pharmacist identifier for engagement stage.
date_engagement_completed	timestamp	Patient engagement completed datetime.
intervention_attended	boolean	Intervention stage attended flag.
intervention_not_attended_reason	varchar	Intervention not attended reason text.
intervention_non_provided	boolean	Intervention stage non-provided flag.
intervention_diet	boolean	Intervention stage diet flag.
intervention_physical_activity	boolean	Intervention stage physical activity flag.
intervention_sexual_health	boolean	Intervention stage sexual health flag.
intervention_weight_management	boolean	Intervention stage weight management flag.
intervention_smoking	boolean	Intervention stage smoking flag.
intervention_alcohol	boolean	Intervention stage alcohol flag.
intervention_pharmacist_id	integer	Pharmacist identifier for intervention stage.
date_intervention_completed	timestamp	Intervention completed datetime.
followup_attended	boolean	Follow-up stage attended flag.
followup_not_attended_reason	varchar	Follow-up not attended reason text.
followup_non_provided	boolean	Follow-up stage non-provided flag.
followup_diet	boolean	Follow-up stage diet flag.
followup_physical_activity	boolean	Follow-up stage physical activity flag.
followup_sexual_health	boolean	Follow-up stage sexual health flag.
followup_weight_management	boolean	Follow-up stage weight management flag.
followup_smoking	boolean	Follow-up stage smoking flag.
followup_alcohol	boolean	Follow-up stage alcohol flag.
followup_pharmacist_id	integer	Pharmacist identifier for follow-up stage.
date_followup_completed	timestamp	Follow-up completed datetime.
date_exited	timestamp	Datetime when the NMS was exited.
prescriber_prescribing_organisation_id	integer	Prescribing organisation identifier associated with the NMS prescription context.
session_id	integer	Session ID from appointment session NMS.
session_parts	varchar	Comma-separated list of session parts recorded against the NMS.
hospital_discharge_note	varchar	Hospital discharge note text for NMS.
other_note	varchar	Free-text other note for NMS.
hypercholesterolaemia	boolean	Hypercholesterolaemia flag.
osteoporosis	boolean	Osteoporosis flag.
gout	boolean	Gout flag.
glaucoma	boolean	Glaucoma flag.
epilepsy	boolean	Epilepsy flag.
parkinsons_disease	boolean	Parkinsons disease flag.
urinary_incontinence_retention	boolean	Urinary incontinence retention flag.
heart_failure	boolean	Heart failure flag.
acute_coronary_syndromes	boolean	Acute coronary syndromes flag.
atrial_fibrillation	boolean	Atrial fibrillation flag.
risk_of_embolism	boolean	Risk of embolism flag.
stroke_or_transient_ischemic_attack	boolean	Stroke or transient ischemic attack flag.
coronary_heart_disease	boolean	Coronary heart disease flag.
antidepressant	boolean	Antidepressant flag.
drug_given_previously_status_id	integer	Drug given previously status identifier used in claimability logic.
nms_status	varchar	Overall NMS status derived from decline, escape, deletion, and stage completion logic.
nms_intervention_status	varchar	Derived intervention-stage status including claimability pathway outcomes.
nms_followup_status	varchar	Derived follow-up-stage status including claimability pathway outcomes.
pharmacy_name	varchar	Name of the pharmacy.
branch_identifier	varchar	Branch identifier assigned by head office for data exchange workflows.
national_practice_code	varchar	Pharmacy NacsCode used to identify the pharmacy when the user logs in.
is_deleted	boolean	Whether this record should be considered deleted. Data deleted at source has non-key columns set to null while primary keys are retained.
row_id	varchar	Unique hash generated based on column values, used to identify data changes.
last_updated_date	date	Date that this record was last updated by the orchestration process.