Test page: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
No edit summary
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{TOC right}}
==Sortable tables==


{| class="sortable" border="1" style="border-collapse:collapse"
{| class="sortable" border="1" style="border-collapse:collapse"
|- style="background-color:#90A4AE; color: white"  
|- style="background-color:#90A4AE; color: white"  
!scope="col" width="20%" |Date
!scope="col" width="10%" |Updated
!scope="col" width="10%" |Issue
!scope="col" width="10%" |Issue
!scope="col" width="60%" |Summary
!scope="col" width="55%" |Summary
!scope="col" width="10%" |Status
!scope="col" width="7%" |Status
!scope="col" width= 6%"  |Sites affected
!scope="col" width= 6%"  |Subscribers affected
!scope="col" width= 6%"  |STP
|- valign="top"
|- valign="top"
|'''[[Cabergoline]]'''
|21 January 2021
|Barts Health NHS Trust
|COVID-19 vaccinations
|The aim of this project is to determine whether there is a link between cabergoline at lower ‘endocrine doses’ (typically used in the treatment of hyperprolactinaemia) and the development of fibrotic heart disease.
|'''How long does it take to get the COVID-19 vaccination notifications into the patient records in EMIS Web?'''
|Patient identifiable
EMIS have informed us that "data is collected by NHS Digital at 22:00 each day, comprising all vaccination data received in that last 24 hour period. NHS Digital send us this data the following day and we will perform a daily upload of these vaccination notifications during that afternoon."
|Ongoing
|xxxx
|xxxxx
|xxxx
|-
|-
|'''[[Childhood immunisations]]'''
|13 May 2020
|Barking and Dagenham, Havering & Redbridge (BHR) CCGs
|
|The childhood immunisations extract provides Barking and Dagenham, Havering & Redbridge (BHR) CCGs with child health data from GP systems.
|
|Patient identifiable and anonymised
|
|-
|
|'''[[Childhood immunisations and six week check]]'''
|
|North East London Child Health Information Service (CHIS)
|
|The daily extract (delta) provides an update on changes made to the defined criteria over the past 24 hours; so that the hub and GP systems are in sync.
|Patient identifiable
|-
|'''[[Diabetes retinopathy recall]]'''
|Barking and Dagenham, Havering & Redbridge (BHR) CCGs
|This project aims to identify sight-threatening diabetic eye disease at a treatable stage, to prevent blindness in people with diabetes.
|Patient identifiable
|-
|'''[[East London Genes and Health]]'''
|Newham, City and Hackney, Tower Hamlets and Waltham Forest CCGs
|The East London Genes and Health (ELG&H) study aims to improve the health of people of Pakistani and Bangladeshi heritage by analysing the genes and health of 100,000 local people.
|Patient identifiable
|-
|'''[[ELHCP Analytics Portal]]'''
|East London Health & Care Partnership
|Link with Discovery to combine data across the STP footprint to deliver a collaborative and fully informed approach to a holistic view of the citizen in the STP footprint, to enable predictive analytics to be more proactive in delivering healthcare and to provide a portal for informed and effective service redesign and planning.
|Pseudonymised
|-
|'''[[Health checks (BHR)]]'''
|Barking and Dagenham, Havering & Redbridge (BHR) CCGs
|The Barking and Dagenham, Havering & Redbridge CCG Health check project uses a DDS query to identify all individuals who are eligible for an NHS Health Check.
|Patient identifiable
|-
|'''[[LBH Adult Social Care linkage]]'''
|London Borough of Hackney
|Linking adult social care users to primary and secondary care data.
|Pseudonymised
|-
|'''[[Molecular Epidemiology Approach Towards Pancreatic Cancer (PaC)]]'''
|Barts Cancer Institute, Queen Mary University of London
|Molecular pathological epidemiology (MPE) has contributed to the better understanding of several neoplastic diseases . By connecting putative etiological factors to specific molecular signatures across tumour phenotypes, the MPE approach can yield more accurate risk measures regarding PaC. Towards this broad goal, a case-control study will be conducted first on patients with different types of pancreas cancer and pancreatico-biliary diseases to identify associations among potential risk factors and PaC diagnosis and prognosis.
|Anonymised
|-
|-
|'''[[NE London Diabetes Eye Screening Data Access]]'''
|Homerton University Hospital NHS Foundation Trust
|To provide a monthly list of 'Everyone with Diabetes', the information will be used for direct patient care purpose to ensure all those who need it are screened, and those who have moved away or died are not invited for screening unnecessarily.
|Patient identifiable
|-
|'''[[NHS 111 Discovery frailty flagging]]'''
|Inner East London; City and Hackney, Tower Hamlets, Waltham Forset, and Newham CCGs
|"As a London Ambulance Service (LAS) clinician who provides expertise for NHS 111 in North East London (NEL), I want to obtain access to the local NEL information within the Discovery Dataset to determine whether the caller is potentially seriously frail." The Discovery Data Service helps to identify potentially frail patients using a frailty algorithm and the results are provided via the Get flag for patient API.
|Patient identifiable
|-
|'''[[Serious Mental Illness (SMI)]]'''
|East London Foundation Trust (ELFT)
|The SMI query reconciles ELFT secondary care mental health data with primary care SMI datasets.
|Pseudonymised
|-
|'''[[Whole Systems Data Project]]'''
|Tower Hamlets CCG
|The project provides an integrated health, social care and wider determinants of health dataset across Tower Hamlets that allows effective risk stratification and needs-based resource allocation for the local population based on evidence.
|Patient identifiable and anonymised
|-
|'''[[LBH Social Services Interventions]]'''
|London Borough of Hackney
|The aim of the project is to link primary care and secondary care data to adult social care records on an individual level to understand the prevalence of multimorbidity and healthcare usage among those people with short and long term social care packages in order to target potential interventions such as digital CBT promoted through social services.
|Pseudonymised
|-
|[[Whole Systems Integrated Care Data Warehouse (WSIC)|'''Whole Systems Integrated Care Data Warehouse (WSIC)''']]
|North West London CCGs
|This project provides WISC with patient data, as bulk and delta data files, for all North West London GPs and community services.
|Patient identifiable
|-
|-
|}
|}


