NDW Utility


NDW Utility

The NextGen Healthcare National Data Warehouse (NDW) reporting utility provides a platform for clients that report to IHS (Indian Health Services) to gather the data required by Indian Health Services for their yearly GPRA reporting.

To purchase NDW or request a previously purchased license key, please submit a support case in client community. Please note: NDW will not function without a license key.

The current version of NDW is for the CY2023 reporting season.

To download and install the latest version on your machine, click the INSTALL link below.

Download Latest Version:  v10.5.2
September 30, 2023
Team R&D
September 30, 2023
  • Added the order_ table as an additional data source for CPT / Diagnosis documentation for reportable encounters.
  • Lengthened the SQL command timeout setting to help prevent timeouts when 'Viewing' data within the encounters report grid.
  • Added a report date range constraint to the logic that gathers the data for the problems list.
September 20, 2023
  • Enhancement: Functionality added to allow for overriding race filter. (When selected, NDW will no longer filter data by any specific race)
  • - Minor UI Tweaks related to clipping issues now resolved.
September 6, 2023
  • 2023 Release
  • Bugfix: Cancelling during report data generation or exporting now functions as expected.
  • Updated all IHS SCB code tables
10.3 SR5
August 16, 2023
  • Updates to how NDW assigns the service category data point.
10.3 SR4
August 1, 2023
  • Bugfix: When gathering charges / procedures, NDW in some instances, could duplicate the charges gathered based upon an incorrect join to the service_item_mstr table.
10.3 SR3
July 18, 2023
  • Update: Filtering options for the datagrid now reset after a generating report data.
  • Update: Exporting to HL7 will now export all three NDW output files at once rather than cycling through the report type DDL.
  • Update: The progress bar along with other progress indicators have been optimized to require less screen geography, providing additional space for other on-screen controls such as the datagrid viewer.
  • Update: The status bar now displays appropriate status information as well as the current NDW version, NGXN version, logged in user and ID.
  • Update: NDW now uses both charges and patient procedure as data sources for gathering procedures.
  • Update: Minor cleanup and optimization on datagrid viewer. More datagrid optimizations to come.
  • Update: Improved 'service category' assignment logic.
10.3 SR2
July 11, 2023
  • Bugfix: Dental exams in some instances were not getting picked up by NDW due to a string comparison mismatch.
  • Update: NDW service category assignment logic refactored to increase accuracy.
  • Update: Additional ADA codes added for dental exam detection.
  • More to come...
v10.3.0 UPDATE
October 12, 2022
  • v10.3.0 UPDATE: Minor bug fixes, Addressed an issue where race may not be set correctly due to a dependency field within the person_race_xref table not getting populated, Addressed an issue with breast feeding data not formatted properly within the final HL7 output, Addressed an issue with service category potentially not getting set correctly.
  • IHS Dental report codes added (0000, 0007, 0190) for dental encounter detection
September 22, 2022
  • NDW Utility for 2022 Reporting
  • - Previous versions of NDW imposed an inner join constraint on the master_im_ template table to determine visit_type. Visit type is used by NDW to determine whether an encounter was an ambulatory encounter. This causes issues with BH, PT and other specialty workflows that do not necessarily use the standard intake or SOAP template and possibly excludes encounters that are reportable: This has been addressed by relaxing the master IM constraint and using standard E&M codes to detect ambulatory visits that did not follow a workflow that utilizes the Intake or SOAP template. Additionally, any encounters that do not have any associated procedures or diagnosis will be considered a Chart Update by NDW for reporting purposes as no discernable/codified visit, service or diagnosing was performed. This also means that it is likely the base load of encounters gathered by NDW will increase.
  • - Test patients identified with 'NDW' in other ID field on persons chart: Historically, the value "NDW" could only occupy this field for this to work. Now "NDW" can appear anywhere in the field.
  • - Diabetic foot exam: Added the table PhysExamExtPop_ as an additional data source for pulling diabetic foot exams. Added the SNOMED code for monofilament test. At this time, the core logic for this measure appears correct.
  • - Problems and Diagnosis: When determining IHS problem status for patient problems and diagnosis, the status values were not aligned with IHS specifications. The following status values for diagnosis will be used. If a status other than what is listed below is used, then the field will be blank in the report. A = CHRONIC, R = ROUTINE/ADMIN, S = SUB-ACUTE, E = EPISODIC, I = INACTIVE, per our clinical advisor.
  • - Facility / practice name displayed in HL7 exceeds 30 characters: The practice name within the header and footer of the HL7 report document will be trimmed to 30 characters (any alpha-numerics exceeding 30) if it exceeds this limit.
  • - Telehealth encounters not included in report: Telehealth encounters will be identified in the NDW using the following modifiers on CPT codes ('GT','GQ','95','FQ') and/or Place of Service = '02’ which aligns with both CMS and current telehealth billing requirements.
  • - Infant feeding choice measure not populating: The infant feeding choice data is gathered from the pediatric nutrition assessment template. A bug was addressed where the feeding choice IHS code was being populated in the wrong element within the OBX-IFC segment.
  • - Determining race for report eligibility: Nextgen deprecated the uds_race_id field on the person table which NDW was still in part using to determine race. Race will now ONLY be determined by setting the race value on a persons chart under the demographics tab. Also of note here, you have the option of choosing multiple races in this field. American Indian or Alaska Native (valid race choice for NDW), can appear in any of the choices in any order.
  • - A New icon for NDW.
