Schema

Column Name	Data Type	Description
mds_item_id	integer	Primary key for the MDS item.
mds_item_guid	varchar	Unique identifier for the MDS item across systems.
organisation	varchar	An organisation is synonymous with a pharmacy and is also known as the RXid.
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.
pharmacy_id	integer	Foreign key to the pharmacy table.
patient_id	integer	Foreign key to the patient table, identifying the patient.
unique_patient_id	varchar	Unique identifier for the patient, generated as a surrogate key from organisation and patient_id.
patient_guid	varchar	Unique identifier for the patient across systems.
nursing_home_id	integer	Foreign key for nursing home identification.
preparation_code_id	integer	Preparation code identifier.
pack_code_id	integer	Local identifier of ProScript Connect packs.
pharmacy_name	varchar	The name of the pharmacy.
patient_deleted	boolean	Whether or not the patient is deleted.
patient_full_name	varchar	Full name of the patient (formatted).
patient_deceased	boolean	Whether or not the patient has died.
date_added	timestamp	The date when the MDS item was added.
dispensed_date	timestamp	The date when the item was dispensed.
nursing_home_name	varchar	Nursing home name.
nursing_home_type	varchar	Nursing home type.
quantity	numeric	Quantity of the MDS item.
product_name	varchar	Text description of the product - pack name.
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.
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.