MDW - Discover Metadata Catalogue

MDW Discover  > IQVIA Medical Research Data (IMRD) @ 1031

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

IQVIA Medical Research Data, (IMRD) contains longitudinal non-identified patient electronic healthcare records (EHR) collected from UK General Practitioner (GP) clinical systems via the IQVIA Medical Research Extraction Scheme.

All issued prescribed medication including name, form, strength, quantity and dose

Observations records including symptoms, diagnosis, tests, referrals and immunizations

HDR UK

IQVIA Medical Research Data, IMRD

Encrypted unique identifier given to a practice. This is the primary key for this table.

pracid

The Consultation table contains information relating to the type of consultation (e.g., telephone, home visit, practice visit

Consultation

Unique identifier given to the consultation. This is the primary key for this table.

consid

Encrypted unique identifier given to a patient.

patid

consdate

effectivedateprecision

Date the event was entered into the practice system

enterdate

entertime

Encrypted unique identifier given to the practice staff member.

staffid

Encrypted unique identifier given to the practice staff member who entered the details ?

enteredbyid

appointmentslotid

Source of the consultation e.g. telephone, main surgery. Link to  LU_Consultationsourceterm

consultsourcetermid

Source of the consultation from EMIS software. This is a clinical code that can be used with the clinical codes lookup . Link to LU_Clinicalcode

clinicalcodeid

complete

The Drug record table contains a list of the patient’s drugs which is used for prescription authorisations.

DrugRecord

Unique identifier given to the issue record. This is the primary key for this table.

drugrecid

issuedate

Date the event was entered into EMIS Web®

Encrypted unique identifier given to the practice staff member. This is the primary key for this table.

Unique code for the treatment selected by the GP  link to LU_drugcodes

drugcodeid

Identifier that allows dosage information on the event to be retrieved. Link to LU_Dosage

dosageid

Total quantity entered by the GP for the prescribed treatment

quantity

Unit of the treatment (capsule, tablet)  link to LU_Quantityunit

quantunitid

Typeid of prescription (acute/repeat) link to LU_Prescriptiontype

typeid

Is this still active (true = 1 / False = 0)

active

cancellation

No. of times drug has been issued on current authorisation

numberissues

authorisedissues

Original Term added at time of drugrecord link to LU_Originalterm

originaltermid

The Observation table contains a record of symptoms, diagnoses and interventions as well as clinical measurements, laboratory test results and immunisations recorded by the GP and primary care team

Observation

Unique identifier given to the observation. This is the primary key for this table.

obsid

obsdate

Observation identifier (obsid) that is the parent to the observation. This enables grouping of multiple observations, such as systolic and diastolic blood pressure, or blood test results.

parentobsid

Unique code for the medical term selected by the GP link to LU_Clinicalcode

Link to CareRecord_Problem.ObservationGuid

problemguid

Unique identifier given to the consultation.

Numeric value associated with unit measurement

value

Unit of measurement  (unit bridging TBC) Link to LU_numericunit actual value in 1st iteration

numunitid

link to Type of observation (allergy, family history, observation)  link to LU_Observationtype

obstypeid

numrangelow

numrangehigh

documentguid

Flag to indicate observation is marked as confidential (true = 1 / False = 0)

isconfidential

dataflag

Original Term added at time of observation link to LU_Originalterm

batchnumber

manufacturer

The Patient table contains information on patient characteristics and registration details

Patient

Encrypted unique identifier given to a patient. This is the primary key for this table.

The GP that the patient is nominally registered with. To be used with the Staff table for reference

usualgp

gender

Patient’s year of birth. This is actual year of birth e.g. 1984.

Patient’s month of birth (for those aged under 16).

Date of death as recorded in the EMIS software.

dateofdeath

The earliest date that the patient registered with the contributing practice.

earliestregstartdate

Most recent date the patient is recorded as having registered at the practice. If a patient deregistered for a period of time and returned, the return date would be recorded.

lastregstartdate

Bridge codeid lookup category that the patient has been assigned to e.g. private, regular, temporary. Link to LU_Patienttype

patienttypeid

Date the patient's registration at the practice ended. This may represent a transfer-out date or death date.

regenddate

patient's ethnic categoryid,  link to LU_Ethnicity

ethnicity

patients linked IMD decile - 1 = most deprived, 10 = least deprived

patient 'address_id' for patient  in the same house hold

familyid

The Practice table contains information for each practice, including a  encrypted practice identifier

Practice

Date of the most recent data collection for the practice.

computerisationdate

Value to indicate NHS Region where in the UK the practice is based.

region

status

software

The Prescription table contains information on all prescriptions issued to patients

Prescription

issueid

Link to Prescribing_DrugRecord.DrugRecordGuid

Unique code for the treatment selected by the GP  link to LU_drugcode

quantity code id - e.g. 1 link to LU_Quantityunit

Unique identifier for the observation that links to a problem under which this prescription was issued. Link to obsid in Problem and obsid in Observation

duration

Estimated cost of the treatment to the NHS

estmhscost

Original Term added at time of prescription link to LU_Originalterm

The Prescription Problem Link table contains linking information to join between Prescription and Problems / Observation

Prescription_Problem_Link

IQVIA Medical Research Data (IMRD) is non-identified electronic patient health record data supplied from UK General Practitioner (GP) clinical systems via the IQVIA Medical Research Extraction Scheme and used for medical and public health research and treatment analysis.

IQVIA Medical Research Data (IMRD)

LU_Quantityunit

The Staff table contains information on practice staff with details of job category (staffid) can be used to identify the member of staff recording observations, prescriptions

Staff

LU_Referralservicetype

LU_Referralmode

LU_Jobcategorycode

LU_Sex

LU_Prescriptiontype

LU_Significancedescription

LU_Numericunit

LU_Parentproblemrelationship

LU_Clinicalcode

LU_Drugcode

LU_Dosage

LU_Problemstatus

LU_Ethnicity

LU_Consultationsourceterm

The Referral table contains information on referrals to and from external care organisations

Referral

LU_Referralurgency

LU_Organisationtype

The Problem table contains records where an observation is recorded as a problem. In EMIS a problem is used to mark an event as being the onset of a diagnosis

IQVIA Medical Research Data (IMRD)

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin