Ryan White RSR Extract Utility


Ryan White RSR Extract Utility

The NextGen TCS Ryan White RSR utility automates the extraction of data from NextGen Ambulatory EHR (Demographics, Orders, Social History, Ryan White, etc.) to create a HRSA standard RSR report for submission.

The Ryan White RSR Extract Utility for CY2022 Reporting is now available for download.

Note that this is not an interface to CAREWare.

Note that the utility is non-functional until a License Key is supplied.

The RSR Template is compatible with KBM 8.3.x clients on 5.8 UD2 HF111 and higher.

A License Key (sold separately) can be obtained by contacting the NextGen Healthcare Success Community, or by calling NextGen Healthcare Corporate Headquarters at (215) 657-7010.

Download Latest Version:  v2.9.12
February 28, 2024
Team R&D
February 28, 2024
  • Fix: KI203259 : If Housing Status ID is either "blank / NULL" or "X", then this tag will not be part of exported xml file
February 27, 2024
February 21, 2024
  • Fix to incorrect totals for each year of the first ambulatory care visit date
February 21, 2024
  • Update SP ncs_rsr_get_view_export to handle any exception coming from table lab_results_obx Added Logger which is configurable in config file
November 10, 2023
  • Only HIV Pos Test Dates before the end of reporting period are pulled
  • Added warning if patient has HIV Pos Test Date but is HIV negative
November 1, 2023
  • Outpatient/Ambulatory Health Service Dates that occurred before the reporting period no longer pulled
  • Added warning if viral load value is low (<200) with Prescribed Art as No
October 17, 2023
  • Updated Viral Load field to detect and discard the phrases "DETECTED" AND "NOT DETECTED"
  • Updated Viral Load field to express lab results as a log when a decimal point is present
  • Added a checkbox/filter for "Warning" status items
  • Added warning if patient has more Outpatient/Ambulatory Health Services visits reported than Outpatient/Ambulatory Health Service Visit dates
  • Added warning if patient is HIV negative and has Core Medical Services
  • Added warning if patient has greater than 365 visits of any particular service category
  • Removed CAST of medical_support_date_.txt_delivered_date to DATETIME datatype
October 3, 2023
  • Fixed bug with income eff dates and exp dates
  • Added columns for income eff and exp dates to utility screen
  • Added validation/warning messages for HIV/AIDS status and HIV Diagnosis Year fields
  • Added Installation & User Guide
  • Allowed HIV Pos Test Dates that are before the reporting period to appear and added a warning
September 18, 2023
  • Added encounter info to display: enc datetime, rend provider, enc nbr, location, visit type
  • Changed Status to "Warning" from "Output" anytime a warning appears in the status message
  • Moved the frozen column so that the last name, first name, and date of birth always appear
  • Gender validation for pregnancy ID now checks if pregnancy status is YES for patients with gender of male or unknown
  • Populated content in the View Source screen for newer columns
September 5, 2023
  • License key now required to use the application
  • Added warning message for missing Poverty Level Percent and Family Income fields
  • Added warning message for missing New Client field
  • Changed message for missing Housing Status field from error to warning
August 22, 2023
  • Client Report Health Coverage - The utility now takes into account the patient's insurance policy's effective date and expiration dates for the report period
August 8, 2023
  • Fixed bug when attempting to sort the Health Coverage column in the utility
  • Added status message if patient is HIV/AIDS positive, has had services in Outpatient Ambulatory Health, Medical Case Mgmt, or Non Medical Case Mgmt, but lacks HIV Risk Factors
  • Added status message if patient is HIV/AIDS positive, has had services in Outpatient Ambulatory Health, Medical Case Mgmt, or Non Medical Case Mgmt, but lacks Screened Syphilis
  • Added age check for Screened Syphilis
  • Added error message if patient has invalid first name and last name (for creating UCI field)
  • Added the "Risk factor not reported or not identified above" column to the utility screen
  • Added validation for PregnantId field by comparing entered pregnancy diagonosis with a list of valid pregnancy diagnoses
  • Added PregnantId value to utility screen
  • Removed non-Class Library exception handlers
