MDW - Discover Metadata Catalogue

MDW Discover  > Maternity Services Data Set (MSDS) @ 1342

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

https://digital.nhs.uk/data-and-information/data-collections-and-data-sets/data-sets/maternity-services-data-set

Number of distinct individual in the 001MotherDemog dataset

HDR UK

AGEM Derived: Used to identify which load batch the record belongs to.

AuditId

NHSE Derived: Date processing started for this extract.

EndProcDate

NHSE Derived: Time processing started for this extract.

EndProcTime

Provider Submitted: Date upload file was created.

FileCreationDate

Provider Submitted: Time upload file was created.

FileCreationTime

NHSE Derived: A unique ID per table.  This continues across reporting periods and across providers.  This uniquely identifies a row of data within a table.

MSD000_ID

NHSE Derived: Organisation code of provider submitting the data.

OrgCodeProvider

Provider Submitted: The organisation identifier of the organisation acting as a health care provider.

OrgIDProvider

Provider Submitted: The organisation identifier of the organisation acting as the physical sender of a data set submission.

OrgIDSubmit

Provider Submitted: Name of the Primary Data Collection System in use by the Health Care Provider.

PrimSystemInUse

Provider Submitted: The reporting period end date to which this file refers.

RPEndDate

Provider Submitted: The reporting period start date to which the file refers.

RPStartDate

NHSE Derived: Total count of rows for a specific table  related to a specific header within the extract.

TotMSD001

TotMSD002

TotMSD003

TotMSD004

TotMSD101

TotMSD102

TotMSD103

TotMSD104

TotMSD105

TotMSD106

TotMSD107

TotMSD108

TotMSD109

TotMSD201

TotMSD202

TotMSD203

TotMSD301

TotMSD302

TotMSD401

TotMSD402

TotMSD403

TotMSD404

TotMSD405

TotMSD406

TotMSD501

TotMSD502

TotMSD503

TotMSD504

TotMSD601

TotMSD602

TotMSD901

NHSE Derived: Total count of rows in all the extract tables that relate to this Header.

TotRec

NHSE Derived: A unique ID applied when original data file was uploaded to the submission portal.

UniqSubmissionID

NHSE Derived: Date original data file was uploaded to the submission portal.

UploadDate

NHSE Derived: Time original data file was uploaded to the submission portal.

UploadTime

Provider Submitted: The version number of a Data Set.

Version

NW_DME.MSDS.MSD000Header

NHSE Derived: Age of mother  in years  at time of death.

AgeAtDeathMother

NHSE Derived: Age of mother  in years  at the reporting period end date.

AgeRPEndDate

NHSE Derived: Care Commissioning Group residential area of responsibility of Mother  derived from POSTCODE OF USUAL ADDRESS (MOTHER) and Gridall. For data relating to activity between 1 July 2022 and 31 March 2023 this derivation is based on the CCG associated with the POSTCODE OF USUAL ADDRESS as at 30 June 2022. Any changes to the assignment of a POSTCODE OF USUAL ADDRESS to a Sub-ICB Location between 1 July 2022 and 31 March 2023 will not be reflected in this derivation.

CCGResidenceMother

NHSE Derived: County of Mother  derived from POSTCODE OF USUAL ADDRESS (MOTHER) and Gridall.

CountyMother

AGEM Derived: Internal processing data item used to allocate / disseminate activity to clients.

CustomerAll

NHSE Derived: The day of the week the mother died (where death occurred whilst the mother was still being cared for by maternity services).

DayOfWeekOfDeathMother

AGEM Derived: Country code where default postcode supplied. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_default_country_code

AGEM Derived: Postcode type where default postcode supplied. POSTCODE OF USUAL ADDRESS (MOTHER)

Der_default_postcode_type

AGEM Derived: Default reciprocal agreement where default postcode supplied. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_default_reciprocal_agreement

AGEM Derived: Derived date of birth format MM-YYYY. Uses PERSON BIRTH DATE (MOTHER)

Der_DOB_MthYr

