Short Description Logic

[AngelaFaulding]

As discussed with James, we would like logic adding so items don't fail the integrity check.

Below is for Data Elements:

• Bold Headings, e.g. https://www.datadictionary.nhs.uk/data_elements/attended_or_did_not_attend_code.html. Where there is a bold heading under the line "is the same as attribute"; use the definition from the Attribute as the short description.
• Permitted National Codes, e.g. https://www.datadictionary.nhs.uk/data_elements/attended_or_did_not_attend_code__patient_level_information_costing_.html. Where there is a "Permitted National Codes" heading under the line "is the same as attribute"; use the definition from the Attribute as the short description.
• Notes, e.g. https://www.datadictionary.nhs.uk/data_elements/administrative_category_code.html. Where there is a line starting "Note: " under the line "is the same as attribute"; use the definition from the Attribute as the short description.
• For the ..... data set, e.g. https://www.datadictionary.nhs.uk/data_elements/body_mass_index.html. Where there is a line starting "For the ..... data set: " under the line "is the same as attribute"; use the definition from the Attribute as the short description.

[AngelaFaulding]

Can logic be applied for items so the score/value information does not display as short descriptions: The score is in the range of 0-5. https://www.datadictionary.nhs.uk/data_elements/revised_international_prognostic_index_score.html The permitted values are 0 and 2-8. https://www.datadictionary.nhs.uk/data_elements/allred_score__estrogen_receptor_.html The value is presented in the range 0.0 - 50.0. https://www.datadictionary.nhs.uk/data_elements/blood_glucose_concentration__on_admission_to_neonatal_critical_care_.html The value is in the range of 0-6. https://www.datadictionary.nhs.uk/data_elements/gestation_length__remaining_days_at_delivery_.html

[jamesrwelch]

@AngelaFaulding Here's a spreadsheet of short descriptions based on the April 2022 release April2022ShortDescriptions.xlsx

[jamesrwelch]

Another iteration of the short descriptions for April. I've completely re-worked the code, so this may be quite different from the previous version but hopefully better April2022ShortDescriptions2.csv

[AngelaFaulding]

@jamesrwelch - I have been through the document and have some observations. We can discuss when you have had a look. One question is, will new descriptions overwrite those on the website even if they are incorrect?

• Some on the spreadsheet are different to the website, where the website is correct, e.g. DIAGNOSIS (ICD ON ADMISSION TO NEONATAL CRITICAL CARE): A unique clinical classification identifier for a CODED CLINICAL ENTRY. Website: DIAGNOSIS (ICD ON ADMISSION TO NEONATAL CRITICAL CARE) is the ICD code describing a PATIENT DIAGNOSIS for the baby on admission to neonatal critical care.

DIAGNOSIS (ICD ON NEONATAL CRITICAL CARE DAILY CARE DATE): A unique clinical classification identifier for a CODED CLINICAL ENTRY. Website: DIAGNOSIS (ICD ON NEONATAL CRITICAL CARE DAILY CARE DATE) is the ICD code describing a PATIENT DIAGNOSIS made on a Neonatal Critical Care Daily Care Date during a Neonatal CRITICAL CARE PERIOD.

• DIAGNOSIS (CODED CLINICAL ENTRY): Note:DIAGNOSIS (CODED CLINICAL ENTRY) is the same as attribute CLINICAL CLASSIFICATION CODE or CLINICAL TERMINOLOGY CODE. It has note but this is not present on the website.

• Short descriptions, mainly data sets have \ where there is a link, e.g. AIDC for Patient Identification Data Set: The purpose of the \nAutomatic Identification and Data Capture for Patient Identification Data Set is to support the accurate, timely and, therefore, safer identification of NHS \nPATIENTS in England, by encoding the key \nPATIENT identifiers into a \nGS1 DataMatrix 2D barcode which is printed on the \nPATIENT identity band

Aggregate Contract Monitoring Data Set : The \nAggregate Contract Monitoring Data Set is to enable the interchange, in a uniform and consistent format, of monthly aggregate \nContract Monitoring data between all purchasers and \nHealth Care Providers

CDS V6-2-2 Type 004 - CDS Message Trailer: The \nCDS V6-2-2 Type 004 - Commissioning Data Set Message Trailer carries mandatory controls for a Commissioning Data Set Message and is only used by inclusion in other \nCDS Types

• Some data set short descriptions have Introduction, but others correctly don't, e.g. CDS V6-2 Type 020 - Outpatient CDS: IntroductionThe \nCDS V6-2 Type 020 - Outpatient Commissioning Data Set carries the data for an Outpatient Attendance or a cancelled/missed \nAPPOINTMENT

CDS V6-3 Type 020 - Outpatient CDS: IntroductionThe \nCDS V6-3 Type 020 - Outpatient Commissioning Data Set carries the data for a \nCare Professional Out-Patient Attendance or a cancelled/missed \nAPPOINTMENT

Critical Care Minimum Data Set: IntroductionThe \nCritical Care Minimum Data Set was developed by the Critical Care Information Advisory Group (CCIAG) and endorsed by the Intensive Care Society

Female Genital Mutilation Data Set: IntroductionThe \nFemale Genital Mutilation Data Set provides essential information in relation to the female genital mutilation population across England

GUMCAD Sexually Transmitted Infection Surveillance System Data Set: IntroductionThe \nGUMCAD Sexually Transmitted Infection Surveillance System Data Set provides essential public health information about Sexually Transmitted Infection (STI) diagnoses, treatments and \nSERVICES provided by \nLevel 3 Genitourinary Medicine Services and commissioned \nLevel 2 Sexual Health Services