''Tooltips''
== Tooltips ==
 
{{#tip-text: text | tooltip-text}} {{#tip-info: icon tooltip text}}
{{#tip-text: text | tooltip-text}} {{#tip-info: icon tooltip text}}


{{#tip-img: images/8/84/IM_Package_Value_set.jpg | image tooltip}}
{{#tip-img: images/8/84/IM_Package_Value_set.jpg | image tooltip}}


 
==Text colour==
Set '''text''' color by using  
Set '''text''' color by using  


<span style="color:#FF0000">This text will be red</span>
<span style="color:#FF0000">This text will be red</span>
<span style="color:#000080">'''<nowiki></span></nowiki>'''</span>
<span style="color:#000080">'''<nowiki></span></nowiki>'''</span>
==External document links==


This is a test link to a google drive document > DDS Wiki > Public documents > [https://drive.google.com/file/d/1ZhuPIySPCv-gvHBepXbGogk7wtv42VgQ/view?usp=sharing test xls link]
This is a test link to a google drive document > DDS Wiki > Public documents > [https://drive.google.com/file/d/1ZhuPIySPCv-gvHBepXbGogk7wtv42VgQ/view?usp=sharing test xls link]
Line 101: Line 52:
This is some test text...
This is some test text...


==Images==
[[File:East London genes and health 588x115.jpg|link=http://www.genesandhealth.org]]
==Image preview tooltip==


<imagemap>
<imagemap>
Line 106: Line 62:
default [[Whole_Systems_Data_Project|WSDP]]
default [[Whole_Systems_Data_Project|WSDP]]
</imagemap>
</imagemap>
[[File:East London genes and health 588x115.jpg|link=http://www.genesandhealth.org]]


This is a link to an <span>image</span> with a preview on tooltip
This is a link to an <span>image</span> with a preview on tooltip
Line 116: Line 67:
<div class="line"><span>THIS IS A TEST</span></div>
<div class="line"><span>THIS IS A TEST</span></div>
<p>this is some content other</p>
<p>this is some content other</p>
==Note/Warning/Info/Tip/Question==


{{Warning| This is a warning.}}
{{Warning| This is a warning.}}
Line 121: Line 74:
{{Info| This is some info.}}
{{Info| This is some info.}}
{{Tip| This is a tip.}}
{{Tip| This is a tip.}}
{{Question| This is a question.}}<br />
== Ordered lists ==
<ol>
  <li>About the author</li>
  <li>Foreword to the first edition</li>
  <li>Foreword to the second edition</li>
<li>test
<ol>
  <li>About the author</li>
  <li>Foreword to the first edition</li>
  <li>Foreword to the second edition
<ol>
  <li>About the author</li>
  <li>Foreword to the first edition</li>
  <li>Foreword to the second edition</li>
</ol></li>
</ol>
</li>
</ol>
<ol>
  <li>About the author</li>
  <li>Foreword to the first edition</li>


  <li>Foreword to the second edition</li>


=Tables=
</ol>
<br />
==Tables==


{| class="mw-collapsible" border="1" cellpadding="1" cellspacing="1" style="width: 500px;" summary="Summary"
{| class="mw-collapsible" border="1" cellpadding="1" cellspacing="1" style="width: 500px;" summary="Summary"
Line 156: Line 155:
</div>
</div>


=Syntax Highlight=
==Syntax Highlight==


== SQL==
=== SQL===
This section should be highlighted source code (SQL)
This section should be highlighted source code (SQL)
<syntaxhighlight lang="SQL">SELECT *  
<syntaxhighlight lang="SQL">SELECT *  
Line 164: Line 163:
WHERE patient_id = 1234 </syntaxhighlight>
WHERE patient_id = 1234 </syntaxhighlight>


==JSON==
===JSON===
<syntaxhighlight lang="JSON">
<syntaxhighlight lang="JSON">
{
{
Line 172: Line 171:
</syntaxhighlight>
</syntaxhighlight>


==Java==
===Java===
<syntaxhighlight lang="java">
<syntaxhighlight lang="java">
public class Test {
public class Test {
Line 281: Line 280:
|}
|}


&nbsp;
== &nbsp;Expanding text ==
 
<div class="toccolours mw-collapsible mw-collapsed">
<div class="toccolours mw-collapsible mw-collapsed">
This text is not collapsible; but the next is collapsible and hidden by default:
This text is not collapsible; but the next is collapsible and hidden by default:
Line 295: Line 293:


[[Image:Family relationships.jpg|right|thumb|Example of a family tree. Reading left to right Lucas Grey is the father of three children, the grandfather of five grandchildren and the great-grandfather of three siblings Joseph, John and Laura Wetter.]]
[[Image:Family relationships.jpg|right|thumb|Example of a family tree. Reading left to right Lucas Grey is the father of three children, the grandfather of five grandchildren and the great-grandfather of three siblings Joseph, John and Laura Wetter.]]
{{multiple image
| footer    = Players are cautioned with a yellow card and sent off with a red card.
| width    = 60
| image1    = Yellow card.svg
| alt1      = Yellow cartouche
| image2    = Red card.svg
| alt2      = Red cartouche
}}
==Font awesome==
Font Awesome
{{#far:abacus}}

Revision as of 13:15, 17 June 2021

Sortable tables

Updated Issue Summary Status Sites affected Subscribers affected STP
21 January 2021 COVID-19 vaccinations How long does it take to get the COVID-19 vaccination notifications into the patient records in EMIS Web?

EMIS have informed us that "data is collected by NHS Digital at 22:00 each day, comprising all vaccination data received in that last 24 hour period. NHS Digital send us this data the following day and we will perform a daily upload of these vaccination notifications during that afternoon."

Ongoing xxxx xxxxx xxxx
13 May 2020

Tooltips

text

Text colour

Set text color by using

This text will be red </span>

External document links

This is a test link to a google drive document > DDS Wiki > Public documents > test xls link


This is some test text...

Images

East London genes and health 588x115.jpg


Image preview tooltip

Alt text
About this image

This is a link to an image with a preview on tooltip

THIS IS A TEST

this is some content other

Note/Warning/Info/Tip/Question

This is a warning.
This is a note.
This is some info.
This is a tip.
This is a question.


Ordered lists

     
  1. About the author
  2.  
  3. Foreword to the first edition
  4.  
  5. Foreword to the second edition
  6. test
       
    1. About the author
    2.  
    3. Foreword to the first edition
    4.  
    5. Foreword to the second edition
         
      1. About the author
      2.  
      3. Foreword to the first edition
      4.  
      5. Foreword to the second edition
     
  1. About the author
  2.  
  3. Foreword to the first edition
  4.  
  5. Foreword to the second edition


Tables

xxxzxxz--David Stables 11:18, 5 May 2020 (UTC)Caption
Code Term

H33..
Asthma
G33..
Diabetes

 

Code Term
H33.. Asthma
G33.. Diabetes

 


This text is not collapsible; but the next is collapsible and hidden by default:

This is additional hidden text
 

Syntax Highlight

SQL

This section should be highlighted source code (SQL)

SELECT * 
FROM observation 
WHERE patient_id = 1234

JSON

{
    "iri" : ":DM_RecordModel",
    "status" : "Active"
}

Java

public class Test {
    private int _id;
    public String name;
}

this is Jo's test open office to mediawiki:

1.    Table: allergy_intolerance

PRIMARY KEY (organization_id,person_id,id)

Column name Data type Constraint Comments References
id bigint(20) NOT NULL

 

 

organization_id bigint(20) NOT NULL Owning organisation (i.e. publisher) organization.id
patient_id bigint(20) NOT NULL The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times patient.id
person_id bigint(20) NOT NULL Unique individual across all organisations person.id
encounter_id bigint(20) DEFAULT NULL

 

encounter.id
practitioner_id bigint(20) DEFAULT NULL The clinician the activity is recorded against practitioner.id
clinical_effective_date date DEFAULT NULL The date the clinical code is recorded for  
date_precision_id smallint(6) DEFAULT NULL Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)  
snomed_concept_id bigint(20) DEFAULT NULL The SNOMED code  
original_code varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL The original code from the source system  
original_term varchar(1000) DEFAULT NULL The original code term from the source system  
is_review tinyint(1) NOT NULL Is this instance of the code a review of a previous encounter  
PRIMARY KEY (organization_id,person_id,id),
UNIQUE KEY allergy_intolerance_id (id),
KEY allergy_intolerance_patient_id (patient_id),
KEY allergy_intolerance_snomed_concept_id (snomed_concept_id)
 

 Expanding text

This text is not collapsible; but the next is collapsible and hidden by default:

{
    "iri" : ":DM_RecordModel",
    "status" : "Active"
}
 


Example of a family tree. Reading left to right Lucas Grey is the father of three children, the grandfather of five grandchildren and the great-grandfather of three siblings Joseph, John and Laura Wetter.

Template:Multiple image

Font awesome

Font Awesome