Schema

Column Name	Data Type	Description
pharmacy_id	integer	Foreign key to the pharmacy table.
ods_order_id	integer	Primary key from the ODS order table.
ods_order_item_id	integer	Primary key from the ODS order item table.
prescription_guid	varchar	Unique identifier for the prescription across systems.
prescription_item_guid	varchar	Unique identifier for the prescription item across systems.
order_added_date	timestamp	The date and time when the order was added.
order_modified_date	timestamp	The date and time when the order was last modified.
order_item_added_date	timestamp	The date and time when the order item was added.
order_item_modified_date	timestamp	The date and time when the order item was last modified.
local_dispense	boolean	Flag indicating whether the item was dispensed locally.
description	varchar	Description of the RDS order item status.
item_status_reason	varchar	Description of the item status reason.
accuracy_check_user	varchar	Display name of the user who performed the accuracy check.
date_accuracy_checked	timestamp	The date and time when the user performed the accuracy check.
date_clinically_checked	timestamp	The date and time when the user performed the clinical check.
clinical_check_user	varchar	Display name of the pharmacist who performed the clinical check.
patient_full_name	varchar	Formatted full name of the patient.
action_description	varchar	Description of each recorded action.
quantity_ordered	numeric	User ordered quantity.
quantity_received	numeric	Quantity that the service responded it will send back.
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.
organisation	varchar	An organisation is synonymous with a pharmacy and is also known as the RXid.
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.