September 30, 2021
  • NDW Utility for 2021 Reporting
  • The GRID has returned! Better than ever!
  • Support for EDR (please see EDR Workflow and Notes document in Resources section)
  • Numerous bug fixes and internal updates
October 16, 2019
  • The BHS and MHS segments were incorrectly formatted and included some incorrect data. This was reported by IHS, and is now fixed.
  • SEVERE BUG: NDW was deleting the IHS Eligibility Status values from Master List and adding new ones (which regenerated their internal ID). This effectively removed the Eligibility Status from all patients on which it had been set. NDW update scripts have been changed, and it no longer deletes the existing values from Master List. It merely checks if they exist, and adds them only if missing. It is recommended that installations with an older version of NDW installed, to go through their patients and see if the IHS eligible patients have had their eligibility flag removed.
October 14, 2019
  • If an Encounter had a missing Location (which can happen for ... reasons), NDW would be fail with a "Location Not Found" error. This has been corrected.
  • The BLOOD QUANTUM value written to ZP2 was the NG Master File GUID instead of the IHS Blood Quantum Code. This has been corrected.
  • When writing out Dental information, ZDP will now only be written if Field 2 (OPSITE) contains a value.
  • The ADA Codes being written to ZDN were the CDT code (ex. D2392) not the ADA code (ex. 2392). This has been corrected.
  • The progress indicator was showing 100% complete before processing was actually complete. This has been corrected.
October 12, 2019
  • PROCEDURES were being collected if they occurred on or before the FIRST DAY of the report period, instead of the LAST DAY of the report period. As you can imagine, this dramatically reduced the mumber of PROCEDURES being collected. This has been fixed.
  • The SITE ID wasn't being set properly in the app, so HL7 files still showed Site ID NXGN. This has been corrected to use the value specified in PRACTICES for the selected practice. Your actual Site ID will now be used.
  • Lower-case letters were being written to HL7. Since all old files only contained upper case letters, this has been changed. HL7 will now only include upper case letters.
  • OBX-LAB segments include a Lab test description. NDW was applying inappropriate formatting to the text, which has been discontinued.
  • Some clients have copies of NDW tables in different Schemas. Some NDW logic was trying to clean indexes and tables without specifying the Schema, which was causing errors. Now NDW only checks for and removes indexes/tables in the "current" schema assigned to the current user. This is typically DBO.
October 11, 2019
  • NDW was failing to properly convert DATE information in several HL7 Segments. Sometimes the date value looked like letters, sometimes it looked a human-formatted date/time value. The formatting has been corrected for all dates represented in HL7. All Segments were checked and tested.
  • The development team was under the impression that data files created by non-RPMS applications (such as NextGen EHR) should have a filename using the SITE ID "YNEZ". This is incorrect; YNEZ is an active IHS Site (Santa Ynez Tribal Clinic). The app has been changed back to the old logic, meaning it uses the local NDW SITE ID (aka YOUR Site ID) instead of YNEZ.
  • Several HL7 Segments were incorrectly writing fewer than the number of required data values (e.g. holding 14 values, only outputting 8). This has been corrected.
  • Some locations have created CPT codes longer than 5 chars as a special marking. The first five digits are a valid CPT. NDW now collects only the first five characters of any field deemed to hold a CPT code, to allow reporting to properly interpret, find, and use data.
  • NDW checks to see if the generated data still exists in the database. If so, it loads the previously selected date range and practice and chooses those in the interface.
  • Using QuickDate, a User can easily choose common date ranges for any Fiscal Year period, using only a few mouse clicks and no keyboard interaction.