AGEM Derived: Derived financial month value based on RPStartDate in the format MM

Der_Financial_Month

AGEM Derived: Derived financial year value based on RPStartDate in the format YYYY/YY.

Der_Financial_Year

AGEM Derived: The code of the CCG where the patient&#039;s postcode of usual address is based  unless the given postcode is ZZ99 3VZ (no fixed abode)  ZZ99 3WZ (address not known) or ZZ99 3CZ (England UK - not specified)  in which case NULL is given. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_Postcode_CCG_Code

AGEM Derived: The code of the constituency where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_Postcode_Constituency_Code

AGEM Derived: The code of the district unitary authority where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_Postcode_Dist_Unitary_Auth

AGEM Derived: The code of the electoral Ward where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_Postcode_Electoral_Ward

AGEM Derived: Due to IG guidance this field is no longer being disseminated

Der_Postcode_Grid_Easting

Der_Postcode_Grid_Northing

AGEM Derived: The code of the local authority where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_Postcode_Local_Auth

AGEM Derived: The code of the Lower Layer Super Output Area (LSOA) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of LSOAs as of the 2001 census. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_Postcode_LSOA_Code

AGEM Derived: The code of the Middle Layer Super Output Area (MSOA) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of MSOAs as of the 2001 census. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_Postcode_MSOA_Code

AGEM Derived: The code of the primary care trust (PCT) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of PCT geographies as of closure date (31st March 2013). Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_Postcode_PCT_Code

AGEM Derived: Derived postcode sector based upon the patient&#039;s postcode. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_Postcode_Sector

AGEM Derived: The code of the Lower Layer Super Output Area (LSOA) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of LSOAs as of the 2011 census. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_Postcode_yr2011_LSOA

AGEM Derived: The code of the Middle Layer Super Output Area (MSOA) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of MSOAs as of the 2011 census. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_Postcode_yr2011_MSOA

AGEM Derived: Commissioning Hub code if prison postcode supplied. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_prisons_CommHub_Code

AGEM Derived: Postcode type  if prison postcode supplied. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_prisons_postcode_type

AGEM Derived: YDE Code if prison postcode supplied. Uses POSTCODE OF USUAL ADDRESS (MOTHER)

Der_prisons_YDE_code

AGEM Derived: Der_Pseudo_NHS_Number (or Client version). Derived by pseudonymising NHS number and applying pseudonymisation algorithm.

Der_Pseudo_NHS_Number

DerRfaRecipientAll

NHSE Derived: Electoral Ward of Mother  derived from POSTCODE OF USUAL ADDRESS (MOTHER) and Gridall.

ElectoralWardMother

Provider Submitted: Based on the 2001 census values  the ethnicity of the mother in a maternity episode as specified by herself.

EthnicCategoryMother

NHSE Derived: Local Authority District/Unitary Authority of Mother  derived from POSTCODE OF USUAL ADDRESS (MOTHER) and Gridall.

LAD_UAMother

Provider Submitted: The unique local patient identifier of the mother as generated by the NHS care provider.  This is not the NHS number.

LPIDMother

NHSE Derived: Lower Super Output Area of Mother  derived from POSTCODE OF USUAL ADDRESS (MOTHER) and Gridall.

LSOAMother2011

NHSE Derived: The meridian (i.e. AM or PM) the mother died (where death occurred before 28 completed days of birth).

MeridianOfDeathMother

NHSE Derived: The month of the year the mother died (where death occurred whilst the mother was still being cared for by maternity services).

MonthOfDeathMother

MSD001_ID

Provider Submitted: Whether the NHS number of the mother has been verified by the NHS Care Records Service.

NHSNumberStatusMother

NHSE Derived: The ICB of the Mothers residence  as derived from data item POSTCODE OF USUAL ADDRESS (MOTHER).

OrgIDICBRes

Provider Submitted: The ORGANISATION IDENTIFIER of the organisation that assigned the local patient identifier.

OrgIDLPID

Provider Submitted: The ORGANISATION IDENTIFIER derived from the patients POSTCODE OF USUAL ADDRESS

