Schema

Column Name	Data Type	Description
dispensed_item_deleted	boolean	Dispensed item deleted flag.
unique_patient_id	varchar	A globally unique patient identifier.
organisation	varchar	An organisation is synonymous with a pharmacy and is also known as the RXid.
prescription_item_dispensed_id	integer	Dispensing identifier. Unique in combination with organisation.
prescription_item_dispensed_guid	varchar	A globally unique Prescription identifier.
prescription_id	integer	Prescription identifier.
prescription_item_id	integer	Prescription item identifier.
prescription_type	varchar	Prescription type description.
prescribed_date	date	Prescription date.
prescribed_endorsement	varchar	Endorsement for prescription.
prescribed_dosage	varchar	Dosage of prescribed item.
prescribed_quantity	numeric	Prescribed quantity.
is_opd_applied	boolean	Set to true when original pack dispensing has been applied.
prescribed_product	varchar	Prescribed product.
is_owed	boolean	A flag that is true when the owing quantity is greater than 0.
owing_date	date	The date when the owing was created.
owing_quantity	numeric	Owed quantity for a prescribed item.
dispensed_date_time	timestamp	The date and time when the item was dispensed on.
dispensed_pack_code_id	integer	Pack identifier.
dispensed_quantity	numeric	Dispensed quantity.
dispensed_cost	numeric	Cost of dispensed item.
dispensed_price	numeric	Price of dispensed item.
dispensed_not_given	boolean	A flag that indicates whether the dispensed item was given to a patient or not.
is_dispensing_activity	boolean	A flag that is true when a dispensed item’s is_given flag is true, quantity is more than 0, and is not deleted.
product_pack_size	numeric	Pack size from PKB.
dispensed_packs	numeric	Packs dispensed, calculated based on dispensed quantity and product pack size.
product_name	varchar	PKB product name.
manufacturer_name	varchar	PKB manufacturer name.
product_pack_type	integer	Dmd Product Type (0 = VMPP, 1 = AMPP).
product_pack_code_id	integer	Dmd Pack (VMPP/AMPP) identifier. Relates to Dmd.VirtualProductPack and Dmd.ActualProductPack tables.
virtual_product_pack_id	integer	Generic pack information corresponding to a virtual product. Virtual packs form the base for actual pack equivalents and provide additional data such as unit measure and size links.
virtual_product_name	varchar	PKB virtual product name.
dispensed_virtual_product_id	integer	Unique Virtual Product identifier of the dispensed item.
dispensed_drug_code	varchar	The DrugCode of the Pack from which the Preparation is derived.
prescribed_virtual_product_id	integer	Unique Virtual Product identifier of the prescribed item.
dispensed_pip_code	varchar	PIP code of the dispensed drug.
pharmacy_name	varchar	The name of the pharmacy.
surgery_name	varchar	Surgery description name.
surgery_registration_code	varchar	Alpha-numeric surgery code.
patient_full_name	varchar	Name of the patient.
patient_birth_date	date	Birth date of the patient.
patient_house_number_flat_number	varchar	Patient house number or flat number.
patient_number_and_street	varchar	Patient number and street.
patient_village	varchar	Patient village.
patient_town	varchar	Patient town.
patient_post_code	varchar	Patient post code.
nursing_home_id	integer	Identifier for the nursing home.
nursing_home_name	varchar	Name for the nursing home.
nursing_home_type	varchar	Nursing home type.
nursing_home_house_name_flat_number	varchar	Nursing home house name or flat number.
nursing_home_number_and_street	varchar	Nursing home number and street.
nursing_home_village	varchar	Nursing home village.
nursing_home_town	varchar	Nursing home town.
nursing_home_post_code	varchar	Nursing home post code.
nursing_home_address_id	integer	Identifier for the nursing home address.
nursing_home_registration	varchar	Nursing home identifier value.
off_site_fulfilment	boolean	Indicates whether the item was fulfilled or dispensed off-site.
bnf_chapter_refs	array	An array of BNF chapters that the item is referenced in.
uom_description	varchar	Measurement unit of the drug.
preparation_description	varchar	Text description of the preparation code.
branch_identifier	varchar	Branch identifier assigned by the head office. Used when sending and receiving data from a a head office, but otherwise not used by the application.
national_practice_code	varchar	Pharmacy NacsCode. Used to identify the pharmacy when the user logs in.
non_MDS	boolean	Boolean flag indicating whether the prescription item is non-MDS (Medicine Dispensing Service).
audited_clinical_check_date	timestamp	Date when the clinical check was audited.
audited_clinical_check_pharmacist_id	integer	ID of the pharmacist who performed the audited clinical check.
audited_clinical_check_user_in_role_id	integer	User in role ID who performed the audited clinical check.
external_accuracy_check_user_and_date	varchar	External accuracy check user and date information.
row_id	varchar	Unique hash generated based on column values, used to identify data changes.
last_updated_date	date	The date that this record was last updated. Its basis is from the ingestion process and is populated by the job orchestration tool.