ADR Metadata Catalogue

ADR  > National Community Child Health Database (NCCH) @ 360

https://saildatabank.com/about-us/, https://popdatasci.swan.ac.uk/centres-of-excellence/sail/, https://saildatabank.com/, https://www.gov.wales/healthy-child-wales-programme, https://statswales.gov.wales/Catalogue/Health-and-Social-Care/NHS-Primary-and-Community-Activity/Healthy-Child-Wales-Programme, https://www.datadictionary.wales.nhs.uk/index.html#!WordDocuments/livedataitemsaz.htm

The Child Health System in Wales; includes birth registration and monitoring of child health examinations and immunisations.

The dataset brings together data from local Child Health System databases which are held by NHS Trusts and used by them to administer child immunisation and health surveillance programmes.

The dataset contains all children born, resident or treated in Wales and born after 1987.

This dataset requires additional governance approvals from the data provider before data can be provisioned to a SAIL project.

Please note: the view &#039;CHILD_MEASUREMENT_PROGRAM&#039; must be explicitly requested in the IGRP (governance) application in Section 5,  where the information required from this view must be listed.

SAIL Databank (Wales)

DHCW

Date when the data made available i.e. date of loading

AVAIL_FROM_DT

Contains blood test data, required to monitor outcomes for tests for genetic disorders such as cystic fibrosis. Test data includes test outcome codes [please note that codes differ pre/post June 2012; new tests added post Jan 2015], test date, and anonymised ID of patient.

BLOOD_TEST

Unique encrypted client identifier - generated by CCH2000 for child in the trust. Needs to be used along with PROV_UNIT_CD to uniquely identify a child.

CLIENT_ID_E

Provider unit code - the NHS trust organisation code for the provider / Local Health Board.

PROV_UNIT_CD

SECTOR

TDATE_EST

TEST_CD

TEST_DT

Code indicating outcome of blood test. NOTE - codes are different starting pre/post 2012. Pre-2012 codes range from A-M, and Post-2012 codes range from 01-10.

TEST_RESULT_CD

The Anonymised Linking Field, which has been Encrypted for its use within the database, is derived from the persons NHS number by double encryption (first encryption occurs in DHCW and the second in SAIL). If the NHS number is not supplied in the data extract then matching methods are applied.

ALF_E

BREAST_FEEDING

Unique encrypted child identifier, to be used to link between other NCCHD data views. Number of records does not equal the number of CHILD_ID_E&amp;#039;s, so there are duplicates; also possible that one individual has several CHILD_ID_E&amp;#039;s.

CHILD_ID_E

COLLECTION_DT

COLLECTION_TIME_ID

OUTCOME_ID

REC_STS

Contains data relating to Healthy Child Wales

CHE_HEALTHYCHILDWALESPROGRAMME

COGNITIVE_SKILLS

CONSENT

CONTACT

CONTACT_AGE

DEVELOPMENT

DOMESTIC_VIOLENCE

DT_OF_CONTACT

ENGAGEMENT

Code to denote Examiner Type. Type of examiners can include Doctor, School Nurse, Child Health Admin, Vision Screener, and etc. Records most often obtained via School Nurse.

EXAMINER_TYPE

EYES

FAMILY_HEALTH

FAMILY_SUPPORT

FGM_EVIDENCE

FRAIT

FURTHER_DEVELOPMENT

GENERAL

HEAD

HEARING_LANGUAGE_SKILLS

HEART

Height in cm. Typically this dataset will either miss an entry for height, or weigh, or both; thus the BMI [body-mass index] can only be calculated for 40-50% of the dataset as a whole.

HEIGHT

HIPS

INTERACTIVE_SOCIAL_SKILLS

LOCOMOTOR_SKILLS

LOC_TYPE

LOOKED_AFTER

MANIPULATIVE_SKILLS

ONWARD_REFERRALS_MADE

ON_PROTECTION_REGISTER

Reason for no examination. These reasons can include: 1=Opted Out, 2=Uncooperative child, 3=Unwell, 4=Left School, 5=Session Cancelled, 6=Absent that day.

REASON_NON_EXAM

REC_FLYING_START_SERVICES

RESP_PARENTING

SELF_CARE_SOCIAL_SKILLS

SOCIO_ECONOMIC

