Schema

Column Name	Data Type	Description
emar_history_id	integer	Identifier for the electronic medicines administration history record.
emar_history_guid	varchar	Globally unique identifier for the electronic medicines administration history record.
pharmacy_id	integer	Identifier for the pharmacy associated with the administration history.
pharmacy_name	varchar	Name of the pharmacy associated with the administration history.
patient_id	integer	Identifier for the patient the administration history belongs to.
patient_guid	varchar	Globally unique identifier for the patient.
patient_deleted	boolean	Whether the patient record has been deleted at source.
patient_deceased	boolean	Whether the patient is deceased.
nursing_home_name	varchar	Name of the nursing home the patient is associated with.
emar_system_type_id	integer	Identifier for the type of electronic medicines administration system used.
nursing_home_id	integer	Identifier for the nursing home the patient is associated with.
nursing_home_guid	varchar	Globally unique identifier for the nursing home.
nursing_home_type	varchar	Type classification of the nursing home.
emar_status_id	integer	Identifier for the status of the electronic medicines administration record.
date_added	timestamp	Date and time the administration history record was created.
date_sent	timestamp	Date and time the administration record was sent.
emar_history_item_id	integer	Identifier for the specific dispensed item within the administration history record.
emar_history_item_guid	varchar	Globally unique identifier for the administration history item.
product_name	varchar	Name of the medicinal product associated with the administration history item.
preparation_code_id	integer	Identifier for the preparation code of the product.
pack_code_id	integer	Identifier for the pack code used to look up the product.
quantity	numeric	Quantity of the product included in the administration history item.
organisation	varchar	An organisation is synonymous with a pharmacy and is also known as the RXid.
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.
MDS_inactive	timestamp	Date and time from which the patient was flagged as inactive on the Monitored Dosage System.
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.