Prescription Tables
Prescriptions Overview
The prescription tables contain patients prescribed the specified medications in the previous 6 months.
Common Fields
Each table has the following fields:
| fieldname | description |
|---|---|
| label | descriptive label of the table contents. Be 'diabetes' |
| area_id | area id for GP Practice |
| ods_code | ODS (Organisation Data Service) identifier for the GP Practice. |
| person_id | identifier of person |
| patient_id | identifier of patient at a practice |
Information format:
table name (full name, abbreviation)
The business rules syntax used to create the table with (CLUSTER ID)s and date ranges.
Table of fieldnames + description specific to the table
Additional information
prescribed_antidepressants
Anti-depressant medication (BNF 0403) excluding Amitriptyline hydrochloride (BNF 0403010B0) recorded >=last 6 months, selecting latest Repeat prescription or, where no Repeat prescription is found, latest Acute prescription. With earliest date of prescription course, prescription type and count of prescriptions within the course.
| fieldname | description |
|---|---|
| latest6m_date | latest date of code for prescription in the last 12 months |
| latest6m_code | SNOMED concept id for latest code in the last 12 months |
| latest6m_name | code term for latest code in the last 12 months |
| prescription_type | type of prescription (repeat / acute) |
| prescription_count | count of prescriptions within the prescription course |
| prescription_earliest_date | earliest prescription date for the prescription course |
| bnf_code | British National Formulary code for medication |
See Antidepressants for more detail of the medications included.
prescribed_statins
Statins meds code (STAT_COD) recorded >=last 6 months, and earliest recorded
| fieldname | description |
|---|---|
| latest6m_date | latest date of prescription code in the last 12 months |
| latest6m_code | SNOMED concept id for latest code in the last 12 months |
| latest6m_name | code term for latest code in the last 12 months |
| earliest_date | earliest date of prescription code |
| earliest_code | SNOMED concept id for earliest prescription code |
| earliest_name | code term for earliest prescription code |
Backlinks:
Mental Health
The prescribed_antidepressants table contains all patients who have been prescribed anti-depressant medication (BNF 04:03 excluding amitriptyline) in the past six months. Amitriptyline is excluded as it is not recommended for treating depression and is more commonly prescribed for pain relief. Other drugs within this chapter may also be prescribed for conditions other than depression, sometimes with differing dosages:
The prescribed_antidepressants table can be joined to the ../Data/Registers.md table, in order to identify patients with both a depression code and a current anti-depressant medication. As described above, there is no guarantee however that the patient isn't being medicated for an alternative condition. Attention may want to be given, therefore, to the type of prescription, how long the prescription has
NHS Health Checks
- Statin Prescription. (prescribed_statins)