Data is to be extracted via a SQL-2-SQL view from the Local Health Boards data warehouse into the national (NWIS) data warehouse.
Full details of this implementation can be found here Maternity Dataset Technical Implementation.
The data will be extracted on the 15th of each month with data relating to events that took place up to and including the end of the previous month.
Patient Security & Confidentiality
‘Patient Name’ and ‘Patient Usual Address’ (not ‘Postcode of Usual Address’) should not be populated in the Maternity Indicators Data Set where a valid NHS Number is present.
A valid NHS Number is one that has passed the check digit calculation on entry into the source system. If an NHS Number is not valid (i.e. does not conform with the check digit algorithm) then Patient Names and Patient Usual Addresses should not be removed, as the reliability of the NHS Number will not be known.
The NHS Number Status Indicator is a mandatory data item within the Maternity Indicators data set. ‘Patients Name’ and ‘Patients Usual Address’ should be removed when a valid NHS Number is present, even if the NHS Number Status Indicator does not have a value of ‘nn - Number present and traced using Welsh NHS AR’ or ’01 – Number present and traced’.