October 10, 2019
  • SQL Scripts were including Encounters that referred to Persons that weren't included during entity identification. Fixed.
  • NDW shows progress as reports are generated.
  • NDW shows time elapsed, count of records being written, and estimated time remaining.
  • NDW generates one report at a time, selected in the NDW REPORT TYPE drop list. Recently this settings was ignored, and all three reports were always generated.
  • CANCEL Button functions when generating reports.
  • SQL Libraries broken into smaller parts so progress occurs more quickly
October 4, 2019
  • Changed SQL Queries that collect NDW data completely redesigned to improve speed and maintainability.
  • Changed HL7 generator. Result is more complete, more accurate, and more maintainable to change/fix.
  • Added information regarding breastfeeding for 2019 reporting.
  • Progress Bar while extracting database info, and while generating HL7 files.
  • HL7 Filename updated to follow IHS recommendations/requirements.
October 17, 2018
  • Updated clinic codes
October 8, 2018
  • Updated to support latest IHS code book standards, and code books.
October 4, 2018
  • Updated previous code books.
October 2, 2018
  • Updated Community Codes, and Beneficiary Classes
September 26, 2018
  • Windows 10 license support.
September 25, 2018
  • Export warning added.
August 22, 2018
  • Updated to support lab formats.
August 14, 2018
  • Updated performance. Improved DX code results.
July 31, 2018
  • Updated to included additional alcohol screening checks.
May 30, 2018
  • Updated view source
May 23, 2018
  • Updated Provider Cross Reference to sort. Added provider information on encounters report.
May 10, 2018
  • Removed index update from CL.
April 19, 2018
  • Improved charges
April 18, 2018
  • Better support for service categories Improved performance
April 9, 2018
  • Updated medical quantity limits.
April 6, 2018
  • Updated codes. Better DX code support.
February 12, 2018
  • Support for not saving settings.
February 12, 2018
  • Parameter optimizations.
February 7, 2018
  • Limit on the OBX LAB.
February 1, 2018
  • CVX codes are padded when needed. Refusal codes are added.
January 4, 2018
  • Lab results filter radiology.
October 25, 2017
  • Improved logging features.
October 11, 2017
  • Cleaned old references.
September 27, 2017
  • Updated GPA MSH counter ID, and GPA date format.
September 21, 2017
  • Patient History now follows GPA design.
September 19, 2017
  • Added community codes reporting to ZP2 segment of encounters report.
September 18, 2017
  • Added field for billable flag.
September 15, 2017
  • Added support for larger than expected vital signs.
September 1, 2017
  • Support for non-billable encounters
August 15, 2017
  • Improved Encounters performance
August 11, 2017
  • Support for .Net 4.5.1
August 1, 2017
  • Improved MVX output.
July 26, 2017
  • Improved support for SQL server 2008
July 20, 2017
  • Added additional GPA details.
July 12, 2017
  • Update to Patient History.
July 11, 2017
  • ZPL updates.
July 6, 2017
  • Updated BMI results.
July 6, 2017
  • Improved GPRA output.
June 27, 2017
  • Added more patient history support.
June 8, 2017
  • Site Id used in registration.
June 6, 2017
  • Updated application settings screen to more friendly resolution.
  • Updated view source data.
  • Fixed infant feeding codes.
  • Better checks for site ID and NDW site ID.
June 6, 2017
  • Installer improvements.
May 10, 2017
  • Support for Orders without unique IDs. (This should not happen in your system.)
  • Updated View Source.
April 28, 2017
  • Update PID output of SSN.
April 27, 2017
  • Improved encounters performance.
  • Improved GPRA quality.
April 25, 2017
  • Support for pseudo 4 digit SSN
April 5, 2017
  • Updated to latest IHS code tables.
February 22, 2017
  • Improved missing providers and missing locations screens.
January 3, 2017
  • Updated Encounter segment order.

Privacy Policy | Legal Notices | © 2009 - 2024 NXGN Management, LLC. All Rights Reserved.

Technical Consulting Admin Login