The National Booking Reporting System Data Warehouse (NBRS DW) was established to consolidate information from the NBRS inpatient database, summary statistics, and cost weighted discharge information from the NMDS and Sector Services. This consolidated view of the data supports the monthly production of Elective Services Patient Flow Indicators (ESPIs) reports and ad hoc queries.

Additional information:

Have_(encrypted)_NHI Yes
Personally identifiable (e.g. linked to NHI numbers) and longitudinal or aggregated (e.g. for planning, clinical research etc.)? encrypted NHI
Volume of data (e.g. how many records) Since when? data from 1 August 2000
Purpose and governance including ethics committee/patient consent mechanisms. Q: How do you get around ethics/privacy issues with your data sources? Esp. DHBs? The NBRS Data Warehouse is accessed by authorised National Collections and Reporting staff for maintenance, data quality, analytical, and audit purposes. Authorised users from the Ministry of Health’s Elective Services Team and DHBs have access to the data for analytical purposes via the Business Objects reporting tool and the secure Health Information Network.
Scope National
Does the data contain diagnoses and clinical outcomes? Does the data contain procedures, device information and medication for therapy? Does this data set have cost / price data? No dx, no outcome, has booked procedures/specialty
Presence of Data dictionary? Column headings in Excel or any kind of data model if residing in a relational database (e.g. Access, SQL Server, Oracle etc.)
Linked (or linkable) to other datasets within your organisation or across the Sector The NBRS DM contains agreement volume contractual data from the Contract Management System, actual inpatient contractual data from the NMDS, and summary outpatient data for patients referred to DHBs, as well as summaries of all booking status events held in the National Booking Reporting System (NBRS).
How often does this data set get updated? Daily? Weekly? Monthly? Quarterly? Yearly? The NBRS DW is updated every month with the last six months of data from: the NBRS, which is a collection of all booking system events involving a healthcare user who receives an assessment of priority for a medical or surgical service and who is accepted for publicly funded treatment; this data is collected from the 21 DHBs; the Monthly Reporting Access database, which contains national summary outpatient data; this data is collected monthly from the 21 DHBs.
Brief info about the systems and processes used to collect/manage data. Q: Where the data is collected, in what form, and accessibility? Data is sourced from DHBs via: National Booking Reporting System (booking event data); National Booking Reporting System Monthly Reporting (NBRSMR) (outpatient data). Information is collected about the patient’s date of entry into the system, their assessed priority, and their booking status.
Data format, e.g., data structure, data types, and storage form (relational database, Excel, csv, etc.). Oracle DB
How well the data is structured, e.g. free text VS coded text VS pick-list (drop-down list) coded
How quickly can the data be made available from time of request and how old is the data once it is made available Information available to the general public is of a statistical and non-identifiable nature. Researchers requiring identifiable data will usually need approval from an Ethics Committee. Customised datasets or summary reports are available on request, either electronically or on paper. Staff from the Analytical Services team can help to define the specifications for a request and are familiar with the strengths and weaknesses of the data.