gpes data for pandemic planning and research… · 2020-05-18 · 1. amendment history version date...

Business Rules for Patient-level Data Extracts 2020/21

GPES Data for Pandemic Planning and Research

Author: General Practice Specification and Extraction Service (GPSES), NHS Digital Version Date: 07/05/2020

Version: 2.0

GPES Data for Pandemic Planning and Research PLE Business Rules v2.0 Version Date: 07/05/2020

Published by NHS Digital on behalf of the Department for Health and Social Care (DHSC). The Health and Social Care Information Centre is a non-departmental body created by statute, also known as NHS Digital. of 30

Contents 1. Amendment history ........................................................................................................................................ 4

2. Background ..................................................................................................................................................... 5

2.1. Document purpose ....................................................................................................................................................................5

2.2. Business rules supporting information .......................................................................................................................................5

2.3. Clinical codes.............................................................................................................................................................................5

2.4. Guidance ...................................................................................................................................................................................6

3. Dataset specification ...................................................................................................................................... 7

3.1 Qualifying dates .........................................................................................................................................................................7

3.2 Patient selection criteria .............................................................................................................................................................8

3.2.1 GMS registration status ............................................................................................................................................................................................ 8

3.2.2 Populations ............................................................................................................................................................................................................... 9

3.2.3 Clinical code clusters .............................................................................................................................................................................................. 11

3.2.4 Clinical data extraction criteria ................................................................................................................................................................................ 15

4. Outputs .......................................................................................................................................................... 26

4.1. Indicator(s) ............................................................................................................................................................................... 26

4.2. Payment count(s) ..................................................................................................................................................................... 26

4.3. Management information count(s) ........................................................................................................................................... 26

4.4. Patient-level extracts ............................................................................................................................................................... 27

GDPPR001 ........................................................................................................................................................................................................................ 27

5. Appendix - supporting data for NHS Digital GPSES .................................................................................. 30



This document is produced by NHS Digital on behalf of the Department for Health and Social Care (DHSC). It is published in MS Word format. If anyone intends to re-use the information contained within it or publish in another format then they should acknowledge the source document, NHS Digital and DHSC.



1. Amendment history

Version Date Amendment history

1.0 01 May 2020 New 2020/21 service to support COVID19 activity and research.

2.0 07 May 2020 Revised specification for new 2020/21 service, reduced number of fields required, new clusters implemented.



2. Background

2.1. Document purpose

The dataset and business rules documents produced by the NHS Digital General Practice Specification and Extraction Service (GPSES) are created primarily for the uses of GPES and GP system suppliers. These documents contain specifications to communicate technical details of extracts from Primary Care systems which may be used to provide practice-level information regarding services and/or allocate rewards, such as payments or QOF points. This document is not intended to be used in place of clinical guidelines, but may be referred to by any individual or organisation to aid understanding of which patients and/or activity are included in each population or output. Non-technical, textual descriptions of business rules can be found in the table columns highlighted in pale blue throughout the document.

2.2. Business rules supporting information

Further information regarding the setup of the business rules, terminology used and the calculation methods can be found in version 1.4 of the supporting information document which can be accessed here: http://content.digital.nhs.uk/qofesextractspecs

2.3. Clinical codes

The clinical code strings have been replaced by clinical reference sets (refsets). Both clinical refset and drug refset IDs are denoted by a ‘^’ prefix. Please note the content of clinical and drug refsets are subject to change over the course of a year. Drug refsets have the scope to be updated every 4 weeks. Clinical refsets will be updated at least twice a year. The latest content of refsets can be accessed using the files from Technology Reference data Update Distribution (TRUD)/Power BI portal.

http://content.digital.nhs.uk/qofesextractspecs



2.4. Guidance

Data should only be returned if it is recorded in General Practice records. For any linked records in other modules/units e.g. secondary care, data should NOT be returned. In order to keep the clusters straightforward and due to the expediency required for the extraction of information, there is duplication of codes across the drug clusters. To account for this, there is a requirement to return distinct entries across all specified arrays, which is an additional requirement as compared with typical extracts. There is also the requirement to return numerous additional fields from the ‘Journals’ table as compared with typical extracts.



3. Dataset specification

3.1 Qualifying dates

The dataset and rules in this document refer to various dates, which may include any number of the dates from the table below. Further information regarding how to use these dates within calculations can be found in the supporting information document (see section 2.2).