SPEECH_LANGUAGE_SKILLS

TESTES

VISUAL_SKILLS

Weight in kg. Typically this dataset will either miss an entry for height, or weigh, or both; thus the BMI [body-mass index] can only be calculated for 40-50% of the dataset as a whole.

WEIGHT

Primarily provides child birth information, such as birth weight, gestation time, birth order, as well as information regarding the mother [e.g. smoker, type of maternity care]. The recommended table to use is this CHILD table, as opposed to CHILD_TRUST.

CHILD

Anonymised Linked Field Match Percentage. This number is a match % score from probabalistic matching, when joining together anonymised data. This linkage process consists of matching against the Welsh Demographic Service by NHS number, where a valid number exists, and where there is no valid number then matching is attempted using first name, surname, date of birth, and postcode. This is an artificial score with no real-world meaning; i.e. a match of .99 does not mean there is a 99% chance the match is correct. This number is assigned when deriving the Encrypted Anonymised Linking Field.

ALF_MTCH_PCT

Anonymised Linked Field Status Code. This is assigned when deriving the Encrypted Anonymised Linking Field.

ALF_STS_CD

APGAR 1 score. This is a measure of a baby&amp;#039;s physical state at birth with particular reference to asphyxia - taken at 1 minute. Scores 3 and below are generally regarded as critically low; 4-6 fairly low, and 7-10 generally normal. Field can contain high amount of unknowns/non-entries.

APGAR_1

APGAR 2 score. This is a measure of a baby&amp;#039;s physical state at birth with particular reference to asphyxia - taken at 5 minutes. Scores 3 and below are generally regarded as critically low; 4-6 fairly low, and 7-10 generally normal. Field can contain high amount of unknowns/non-entries.

APGAR_2

Birth order. Order of birth for multiple births - this will mainly be &amp;#039;1&amp;#039; as most births are single births. Approx 10% of this dataset will be NULL/missing values.

BIRTH_ORDER

Time of birth. Approx 20% of this dataset will be NULL/missing values.

BIRTH_TM

Weight of the child at birth [actual]. Both metric and imperial units are included.

BIRTH_WEIGHT

Weight [as a decimal] of the child at birth - this is supposedly the &amp;#039;cleaned&amp;#039; version of BIRTH_WEIGHT, however both fields are the same.

BIRTH_WEIGHT_DEC

Indicates if child is breastfed at 6/8 weeks after birth. 1 = Breastfed.

BREASTFEED_8_WKS_FLG

Denotes the actual method of feeding established at the time of discharge from maternity care, typically within 1 week. 1 = Breastfed.

BREASTFEED_BIRTH_FLG

Current Local Health Board [LHB] code for the place of birth.

CURR_LHB_CD_BIRTH

Delivery code. This indicates mode of delivery for child, e.g. elective c-section, normal vertex, forceps low/other, and etc.

DEL_CD

Date of death of child. This is derived using the current status date where current status = 5.

ETHNIC_GRP_CD

Gestation age. This is the best estimate of gestation [in completed weeks] at time of delivery; this is normally based on the postmenstrual age, but may be modified on the basis of antenatal ultrasound scan. Where gestation is unknown, it is based on the postnatal estimate of maturity. Gestational age is an important determinate of outcome; a major risk factor for neonatal mortality and morbidity, and it required to analyse the outcomes of antenatal and perinatal care. Gestation age should also be taken into account when assessing growth and weight gain. Approx 20-30% of this dataset will be NULL/missing values.

GEST_AGE

This is the sex (gender) of person, employee or patient. Can potentially assist in correct identification of gender-specific primary cancer sites. Can potentially be different from gender identity as stated/assigned at birth.

GNDR_CD

Encrypted health visitor code. Unclear if this is assigned to health visitors or all visitors. Each Health Visitor requires a unique code to ascribe children to Health Visitor or School Nurse caseload. These codes are managed locally at Local Health Board level.

HEALTH_VISITOR_CD_E

Labour onset code - the method by which the process of labour began or delivery by a caesarean section occurred.

LABOUR_ONSET_CD

Current Local Health Board [LHB] code of current residence - derived from the postcode.

LHB_CD

