IHS Diabetic Audit Report (IDA)


IHS Diabetic Audit Report (IDA)

The IDA (IHS Diabetic Audit) Report extracts audit data from the NextGen Healthcare database to assess diabetes care and health outcomes for American Indians and Alaska Natives with diagnosed diabetes.


The Product User Guide helps to explain the purpose of the utility and how to use it successfully.

To purchase IHS Diabetes Care and Outcome Report, please submit a NextGen Healthcare Success Community request and we will provide a quote.

If you have purchased IHS DART Reporting Application and have not received a license key, please submit a NextGen Healthcare Success Community request and we will provide a license key as soon as possible.

To download and install the latest version on your machine, first uninstall any previous version of the DART application then click the INSTALL link below to download.

Download Latest Version:  2019.621
June 21, 2019
Team Cianos
June 21, 2019
  • An error in the build process prevented script changes from being added to the build. This has been corrected.
June 19, 2019
  • Lab Results for eGFR now accept the following LOINC codes (in addition to all previous codes): 88294-4, 88293-6, 2160-0
  • When collecting Patient data from PATIENT_DIAGNOSIS using CPT codes, a Patient with DM Type 2 was being collected and reported as having DM Type 1. This has been corrected.
  • If VAPING SCREENING has been completed, but no VAPING STATUS occurs, the VAPING STATUS will be set to 3 - NOT DOCUMENTED.
June 13, 2019
  • Dental Exam, Eye Exam, and Foot Exam now include records from PATIENT_PROCEDURE, using specific CPT codes.
  • Bug in final script preventing application from working correctly. Fixed.
June 7, 2019
  • Diabetes Education: Included a KBM Document (Diabetes Self Management Education) in the list of documents indicating Diabetes Education
  • UACR was allowing LOINC codes 14957-5 (Albumin) and 2161-8 (Creatinine) to count as if they were Microalbumin/Creatinine Ratio Panel. This is incorrect and has been fixed.
  • Amputations were not including "History of Amputation of Lesser Toe". Added ICD and SNOMED code to the appropriate lists to start capturing this data.
  • Pneumococcal Vaccine: IHS wants to know if it was EVER GIVEN, while IDA was only including the data if given during the REPORT PERIOD. Fixed.
May 28, 2019
  • Minor changes to queries to improve join speed. Medications joining on GCN_NUMBER to be more correct.
April 4, 2019
  • Changed query timeout to 20 minutes per command. Was set to 2 by default.
  • Changed code to show more of the error information when exceptions occur. Meant to help in troubleshooting unknown errors on some systems.
  • Updated SQL Scripts so that IDA LIST tables are deleted once every day (the first time the script runs on that day), and when the product is upgraded. This makes sure that changes to List Data takes effect during the product upgrade that introduces the change, and at least once per day.
April 4, 2019
  • Spelling error in a script causing failure. Fixed.
April 3, 2019
  • IDA was incorrectly requiring HEIGHT to be taken during the Reporting Period, though the report only expects the last ever recorded value. Fixed. Metformin codes were incorrect and have been adjusted.
April 3, 2019
  • The DIABETIC FOOT EXAM update code was removed by accident. It has been restored, meaning Foot Exam data will now be correct.
April 2, 2019
  • Key medications were being tested to see if they were being used AT ANY POINT in the Report Period. IHS indicated that the patient must STILL BE USING a prescribed medication through the end of the report period. Affected checks for INSULIN, METFORMIN, SULFONYLUREA, DPP4 INHIBITOR, INJECTABLE GLP-1, SGLT2 INHIBITOR, PIOGLITAZONE, ACARBOSE, REPAGLINIDE, AMYLIN, BROMOCRYPTINE, COLESEVELAM, ACE INHIBITOR, ASPIRIN, and STATINS.
  • EYE EXAM: Was counting eye exams labeled "EYE EXAM", but not exams labeled "DILATED EYE EXAM". Fixed.
  • DEPRESSION DIAGNOSIS: Was missing the diagnosis entirely thanks to an invalid NULL check on a date. Fixed.
  • eGFR: Some Lab services return a numeric value for eGFR, and some return a text string indicating the range. One client has results of ">60" instead of a number. IDA has been changed to ignore invalid values for eGFR, and to attempt to calculate it using Age, Sex, and Serum Creatinine (if available). Fixed.
  • Most Recent Eligible Location: IDA attempts to find the most recent visit to an Eligible Location. It was not properly excluding invalid records, which caused some persons to be incorrectly excluded if the last Location they had an Encounter was an ineligible location (according to IHS). This has been fixed.
