Completed record extract

The NPID online system now includes a reporting function that allows registered users to extract a copy of the data they have submitted to the NPID audit using the online system.

Remember that this file will contain patient identifiable data and must not be shared with anyone other than other registered users of the NPID system within your hospital, if saved locally it must be stored with appropriate security in line with your local governance policy. Any publication or presentation of this data must be done so with appropriate aggregation and anonymisation again in line with your local governance policies and procedures.

Only users registered to access the NPID online system will be able to run the extract. Registration for the system requires Caldicott Guardian approval for each user. Any participating hospital can register additional users using the registration form.

The extract will only include data entered directly onto the system – where data for national reporting is obtained by linking the data entered on the NPID system to other data such as the National Diabetes Audit or Hospital Episode Statistics, this data will not be included in the extract.

A registered user extracting data will see the records submitted by their hospital as follows:

• for pregnancies ending on or before 31 December where any user registered at that hospital entered the pregnancy details (Section B of the NPID audit form)
• for pregnancies ending on or after 1 January [the following year] where that hospital was recorded as the booking hospital or the delivery hospital

Pregnancies with multiple outcomes (for example twins) will appear as a complete line for each pregnancy outcome so for twins there will be two lines showing the same pregnancy details with each outcome. Such records are flagged in the extract in the baby count column. 

The extract will be raw data prior to the data cleaning that we run for the national and regional audit reports. For example, the cleaning process removes inconsistent date entries where for example, the first HbA1c date in pregnancy entered is more than 40 weeks prior to the estimated delivery date.