XML Schema Constraints applied to the Cancer Outcomes and Services Data Set.
Key to XML Schema Constraint Column Headings:
| Column Name | Column Meaning | Column Options | ||
| XML Schema Format/Length | Indicates any differences between the Format/Length of the item in the NHS Data Model and Dictionary and the XML Schema representation | None = The Format/Length is the same as the NHS Data Model and Dictionary | Any other entry = The Format/Length is different in the XML Schema to the NHS Data Model and Dictionary | |
| Allowed Values | Indicates whether the NHS Data Model and Dictionary National Codes and Default Codes are present in the XML Schema | None = The NHS Data Model and Dictionary National and Default Codes are present in the XML Schema | Removed = The NHS Data Model and Dictionary National Codes and Default Codes are not present in the XML Schema | Any other entry = Shows the values present in the XML Schema which are a subset of those in the NHS Data Model and Dictionary |
| Range | Indicates whether a range value constraint has been applied in the XML Schema | None = There is no range value constraint applied in the XML Schema | Any other entry = Shows the range value constraint applied in the XML Schema | |
| Pattern Match | Indicates whether a data pattern, to which the data must conform, has been applied in the XML Schema | None = There is no data pattern, to which the data must conform, applied in the XML Schema | Any other entry = Shows the data pattern, to which the data must conform, applied in the XML Schema | |
XML Schema Constraints:
| Data Element | XML Schema Format/Length | Allowed Values | Range | Pattern Match | Reason / Comment / XML Choice |
| ABBREVIATED MENTAL TEST SCORE | None | None | 0-10 | None | Range 0-10 |
| ALLRED SCORE (OESTROGEN RECEPTOR) | None | None | 0 and 2-8 | None | Range 0 and 2-8 |
| ALLRED SCORE (PROGESTERONE RECEPTOR) | None | None | 0 and 2-8 | None | Range 0 and 2-8 |
| BONE MARROW BLAST CELLS PERCENTAGE | None | None | 0-100 | None | Range 0-100 |
| BODY MASS INDEX | None | None | None | \d{2}(\.\d){1} | Format pattern applied to allow correct reporting of BODY MASS INDEX |
| BRESLOW THICKNESS | None | None | None | \d{1,2}\.\d{1,2} | Format pattern applied to allow correct reporting of BRESLOW THICKNESS |
| CANCER SYMPTOMS FIRST NOTED DATE | None | None | None | ((19|20)\d\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])|(19|20)\d\d-(0[1-9]|1[012])|(19|20)\d\d) | Format pattern applied to allow correct reporting of CANCER SYMPTOMS FIRST NOTED DATE |
| CARE PROFESSIONAL MAIN SPECIALTY CODE (CANCER REFERRED BY) | None | Removed | None | None | National Codes and default codes not enumerated in the XML Schema |
| CARE PROFESSIONAL MAIN SPECIALTY CODE (AT DIAGNOSIS) | None | Removed | None | None | National Codes and default codes not enumerated in the XML Schema |
| CELLULARITY PERCENTAGE | None | None | 0-100 | None | Range 0-100 |
| CHRONIC MYELOID LEUKAEMIA INDEX SCORE (SOKAL) | None | None | None | \d{1}(\.\d){1} | Format pattern applied to allow correct reporting of CHRONIC MYELOID LEUKAEMIA INDEX SCORE (SOKAL) |
| COSDS SUBMISSION IDENTIFIER | None | None | None | [0-9A-F]{8}-[0-9A-F]{4}-[0-9A-F]{4}-[0-9A-F]{4}-[0-9A-F]{12} | Format pattern applied to allow correct reporting of COSDS SUBMISSION RECORD COUNT |
| COSDS UNIQUE IDENTIFIER | None | None | None | [0-9A-F]{8}-[0-9A-F]{4}-[0-9A-F]{4}-[0-9A-F]{4}-[0-9A-F]{12} | Format pattern applied to allow correct reporting of COSDS UNIQUE IDENTIFIER |
| DIAGNOSIS (SNOMED CT) | None | None | None | [0-9]{6,18} | Format pattern applied to allow correct reporting of DIAGNOSIS (SNOMED CT) |
| DIFFUSION CAPACITY TEST RESULT | None | None | 0-200 | None | Range 0-200 |
| DISTANCE BEYOND MUSCULARIS PROPRIA | None | None | None | \d{1,3}\.\d{1,2} | Format pattern applied to allow correct reporting of DISTANCE BEYOND MUSCULARIS PROPRIA |
| DISTANCE FROM DENTATE LINE | None | None | None | \d{1,3}\.\d{1,2} | Format pattern applied to allow correct reporting of DISTANCE FROM DENTATE LINE |
| DISTANCE TO CLOSEST NON PERITONEALISED CIRCUMFERENTIAL RESECTION MARGIN | None | None | None | \d{1,2}\.\d{1,2} | Format pattern applied to allow correct reporting of DISTANCE TO CLOSEST NON PERITONEALISED CIRCUMFERENTIAL RESECTION MARGIN |
| DISTANCE TO MARGIN | None | None | None | \d{1,2}\.\d{1} | Format pattern applied to allow correct reporting of DISTANCE TO MARGIN |
| ETHNIC CATEGORY | max an2 | None | None | None | Existing Format/Length an2 means fixed length which is incorrect. Unable to change this as it is used in other data sets. Second character can be for local use. XML Schema allows max an2 |
| FOLLICULAR LYMPHOMA INTERNATIONAL PROGNOSTIC INDEX 2 SCORE | None | None | 0-5 | None | Range 0-5 |
| FORCED EXPIRATORY VOLUME IN 1 SECOND (ABSOLUTE AMOUNT) | None | None | 0.10-9.99 | (0.1[0-9]{1}|0.[2-9]{1}[0-9]{1}|[1-9].\d\d){1} | Range 0.10 to 9.99. Format pattern applied to allow correct reporting of FORCED EXPIRATORY VOLUME IN 1 SECOND (ABSOLUTE AMOUNT) |
| FORCED EXPIRATORY VOLUME IN 1 SECOND (PERCENTAGE) | None | None | 1-200 | None | Range 1 to 200 |
| GENERAL MEDICAL PRACTICE (PATIENT REGISTRATION) | None | Removed | None | [A-Z0-9]{8} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of GENERAL MEDICAL PRACTICE (PATIENT REGISTRATION) |
| GENERAL MEDICAL PRACTITIONER (SPECIFIED) | None | Removed | None | None | Default codes not enumerated in the XML Schema |
| GLEASON GRADE (BIOPSY PRIMARY) | None | None | 3-5 and 8 | None | Range 3-5 and 8 |
| GLEASON GRADE (BIOPSY SECONDARY) | None | None | 3-5 and 8 | None | Range 3-5 and 8 |
| GLEASON GRADE (NON BIOPSY PRIMARY) | None | None | 2-5 and 8 | None | Range 2-5 and 8 |
| GLEASON GRADE (NON BIOPSY SECONDARY) | None | None | 2-5 and 8 | None | Range 2-5 and 8 |
| GLEASON GRADE (NON BIOPSY TERTIARY) | None | None | 3-5 and 8 | None | Range 3-5 and 8 |
| HASENCLEVER INDEX SCORE | None | None | 0-7 | None | Range 0-7 |
| IMAGING CODE (SNOMED CT) | None | None | None | [0-9]{6,18} | Format pattern applied to allow correct reporting of IMAGING CODE (SNOMED CT) |
| INTERNATIONAL PROGNOSTIC INDEX SCORE | None | None | 0-5 | None | Range 0-5 |
| INVASIVE THICKNESS | None | None | None | \d{1,2}\.\d{1,2} | Format pattern applied to allow correct reporting of INVASIVE THICKNESS |
| KI-67 PERCENTAGE RESULT | None | None | 0-100 | None | Range 0-100 |
| LESION SIZE (PATHOLOGICAL) | None | None | None | \d{1,3}\.\d{1,2} | Format pattern applied to allow correct reporting of LESION SIZE (PATHOLOGICAL) |
| LOCAL PATIENT IDENTIFIER (EXTENDED) | min an1 max an20 | None | None | None | Existing Format/Length means fixed length which is incorrect. Unable to change this as it is used in other data sets. XML Schema allows min an1 max an20 |
| MANTLE CELL INTERNATIONAL PROGNOSTIC INDEX SCORE | None | None | 0-5 | None | Range 0-5 |
| MOLECULAR DIAGNOSTIC CODE | None | None | None | (0[6-9]|[1-8][0-9]|9[012389]) | Format pattern applied to allow correct reporting of MOLECULAR DIAGNOSTIC CODE |
| MORPHOLOGY (SNOMED CANCER TRANSFORMATION) | None | None | None | [A-Z0-9]{6,18} | Format pattern applied to allow correct reporting of MORPHOLOGY (SNOMED CANCER TRANSFORMATION) |
| MORPHOLOGY (SNOMED DIAGNOSIS) | None | None | None | [A-Z0-9]{6,18} | Format pattern applied to allow correct reporting of MORPHOLOGY (SNOMED DIAGNOSIS) |
| MORPHOLOGY (SNOMED PATHOLOGY) | None | None | None | [A-Z0-9]{6,18} | Format pattern applied to allow correct reporting of MORPHOLOGY (SNOMED PATHOLOGY) |
| MULTIDISCIPLINARY TEAM MEETING TYPE (CANCER) | None | Removed | None | None | National Codes not enumerated in the XML Schema |
| NHS NUMBER | None | None | None | [0-9]{10} | Format pattern applied to allow correct reporting of NHS NUMBER |
| NON INVASIVE TUMOUR SIZE | None | None | None | \d{1,3}\.\d{1,2} | Format pattern applied to allow correct reporting of NON INVASIVE TUMOUR SIZE |
| ORGANISATION IDENTIFIER (CODE OF PROVIDER) | min an3 max an5 | Removed | None | [A-Z0-9]{3,5} | Default codes not enumerated in the XML Schema. an6 is not applicable for the Cancer Outcomes and Services Data Set. Format pattern applied to allow correct reporting of ORGANISATION IDENTIFIER (CODE OF PROVIDER). |
| ORGANISATION IDENTIFIER (CODE OF SUBMITTING ORGANISATION) | None | None | None | [A-Z0-9]{3,6} | Format pattern applied to allow correct reporting of ORGANISATION IDENTIFIER (CODE OF SUBMITTING ORGANISATION) |
| ORGANISATION IDENTIFIER (OF AUTHORISING PATHOLOGIST) | None | None | None | [A-Z0-9]{3,5} | Format pattern applied to allow correct reporting of ORGANISATION IDENTIFIER (OF AUTHORISING PATHOLOGIST) |
| ORGANISATION SITE IDENTIFIER (OF ACUTE ONCOLOGY ASSESSMENT) | None | Removed | None | [A-Z0-9]{5} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION SITE IDENTIFIER (OF ACUTE ONCOLOGY ASSESSMENT). |
| ORGANISATION SITE IDENTIFIER (OF CANCER SITE SPECIFIC STAGE) | None | Removed | None | [A-Z0-9]{5,9} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION SITE IDENTIFIER (OF CANCER SITE SPECIFIC STAGE). |
| ORGANISATION SITE IDENTIFIER (OF DIAGNOSIS) | None | Removed | None | [A-Z0-9]{5,9} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION IDENTIFIER (CODE OF PROVIDER). |
| ORGANISATION SITE IDENTIFIER (OF DIAGNOSTIC PROCEDURE) | None | Removed | None | [A-Z0-9]{5,9} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION SITE IDENTIFIER (OF DIAGNOSTIC PROCEDURE). |
| ORGANISATION SITE IDENTIFIER (OF IMAGING) | None | Removed | None | [A-Z0-9]{5,9} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION SITE IDENTIFIER (OF IMAGING). |
| ORGANISATION IDENTIFIER (OF LABORATORY RESULT) | None | Removed | None | [A-Z0-9]{3,5} | Format pattern applied to allow correct reporting of ORGANISATION IDENTIFIER (OF LABORATORY RESULT). |
| ORGANISATION SITE IDENTIFIER (OF MULTIDISCIPLINARY TEAM MEETING) | None | Removed | None | [A-Z0-9]{5,9} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION SITE IDENTIFIER (OF MULTIDISCIPLINARY TEAM MEETING). |
| ORGANISATION SITE IDENTIFIER (OF PATHOLOGY TEST REQUEST) | None | Removed | None | [A-Z0-9]{5,9} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION SITE IDENTIFIER (OF PATHOLOGY TEST REQUEST). |
| ORGANISATION SITE IDENTIFIER (OF PROVIDER CANCER TREATMENT START DATE) | None | Removed | None | [A-Z0-9]{5,9} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION SITE IDENTIFIER (OF PROVIDER CANCER TREATMENT START DATE) . |
| ORGANISATION SITE IDENTIFIER (OF PROVIDER FIRST CANCER SPECIALIST) | None | Removed | None | [A-Z0-9]{5,9} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION SITE IDENTIFIER (OF PROVIDER FIRST CANCER SPECIALIST). |
| ORGANISATION SITE IDENTIFIER (OF PROVIDER FIRST SEEN) | None | Removed | None | [A-Z0-9]{5,9} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION SITE IDENTIFIER (OF PROVIDER FIRST SEEN). |
| ORGANISATION SITE IDENTIFIER (OF PROVIDER FIRST SEEN NON PRIMARY CANCER PATHWAY) | None | Removed | None | [A-Z0-9]{5,9} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION SITE IDENTIFIER (OF PROVIDER FIRST SEEN NON PRIMARY CANCER PATHWAY) |
| ORGANISATION SITE IDENTIFIER (OF TNM STAGE GROUPING FINAL PRETREATMENT) | None | Removed | None | [A-Z0-9]{5,9} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION SITE IDENTIFIER (OF TNM STAGE GROUPING FINAL PRETREATMENT). |
| ORGANISATION SITE IDENTIFIER (OF TNM STAGE GROUPING INTEGRATED) | None | Removed | None | [A-Z0-9]{5,9} | Default codes not enumerated in the XML Schema. Format pattern applied to allow correct reporting of ORGANISATION SITE IDENTIFIER (OF TNM STAGE GROUPING INTEGRATED)). |
| PERSON HEIGHT IN METRES | None | None | None | \d{1}(\.\d{1,2}){1} | Format pattern applied to allow correct reporting of PERSON HEIGHT IN METRES |
| PERSON WEIGHT | None | None | None | \d{1,3}\.\d{1,3} | Format pattern applied to allow correct reporting of PERSON WEIGHT |
| PRIMARY PROCEDURE (SNOMED CT) | None | None | None | [0-9]{6,18} | Format pattern applied to allow correct reporting of PRIMARY PROCEDURE (SNOMED CT) |
| PROCEDURE (SNOMED CT) | None | None | None | [0-9]{6,18} | Format pattern applied to allow correct reporting of PROCEDURE (SNOMED CT) |
| PROSTATE SPECIFIC ANTIGEN (AT DIAGNOSIS) | None | None | None | \d{1,5}(\.\d){1} | Format pattern applied to allow correct reporting of PROSTATE SPECIFIC ANTIGEN (AT DIAGNOSIS) |
| REVISED INTERNATIONAL PROGNOSTIC INDEX SCORE | None | None | 0-5 | None | Range 0-5 |
| TOPOGRAPHY (SNOMED PATHOLOGY) | None | None | None | [A-Z0-9]{6,18} | Format pattern applied to allow correct reporting of TOPOGRAPHY (SNOMED PATHOLOGY) |
| TUMOUR NECROSIS PERCENTAGE | None | None | 0-100 | None | Range 0-100 |
| TURP TUMOUR PERCENTAGE | None | None | 0-100 | None | Range 0-100 |
| UNINVOLVED CERVICAL STROMA THICKNESS | None | None | None | \d{1,2}\.\d{1,2} | Format pattern applied to allow correct reporting of UNINVOLVED CERVICAL STROMA THICKNESS |
| WHITE BLOOD CELL COUNT (HIGHEST PRETREATMENT) | None | None | None | \d{1,3}(\.\d{1}){1} | Format pattern applied to allow correct reporting of WHITE BLOOD CELL COUNT (HIGHEST PRETREATMENT) |
| WHOLE TUMOUR SIZE | None | None | None | \d{1,3}\.\d{1,2} | Format pattern applied to allow correct reporting of WHOLE TUMOUR SIZE |