Changes between Version 22 and Version 23 of DataIntegration GENVASC Primary Care Data Request Codes


Ignore:
Timestamp:
12/09/15 19:42:06 (9 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DataIntegration GENVASC Primary Care Data Request Codes

    v22 v23  
    22
    33Tags: [[GENVASC Study]]
    4 
    5 == Patient Request
    6 
    7 UHLDWH.DWBRICCS.dbo.UVW_GENVASC_PATIENTS_GEM => UHLDBSQLCORP02.LLR_CSS.dbo.BRICCS_GENVASC_PATIENTS
    8 
    9 == Data Response
    10 
    11 
    12 UHLDBSQLCORP02.LLR_CSS.dbo.Genvasc_Clinical_ReadCode => UHLDWH.DWBRICCS.dbo.Genvasc_Clinical_ReadCode
    13 
    14 UHLDBSQLCORP02.LLR_CSS.dbo.Genvasc_Ethnic_ReadCode => UHLDWH.DWBRICCS.dbo.Genvasc_Ethnic_ReadCode
    154
    165== Requested Read Codes
     
    10897Excluded - Presumed Type 1
    10998
    110 X40J4   Type I diabetes mellitus
    111 Xa4g7   Unstable type I diabetes mellitus
    112 X40JY   Insulin-dependent diabetes mellitus secretory diarrhoea synd
    113 C1080   Type I diabetes mellitus with renal complications
    114 C1081   Type I diabetes mellitus with ophthalmic complications
    115 C1082   Type I diabetes mellitus with neurological complications
    116 C1083   Type I diabetes mellitus with multiple complications
    117 C1085   Type I diabetes mellitus with ulcer
    118 C1086   Type I diabetes mellitus with gangrene
    119 C1088   Type I diabetes mellitus - poor control
    120 C1089   Type I diabetes mellitus maturity onset
    121 XaELP   Type I diabetes mellitus without complication
    122 XaFWG   Type I diabetes mellitus with hypoglycaemic coma
    123 XaFmK   Type I diabetes mellitus with peripheral angiopathy
    124 XaFmL   Type I diabetes mellitus with arthropathy
    125 XaFmM   Type I diabetes mellitus with neuropathic arthropathy
    126 XaEnn   Type I diabetes mellitus with mononeuropathy
    127 XaEno   Type I diabetes mellitus with polyneuropathy
    128 XaKyW   Type 1 diabetes mellitus with gastroparesis
    129 C1087   Type I diabetes mellitus with retinopathy
    130 XaF04   Type I diabetes mellitus with nephropathy
    131 XaFm8   Type I diabetes mellitus with diabetic cataract
    132 XaIzM   Type 1 diabetes mellitus with persistent proteinuria
    133 XaIzN   Type 1 diabetes mellitus with persistent microalbuminuria
    134 XaJSr   Type 1 diabetes mellitus with exudative maculopathy
    135 C1010   Type 1 diabetes mellitus with ketoacidosis
    136 C1030   Type 1 diabetes mellitus with ketoacidotic coma
    137 XM1Xk   Xa4g7   Xa4g7   Unstable type I diabetes mellitus
    138 XM1Xk   C1088   C1088   Type I diabetes mellitus - poor control
     99- X40J4 Type I diabetes mellitus
     100- Xa4g7 Unstable type I diabetes mellitus
     101- X40JY Insulin-dependent diabetes mellitus secretory diarrhoea synd
     102- C1080 Type I diabetes mellitus with renal complications
     103- C1081 Type I diabetes mellitus with ophthalmic complications
     104- C1082 Type I diabetes mellitus with neurological complications
     105- C1083 Type I diabetes mellitus with multiple complications
     106- C1085 Type I diabetes mellitus with ulcer
     107- C1086 Type I diabetes mellitus with gangrene
     108- C1088 Type I diabetes mellitus - poor control
     109- C1089 Type I diabetes mellitus maturity onset
     110- XaELP Type I diabetes mellitus without complication
     111- XaFWG Type I diabetes mellitus with hypoglycaemic coma
     112- XaFmK Type I diabetes mellitus with peripheral angiopathy
     113- XaFmL Type I diabetes mellitus with arthropathy
     114- XaFmM Type I diabetes mellitus with neuropathic arthropathy
     115- XaEnn Type I diabetes mellitus with mononeuropathy
     116- XaEno Type I diabetes mellitus with polyneuropathy
     117- XaKyW Type 1 diabetes mellitus with gastroparesis
     118- C1087 Type I diabetes mellitus with retinopathy
     119- XaF04 Type I diabetes mellitus with nephropathy
     120- XaFm8 Type I diabetes mellitus with diabetic cataract
     121- XaIzM Type 1 diabetes mellitus with persistent proteinuria
     122- XaIzN Type 1 diabetes mellitus with persistent microalbuminuria
     123- XaJSr Type 1 diabetes mellitus with exudative maculopathy
     124- C1010 Type 1 diabetes mellitus with ketoacidosis
     125- C1030 Type 1 diabetes mellitus with ketoacidotic coma
     126- XM1Xk Xa4g7   Xa4g7   Unstable type I diabetes mellitus
     127- XM1Xk C1088   C1088   Type I diabetes mellitus - poor control
    139128
    140129Excluded - not sure if Type 1 or Type 2:
    141130
    142 C10..   Diabetes mellitus
    143 XaOPu   Latent autoimmune diabetes mellitus in adult
    144 X40JA   Secondary diabetes mellitus
    145 XaMzI   Cystic fibrosis related diabetes mellitus
    146 X40JB   Secondary pancreatic diabetes mellitus
    147 X40JC   Secondary endocrine diabetes mellitus
    148 XSETK   Drug-induced diabetes mellitus
    149 XaJlR   Secondary diabetes mellitus without complication
    150 XaJUI   Diabetes mellitus induced by non-steroid drugs
    151 XaJlM   DM induced by non-steroid drugs without complication
    152 XaJlL   Secondary pancreatic diabetes mellitus without complication
    153 X40JG   Genetic syndromes of diabetes mellitus
    154 X40JI   Diabetes mellitus autosomal dominant
    155 X40JO   Congenital lipoatrophic diabetes
    156 X40JS   Hyperproinsulinemia
    157 XSETH   Maturity onset diabetes mellitus in young
    158 X40JZ   Diabetes-deafness syndrome maternally transmitted
    159 XSETp   Diabetes mellitus due to insulin receptor antibodies
    160 XM1Xk   Unstable diabetes
    161 X008t   Diab insipidus,diab mell,optic atrophy and deafness
     131- C10.. Diabetes mellitus
     132- XaOPu Latent autoimmune diabetes mellitus in adult
     133- X40JA Secondary diabetes mellitus
     134- XaMzI Cystic fibrosis related diabetes mellitus
     135- X40JB Secondary pancreatic diabetes mellitus
     136- X40JC Secondary endocrine diabetes mellitus
     137- XSETK Drug-induced diabetes mellitus
     138- XaJlR Secondary diabetes mellitus without complication
     139- XaJUI Diabetes mellitus induced by non-steroid drugs
     140- XaJlM DM induced by non-steroid drugs without complication
     141- XaJlL Secondary pancreatic diabetes mellitus without complication
     142- X40JG Genetic syndromes of diabetes mellitus
     143- X40JI Diabetes mellitus autosomal dominant
     144- X40JO Congenital lipoatrophic diabetes
     145- X40JS Hyperproinsulinemia
     146- XSETH Maturity onset diabetes mellitus in young
     147- X40JZ Diabetes-deafness syndrome maternally transmitted
     148- XSETp Diabetes mellitus due to insulin receptor antibodies
     149- XM1Xk Unstable diabetes
     150- X008t Diab insipidus,diab mell,optic atrophy and deafness
    162151
    163152=== Episodic Data
     
    171160* Drug groups primarily affecting the cardiovascular System: x01QF and Children.
    172161
    173 
    174 
    175162== Recreating the Health Check Discussion
    176163
    177 Below are some questions with responses by Sarah-Jane Gray (in italics) about the Read Codes used to generate a QRisk Score:
    178 
    179 - What (Read code or otherwise) do the CCG use to identify that a health check has occurred for payment purposes?
    180     ''XaPkZ - Cardiovascular disease risk assessment done''
    181 
    182 - For questions where the answer is a tick box (yes/no) is there a way to differentiate for all cases between an answer of ‘no’ / unticked and the question not being answered?
    183     ''No – one of the drawbacks of the system in terms of data gathering is that the read codes are for a positive response and rarely a negative. Tickbox indicates a ‘yes’ response to that question but absence of a tick could be either ‘no’ or ‘not applicable / not asked’''
    184 
    185 - Similarly, for questions where the answer is a number, is there a way to differentiate for all cases between an answer of zero and the question not being answered?
    186     ''Generally with numeric, because a negative (0) can be recorded, question not being answered is not the same as a negative response.''
    187 
    188 - What audit data is available for the data completeness for health checks?
    189     ''Might need more explanation on what you mean for this one J''
    190 
    191 - For calculations such as QRisk or BMI, is it possible for the health check form to be filled in such a way that they are not calculated?
    192     ''Yes. These should be recorded as part of a health check but there is the possibility (particularly with QRISK being a tool external to the template which ‘pops up’) but it is possible to complete the template without calculating these.''
    193 
    194 - For calculations such as QRisk or BMI, is it possible for the calculation to be based on historic data?  Is there a limit to how old that data can be?
    195     ''Yes. This is generally the most recent reading in the last 5yrs except ‘treated for hypertension’ in QRISK which needs to be hypertension diagnosis (any time) but hyp meds prescribed within last 6 months of the calculation. For BMI/BP, if nothing is recorded then a default value considering the patient’s age, sex and ethnicity is calculated.''
    196 
    197 - Is there a way to correctly identify all the values associated with a health check or QRisk calculation?
    198     ''Not easily. We can produce a template specification for the NHS Health Check template which lists all the codes used (this is what you attached to the original email) but not for the QRISK calculation.''
    199  
    200 
    201 - In addition, we want to make sure that we have all the information that was used to calculate the QRisk score.  From what I can gather, the following fields are required for this calculation:
    202  - Ethnicity
    203  - Age > ''directly taken from patient demographic information''
    204  - Sex > ''directly taken from patient demographic information''
    205  - Smoking Status
    206  - Systolic blood pressure
    207  - Total cholesterol:HDL ratio
    208  - BMI
    209  - Family History of CHD in 1st degree relative under 60 > ''both codes used in the template will mark this as positive. On S1 is just ‘Family history of CVD’ ?''
    210  - Townsend deprivation score > ''directly taken from patient demographic information (if postcode recognised)''
    211  - Treated hypertension > ''Any codes in the HYP cluster (I can provide these) with hypertension medication in <6m''
    212  - Rhematoid arthritis > ''Any codes in the RARTH cluster''
    213  - Chronic renal disease > ''Any codes in the CKD cluster''
    214  - Type 2 diabetes > ''Codes and children of X40J5 (“Type II diabetes mellitus’)''
    215  - Atrial fibrillation > ''Any codes in the AFIB cluster''
    216  - ''+ also ‘personal history of CVD’''
    217 
    218 - Do you know what algorithm for calculating QRisk is used in SystemOne, as this may resolve the ambiguities?
    219     ''Afraid not, and I can’t see any way of obtaining this from S1 – will see if it’s available elsewhere.''
    220 
    221 
    222 == Health Check Information
    223 
    224 Information about the Health Check can be found on the [[http://www.hscic.gov.uk/nhshealthcheck|HSCIC Health Check]] page.  This includes a [[http://www.hscic.gov.uk/media/9445/NHS-Health-Check---Read-Code-Mapping-Guidance-XLS-396kb/xls/NHS_Health_Check_-_Read_Code_Mapping_Guidance.xls|list of mappings]] for the codes between Read v2 and v3.
    225 
    226 == Primary Care Medication Coding
    227 
    228 After speaking to Stephanie Webb, I have gleaned the following information about primary care medication data:
    229 
    230 - It is extracted from System One and EMIS into the GEM data warehouse
    231 - System One data is ''probably'' in Read Code format.
    232 - EMIS is ''probably'' not, but don't know what format it is in.
    233 
    234 == Patient Post Codes
    235 
    236 After speaking to Stephanie Webb, I have gleaned the following information about patient post codes data.
    237 
    238 - Post code data is not historic, only current post code data is recorded.
    239 - GEM do not get post code data from the primary care IT systems, but get the information from the Exeter database.
    240 - It may be possible to get the data from System One and EMIS, but this would involve an additional charge.
    241 
    242 == Issues
    243 
    244 1. Missing Hypertension codes
    245 
    246     I (RB) am still unclear which coding system is being used.  Therefore I am going to submit the codes from DM+D, Read CTV3, ATC code and BNF code and see what comes back.
    247 
    248 2. Missing Diabetes Type 1 codes
    249 
    250     The paper in the BMJ says that the QRisk2 algorithm uses a diagnosis of diabetes type 1, but not type 2.  However, the QRisk2 batch processor accepts a parameter for diabetes type 1 and this affects the result.  Therefore, I (RB) have got to submit the Type 1 codes above, but keep them separated.
    251 
    252     I have sought clarification from Stephen Hippisley-Cox at ClinRisk about why this requirement has changed.
    253 
    254 3. Missing Similar Codes
    255 
    256     It has become clear that we need to expand the codes used to define certain values (eg, blood pressure) to include other codes that we have yet been requesting.  This will have to be done by manually searching the Read Code hierarchy.
    257 
    258     I have asked Sarah-Jane to post a question on the SystemOne User Forum to see if we can get a definitive list of codes that are used.
    259 
    260     I have been sent a link to the codes that ClinRisk suggest by Stephen Hippisley-Cox.  http://qrisk.org/QRISK2-2013-Code-Lists.pdf
    261 
    262 4. Historic diagnosis
    263 
    264     I think that we need to ignore the ''window'' when it comes to diagnoses.  This needs to be confirmed by Prof.
    265 
    266 5. Differing versions of the QRisk2 algorithm
    267 
    268     Sarah-Jane has posted a question on the SystemOne user forum asking which version they use.
    269 
    270 6. Discrepancies between SystemOne and ClinRisk QRisk2 calculation tools
    271 
    272     The SystemOne QRisk2 calculation tool has some differences to the ClinRisk tool.  Instead of separating diabetes into types 1 and 2, it just has a tick box for diabetes.  Also, it has a tick box for 'personal history of CVD' that is not present on the ClinRisk QRisk2 calculations tools.
    273 
    274     I have asked Sarah-Jane to post a question on the SystemOne user forum asking what differences this will make to the result.
     164    ''XaPkZ - Cardiovascular disease risk assessment done'
    275165
    276166[[BackLinks]]