Term Description Definition Timeframe for this service

Service Data Extract Frequency

Service Data Extract Frequency

The frequency of data extracts associated with the service. Fortnightly

RPED Reporting Period End Date

The date up to which the relevant patient information is considered when determining the output for each extraction.

The last day of each service data extract frequency period

RPED – 2 years Reporting Period End Date minus 2 years

Calculation Based on RPED

01/11/2019 1 November 2019 Fixed date used in qualifying criteria in section below. 01/11/2019



3.2 Patient selection criteria All Populations and Outputs are to be returned at patient-level for this service.

3.2.1 GMS registration status

Qualifying criteria Action if true Action if false Non-technical description

(If REG_DAT ≠ Null AND (If DEREG_DAT = Null OR If DEREG_DAT > RPED)) OR (If ACTIVE = D AND If DEREG_DAT >= 01/11/2019)

Next rule Reject

Pass to the next rule all patients who meet either of the criteria below:

Registered on or before the reporting period end date and who have not subsequently deregistered up to and including the reporting period end date. Or

Have an active status of ‘D’ and who have a deregistration date on or after 1 November 2019.

Reject the remaining patients.

(If POBJEC_DAT ≠ Null AND If POBJECW_DAT = Null) OR (If POBJECW_DAT ≠ Null AND If POBJEC_DAT >= POBJECW_DAT)

Reject Select

Reject patients passed to this rule who dissent from secondary use of GP patient identifiable data (type 1 objection code) which has not been subsequently withdrawn up to the reporting period end date. Select the remaining patients.

End of rules



3.2.2 Populations

3.2.2.1 Case registers N/A - there are no registers for this service.



3.2.2.2 Cohorts Each patient can only be included once per cohort.

Cohort Count ID Description Applied to patients defined in: SDS use only: Version

GDPPRCC001 Count of primary care patients coded with information relevant to pandemic planning and research GMS registration status 100

Rule number

Rule Action if true Action if false Rule description or comments

1 If {GDPPRALL_DAT} ≠ Null Select Reject

Select from the specified population all patients who have any codes relevant to pandemic planning and research recorded up to and including the reporting period end date. Reject the remaining patients.

End of rules



3.2.3 Clinical code clusters

The dataset may include dates and values associated with the presence of clinical codes in a patient’s record. All clinical code clusters referred to in the clinical data extraction criteria are detailed below. The expanded cluster lists for each cluster can be found on the NHS Digital website (see section 2.2). Drug codes may appear in more than one drug cluster; this is a known issue which cannot be resolved under the time limitations imposed on the development of these extract specifications.

Cluster name Description SNOMED CT Cluster Version




ACE_COD Angiotensin-converting enzyme (ACE) inhibitor prescription codes ^12464201000001109 200

AII_COD Angiotensin II receptor blockers (ARB) prescription codes ^12464301000001100 200

ANTIHYP_COD Antihypertensive medications ^999000941000001104 200

ANTIPSYDRUG_COD Antipsychotic drug codes ^999000951000001101 200

ASTTRT_COD Asthma-related drug treatment codes ^12463601000001108 200

ASTTRTATRISK1_COD Asthma inhaled corticosteroids codes ^999000921000001109 200

BSADRUG_COD Bone sparing agent drug codes ^12465701000001102 200

C19ASTDRUG_COD Severe asthma drug treatment codes ^225591000001109 200

C19COPDDRUG_COD Chronic obstructive pulmonary disease (COPD) drug codes ^225571000001105 200

C19CORSTEDRUG_COD Corticosteroid drug codes ^225581000001107 200

C19IMDRUG_COD Severe immunosuppression drug codes ^225681000001108 200

C19PREDDRUG_COD Prednisolone drug codes ^225631000001109 200

CLODRUG_COD Clopidogrel drug codes ^12463801000001107 200

CONSTIPMED_COD Constipation treatment codes ^999000901000001102 200

DIPY_COD Dipyridamole prescription codes ^12463901000001101 200

DMTRTATRISK1_COD Diabetes mellitus drugs codes ^999000851000001109 200




EPILDRUG_COD Drug treatment for epilepsy ^12465301000001101 200

EZETIMIBE_COD Product containing ezetimibe (medicinal product) ^115131000001105 200

FLUDRUG_COD Flu vaccine drug codes ^12465201000001105 200

GDPPR_COD Codes required for COVID-19 pandemic planning and research to be returned with no time limit