The code for the Local Super Output Area [LSOA] of residence; this is a code created and maintained by Office for National Statistics. Not to be confused with LSOA name or other LSOA fields. 1909 LSOAs exist in Wales (2011 data); these have a minimum population of 1000, and a max population of 3000. The minimum number of households is 400, and the maximum number of households is 1200. If these threshold are breached, then LSOAs are either split or merged; however this is uncommon.

LSOA_CD

Age of the mother at the time of birth. NOTE - this field needs to be checked against the maternal week of birth [MAT_WOB], as there are a lot of erroneous entries here.

MAT_AGE

Encrypted Maternal Anonymised Linking Field. This is derived in the same fashion as ALF_E. The number of CHILD_ID_E records do not equal the number of MAT_ALF_E&amp;#039;s; this means that some records have not been matched with MAT_ALF_E&amp;#039;s.

MAT_ALF_E

Mother Care code - the type of maternity care allocated/received for the mother. Different codes exist for missing data. Types of care range from booked midwifery, community hospital, or consultant-led care.

MAT_CARE_CD

This is the history of the cigarette smoking habit of the mother. Codes refer to categorised rank of smoking or if smoker is in household, e.g. 0 = non-smoker, 1 = gave up during pregnancy, 2 = 0-9 per day, and etc.

MAT_SMOKING_CD

Maternal week of birth; i.e. same as WOB but for the mother. This is derived in the same fashion as WOB.

MAT_WOB

The number of livebirths a woman has had in previous pregnancies. Used along with PREV_STILLBIRTH data item to calculate parity.

PREV_LIVE_BIRTHS

The number of stillbirths a woman has had in previous pregnancies. Used along with PREV_LIVE_BIRTHS data item to calculate parity.

PREV_STILLBIRTH

Provider site code. Approx 20% of this dataset will be NULL/missing values.

PROV_SITE_CD

Stillbirth flag. This is only filled in where there is a case of stillbirth. Normal value in case of stillbirth = 1.

STILLBIRTH_FLG

Total number of births. Normal value = 1. Highest value [so far] = 5.

TOT_BIRTH_NUM

Indicates whether the mother is resident in Wales at the time of birth of the child.

WELSH_BIRTH_FLG

The date of the Monday that occurs prior, or on, the actual date of birth. Access to this data item is limited, however, as it can be used to calculate age at specific events. Possible errors in extract may include patients with events and event dates before WOB.

Primarily provides child birth information, such as birth weight, gestation time, birth order, as well as information regarding the mother [e.g. smoker, type of maternity care].

CHILD_BIRTHS

The Child Health System in Wales; includes birth registration and monitoring of child health examinations and immunisations.

National Community Child Health Database (NCCH)

Immunisation data table which contains immunisation/vaccination course ID, course date, manufacturer Batch Number of vaccine, location, examiner, and other factors required for monitoring uptake of childhood immunisations.

Contains pathology specimen related details

PATH_SPCM_DETAIL

Reference table for immunisation/vaccination course given; lists codes and corresponding course descriptions.

REFR_IMM_VAC

PATH_BLOOD_TESTS

Significant conditions table provides diagnosis codes, data of diagnosis, and outcome - this table is used to inform CARIS [Congenital Anomaly Register &amp;amp; Information Service] in order to monitor birth defects.

SIG_COND

CHILD_TRUST

This table provides examination details pertaining to each child, including height, weight, vision test, physical test, and etc; this is required for monitoring child development.

EXAM

This table provides child examination information, such as height and weight measurements, as well as audio and visual examinations. The Child Measurement Programme for Wales is a surveillance programme set up to better understand how children in Wales are growing. The programme uses information collected by school nursing services who were already measuring the heights and weights of all reception class children in Wales. Important: The first child health system migrated to CYPriS on 16th July 2018; use CCH2000 codes for historic data (date &amp;lt;01/07/2018). Unique records can be found using CLIENT_ID_E along with PROV_UNIT_CD, to uniquely identify a child. Please note: The event date range in this view is different from the other NCCHD views. Data for an academic year will be made available after the official data has been published by the Welsh Government (e.g. 2022/23 data is published in May 2024).This View will only be provisioned if explicitly requested within the IGRP form under Section 5 &amp;#039;Please list the information needed from this dataset&amp;#039;.

National Community Child Health Database (NCCH)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin