XML Schema Constraints applied to the Commissioning Data Sets V6-2.
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:
Note:
- The active CARE PROFESSIONAL MAIN SPECIALTY CODE and ACTIVITY TREATMENT FUNCTION CODE allowed values differ between CDS-XML Schema version 6-2 and CDS-XML Schema version 6-2-0, see DDCN 1815 Commissioning Data Set Schema Version 6-2-0.
Data Element | XML Schema Format/Length | Allowed Values | Range | Pattern Match | Reason / Comment / XML Choice |
ACTIVITY LOCATION TYPE CODE | None | A01,A02,A03,A04,B01,B02,C01,C02,C03,D01,D02,D03, E01,E02,E03,E04,E99,F01,G01,G02,G03,H01,J01,K01,K02, L01,L02,L03,L04,L05,L06,L99,M01,M02,M03,M04,M05, N01,N02,N03,N04,N05,X01 | None | None | National Code G04 removed (not allowed in XML Schema) |
ADVANCED CARDIOVASCULAR SUPPORT DAYS | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
ADVANCED RESPIRATORY SUPPORT DAYS | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
AGE AT CDS ACTIVITY DATE | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
AGE AT CENSUS | max n3 | None | None | None | Existing Format/Length states n3 - XML Schema allows max n3 |
AGE ON ADMISSION | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
ATTENDANCE IDENTIFIER | max an12 | None | None | None | Existing Format/Length states an12 - XML Schema allows max an12 |
BASIC CARDIOVASCULAR SUPPORT DAYS | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
BASIC RESPIRATORY SUPPORT DAYS | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
BIRTH WEIGHT | max n4 | None | None | None | Existing Format/Length states max an4 - XML Schema allows max n4 |
CARE PROFESSIONAL MAIN SPECIALTY CODE | None | 100,101,110,120,130,140,141,142,143,145,146,147,148,149, 150,160,170,171,180,190,192,300,301,302,303,304,305,310, 311,312,313,314,315,320,321,325,326,330,340,350,352,360, 361,370,371,400,401,410,420,421,430,450,451,460,501,502, 504,560,600,601,700,710,711,712,713,715,800,810,820,821, 822,823,824,830,831,833,834,900,901,902,903,904,950,960, 199,499 | None | None | National Code 500 removed (not allowed in XML Schema) |
CDS COPY RECIPIENT IDENTITY | min an3 max an12 | Removed | None | None | Field size extended to future proof for ODS ORGANISATION CODE changes |
CDS INTERCHANGE APPLICATION REFERENCE | max an14 | None | None | None | Existing Format/Length states min an1 max an14 - XML Schema allows max an14 |
CDS INTERCHANGE RECEIVER IDENTITY | max an15 | None | None | None | Existing Format/Length states min an1 max an15 - XML Schema allows max an15 |
CDS INTERCHANGE SENDER IDENTITY | max an15 | None | None | None | Existing Format/Length states min an1 max an15 - XML Schema allows max an15 |
CDS MESSAGE REFERENCE | max n7 | None | None | None | Existing Format/Length states max an7 - XML Schema allows max n14 but SUS accepts max n7 |
CDS MESSAGE VERSION NUMBER | None | CDS062 | None | None | Message version is hard coded in the XML Schema |
CDS PRIME RECIPIENT IDENTITY | min an3 max an12 | Removed | None | None | Field size extended to future proof for ODS ORGANISATION CODE changes |
CDS RECORD IDENTIFIER | max an35 | None | None | None | Existing Format/Length states min an1 max an35 - XML Schema allows max an35 |
CDS SENDER IDENTITY | min an3 max an12 | None | None | None | Field size extended to future proof for ODS ORGANISATION CODE changes |
CDS UNIQUE IDENTIFIER | max an35 | None | None | None | Existing Format/Length states min an1 max an35 - XML Schema allows max an35 |
CONSULTATION MEDIUM USED | None | 01,02,03,04 | None | None | National Codes 05, 06, 07, 08 and 98 are not used in CDS version 6-2 |
COUNT OF DAYS SUSPENDED | max n4 | None | None | None | Existing Format/Length states n4 - XML Schema allows max n4 |
CRITICAL CARE ACTIVITY CODE | None | 01,02,03,04,05,06,07,08,09,10,11,12,13,14, 15,16,21,22,23,24,25,26,27,28,29,50,51,52, 53,55,56,57,58,59,60,61,62,63,64,65,66,67, 68,69,70,71,72,73,74,99 | None | None | National Codes 80, 81, 82, 83, 84, 85, 94, 95, 96 and 97 removed (not allowed in the XML Schema) |
CRITICAL CARE DISCHARGE DESTINATION | n2 | None | None | None | Existing Format/Length states an2 - XML Schema allows n2 |
CRITICAL CARE LEVEL 2 DAYS | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
CRITICAL CARE LEVEL 3 DAYS | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
DERMATOLOGICAL SUPPORT DAYS | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
DISCHARGE METHOD CODE (HOSPITAL PROVIDER SPELL) | None | 1,2,3,4,5,8,9 | None | None | National Codes 6 and 7 are not used in CDS version 6-2 |
DURATION OF CARE TO PSYCHIATRIC CENSUS DATE | max n5 | None | None | None | Existing Format/Length states n5 - XML Schema allows max n5 |
DURATION OF DETENTION | max n5 | None | None | None | Existing Format/Length states n5 - XML Schema allows max n5 |
DURATION OF ELECTIVE WAIT | max n4 | None | None | None | Existing Format/Length states max an4 - XML Schema allows max n4 |
ELECTIVE ADMISSION LIST ENTRY NUMBER | max an12 | None | None | None | Existing Format/Length states an12 - XML Schema allows max an12 |
ETHNIC CATEGORY | max an2 | None | None | None | Existing Format/Length 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. Format/Length amended to max an2 |
GASTRO-INTESTINAL SUPPORT DAYS | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
GESTATION LENGTH (ASSESSMENT) | n2 | None | None | None | Existing Format/Length states an2 - XML Schema allows n2 |
GESTATION LENGTH (AT DELIVERY) | n2 | None | None | None | Existing Format/Length states an2 - XML Schema allows n2 |
GESTATION LENGTH (LABOUR ONSET) | n2 | None | None | None | Existing Format/Length states an2 - XML Schema allows n2 |
GENERAL MEDICAL PRACTITIONER PRACTICE (ANTENATAL CARE) | min an3 max an12 | Removed | None | None | Field size extended to future proof for ODS ORGANISATION CODE changes |
GENERAL MEDICAL PRACTICE CODE (PATIENT REGISTRATION) | min an3 max an12 | Removed | None | None | Field size extended to future proof for ODS ORGANISATION CODE changes |
GENERAL MEDICAL PRACTITIONER (ANTENATAL CARE) | None | Removed | None | None | National Codes and default codes not enumerated in the XML Schema |
GENERAL MEDICAL PRACTITIONER (SPECIFIED) | None | Removed | None | None | National Codes and default codes not enumerated in the XML Schema |
INTENDED SITE CODE (OF TREATMENT) | min an3 max an12 | Removed | None | None | Field size extended to future proof for ODS ORGANISATION CODE changes |
LIVER SUPPORT DAYS | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
LOCAL PATIENT IDENTIFIER | max an10 | None | None | None | Existing Format/Length states an10 - XML Schema allows max an10 |
LOCAL PATIENT IDENTIFIER (BABY) | max an10 | None | None | None | Existing Format/Length states an10 - XML Schema allows max an10 |
LOCAL PATIENT IDENTIFIER (MOTHER) | max an10 | None | None | None | Existing Format/Length states an10 - XML Schema allows max an10 |
MENTAL HEALTH ACT LEGAL STATUS CLASSIFICATION CODE (AT CENSUS DATE) | None | 01,02,03,04,05,06,07,08,09,10,11,12,13,14, 15,16,17,18,19,20,31,32,34,35,36,37,38 | None | None | Additional National Codes 37 and 38 added |
MENTAL HEALTH ACT LEGAL STATUS CLASSIFICATION CODE (ON ADMISSION) | None | 01,02,03,04,05,06,07,08,09,10,11,12,13,14, 15,16,17,18,19,20,31,32,34,35,36,37,38 | None | None | Additional National Codes 37 and 38 added |
NEUROLOGICAL SUPPORT DAYS | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
ORGAN SUPPORT MAXIMUM | n2 | None | 00-06 | None | Existing Format/Length states an2 - XML Schema allows max n2. Range 00-06 allowed |
ORGANISATION CODE (CODE OF COMMISSIONER) | min an3 max an12 | Removed | None | None | Field size extended to future proof for ODS ORGANISATION CODE changes |
ORGANISATION CODE (CODE OF PROVIDER) | min an3 max an12 | Removed | None | None | Field size extended to future proof for ODS ORGANISATION SITE CODE changes |
ORGANISATION CODE (LOCAL PATIENT IDENTIFIER) | min an3 max an12 | None | None | None | Field size extended to future proof for ODS ORGANISATION CODE changes |
ORGANISATION CODE (LOCAL PATIENT IDENTIFIER (BABY)) | min an3 max an12 | None | None | None | Field size extended to future proof for ODS ORGANISATION SITE CODE changes |
ORGANISATION CODE (LOCAL PATIENT IDENTIFIER (MOTHER)) | min an3 max an12 | None | None | None | Field size extended to future proof for ODS ORGANISATION SITE CODE changes |
ORGANISATION CODE (PATIENT PATHWAY IDENTIFIER ISSUER) | min an3 max an12 | None | None | None | Field size extended to future proof for ODS ORGANISATION CODE changes |
ORGANISATION CODE (RESIDENCE RESPONSIBILITY) | min an3 max an12 | Removed | None | None | Field size extended to future proof for ODS ORGANISATION CODE changes |
PERSON WEIGHT | n3.n3 | None | None | None | Existing Format/Length states max n3.max n3 - XML Schema enforces 3 digits before and after the decimal point - max removed |
PRIMARY DIAGNOSIS (READ) | max an5 | None | None | None | Existing Format/Length allows for all clinical classifications -XML Schema allows max an5 |
PROFESSIONAL REGISTRATION ENTRY IDENTIFIER (MAIN OPERATING CARE PROFESSIONAL) | max an12 | None | None | None | Existing Format/Length states max an32 - XML Schema allows max an12 |
PROFESSIONAL REGISTRATION ENTRY IDENTIFIER (RESPONSIBLE ANAESTHETIST) | max an12 | None | None | None | Existing Format/Length states max an32 - XML Schema allows max an12 |
REFERRER CODE | None | Removed | None | None | National Codes and default codes not enumerated in the XML Schema |
REFERRING ORGANISATION CODE | min an3 max an12 | Removed | None | None | Field size extended to future proof for ODS ORGANISATION CODE changes |
RENAL SUPPORT DAYS | max n3 | None | None | None | Existing Format/Length states max an3 - XML Schema allows max n3 |
SECONDARY DIAGNOSIS (READ) | max an5 | None | None | None | Existing Format/Length allows for all clinical classifications -XML Schema allows max an5 |
SITE CODE (OF TREATMENT) | min an3 max an12 | Removed | None | None | Field size extended to future proof for ODS ORGANISATION SITE CODE changes |
SOURCE OF ADMISSION CODE (HOSPITAL PROVIDER SPELL) | None | 19,29,39,49,51,52,53,54,65,66,79,85,87,88 | None | None | National Codes 40, 41 and 42 are not used in CDS version 6-2 |
WAITING TIME MEASUREMENT TYPE | None | 01,02,09 | None | None | National Codes 03, 04, 05, 06, 07 and 08 not valid in Commissioning Data Sets |