OrgIDResidenceResp

NHSE Derived: The Sub ICB Location of the Mothers residence  as derived from data item POSTCODE OF USUAL ADDRESS (MOTHER) and Gridall.

OrgIDSubICBLocResidence

NHSE Derived: A nationally unique pseudonymised ID for the mother generated by the Master Person Service (MPS).

Person_ID_Mother

Provider Submitted: Date of death within the antenatal  intrapartum and postpartum periods.  The postpartum period will only cover deaths during the period the woman is in the care of maternity services (i.e. up to point of discharge from maternity services).

PersonDeathDateMother

Provider Submitted: Time of death within the antenatal  intrapartum and postpartum periods.  The postpartum period will only cover deaths during the period the woman is in the care of maternity services (i.e. up to point of discharge from maternity services).

PersonDeathTimeMother

NHSE Derived: Postcode District of Mother  derived from POSTCODE OF USUAL ADDRESS (MOTHER) and Gridall.

PostcodeDistrictMother

NHSE Derived: The derived decile of the Index of Multiple Deprivation 2015. Derived using the LSOA 2011.

Rank_IMD_Decile_2015

RecordEndDate

NHSE Derived: This is a unique ID  which identifies each flowed patient record. The rows in the MSD001MPI and associated episode and event tables within a submission are linked via the Record Number.

RecordNumber

NHSE Derived: The reporting period end date for the file that this data was submitted in  derived from the header.

NHSE Derived: The reporting period start date for the file that this data was submitted in  derived from the header.

NHSE Derived: The unique identifier allocated to each maternity episode.

UniqPregID

NHSE Derived: Y if NHS number has passed validation and is not null in the submission  otherwise N.

ValidNHSNoFlagMother

NHSE Derived: Y if postcode has passed validation and is not null in the pre deadline submission  otherwise N.

ValidPostcodeFlag

NHSE Derived: The year the mother died (where death occurred whilst the mother was still being cared for by maternity services).

YearOfDeathMother

NW_DME.MSDS.MSD001MotherDemog

NHSE Derived: The CCG of the mothers registered GP Practice  as derived from data item GENERAL MEDICAL PRACTICE CODE (PATIENT REGISTRATION (MOTHER)). For data relating to activity between 1 July 2022 and 31 March 2023 this derivation is based on the CCG associated with the GENERAL MEDICAL PRACTICE CODE (PATIENT REGISTRATION) as at 30 June 2022. Any changes to the assignment of a GENERAL MEDICAL PRACTICE CODE (PATIENT REGISTRATION) to a Sub-ICB Location between 1 July 2022 and 31 March 2023 will not be reflected in this derivation.

CCGResponsibilityMother

Provider Submitted: The DATE on which the PERSON ceased to be registered with a General Medical Practitioner Practice.

EndDateGMPReg

MSD002_ID

Provider Submitted: The ORGANISATION CODE of the GP Practice that the MOTHER is registered with.

OrgCodeGMPMother

Provider Submitted: The ORGANISATION IDENTIFIER?of the ORGANISATION?responsible for the GP Practice?where the?PATIENT?is registered  irrespective of whether they reside within the boundary of the Clinical Commissioning Group. This field can routinely be left blank  however if populated it should contain the organisation code of the commissioner that is associated with the patient?s current registered GP Practice.

OrgIDGPPrac

NHSE Derived: The ICB Location of the Mothers registered GP Practice  as derived from data item GENERAL MEDICAL PRACTICE CODE (PATIENT REGISTRATION MOTHER)).

OrgIDICBGPPractice

NHSE Derived: The Sub ICB Location of the Mothers registered GP Practice  as derived from data item GENERAL MEDICAL PRACTICE CODE (PATIENT REGISTRATION).

OrgIDSubICBLocGP

Provider Submitted: The same as attribute ACTIVITY DATE where the ACTIVITY DATE TYPE is National Code Start Date on which the PERSON registered with a General Medical Practitioner Practice.

Maternity Services Data Set (MSDS)

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin