Schema

Column Name	Data Type	Description
dmr_id	integer	System generated ID for DMR entry.
dmr_guid	varchar	System generated GUID for DMR entry.
eligibility_criterium_id	integer	Eligibility criterium ID related to the DMR.
description	varchar	Criteria description.
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.
patient_id	integer	System generated ID for patient.
unique_patient_id	varchar	Unique identifier for patient across systems.
pharmacy_name	varchar	The name of the pharmacy.
rx_id	varchar	RX id of the pharmacy.
patient_full_name	varchar	Name of the patient.
date_added	timestamp	Date the DMR was added.
date_part_0_completed	timestamp	Date and time when the Consent and Eligibility part was completed.
date_part_1_completed	timestamp	Date and time when the DMR Part 1 part was completed.
date_part_2_completed	timestamp	Date and time when the DMR Part 2 part was completed.
advice_id	integer	Reference ID for advice type.
advice_description	varchar	Description of advice type.
consent_status_id	integer	ID reference for consent type.
consent_status_description	varchar	Description of consent type.
deleted	boolean	Deleted flag.
pharmacist_id	integer	System generated ID for pharmacist.
pharmacist_full_name	varchar	Pharmacist name.
cancel_reason_id	integer	Reference ID for cancellation reason.
cancel_reason_description	varchar	Description of cancellation reason.
date_part_2_contact_attempt_1	date	Date of first attempt to contact patient for second part appointment.
date_part_2_contact_attempt_2	date	Date of second attempt to contact patient for second part appointment.
is_claimable	boolean	Claimable flag for DMR record.
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.