{"Section":"BLOOD_TEST","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"BLOOD_TEST","Column.name":"CLIENT_ID_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"BLOOD_TEST","Column.name":"PROV_UNIT_CD","Data.type":"CHARACTER","Column.description":"Provider unit code - the NHS trust organisation code for the provider / Local Health Board.","Sensitive":"false"}
{"Section":"BLOOD_TEST","Column.name":"SECTOR","Data.type":"CHARACTER","Column.description":"_","Sensitive":"false"}
{"Section":"BLOOD_TEST","Column.name":"TDATE_EST","Data.type":"CHARACTER","Column.description":"_","Sensitive":"false"}
{"Section":"BLOOD_TEST","Column.name":"TEST_CD","Data.type":"CHARACTER","Column.description":"Type of blood test.","Sensitive":"false"}
{"Section":"BLOOD_TEST","Column.name":"TEST_DT","Data.type":"TIMESTAMP","Column.description":"Date if blood test.","Sensitive":"false"}
{"Section":"BLOOD_TEST","Column.name":"TEST_RESULT_CD","Data.type":"CHARACTER","Column.description":"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.","Sensitive":"false"}
{"Section":"BREAST_FEEDING","Column.name":"ALF_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"BREAST_FEEDING","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"BREAST_FEEDING","Column.name":"CHILD_ID_E","Data.type":"BIGINT","Column.description":"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's, so there are duplicates; also possible that one individual has several CHILD_ID_E's.","Sensitive":"false"}
{"Section":"BREAST_FEEDING","Column.name":"COLLECTION_DT","Data.type":"TIMESTAMP","Column.description":"Collection Data","Sensitive":"false"}
{"Section":"BREAST_FEEDING","Column.name":"COLLECTION_TIME_ID","Data.type":"VARCHAR","Column.description":"Collection Time Identifier","Sensitive":"false"}
{"Section":"BREAST_FEEDING","Column.name":"OUTCOME_ID","Data.type":"VARCHAR","Column.description":"Outcome Identifier","Sensitive":"false"}
{"Section":"BREAST_FEEDING","Column.name":"REC_STS","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"BREAST_FEEDING","Column.name":"SECTOR","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"CLIENT_ID_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"COGNITIVE_SKILLS","Data.type":"VARCHAR","Column.description":"Cognitive Skills","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"CONSENT","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"CONTACT","Data.type":"DECIMAL","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"CONTACT_AGE","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"DEVELOPMENT","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"DOMESTIC_VIOLENCE","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"DT_OF_CONTACT","Data.type":"TIMESTAMP","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"ENGAGEMENT","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"EXAMINER_TYPE","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"EYES","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"FAMILY_HEALTH","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"FAMILY_SUPPORT","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"FGM_EVIDENCE","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"FRAIT","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"FURTHER_DEVELOPMENT","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"GENERAL","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"HEAD","Data.type":"DECIMAL","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"HEARING_LANGUAGE_SKILLS","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"HEART","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"HEIGHT","Data.type":"DECIMAL","Column.description":"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.","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"HIPS","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"INTERACTIVE_SOCIAL_SKILLS","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"LOCOMOTOR_SKILLS","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"LOC_TYPE","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"LOOKED_AFTER","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"MANIPULATIVE_SKILLS","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"ONWARD_REFERRALS_MADE","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"ON_PROTECTION_REGISTER","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"PROV_UNIT_CD","Data.type":"CHARACTER","Column.description":"Provider unit code - the NHS trust organisation code for the provider / Local Health Board.","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"REASON_NON_EXAM","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"REC_FLYING_START_SERVICES","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"RESP_PARENTING","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"SELF_CARE_SOCIAL_SKILLS","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"SOCIO_ECONOMIC","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"SPEECH_LANGUAGE_SKILLS","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"TESTES","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"VISUAL_SKILLS","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHE_HEALTHYCHILDWALESPROGRAMME","Column.name":"WEIGHT","Data.type":"DECIMAL","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"ALF_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"ALF_MTCH_PCT","Data.type":"DECIMAL","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"ALF_STS_CD","Data.type":"CHARACTER","Column.description":"Anonymised Linked Field Status Code. This is assigned when deriving the Encrypted Anonymised Linking Field.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"APGAR_1","Data.type":"CHARACTER","Column.description":"APGAR 1 score. This is a measure of a baby'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.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"APGAR_2","Data.type":"CHARACTER","Column.description":"APGAR 2 score. This is a measure of a baby'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.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"CHILD","Column.name":"BIRTH_ORDER","Data.type":"SMALLINT","Column.description":"Birth order. Order of birth for multiple births - this will mainly be '1' as most births are single births. Approx 10% of this dataset will be NULL/missing values.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"BIRTH_TM","Data.type":"TIME","Column.description":"Time of birth. Approx 20% of this dataset will be NULL/missing values.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"BIRTH_WEIGHT","Data.type":"REAL","Column.description":"Weight of the child at birth [actual]. Both metric and imperial units are included.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"BIRTH_WEIGHT_DEC","Data.type":"DECIMAL","Column.description":"Weight [as a decimal] of the child at birth - this is supposedly the 'cleaned' version of BIRTH_WEIGHT, however both fields are the same.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"BREASTFEED_8_WKS_FLG","Data.type":"CHARACTER","Column.description":"Indicates if child is breastfed at 6/8 weeks after birth. 1 = Breastfed.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"BREASTFEED_BIRTH_FLG","Data.type":"CHARACTER","Column.description":"Denotes the actual method of feeding established at the time of discharge from maternity care, typically within 1 week. 1 = Breastfed.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"CHILD_ID_E","Data.type":"INTEGER","Column.description":"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's, so there are duplicates; also possible that one individual has several CHILD_ID_E's.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"CURR_LHB_CD_BIRTH","Data.type":"CHARACTER","Column.description":"Current Local Health Board [LHB] code for the place of birth.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"DEL_CD","Data.type":"CHARACTER","Column.description":"Delivery code. This indicates mode of delivery for child, e.g. elective c-section, normal vertex, forceps low/other, and etc.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"DOD","Data.type":"TIMESTAMP","Column.description":"Date of death of child. This is derived using the current status date where current status = 5.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"ETHNIC_GRP_CD","Data.type":"CHARACTER","Column.description":"Ethnic Group Code","Sensitive":"false"}
{"Section":"CHILD","Column.name":"GEST_AGE","Data.type":"CHARACTER","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"GNDR_CD","Data.type":"CHARACTER","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"HEALTH_VISITOR_CD_E","Data.type":"INTEGER","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"LABOUR_ONSET_CD","Data.type":"CHARACTER","Column.description":"Labour onset code - the method by which the process of labour began or delivery by a caesarean section occurred.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"LHB_CD","Data.type":"CHARACTER","Column.description":"Current Local Health Board [LHB] code of current residence - derived from the postcode.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"LSOA_CD","Data.type":"CHARACTER","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"MAT_AGE","Data.type":"INTEGER","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"MAT_ALF_E","Data.type":"BIGINT","Column.description":"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's; this means that some records have not been matched with MAT_ALF_E's.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"MAT_CARE_CD","Data.type":"CHARACTER","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"MAT_SMOKING_CD","Data.type":"CHARACTER","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"MAT_WOB","Data.type":"DATE","Column.description":"Maternal week of birth; i.e. same as WOB but for the mother. This is derived in the same fashion as WOB.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"PREV_LIVE_BIRTHS","Data.type":"SMALLINT","Column.description":"The number of livebirths a woman has had in previous pregnancies. Used along with PREV_STILLBIRTH data item to calculate parity.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"PREV_STILLBIRTH","Data.type":"SMALLINT","Column.description":"The number of stillbirths a woman has had in previous pregnancies. Used along with PREV_LIVE_BIRTHS data item to calculate parity.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"PROV_SITE_CD","Data.type":"CHARACTER","Column.description":"Provider site code. Approx 20% of this dataset will be NULL/missing values.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"STILLBIRTH_FLG","Data.type":"CHARACTER","Column.description":"Stillbirth flag. This is only filled in where there is a case of stillbirth. Normal value in case of stillbirth = 1.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"TOT_BIRTH_NUM","Data.type":"SMALLINT","Column.description":"Total number of births. Normal value = 1. Highest value [so far] = 5.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"WELSH_BIRTH_FLG","Data.type":"CHARACTER","Column.description":"Indicates whether the mother is resident in Wales at the time of birth of the child.","Sensitive":"false"}
{"Section":"CHILD","Column.name":"WOB","Data.type":"TIMESTAMP","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"ALF_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"ALF_MTCH_PCT","Data.type":"DECIMAL","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"ALF_STS_CD","Data.type":"VARCHAR","Column.description":"Anonymised Linked Field Status Code. This is assigned when deriving the Encrypted Anonymised Linking Field.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"APGAR_1","Data.type":"VARCHAR","Column.description":"APGAR 1 score. This is a measure of a baby'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.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"APGAR_2","Data.type":"VARCHAR","Column.description":"APGAR 2 score. This is a measure of a baby'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.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"BIRTH_ORDER","Data.type":"SMALLINT","Column.description":"Birth order. Order of birth for multiple births - this will mainly be '1' as most births are single births. Approx 10% of this dataset will be NULL/missing values.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"BIRTH_TM","Data.type":"VARCHAR","Column.description":"Time of birth. Approx 20% of this dataset will be NULL/missing values.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"BIRTH_WEIGHT","Data.type":"DECFLOAT","Column.description":"Weight of the child at birth [actual]. Both metric and imperial units are included.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"BIRTH_WEIGHT_CAT","Data.type":"VARCHAR","Column.description":"Birth weight category - this is a derived variable. Categories list classes for birth weights, which are also used to discard outliers and missing values. Birth weight [BW] classes are defined as follows: Extremely low [ELBW], Very low [VLBW], Low [LBW], Normal [NBW], High [HBW], and Very high [VHBW]. Unclear if there is a strict lower limit for ELBW or upper limit to VHBW.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"BREASTFEED_8_WKS_FLG","Data.type":"INTEGER","Column.description":"Indicates if child is breastfed at 6/8 weeks after birth. 1 = Breastfed.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"BREASTFEED_BIRTH_FLG","Data.type":"INTEGER","Column.description":"Denotes the actual method of feeding established at the time of discharge from maternity care, typically within 1 week. 1 = Breastfed.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"CHILD_ID_E","Data.type":"BIGINT","Column.description":"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's, so there are duplicates; also possible that one individual has several CHILD_ID_E's.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"DEL_CD","Data.type":"VARCHAR","Column.description":"Delivery code. This indicates mode of delivery for child, e.g. elective c-section, normal vertex, forceps low/other, and etc.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"DOD","Data.type":"TIMESTAMP","Column.description":"Date of death of child. This is derived using the current status date where current status = 5.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"ETHNIC_GRP_CD","Data.type":"VARCHAR","Column.description":"Ethnic Group Code","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"GEST_AGE","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"GEST_AGE_CAT","Data.type":"VARCHAR","Column.description":"Gestation age category - this is a derived variable. Categories list classes for gestation ages, which are also used to discard outliers and missing values. Gestation age classes are defined as follows: Extremely Pre-Term [EPT], Very Pre-Term [VPT], Pre-Term, Term, Late-term. Unclear if there is a lower limit to EPT, e.g. would an extremely low number indicate miscarriage?","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"GNDR_CD","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"HEALTH_VISITOR_CD_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"HOSP_PROV_SITE_CD_BIRTH","Data.type":"VARCHAR","Column.description":"Hospital provider site code for the place of birth.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"LABOUR_ONSET_CD","Data.type":"VARCHAR","Column.description":"Labour onset code - the method by which the process of labour began or delivery by a caesarean section occurred.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"LHB_CD_BIRTH","Data.type":"CHARACTER","Column.description":"Current Local Health Board [LHB] code of current residence - derived from the postcode.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"LSOA_CD_BIRTH","Data.type":"VARCHAR","Column.description":"The code for the Local Super Output Area [LSOA] of residence is based on 2001 LSOA data; this is a code created and maintained by Office for National Statistics. Not to be confused with LSOA name or other LSOA fields. 1,896 LSOAs exist in Wales (2001 data); each with a population of approximately 1500.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"MAT_AGE","Data.type":"INTEGER","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"MAT_ALF_E","Data.type":"BIGINT","Column.description":"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's; this means that some records have not been matched with MAT_ALF_E's.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"MAT_ALF_MTCH_PCT","Data.type":"DECIMAL","Column.description":"Maternal 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.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"MAT_ALF_STS_CD","Data.type":"VARCHAR","Column.description":"Maternal Anonymised Linked Field Status Code. This is assigned when deriving the Encrypted Maternal Anonymised Linking Field.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"MAT_CARE_CD","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"MAT_SMOKING_CD","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"PREV_LIVE_BIRTHS","Data.type":"INTEGER","Column.description":"The number of livebirths a woman has had in previous pregnancies. Used along with PREV_STILLBIRTH data item to calculate parity.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"PREV_STILLBIRTH","Data.type":"INTEGER","Column.description":"The number of stillbirths a woman has had in previous pregnancies. Used along with PREV_LIVE_BIRTHS data item to calculate parity.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"STILLBIRTH_FLG","Data.type":"INTEGER","Column.description":"Stillbirth flag. This is only filled in where there is a case of stillbirth. Normal value in case of stillbirth = 1.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"TOT_BIRTH_NUM","Data.type":"SMALLINT","Column.description":"Total number of births. Normal value = 1. Highest value [so far] = 5.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"WELSH_BIRTH_FLG","Data.type":"INTEGER","Column.description":"Indicates whether the mother is resident in Wales at the time of birth of the child.","Sensitive":"false"}
{"Section":"CHILD_BIRTHS","Column.name":"WOB","Data.type":"DATE","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"ACADEMIC_YR_OF_EXAM","Data.type":"VARCHAR","Column.description":"Academic year that the child had the examination, e.g. 2012/13.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"ALF_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"BREAKFAST_IND","Data.type":"VARCHAR","Column.description":"DHCW advised to ignore this field - DO NOT USE. Y, N or null (99% are null)","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"CHILD_ID_E","Data.type":"BIGINT","Column.description":"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's, so there are duplicates; also possible that one individual has several CHILD_ID_E's.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"CLIENT_ID_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"CLOTHING","Data.type":"DECIMAL","Column.description":"Type of clothing worn by child being measured, e.g. \"light clothing\", \"heavy clothing\", etc. Most records are null or just \"light clothing\".","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"EDATE_EST","Data.type":"VARCHAR","Column.description":"DHCW advised to ignore this field - DO NOT USE. 1,2, D or null (99% are null)","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"EXAMINER_E","Data.type":"BIGINT","Column.description":"Encrypted unique ID for examiner.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"EXAMINER_TYPE","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"EXAM_DT","Data.type":"TIMESTAMP","Column.description":"Date of examination for EXAM_NUM. Problems exist here with duplicate records as well as wrong/incorrect date entries.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"EXAM_NUM","Data.type":"DECIMAL","Column.description":"Examination number, which lists the type of exam [e.g. 80 = reception year exam, 84 = Year 4 exam]. Theoretically this should be a unique identifier of the examinations carried out per child. However, there are duplicates due to: A - wrong examination date entries, B - duplicate examination numbers on the same date, C - duplicate numbers on different dates.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"EXAM_TIME","Data.type":"VARCHAR","Column.description":"Time of exam.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"HEIGHT","Data.type":"DECIMAL","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"HIP_CIR","Data.type":"DECIMAL","Column.description":"DHCW advised to ignore this field - DO NOT USE. 99% are null","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"LOCATION","Data.type":"VARCHAR","Column.description":"Location of where the examination was completed. These are school codes, which are unique to child health system so mapping is required. This reference table is not currently available.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"LOCATION_SCHEDULE","Data.type":"DECIMAL","Column.description":"DHCW advised to ignore this field - DO NOT USE.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"LOCATION_TYPE","Data.type":"VARCHAR","Column.description":"Type of location where the examination was completed. Important: The first child health system migrated to CYPriS on 16th July 2018, so CCH2000 codes for historic data (date <01/07/2018). Codes can range from School [approx 99% of records], to Clinic, Hospital, Exam Centre, At Home, or etc. Everything flagged as non-school typically has extremely low record counts, <10 or <100.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"LUNCH","Data.type":"VARCHAR","Column.description":"DHCW advised to ignore this field - DO NOT USE. Y, N or null (99% are null)","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"ORIGIN","Data.type":"VARCHAR","Column.description":"DHCW advised to ignore this field - DO NOT USE. S or null (6% are null)","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"ORIGINATOR","Data.type":"VARCHAR","Column.description":"DHCW advised to ignore this field - DO NOT USE. 100% NULL","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"PARENT_REQ_FEEDBACK","Data.type":"VARCHAR","Column.description":"DHCW advised to ignore this field - DO NOT USE. 1,2, Y or null (98% are null)","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"PROV_UNIT_CD","Data.type":"VARCHAR","Column.description":"Provider unit code - the NHS trust organisation code for the provider / Local Health Board.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"REASON_EXC_CMP","Data.type":"VARCHAR","Column.description":"Reason for no examination, or exclusion from CMP (1= Opted out, and 2 = Accurate measurements unobtainable). 1,2 or null (99% are null)","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"REASON_NON_EXAM","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"RECEPTION_ACADEMIC_YR","Data.type":"VARCHAR","Column.description":"Academic year that the child was in Reception class, e.g. 2012/13.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"STAFF_TYPE","Data.type":"VARCHAR","Column.description":"Reference table is not currently available.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"WAIST","Data.type":"DECIMAL","Column.description":"DHCW advised to ignore this field - DO NOT USE. 99% are null","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"WEIGHT","Data.type":"DECIMAL","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_MEASUREMENT_PROGRAM","Column.name":"YR4_ACADEMIC_YR","Data.type":"VARCHAR","Column.description":"Academic year that the child will be in Year 4 class, e.g. 206/17.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"AGE_BREASTFEED_CEASED_WKS","Data.type":"DECIMAL","Column.description":"Age of child [in weeks] when breastfeeding ceased.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"AGE_SOLID_FOOD_WKS","Data.type":"DECIMAL","Column.description":"Age of child [in weeks] at start of feeding with solid food.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"ALF_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"ALF_MTCH_PCT","Data.type":"DECIMAL","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"ALF_STS_CD","Data.type":"VARCHAR","Column.description":"Anonymised Linked Field Status Code. This is assigned when deriving the Encrypted Anonymised Linking Field.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"ANTENATAL_ASS_DT","Data.type":"TIMESTAMP","Column.description":"Antenatal assessement date.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"APGAR_1","Data.type":"VARCHAR","Column.description":"APGAR 1 score. This is a measure of a baby'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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"APGAR_2","Data.type":"VARCHAR","Column.description":"APGAR 2 score. This is a measure of a baby'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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"BIRTH_ORDER","Data.type":"SMALLINT","Column.description":"Birth order. Order of birth for multiple births - this will mainly be '1' as most births are single births. Approx 10% of this dataset will be NULL/missing values.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"BIRTH_TM","Data.type":"VARCHAR","Column.description":"Time of birth. Approx 20% of this dataset will be NULL/missing values.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"BIRTH_WEIGHT","Data.type":"DOUBLE","Column.description":"Weight of the child at birth [actual]. Both metric and imperial units are included.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"CHILD_ID_E","Data.type":"BIGINT","Column.description":"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's, so there are duplicates; also possible that one individual has several CHILD_ID_E's.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"CLIENT_ID_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"CURRENT_STS_CD","Data.type":"VARCHAR","Column.description":"Current Status Code","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"CURRENT_STS_CHANGE_DT","Data.type":"TIMESTAMP","Column.description":"Current Status Change Date","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"CURR_LHB_CD","Data.type":"VARCHAR","Column.description":"Code for the provider / Local Health Board.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"CURR_RECORD_END_OF_QTR","Data.type":"INTEGER","Column.description":"Current Record End of Quarter","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"DEL_CD","Data.type":"VARCHAR","Column.description":"Delivery code. This indicates mode of delivery for child, e.g. elective c-section, normal vertex, forceps low/other, and etc.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"ETHNIC_GRP_CD","Data.type":"VARCHAR","Column.description":"Ethnic Group Code","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"EXAM_STS_CD","Data.type":"VARCHAR","Column.description":"Examination status code - indicates where a child is receiving Pre-School examinations/screenings.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"FEEDING","Data.type":"VARCHAR","Column.description":"Code to denote type of feeding for the child [e.g. breast, bottle, other, etc].","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"FOETAL_DISTRESS_CD","Data.type":"CHARACTER","Column.description":"Indicator if foetal distress was present and/or monitored.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"GESTATION_AGE","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"GNDR_CD","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"GP_PRAC_CD_NHSAR_E","Data.type":"BIGINT","Column.description":"Encrypted NHSAR GP Practice Code","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"GP_STAFF_CD_E","Data.type":"BIGINT","Column.description":"Encrypted GP Staff Code","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"HEALTH_VISITOR_CD_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"HEALTH_VISITOR_PRAC_CD_E","Data.type":"BIGINT","Column.description":"Encrypted Health Visitor Practice Code","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"HEIGHT_CONSENT_FLG","Data.type":"CHARACTER","Column.description":"Indicates whether or not CMP [National Child Measurement Programme] consent was given.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"HIP_TEST_CD","Data.type":"SMALLINT","Column.description":"-","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"IMM_STS_CD","Data.type":"VARCHAR","Column.description":"Flag to indicate where a child is receiving immunisations.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"INITIAL_STS_CD","Data.type":"VARCHAR","Column.description":"Initial Status Code","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"INITIAL_STS_CHANGE_DT","Data.type":"TIMESTAMP","Column.description":"Initial Status Change Date","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"LABOUR_ONSET_CD","Data.type":"VARCHAR","Column.description":"Labour onset code - the method by which the process of labour began or delivery by a caesarean section occurred.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"LABOUR_PAIN_RELIEF_CD","Data.type":"CHARACTER","Column.description":"Flag to indicate if pain relief was administered during labour.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"LSOA2001_CD","Data.type":"VARCHAR","Column.description":"The code for the 2001 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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"LSOA2011_CD","Data.type":"VARCHAR","Column.description":"The code for the 2011 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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"MARKED_FLG","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"MAT_ALF_E","Data.type":"BIGINT","Column.description":"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's; this means that some records have not been matched with MAT_ALF_E's.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"MAT_ALF_MTCH_PCT","Data.type":"DOUBLE","Column.description":"Maternal 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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"MAT_ALF_STS_CD","Data.type":"VARCHAR","Column.description":"Maternal Anonymised Linked Field Status Code. This is assigned when deriving the Encrypted Maternal Anonymised Linking Field.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"MAT_CARE_CD","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"MAT_HEPB_STS_CD","Data.type":"CHARACTER","Column.description":"Maternal Hepatitis B status code. Data is mostly NULL [98%].","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"MAT_SMOKING_CD","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"MAT_WOB","Data.type":"TIMESTAMP","Column.description":"Maternal week of birth; i.e. same as WOB but for the mother. This is derived in the same fashion as WOB.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"MED_LOCAL_OPTIONS","Data.type":"VARCHAR","Column.description":"Medical Local Options","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"NURSE_CONSENT_FLG","Data.type":"CHARACTER","Column.description":"Indicates whether or not CMP [National Child Measurement Programme] consent was given.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"PERINEUM_CD","Data.type":"CHARACTER","Column.description":"Denotes the state of the perineum after labour.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"PREV_ABORTIONS","Data.type":"SMALLINT","Column.description":"The number of abortions a woman has had in previous pregnancies.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"PREV_LIVE_BIRTHS","Data.type":"SMALLINT","Column.description":"The number of livebirths a woman has had in previous pregnancies. Used along with PREV_STILLBIRTH data item to calculate parity.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"PREV_NEO_DEATHS","Data.type":"SMALLINT","Column.description":"The number of neonatal deaths a woman has had in previous pregnancies.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"PREV_STILLBIRTH","Data.type":"SMALLINT","Column.description":"The number of stillbirths a woman has had in previous pregnancies. Used along with PREV_LIVE_BIRTHS data item to calculate parity.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"PROV_UNIT_CD","Data.type":"VARCHAR","Column.description":"Provider unit code - the NHS trust organisation code for the provider / Local Health Board.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"RECORD_ORDER","Data.type":"INTEGER","Column.description":"-","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"RESEARCH_REC_CD","Data.type":"VARCHAR","Column.description":"Research Record Code","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"SCHOOL_CD_E","Data.type":"BIGINT","Column.description":"Encrypted school code.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"SCHOOL_NURSE_CD_E","Data.type":"BIGINT","Column.description":"Encrypted school nurse code.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"SCHOOL_NURSE_PRAC_CD_E","Data.type":"BIGINT","Column.description":"Encrypted school nurse practice code.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"TOT_BIRTH_NUM","Data.type":"SMALLINT","Column.description":"Total number of births. Normal value = 1. Highest value [so far] = 5.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"TRANSFER_IN_TRUST_CD","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"TRANSFER_OUT_TRUST_CD","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"WEIGHT_CONSENT_FLG","Data.type":"CHARACTER","Column.description":"Indicates whether or not CMP [National Child Measurement Programme] consent was given.","Sensitive":"false"}
{"Section":"CHILD_TRUST","Column.name":"WOB","Data.type":"TIMESTAMP","Column.description":"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.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"AUDIO_TEST_RES_CD","Data.type":"VARCHAR","Column.description":"Gives the result of the audio/hearing test given at an examination/screening. Codes are standard and broken out thusly: S=satisfactory; P=problem; O=observe; T=treatment; R=referral; N=not examined.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"EXAM","Column.name":"BEHAVIOUR_TEST_RES_CD","Data.type":"VARCHAR","Column.description":"This gives the result of the Behaviour test given at an examination/screening.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"CHILD_ID_E","Data.type":"BIGINT","Column.description":"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's, so there are duplicates; also possible that one individual has several CHILD_ID_E's.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"CLIENT_ID_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"EDATE_EST","Data.type":"VARCHAR","Column.description":"DHCW advised to ignore this field - DO NOT USE. 1,2, D or null (99% are null)","Sensitive":"false"}
{"Section":"EXAM","Column.name":"EXAMINER_E","Data.type":"BIGINT","Column.description":"Encrypted unique ID for examiner.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"EXAMINER_TYPE","Data.type":"VARCHAR","Column.description":"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.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"EXAM_DT","Data.type":"TIMESTAMP","Column.description":"Date of examination for EXAM_NUM. Problems exist here with duplicate records as well as wrong/incorrect date entries.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"EXAM_NUM","Data.type":"SMALLINT","Column.description":"Examination number, which lists the type of exam [e.g. 80 = reception year exam, 84 = Year 4 exam]. Theoretically this should be a unique identifier of the examinations carried out per child. However, there are duplicates due to: A - wrong examination date entries, B - duplicate examination numbers on the same date, C - duplicate numbers on different dates.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"HEAD_CM","Data.type":"DOUBLE","Column.description":"Head circumference in cm of child recorded at medical examination.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"HEIGHT_CM","Data.type":"DOUBLE","Column.description":"Height in cm of child recorded at medical examination. Typically this dataset will either miss an entry for height, or weight, or both; thus the BMI [body-mass index] can only be calculated for 40-50% of the dataset as a whole. NOTE - a not-small-percentage of children are larger than 220cm [1%]","Sensitive":"false"}
{"Section":"EXAM","Column.name":"LOCAL1_CONCERN","Data.type":"VARCHAR","Column.description":"Placeholder for additional tests results. Codes are standard and broken out thusly: S=satisfactory; P=problem; O=observe; T=treatment; R=referral; N=not examined.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"LOCAL2_CONCERN","Data.type":"VARCHAR","Column.description":"Placeholder for additional tests results. Codes are standard and broken out thusly: S=satisfactory; P=problem; O=observe; T=treatment; R=referral; N=not examined.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"LOCAL3_CONCERN","Data.type":"VARCHAR","Column.description":"Placeholder for additional tests results. Codes are standard and broken out thusly: S=satisfactory; P=problem; O=observe; T=treatment; R=referral; N=not examined.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"LOCAL4_CONCERN","Data.type":"VARCHAR","Column.description":"Placeholder for additional tests results. Codes are standard and broken out thusly: S=satisfactory; P=problem; O=observe; T=treatment; R=referral; N=not examined.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"LOCAL_TEST1","Data.type":"VARCHAR","Column.description":"Placeholder for additional tests - unclear what this may be specifically.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"LOCAL_TEST2","Data.type":"VARCHAR","Column.description":"Placeholder for additional tests - unclear what this may be specifically.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"LOCAL_TEST3","Data.type":"VARCHAR","Column.description":"Placeholder for additional tests - unclear what this may be specifically.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"LOCAL_TEST4","Data.type":"VARCHAR","Column.description":"Placeholder for additional tests - unclear what this may be specifically.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"LOCATION","Data.type":"VARCHAR","Column.description":"Location of where the examination was completed. These are school codes, which are unique to child health system so mapping is required. This reference table is not currently available.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"LOCATION_TYPE","Data.type":"VARCHAR","Column.description":"Type of location where the examination was completed. Important: The first child health system migrated to CYPriS on 16th July 2018, so CCH2000 codes for historic data (date <01/07/2018). Codes can range from School [approx 99% of records], to Clinic, Hospital, Exam Centre, At Home, or etc. Everything flagged as non-school typically has extremely low record counts, <10 or <100.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"LOCOMOTION_TEST_RES_CD","Data.type":"VARCHAR","Column.description":"Gives the result of the locomotion test given at an examination/screening. Codes are standard and broken out thusly: S=satisfactory; P=problem; O=observe; T=treatment; R=referral; N=not examined.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"MANIPULATION_TEST_RES_CD","Data.type":"VARCHAR","Column.description":"Gives the result of the manipulation test given at an examination/screening. Codes are standard and broken out thusly: S=satisfactory; P=problem; O=observe; T=treatment; R=referral; N=not examined.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"NCCHD_EXAMINATION_NUMBER","Data.type":"SMALLINT","Column.description":"Numeric code to identify examination done. Local examination numbers are mapped to national codes for pre-school examinations.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"PHYSICAL_TEST_RES_CD","Data.type":"VARCHAR","Column.description":"Gives the result of the physical test given at an examination/screening. Codes are standard and broken out thusly: S=satisfactory; P=problem; O=observe; T=treatment; R=referral; N=not examined.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"PROV_UNIT_CD","Data.type":"VARCHAR","Column.description":"Provider unit code - the NHS trust organisation code for the provider / Local Health Board.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"SPEECH_TEST_RES_CD","Data.type":"VARCHAR","Column.description":"Gives the result of the speech test given at an examination/screening. Codes are standard and broken out thusly: S=satisfactory; P=problem; O=observe; T=treatment; R=referral; N=not examined.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"TRUST_CODE_NATIONAL","Data.type":"VARCHAR","Column.description":"The trust code identifies the health care provider who is responsible for managing the treatment of the child.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"VISION_TEST_RES_CD","Data.type":"VARCHAR","Column.description":"Gives the result of the vision test given at an examination/screening. Codes are standard and broken out thusly: S=satisfactory; P=problem; O=observe; T=treatment; R=referral; N=not examined.","Sensitive":"false"}
{"Section":"EXAM","Column.name":"WEIGHT_KG","Data.type":"DOUBLE","Column.description":"Weight in kg of child recorded at medical examination. 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.","Sensitive":"false"}
{"Section":"IMM","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"IMM","Column.name":"CDATE_EST","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"IMM","Column.name":"CHILD_ID_E","Data.type":"BIGINT","Column.description":"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's, so there are duplicates; also possible that one individual has several CHILD_ID_E's.","Sensitive":"false"}
{"Section":"IMM","Column.name":"CLIENT_ID_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"IMM","Column.name":"COURSE_CD","Data.type":"VARCHAR","Column.description":"Course code. These codes refer to the specific type of booster/vaccine or immunisation course given, [e.g. tetanus booster, polio, school entry diphtheria booster, etc].","Sensitive":"false"}
{"Section":"IMM","Column.name":"COURSE_DT","Data.type":"TIMESTAMP","Column.description":"Date the course [immunisation/vaccine] was administered.","Sensitive":"false"}
{"Section":"IMM","Column.name":"IMM_BATCH_NUM_E","Data.type":"BIGINT","Column.description":"Encrypted immunisation batch number. This is the manufacturer's batch code for the vaccine used.","Sensitive":"false"}
{"Section":"IMM","Column.name":"LOCATION","Data.type":"VARCHAR","Column.description":"Location of where the examination was completed. These are school codes, which are unique to child health system so mapping is required. This reference table is not currently available.","Sensitive":"false"}
{"Section":"IMM","Column.name":"LOCATION_TYPE","Data.type":"VARCHAR","Column.description":"Type of location where the examination was completed. Important: The first child health system migrated to CYPriS on 16th July 2018, so CCH2000 codes for historic data (date <01/07/2018). Codes can range from School [approx 99% of records], to Clinic, Hospital, Exam Centre, At Home, or etc. Everything flagged as non-school typically has extremely low record counts, <10 or <100.","Sensitive":"false"}
{"Section":"IMM","Column.name":"PROV_UNIT_CD","Data.type":"VARCHAR","Column.description":"Provider unit code - the NHS trust organisation code for the provider / Local Health Board.","Sensitive":"false"}
{"Section":"IMM","Column.name":"TRUST_CD_NATIONAL","Data.type":"VARCHAR","Column.description":"The trust code identifies the health care provider who is responsible for managing the treatment of the child.","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"ALF_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"CHILD_ID_E","Data.type":"BIGINT","Column.description":"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's, so there are duplicates; also possible that one individual has several CHILD_ID_E's.","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"CLIENT_ID_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"LAB_DT","Data.type":"TIMESTAMP","Column.description":"Lab Date","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"LAB_NO","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"PROV_UNIT_CD","Data.type":"VARCHAR","Column.description":"Provider unit code - the NHS trust organisation code for the provider / Local Health Board.","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"RECORDED_DT","Data.type":"TIMESTAMP","Column.description":"Recorded date","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"SPCM_DT","Data.type":"TIMESTAMP","Column.description":"Specimen Date.","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"STD_TEST","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"TEST_CD","Data.type":"VARCHAR","Column.description":"Type of blood test.","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"TEST_DESC","Data.type":"VARCHAR","Column.description":"Full-length description of type of test performed on child, e.g. \"CONGENITAL HYPOTHYROIDISM\", \"CYSTIC FIBROSIS\", etc. [Please note that codes differ pre/post June 2012; new tests added post Jan 2015].","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"TEST_DESC_10_CHAR","Data.type":"VARCHAR","Column.description":"Shortened 10-character description of type of test performed on child, e.g. \"MUSCULAR D\", \"CYSTIC FIB\", etc. [Please note that codes differ pre/post June 2012; new tests added post Jan 2015].","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"TEST_DT_INTRO","Data.type":"TIMESTAMP","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"TEST_DT_RMVD","Data.type":"TIMESTAMP","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"TEST_RES_CD","Data.type":"VARCHAR","Column.description":"Code to denote test result/outcome. See also TEST_RES_DESC for further explanation. [Please note that codes differ pre/post June 2012; new tests added post Jan 2015].","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"TEST_RES_CMT","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"TEST_RES_COMP_IND","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"TEST_RES_DESC","Data.type":"VARCHAR","Column.description":"Description of test result/outcome, e.g. \"Carrier of other haemoglobin\". [Please note that codes differ pre/post June 2012; new tests added post Jan 2015].","Sensitive":"false"}
{"Section":"PATH_BLOOD_TESTS","Column.name":"TEST_RES_FUNC_AREA","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"ALF_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"AMBIGUOUS_72HR_FEED","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"BLOOD_TRNSFN","Data.type":"VARCHAR","Column.description":"Blood Transfusion","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"CHILD_ID_E","Data.type":"BIGINT","Column.description":"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's, so there are duplicates; also possible that one individual has several CHILD_ID_E's.","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"CLIENT_ID_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"DELETION","Data.type":"TIMESTAMP","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"EST_SPCM_DT","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"HOSP","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"LAB_NO","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"LAN_DT","Data.type":"TIMESTAMP","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"ORIGIN","Data.type":"VARCHAR","Column.description":"DHCW advised to ignore this field - DO NOT USE. S or null (6% are null)","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"OVERALL_CMT_CD","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"PROV_UNIT_CD","Data.type":"VARCHAR","Column.description":"Provider unit code - the NHS trust organisation code for the provider / Local Health Board.","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"RECEIVED_DT","Data.type":"TIMESTAMP","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"REC_STS","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"REPEAT_REQST","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"RESULT_CD_STD","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"SECTOR","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"SPCM_DT","Data.type":"TIMESTAMP","Column.description":"Specimen Date.","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"SPCM_HOSP","Data.type":"VARCHAR","Column.description":"Specimen hospital","Sensitive":"false"}
{"Section":"PATH_SPCM_DETAIL","Column.name":"TEST_CD_STD","Data.type":"VARCHAR","Column.description":"-","Sensitive":"false"}
{"Section":"REFR_IMM_VAC","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"REFR_IMM_VAC","Column.name":"COURSE_CD","Data.type":"CHARACTER","Column.description":"Course code. These codes refer to the specific type of booster/vaccine or immunisation course given, [e.g. tetanus booster, polio, school entry diphtheria booster, etc].","Sensitive":"false"}
{"Section":"REFR_IMM_VAC","Column.name":"COURSE_DESC_1","Data.type":"VARCHAR","Column.description":"Description for type of vaccination course administered.","Sensitive":"false"}
{"Section":"REFR_IMM_VAC","Column.name":"COURSE_DESC_2","Data.type":"VARCHAR","Column.description":"Description for type of vaccination course administered.","Sensitive":"false"}
{"Section":"REFR_IMM_VAC","Column.name":"COURSE_DESC_3","Data.type":"VARCHAR","Column.description":"Description for type of vaccination course administered.","Sensitive":"false"}
{"Section":"SIG_COND","Column.name":"AVAIL_FROM_DT","Data.type":"DATE","Column.description":"Date when the data made available i.e. date of loading","Sensitive":"false"}
{"Section":"SIG_COND","Column.name":"CHILD_ID_E","Data.type":"BIGINT","Column.description":"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's, so there are duplicates; also possible that one individual has several CHILD_ID_E's.","Sensitive":"false"}
{"Section":"SIG_COND","Column.name":"CLIENT_ID_E","Data.type":"BIGINT","Column.description":"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.","Sensitive":"false"}
{"Section":"SIG_COND","Column.name":"DIAG_CD","Data.type":"VARCHAR","Column.description":"ICD 10 Classification code.","Sensitive":"false"}
{"Section":"SIG_COND","Column.name":"DIAG_DT","Data.type":"TIMESTAMP","Column.description":"Date of diagnosis.","Sensitive":"false"}
{"Section":"SIG_COND","Column.name":"OUTCOME_CD","Data.type":"VARCHAR","Column.description":"Outcome code, e.g. H=Historic; S=Satisfactory' Q=Suspect Condition, etc.","Sensitive":"false"}
{"Section":"SIG_COND","Column.name":"PROV_UNIT_CD","Data.type":"VARCHAR","Column.description":"Provider unit code - the NHS trust organisation code for the provider / Local Health Board.","Sensitive":"false"}
{"Section":"SIG_COND","Column.name":"TRUST_CD_NATIONAL","Data.type":"VARCHAR","Column.description":"The trust code identifies the health care provider who is responsible for managing the treatment of the child.","Sensitive":"false"}