^999021651000230109 300

GDPPR2YR_COD Codes required for COVID-19 pandemic planning and research to be returned from the last 2 years

^999021691000230104 300

IMTRTATRISKDRUG_COD Immunosuppression drugs ^999000861000001107 200

LBB_COD Licensed beta-blocker prescription codes ^12465501000001108 200

LIT_COD Lithium prescription codes ^12465601000001107 200

MENACWYDRUG_COD MenACWY vaccine codes ^999000811000001105 200

MENBVACDRUG_COD Men B vaccine drug codes ^999000831000001104 200

METFORMIN_COD Metformin drug codes ^999000931000001106 200

MMRVACDRUG_COD MMR vaccine codes ^133231000001105 200

ORANTICOAGDRUG_COD Oral anticoagulant drug codes ^12463501000001109 200

PCSK9I_COD PCSK9 Inhibitors ^115171000001107 200

PHARMDRUG_COD Pharmacotherapy drug codes ^12465801000001106 200

PNEUVACDRUG_COD Pneumococcal vaccine drug codes ^999000841000001106 200




POBJEC_COD Dissent from secondary use of GP patient identifiable data ^999003131000230102 300

POBJECW_COD Dissent withdrawn from secondary use of GP patient identifiable data ^999003171000230100 300

SAL_COD Salicylate prescription codes ^12463701000001103 200

SFLUGPDRUG_COD Seasonal influenza inactivated vaccine codes ^999000891000001103 200

STAT_COD Statin codes ^12464001000001103 200

THYR_COD Hypothyroidism treatment codes ^999000981000001105 200

ULBB_COD Unlicensed beta-blocker prescription codes ^12465401000001109 200

End of clusters



3.2.4 Clinical data extraction criteria

Field number

Field name Code cluster (if applicable) Qualifying criteria Returned fields Non-technical description

1 PAT_NHSNUMBER n/a Unconditional Patient's NHS number

2 PAT_DOB n/a Unconditional Patient's date of birth

3 PAT_SEX n/a Unconditional Patient's sex

4 PAT_FORENAME n/a Unconditional

Patient’s surname

5 PAT_SURNAME n/a Unconditional

Patient’s forename

6 PAT_ADDRESS n/a Unconditional

Patient’s address.

7 PAT_ADDRESS1 n/a Unconditional

Patient’s address line 1.









12 PAT_POSTCODE n/a Unconditional Patient's postcode



Field number


13 REG_DAT n/a Latest <= RPED

The most recent date that the patient registered for GMS, where this registration occurred on or before the reporting period end date.

14 DEREG_DAT n/a Earliest > REG_DAT

The first occurrence of the patient deregistering from GMS following the latest GMS registration.

15 PAT_DATE_OF_DEATH n/a Unconditional Patient's date of death.

16 ACTIVE n/a Unconditional at RPED Patient’s registration status on the reporting period end date.

17 PAT_ETHNIC n/a Unconditional Patient's ethnicity.

18 POBJEC_DAT POBJEC_COD Latest <= RPED

The date of the most recent patient dissent from secondary use of GP patient identifiable data up to and including the reporting period end date.



Field number


19 POBJECW_DAT POBJECW_COD Latest <= RPED

The date of the most recent patient dissent from secondary use of GP patient identifiable data withdrawn code up to and including the reporting period end date.

20 {GDPPR_DAT} GDPPR_COD All <= RPED

Refer to 4.4 Patient-level Extracts

The specified fields for all identified GDPPR-relevant codes recorded up to and including the reporting period end date.

21 {GDPPR2YR_DAT} GDPPR2YR_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all GDPPR-relevant codes recorded in the 2 years up to and including the reporting period end date.

22 {ACE_DAT} ACE_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all angiotensin-converting enzyme (ACE) inhibitor prescription codes recorded in the 2 years up to and including the reporting period end date.



Field number


23 {AII_DAT} AII_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all angiotensin II receptor blockers (ARB) prescription codes recorded in the 2 years up to and including the reporting period end date.

24 {ANTIHYP_DAT} ANTIHYP_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all antihypertensive medications recorded in the 2 years up to and including the reporting period end date

25 {ANTIPSYDRUG_DAT} ANTIPSYDRUG_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all antipsychotic drug codes recorded in the 2 years up to and including the reporting period end date.

26 {ASTTRT_DAT} ASTTRT_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all asthma-related drug treatment codes recorded in the 2 years up to and including the reporting period end date.

27 {ASTTRTATRISK1_DAT} ASTTRTATRISK1_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all asthma inhaled corticosteroids codes recorded in the 2 years up to and including the reporting period end date.



Field number


28 {BSADRUG_DAT} BSADRUG_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all bone sparing agent drug codes recorded in the 2 years up to and including the reporting period end date.

29 {C19ASTDRUG_DAT} C19ASTDRUG_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all severe asthma drug treatment codes recorded in the 2 years up to and including the reporting period end date.

30 {C19COPDDRUG_DAT} C19COPDDRUG_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all chronic obstructive pulmonary disease (COPD) drug codes recorded in the 2 years up to and including the reporting period end date.

31 {C19CORSTEDRUG_DAT} C19CORSTEDRUG_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all corticosteroid drug codes recorded in the 2 years up to and including the reporting period end date.

32 {C19IMDRUG_DAT} C19IMDRUG_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all severe immunosuppression drug codes recorded in the 2 years up to and including the reporting period end date.



Field number


33 {C19PREDDRUG_DAT} C19PREDDRUG_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all prednisolone drug codes recorded in the 2 years up to and including the reporting period end date.

34 {CLODRUG_DAT} CLODRUG_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all clopidogrel drug codes recorded in the 2 years up to and including the reporting period end date.

35 {CONSTIPMED_DAT} CONSTIPMED_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all constipation treatment codes recorded in the 2 years up to and including the reporting period end date.

36 {DIPY_DAT} DIPY_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all dipyridamole prescription codes recorded in the 2 years up to and including the reporting period end date.

37 {DMTRTATRISK1_DAT} DMTRTATRISK1_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all diabetes mellitus drug codes recorded in the 2 years up to and including the reporting period end date.



Field number


38 {EPILDRUG_DAT} EPILDRUG_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all drug treatment for epilepsy recorded in the 2 years up to and including the reporting period end date.

39 {EZETIMIBE_DAT} EZETIMIBE_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all products containing ezetimibe recorded in the 2 years up to and including the reporting period end date.

40 {FLUDRUG_DAT} FLUDRUG_COD All <= RPED


The specified fields for all flu vaccine drug codes recorded up to and including the reporting period end date.

41 {IMTRTATRISKDRUG_DAT} IMTRTATRISKDRUG_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all immunosuppression drugs recorded in the 2 years up to and including the reporting period end date.

42 {LBB_DAT} LBB_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all licensed beta-blocker prescription codes recorded in the 2 years up to and including the reporting period end date.



Field number


43 {LIT_DAT} LIT_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all lithium prescription codes recorded in the 2 years up to and including the reporting period end date.

44 {MENACWYDRUG_DAT} MENACWYDRUG_COD All <= RPED


The specified fields for all MenACWY vaccine codes recorded up to and including the reporting period end date.

45 {MENBVACDRUG_DAT} MENBVACDRUG_COD All <= RPED


The specified fields for all Men B vaccine drug codes recorded up to and including the reporting period end date.

46 {METFORMIN_DAT} METFORMIN_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all metformin drug codes recorded in the 2 years up to and including the reporting period end date.

47 {MMRVACDRUG_DAT} MMRVACDRUG_COD All <= RPED


The specified fields for all MMR vaccine codes recorded up to and including the reporting period end date.



Field number


48 {ORANTICOAGDRUG_DAT} ORANTICOAGDRUG_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all oral anticoagulant drug codes recorded in the 2 years up to and including the reporting period end date.

49 {PCSK9I_DAT} PCSK9I_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all PCSK9 inhibitors recorded in the 2 years up to and including the reporting period end date.

50 {PHARMDRUG_DAT} PHARMDRUG_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all pharmacotherapy drug codes recorded in the 2 years up to and including the reporting period end date.

51 {PNEUVACDRUG_DAT} PNEUVACDRUG_COD All <= RPED


The specified fields for all pneumococcal vaccine drug codes recorded up to and including the reporting period end date.

52 {SAL_DAT} SAL_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all salicylate prescription codes recorded in the 2 years up to and including the reporting period end date.



Field number


53 {SFLUGPDRUG_DAT} SFLUGPDRUG_COD All <= RPED


The specified fields for all seasonal influenza inactivated vaccine codes recorded up to and including the reporting period end date.