NHS Continuing Healthcare Patient Level Data Set: IntroductionThe \nNHS Continuing Healthcare Patient Level Data Set is \nPATIENT level, output based, secondary user data set

• National Joint Registry Data Sets: The overviews have Introduction and a sentence followed by a full stop but the short descriptions are not working correct. Is this because there is one overview for all data sets, e.g. National Joint Registry Data Set - Ankle: Primary Ankle Replacement SurgeryRevision Ankle Replacement SurgeryPrimary Elbow Replacement SurgeryRevision Elbow Replacement SurgeryPrimary Hip Replacement SurgeryRevision Hip Replacement SurgeryPrimary Knee Replacement SurgeryRevision Knee Replacement SurgeryPrimary Shoulder Replacement SurgeryRevision Shoulder Replacement Surgery National Joint Registry Data Set - Common Details: null National Joint Registry Data Set - Elbow: Primary Ankle Replacement SurgeryRevision Ankle Replacement SurgeryPrimary Elbow Replacement SurgeryRevision Elbow Replacement SurgeryPrimary Hip Replacement SurgeryRevision Hip Replacement SurgeryPrimary Knee Replacement SurgeryRevision Knee Replacement SurgeryPrimary Shoulder Replacement SurgeryRevision Shoulder Replacement Surgery

• Patient Level Information Costing System Data Sets: is this the same issue as above as they share the same overview page? e.g. Patient Level Information Costing System Integrated Data Set - Admitted Patient Care (Acute): Patient Level Information Costing System Reconciliation Data SetPatient Level Information Costing System Integrated Data Set - Admitted Patient Care (Acute)Patient Level Information Costing System Integrated Data Set - Emergency Care (Acute)Patient Level Information Costing System Integrated Data Set - Out-Patient Care (Acute)Patient Level Information Costing System Integrated Data Set - Specialist Ward Care (Acute)Patient Level Information Costing System Integrated Data Set - Supplementary InformationPatient Level Information Costing System Integrated Data Set - Admitted Patient Care (Mental Health)Patient Level Information Costing System Integrated Data Set - Care Contacts (Mental Health)Patient Level Information Costing System Integrated Data Set - Improving Access to Psychological Therapies

Patient Level Information Costing System Integrated Data Set - Improving Access to Psychological Therapies: Patient Level Information Costing System Reconciliation Data SetPatient Level Information Costing System Integrated Data Set - Admitted Patient Care (Acute)Patient Level Information Costing System Integrated Data Set - Emergency Care (Acute)Patient Level Information Costing System Integrated Data Set - Out-Patient Care (Acute)Patient Level Information Costing System Integrated Data Set - Specialist Ward Care (Acute)Patient Level Information Costing System Integrated Data Set - Supplementary InformationPatient Level Information Costing System Integrated Data Set - Admitted Patient Care (Mental Health)Patient Level Information Costing System Integrated Data Set - Care Contacts (Mental Health)Patient Level Information Costing System Integrated Data Set - Improving Access to Psychological Therapies

• Short descriptions with speech marks. The website is correct but the document shows the following: Safeguarding Children: The term \ Safeguarding Children\" is defined as \"the process of protecting children from abuse or neglect

TWO WEEK WAIT CANCER OR SYMPTOMATIC BREAST REFERRAL TYPE: The site where cancer is suspected by the GENERAL MEDICAL PRACTITIONER, GENERAL DENTAL PRACTITIONER or OPTOMETRIST referring the PATIENT where the PRIORITY TYPE is National Code \ Two Week Wait\"."

International Society of Paediatric Oncology: The International Society of Paediatric Oncology's vision is that \No child should die of cancer\"."

[AngelaFaulding]

James to investigate the issues above and retest on the July release

[jamesrwelch]

There are no remaining 'null' values in the short descriptions - where a short description cannot be generated we now use the item name instead. I've updated the integrity checker in the orchestrator accordingly. We may want to discuss further refinement of the logic in the future.

[jamesrwelch]

And here's the latest spreadsheet for reference July2022ShortDescriptions.xlsx

[AngelaFaulding]

There are still entries on the spreadsheet with \ which appear to be either for speech marks or internal links. Examples of a couple are: Spreadsheet: The International Society of Paediatric Oncology 's vision is that \No child should die of cancer\"." DD is correct: https://www.datadictionary.nhs.uk/nhs_business_definitions/international_society_of_paediatric_oncology.html

Spreadsheet: The \nMaternity Services Data Set ( \nMSDS ) is a \nPATIENT -level data set that captures key information at each stage of the maternity care pathway including mother's DD is correct: https://www.datadictionary.nhs.uk/data_sets/clinical_data_sets/maternity_services_data_set.html#dataset_maternity_services_data_set

I assume that these will be OK when we run the intergity check in the Orchestrator once we have the latest version.

[jamesrwelch]

Yes, sorry, here's a later version of the spreadsheet: July2022ShortDescriptions.xlsx

[AngelaFaulding]

There are a few with bullets, i.e and e.g. which I will fix.

There are a few that look odd on the spreadsheet but look OK in the DD:

• Data Element - DIAGNOSIS (CODED CLINICAL ENTRY) Note:DIAGNOSIS (CODED CLINICAL ENTRY) is the same as attribute CLINICAL CLASSIFICATION CODE or CLINICAL TERMINOLOGY CODE .
• NHS Business Definition - International Society of Paediatric Oncology The International Society of Paediatric Oncology 's vision is that \No child should die of cancer\"."
• NHS Business Definition - Youth Offending Team A Youth Offending Team provides the main supervisory elements of statutory youth justice services.\ "

I think we are nearly there. There are some that need fixing when we migrate.

[AngelaFaulding]

The latest release now has no failures in the Orchestrator.