April 1, 2019
  • Added an additional code to the list of Eligible Provider Specialties to include DIETICIAN (29) along with NUTRITIONIST (07) and TRIBAL/CONTRACT NUTRITIONIST (34).
March 29, 2019
  • IDA was not including enough codes to recognize "Registered Dietician" and "Registered Nutritionist". Fixed.
March 28, 2019
  • Fixed default values for when there is no data were incorrect for: Hep B Vaccine, Hep C Diagnosis, Depression Screening, Tobacco Counseling. Also: It is possible for a patient to have a Hep C Diagnosis, but no screening records in EHR (because they were done long ago for example). IDA now automatically sets Hep C Screen to TRUE if a HEP C Diagnosis is found.
March 27, 2019
  • Fixed calculation errors for EGFR that was preventing report from calculating fully.
  • Fixed calculation and output errors for TB Test Result indicator, Tobacco Screening, Tobacco Counseling, and Weight.
March 26, 2019
  • Certain data fields were being stored in the temp tables in the wrong format, preventing them from being read and from appearing in the final IHS Diabetic WebAudit file. This included AGE, EGFRVALUE, and CREATVALUE. This has been fixed.
March 25, 2019
  • An issue was preventing the IHS Diabetic WebAudit file from generating. Fixed.
  • Export to Excel CSV now works
March 23, 2019
  • DM Report Data computed with REFRESH is now persisted across sessions. Choosing a YEAR will automatically load the saved data about each Person in the list, and remember the User's INCLUDE or EXCLUDE setting for each one.
  • Selecting the YEAR will automatically load the information that was SAVED for persons in that year. If there is no saved data, a message is shown indicating that the user needs to click REFRESH to make the IDA check all Users again and build data to be saved.
  • When creating the DM List for a new report year, IDA will use the patient selections from the previous report year's DM List in the new DM list by default when choosing REFRESH. This is intended to save time when choosing the DM List members of the new Report Year, assuming they are similar to the previous year's selections.
  • Saving the DM Patient List will clear all generated Report Data, forcing the User to click GENERATE when they make changes.
  • The year specified in the Ending Date controls which DM Patient List is used when reporting.
  • The IDA will only generate report results for Patients that have been "included" on the DM Patient List.
  • The DM Patient List shows all Native American/Alaska Native persons with a DM diagnosis. The User can then choose which ones to include or exclude from reporting during the year.
March 20, 2019
  • IDA now allows the User to create a COHORT for a given reporting year. This makes sure IDA will report on the same persons throughout the reporting period.
March 11, 2019
  • Supports file export in the correct format for 2019 WebAudit. The application is stable. The SQL queries work, but it is unclear if they are completely accurate. Testing is ongoing.
January 24, 2019
  • Initial Release of IDA 2019.124 (released January 24, 2019)
May 2, 2018
  • Included 2018 headers.
March 6, 2018
  • Export by ASUFAC or all locations
February 22, 2018
  • Improved foot exam results
February 16, 2018
  • Updated foot exam support
February 13, 2018
  • Added support for CPT4 cod 2022f from patient procedures.
February 8, 2018
  • Added wider support race support.
February 7, 2018
  • Race ID filtering resolved.
January 29, 2018
  • Added support for 2018 reporting deadline. Improved race filter. Added option to color code columns for easier viewing.
January 16, 2018
  • Corrected filter update issue.
January 12, 2018
  • Removed unused code.
January 11, 2018
  • Updated export DM group by location to work with previous version.
January 10, 2018
  • Supports default ASUFAC and ASUFACs by location.
January 4, 2018
  • Included documents in the help menu.
December 13, 2017
  • UI improvements.
  • Performance improvements.
  • Include missing patients.
May 23, 2017
  • Updated Depression screening to check the chk data present indicator for the depression short form
April 25, 2017
  • Update to some measures for current version
February 9, 2017
  • Update to the appearance of audit form
February 8, 2017
  • Visual update to audit form
February 3, 2017
  • Correct form in application
January 31, 2017
  • Update to 2017 Audit

Terms & Conditions | Privacy Policy | Legal Notices | © 2014-2016 QSI Management, LLC. All Rights Reserved.

Technical Consulting Admin Login