54 {STAT_DAT} STAT_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all statin codes recorded in the 2 years up to and including the reporting period end date.

55 {THYR_DAT} THYR_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all hypothyroidism treatment codes recorded in the 2 years up to and including the reporting period end date.

56 {ULBB_DAT} ULBB_COD All > (RPED - 2 years) AND <= RPED


The specified fields for all unlicensed beta-blocker prescription codes recorded in the 2 years up to and including the reporting period end date.

57 {GDPPRALL_DAT}

RETURN DISTINCT of all of: {GDPPR_DAT}, {GDPPR2YR_DAT}, {ACE_DAT}, {AII_DAT}, {ANTIHYP_DAT},

The distinct (i.e. de-duplicated) specified fields for each of the fields listed in the {GDPPRALL_DAT} qualifying criteria. Please note each



Field number


{ANTIPSYDRUG_DAT}, {ASTTRT_DAT}, {ASTTRTATRISK1_DAT}, {BSADRUG_DAT}, {C19ASTDRUG_DAT}, {C19COPDDRUG_DAT}, {C19CORSTEDRUG_DAT}, {C19IMDRUG_DAT}, {C19PREDDRUG_DAT}, {CLODRUG_DAT}, {CONSTIPMED_DAT}, {DIPY_DAT}, {DMTRTATRISK1_DAT}, {EPILDRUG_DAT}, {EZETIMIBE_DAT}, {FLUDRUG_DAT}, {IMTRTATRISKDRUG_DAT}, {LBB_DAT}, {LIT_DAT}, {MENACWYDRUG_DAT}, {MENBVACDRUG_DAT}, {METFORMIN_DAT}, {MMRVACDRUG_DAT}, {ORANTICOAGDRUG_DAT}, {PCSK9I_DAT}, {PHARMDRUG_DAT}, {PNEUVACDRUG_DAT}, {SAL_DAT}, {SFLUGPDRUG_DAT}, {STAT_DAT}, {THYR_DAT}, {ULBB_DAT}

patient should only be returned once.

End of fields



4. Outputs

4.1. Indicator(s) N/A - there are no indicators for this service.

4.2. Payment count(s)

N/A - there are no payment counts for this service.

4.3. Management information count(s)

N/A - there are no management information counts for this service.



4.4. Patient-level extracts

Extract ID Description Applied to population: SDS use only:

Version

GDPPR001 Primary care patients coded with information relevant to pandemic planning and research GDPPRCC001 100

For every data item listed in the journals table below, bring back all the following fields where present:

Dates

Record dates

Codes

Episodes Condition

Episodes Prescription

Value Condition 1s

Value Condition 2s

Value Prescription 1

Value Prescription 2

Links



Item

Number Table name Data item Description

QID

Number

1 Patient Table PatientTable.PAT_NHSNUMBER See non-technical description column in clinical data extraction criteria table.

1

2 Patient Table PatientTable.PAT_DOB See non-technical description column in clinical data extraction criteria table.

3 Patient Table PatientTable.PAT_SEX See non-technical description column in clinical data extraction criteria table.

4 Patient Table PatientTable.FORENAME See non-technical description column in clinical data extraction criteria table.

5 Patient Table PatientTable.SURNAME See non-technical description column in clinical data extraction criteria table.

6 Patient Table PatientTable.PAT_ADDRESS See non-technical description column in clinical data extraction criteria table.

7 Patient Table PatientTable.PAT_ADDRESS1 See non-technical description column in clinical data extraction criteria table.





12 Patient Table PatientTable.PAT_POSTCODE See non-technical description column in clinical data extraction criteria table.

13 Patient Table PatientTable.PAT_DATE_OF_DEATH

See non-technical description column in clinical data extraction criteria table.



Item

Number Table name Data item Description

QID

Number

14 Patient Table PatientTable.PAT_ETHNIC See non-technical description column in clinical data extraction criteria table.

15 Journals Table {GDPPRALL_DAT} See non-technical description column in clinical data extraction criteria table.

2

End of items



5. Appendix - supporting data for NHS Digital GPSES

Category Database value

TRUD version V29_0_0

Document version 2.0

Ruleset Database ID GDPPR

Database Service ID PLE

QSR Reference if applicable QSR2021028

CQRS service short name GDPPR

gpes data for pandemic planning and research… · 2020-05-18 · 1. amendment history version date...

Documents