July 25, 2023
  • Moved Medical Insurance/Health Coverage/Fin Class code from independent SP to main gather SP.
  • Moved logic for No insurance from C# to SQL.
  • Renamed Medical Insurance IDs column name to Client Report Health Coverage to match report .
  • Gather fin class of payers by enc date now instead of create date
  • The check for Vital Status now checks if patient has service in Outpatient Ambulatory Health, Medical Case Mgmt or Non Medical Case Mgmt
  • Added check for Housting Status ID which checks if patient has service in Outpatient Ambulatory Health, Medical Case Mgmt, Non Medical Case Mgmt, or Housing Services
July 11, 2023
  • Updated FirstAmbulatoryCareDate field to show first encounter where HIV diagnosis or HIV test occurred
  • Added warnings for empty datepickers
  • Added default values to datepickers for previous year
  • Set values to empty settings to False
June 27, 2023
  • HIV Diagnosis Year - Checks for NEW diagnosis. Checks patient_diagnosis table now as well as patient_problems. Also checks if HivAidsStatus is not 1 or 7.
  • HIV Pos Test Date - Added error message if missing when HIVDiagnosisYear is populated, or if blank when patient has had Outpatient Ambulatory Health Services.
  • New Client - Now pulls patients whose first Ryan White encounter is during the reporting year
  • Received Service Previous Year - Now looks at services delivered
June 2, 2023
  • Made HIV AIDS status field more accurate
  • Fixed date formats
  • Adjusted poverty level to use federal guidelines and accounted for Alaska and Hawaii
May 19, 2023
  • Saved Export Path to utility settings
  • In the utility display, removed the Transgender columns and put the data into the Gender column
  • For Viral Load fixed results containing period character (.) by rounding down
  • Updated the information in the View Source screen
  • Split the Services Delivered column into Service Visits Delivered and Core Medical Services Delivered
  • Updated how Settings are pulled from database
  • Migrated main report query to stored procedure
  • Moved ID mapping to stored procedure
  • Updated column names to NextGen notation
  • Made the Core Medical Services Delivered that were removed to be not required
April 3, 2023
  • Excluding <FirstAmbulatoryCareDate> field if the field <ClientReportServiceVisits> has no occurrances of "Outpatient/Ambulatory Health Services" (8)
  • Including patients who tested HIV negative for early intervention patients
  • Added zip code csv file export
March 27, 2023
  • First Ambulatory Care Date: Ignore encounter dates that are dated before the patient date of birth
March 21, 2023
  • Fixed bug data conversion for lab results
March 20, 2023
  • The Prescribed Art ID field is now pulled from Orders Management as well as the Ryan White template
March 17, 2023
  • The report now pulls patients that had encounters within the report date range regardless of when the Ryan White template was created.
  • Viral Load test: Only include lab results with numerical data and pull smaller value if multiple results on same date
  • Set Housing Status Collected Date to the encounter date
March 15, 2023
  • Replaced Enrollment Status ID with Vital Status ID in View screen
  • Added "Other Asian" for Asian Race Subgroup
  • Added "Another Hispanic, Latino/a or Spanish origin" for Hispanic Subgroup
  • Resolved duplicate race items in View screen
  • Added condition to ensure only HIV positive patients are pulled into the report
  • Cleaned up the Hiv Risk Factors field in the View screen
  • The report now pulls encounters based on the encounter date rather than the date the Ryan White template was created for the patient.
  • Moved Chicano from Other Hispanic ethnic Subgroup to Mexican ethcni Subgroup
March 6, 2023
  • Added MRN column to the view screen
  • Added Hispanic Ethnicity Subgroup
  • Added Asian Race Subgroup
  • Added Native Hawaiian/Pacific Islander Race Subgroup
