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 CY2024 reporting season.
To download and install the latest version on your machine, click the INSTALL link below.
Download Latest Version: v10.6.2
VERSION:
UPDATED:
CATEGORY:
COMPATIBILITY:
|
|
10.6.2
- Enhancement: Support for Eye and Dental Exam from Care Guidelines
10.6.1
- Enhancement: Additional support for IPV/DV measure using Social Determinants of Health template -> Exposure to Violence Extended support to report 10-year ASCVD score using MSR segment
10.6.0
- 2024 Release
10.6.0_beta
- Beta release for CY 2024 reporting
10.5.2
- 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.
10.5.1
- 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.
10.5.0
- 2023 Release
- Bugfix: Cancelling during report data generation or exporting now functions as expected.
- Updated all IHS SCB code tables
10.3 SR5
- Updates to how NDW assigns the service category data point.
10.3 SR4
- 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
- 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
- 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
- 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
v10.3.0
- 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.
v10.2.1
- 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
2019.1016
- 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.
2019.1014
- 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.
2019.1012
- 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.
2019.1011
- 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.
2019.1010
- 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
2019.1004
- 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.
1.1.4
- Updated clinic codes
1.1.3
- Updated to support latest IHS code book standards, and code books.
1.1.2
- Updated previous code books.
1.1.1
- Updated Community Codes, and Beneficiary Classes
1.1.0
- Windows 10 license support.
1.0.49
- Export warning added.
1.0.48
- Updated to support lab formats.
1.0.47
- Updated performance. Improved DX code results.
1.0.46
- Updated to included additional alcohol screening checks.
1.0.45
- Updated view source
1.0.44
- Updated Provider Cross Reference to sort. Added provider information on encounters report.
1.0.43
- Removed index update from CL.
1.0.42
- Improved charges
1.0.41
- Better support for service categories Improved performance
1.0.40
- Updated medical quantity limits.
1.0.39
- Updated codes. Better DX code support.
1.0.38
- Support for not saving settings.
1.0.37
- Parameter optimizations.
1.0.36
- Limit on the OBX LAB.
1.0.35
- CVX codes are padded when needed. Refusal codes are added.
1.0.34
- Lab results filter radiology.
1.0.33
- Improved logging features.
1.0.32
- Cleaned old references.
1.0.31
- Updated GPA MSH counter ID, and GPA date format.
1.0.30
- Patient History now follows GPA design.
1.029
- Added community codes reporting to ZP2 segment of encounters report.
1.0.28
- Added field for billable flag.
1.0.27
- Added support for larger than expected vital signs.
1.0.26
- Support for non-billable encounters
1.0.25
- Improved Encounters performance
1.0.24
- Support for .Net 4.5.1
1.0.23
- Improved MVX output.
1.0.22
- Improved support for SQL server 2008
1.0.21
- Added additional GPA details.
1.0.20
- Update to Patient History.
1.0.19
- ZPL updates.
1.0.17
- Updated BMI results.
1.0.18
- Improved GPRA output.
1.0.16
- Added more patient history support.
1.0.15
- Site Id used in registration.
1.0.13
- 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.
1.0.14
- Installer improvements.
1.0.12
- Support for Orders without unique IDs. (This should not happen in your system.)
- Updated View Source.
1.0.11
- Update PID output of SSN.
1.0.10
- Improved encounters performance.
- Improved GPRA quality.
1.0.9
- Support for pseudo 4 digit SSN
1.0.8
- Updated to latest IHS code tables.
1.0.7
- Improved missing providers and missing locations screens.
1.0.6
- Updated Encounter segment order.
Privacy Policy | Legal Notices | © 2009 - 2024 NXGN Management, LLC. All Rights Reserved.