The HEPMA data resource captures and compiles information on all medicines prescribed within the ward/hospital covered by the system; this includes medicine name, formulation, strength, dose, route, and frequency of administration, and dates and times of prescribing.
In addition, the HEPMA dataset also captures information on medicines administration, including dates and time of administration.

ADR  > Hospital Electronic Prescribing and Medicines Administration System (HEPMA) @ 1349

HEPMA is a live clinical system and updated on a continuous basis. Data is automatically extracted from local systems at least weekly and
in most cases, on a nightly basis, and integrated into the national HEPMA dataset. 
Data is currently submitted by all health boards except NHS Fife and NHS Borders.

Scottish Health Data

patient_age_at_presc_start_date

HEPMA

patient_datazone_2011

patient_date_of_birth

9-digit code of the NHS board associated with the patient&#039;s postcode at the Request Received Date using the NHS Board current configuration

patient_health_board_code_9

patient_health_board_name

patient_intermediate_zone_2011

patient_postcode

patient_postcode_area

patient_postcode_district

patient_postcode_sector

Indicates if patient is resident in Scottish Health Board. Values will be Y or N.

patient_scottish_health_board_flag

patient_sex

patient_sex_desc

Indicates if the prescribed medication is to be given when needed. Values will be Y or N.

presc_administer_as_needed

The date the record is valid from. Derived to accommodate overlapping prescription records.

presc_derived_valid_from

The date the record is valid to. Derived to accommodate overlapping prescription records.

presc_derived_valid_to

The ATC (Anatomical Therapeutic Chemical) code associated with the dmd code on the record.

presc_dmd_atc_code

presc_dmd_atc_code_description

The BNF code from the Seer BNF reference information associated with the dmd code on the record.

presc_dmd_bnf_code

presc_dmd_bnf_paragraph

presc_dmd_bnf_paragraph_code

presc_dmd_bnf_paragraph_description

The DMD code of the prescribed medication. Will be VMP or AMP

presc_dmd_code

From the Seer dmd reference information for the dmd code on the record.

presc_dmd_current_unique_ref

The defined daily dose conversion factor. From the Seer dmd reference information for the dmd code on the record.

presc_dmd_ddd_conversion_factor

The VMP (Virtual Medical Product) name of the prescribed medication. From the Seer dmd reference information for the dmd code on the record.

presc_dmd_vmp_name

The VTM (Virtual Therapeutic Moiety) ID of the prescribed medication. From the Seer dmd reference information for the dmd code on the record.

presc_dmd_vtm_id

The VTM (Virtual Therapeutic Moiety) name of the prescribed medication. From the Seer dmd reference information for the dmd code on the record.

presc_dmd_vtm_name

Date &amp; time this version of the prescription ended.

presc_end_date_time

Medication active ingredient. Pharmacy stock control name.

presc_med_active_ingredient

Administration frequency. Locally defined. E.g. TWICE DAILY AT 7AM AND 10PM

presc_med_admin_frequency

presc_med_dose

Medication formulation. Pharmacy stock control drug form.

presc_med_formulation

Medication instruction. E.g. 200 MG TWICE DAILY AT 7AM AND 10PM

presc_med_instruction

Medication route. Locally defined. E.g. ORAL, INHALATION, INTRAVENOUS

presc_med_route

Medication strength. Pharmacy stock control drug strength.

presc_med_strength

presc_med_unit

presc_medication_name

Date &amp; time this version of the order was authorised.

presc_order_authorised_date_time

HEPMA system order identifier. This links to admin_order_id in the administration data

presc_order_id

Date &amp; time version 1 of the order ended.

presc_original_order_end_date_time

Date &amp; time version 1 of the order started.

presc_original_order_start_date_time

presc_setting_code

Description associated with the setting type. E.g. EMERGENCY CARE DEPARTMENT SETTING

presc_setting_description

Date this version of the prescription started.

presc_start_date

Date &amp; time this version of the prescription started.

presc_start_date_time

presc_version

Status of this version of the prescription. E.g. ACTIVE, INACTIVE, UNUSED

prescription_status

Current configuration health board 9 digit code of the data submitter

sending_health_board_code_9

Current configuration health board name of the data submitter

sending_health_board_name

The Health Board code associated with the Location Code at the Supply Date for the current NHS Board configuration (Health Board Code 9 Curr).

treatment_health_board_code_9

The Health Board name associated with the Treatment Health Board Code.

treatment_health_board_name

Date &amp; time the administration was given.

admin_given_date_time

admin_medication_formulation

admin_medication_name

Indicates if  the administration was not given. Values will be Y or N, where N indicates that the administration was given.

admin_not_given

HEPMA system order identifier. This links to presc_order_id in the prescription data.

admin_order_id

Reason the administration was not given. Locally defined. E.g. PATIENT REFUSED, NIL BY MOUTH/FASTING

Hospital Electronic Prescribing and Medicines Administration System (HEPMA)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Origin