February 21, 2023
  • Removed empty tags for ClientReportRace, Asian subgroup, Hispanic subgroup, ClientReportServiceDelivered, ClientReportAmbulatoryService, ClientReportCd4Test, and ClientReportViralLoadTest.
February 9, 2023
  • Updated class library to v8.3
  • Added documentation items
  • A race ID that is not an allowed value (for example, "Declined to specify") is no longer considered an error.The race field will be left blank in the XML output.
February 18, 2022
  • Updates for 2021 RSR Specification
  • Updates for more precise data collection
  • Several defects and UI issues resolved
March 24, 2021
  • Hotfix maintenance release
February 18, 2021
  • Updates for CY2020 Reporting
June 18, 2020
  • Corrected calculation of HIV Pos Test Date
April 27, 2020
  • HIV Diagnosis Year should only be returned for new patients
March 26, 2020
  • Added trim of ethnicity field from master list values
  • Only return HIV Pos Test date if it occurs during submission range (per regs)
  • Return most recent HIV Pos Test date in timeframe (and only display if the date is in the timeframe).
March 16, 2020
  • Removed all ServiceIDs from the ClientReportServiceDelivered section except for: 9 AIDS Pharmaceutical Assistance (LPAP, CPAP) 12 Health Insurance Premium and Cost Sharing Assistance for Low-Income Individuals
February 27, 2020
  • Corrected return of multiple CD4 results when Quest returns incomplete order - one per order
  • Removed viral load loinc codes: 29539-4 ,29541-0, 41514-1, 41516-6, 48510-2, 48552-4, 51780-5. These codes are log copies.
  • Limit encounters returned to billable
  • Return distinct list of encounters in ClientReportAmbulatoryService (dups previously)
  • Added checkbox on mapping screen that, when selected, for any insurance mapped to Uninsured is present, it will not be displayed unless it is the only insurance present. In other words, a patient will not be both insured and uninsured.
July 30, 2019
  • Updates for April 2019 HRSA data dictionary updates (see release notes for details)
February 27, 2019
  • 1. Screened Tb Since Hiv Diagnosis Id Added Loinc 71773-6
  • 2. Screen Hep B added Loinc code 22322-2 and 13952-7
  • 3. Hep B Vaccine added CPT codes 90746 and 90636
  • 4. Hep C screening added Loinc codes 48159-8 and 13955-0
February 8, 2019
  • 13955-0 included as a qualifying code for Hep C Screening
  • fixed insurance ids being overstated
  • fixed poverty levels were not coming through in all cases due to eff and expiration 6 month date ranges. No longer trying to fit them in but pulling in last reported for this year as per the Ryan White specifications.
  • Email address on the console was increased.
November 19, 2018
  • Updated UI and extended timeout.
October 17, 2018
  • Ethnicity not specified or missing will now be reportable, but is now a warning.
October 4, 2018
  • Backwards compatible with 5.8 gender.
September 26, 2018
  • Support Windows 10 license.
  • Removed date requirement for HAART.
September 25, 2018
  • Export warning added.
September 7, 2018
  • Update to support 5.9 gender codes
April 4, 2018
  • Improved Pregnancy status checks.
March 23, 2018
  • Support lab collection dates not matching timestamps.
March 22, 2018
  • Updated CVX codes for Hep B, handle bad patient problems, and better support for invalid lab results.
March 20, 2018
  • Improved date bounds.
March 20, 2018
  • Resolved export issue with viral loads.
March 20, 2018
  • Wider range for viral load counts supported.
March 20, 2018
  • Resolved data type count issue.
March 13, 2018
  • Better support for multiple frames
March 8, 2018
  • Supports recent HRSA guidelines
March 7, 2018
  • Improved HIV Diagnosed Date
February 7, 2018
  • Added query optimizer hints.
January 31, 2018
  • Additional date checks.
  • Additional dates checks
January 31, 2018
January 16, 2018
  • Updated support for invalid dates in services delivered.
November 16, 2017
  • Support for .Net 4.5.1.
October 3, 2017
  • Initial Release.

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

Technical Consulting Admin Login