Maternity and Children’s Data Sets Submission Requirements

This item is being used for development purposes and has not yet been assured by the Information Standards Board for Health and Social Care.

The data carried in the three Maternity and Children's Secondary Uses Data Sets which support the National Service Framework for Children Young People and Maternity Services Data Sets (Maternity Services Secondary Uses Data Set, Children’s and Young People’s Health Services Secondary Uses Data Set and Child and Adolescent Mental Health Services Secondary Uses Data Set) must be structured in a particular way for submission nationally. Data items in the files, including the items in the header records, are tilde-delimited (~ character).

Each data set submission file of data is structured in the following way:

See below for the file structure for each data set row:

This contains information about the submission file, and is structured as follows, for all three data sets:

DATA SET ROW TYPE (MATERNITY AND CHILDRENS DATA SETS) (note - always value HDR in a file header row)
DATA SET IDENTIFIER (MATERNITY AND CHILDRENS DATA SETS)
DATA SET VERSION NUMBER 
ORGANISATION CODE (CODE OF PROVIDER) 
REPORTING PERIOD START DATE 
REPORTING PERIOD END DATE 
DATE AND TIME DATA SET CREATED 
DATA SET SEGMENT RECORDS TOTAL

The Data Set File Header row is present only once, as the first record in the submission file.

This contains Segment type and PATIENT identification information followed by segment content data items, and is structured as follows:

DATA SET SEGMENT IDENTIFIER (MATERNITY SERVICES SECONDARY USES DATA SET)
or
DATA SET SEGMENT IDENTIFIER (CHILD AND ADOLESCENT MENTAL HEALTH SERVICES SECONDARY USES DATA SET)
or
DATA SET SEGMENT IDENTIFIER (CHILDREN AND YOUNG PEOPLES HEALTH SERVICES SECONDARY USES DATA SET)

This is followed in the same row by the segment content data items, which vary depending on which segment is being submitted. This structure is repeated for each data record within the file.

This contains some of the same information as the Data Set File Header row, plus a count of all segment records within the file, as a data quality check, and is structured as follows:

DATA SET ROW TYPE (MATERNITY AND CHILDRENS DATA SETS) (note - always value TRL in a file footer row)
DATA SET IDENTIFIER (MATERNITY AND CHILDRENS DATA SETS)
DATA SET VERSION NUMBER
ORGANISATION CODE (CODE OF PROVIDER)
REPORTING PERIOD START DATE  
REPORTING PERIOD END DATE
DATE AND TIME DATA SET CREATED
DATA SET SEGMENT RECORDS TOTAL

The Data Set File Footer Row is present only once, as the last record in the submission file.