RSR Data Validations

The Ryan White HIV/AIDS Program Services Report (RSR) data pass through a series of validation checks. These validation checks look for consistency and accuracy in your data to improve your data quality. This document provides information on the data validations related to the RSR Recipient Report, Provider Report, and client-level data file. Data element numbers allow you to reference between this document and the RSR Instruction Manual. This resource includes the 2024 data validation messages.

Notes

  • Provider Report Validation Messages
    • Validation Checks 34 validation type has been upgraded from “Alert” to “Warning”.
  • Client Report Validation Messages
    • Validation 84 has updated logic. Clients age 110 and older have been added to the logic.
    • Validation Checks 70 validation type has been upgraded from “Alert” to “Warning”.
    • Validation Checks 85 validation type has been upgraded from “Alert” to “Warning”.

Validations are highlighted in yellow if they were added, were downgraded from an “Alert” to “Warning” or if the conditions that trigger the validation were revised. 

Recipient Report Validations

Section 1: General Information
Check #Question #MessageLevel
187Q#7At least one provider must be specified.Error
188Q#1bCity is required.Error
191Q#7Each provider organization must be funded to provide at least one service.Error
193Q#3eE-mail is required.Error
194Q#8Recipients cannot exempt all of their providers from submitting a Provider Report. At least one provider must be required to submit a Provider Report.Error
195Q#4

Q#4 Minority AIDS Initiative Funds Percentage.

If your organization received a Minority AIDS Initiative designation, you must specify the most recent percentage designation for the reporting period.

Error
196Q#4

Q#4 Minority AIDS Initiative Funds.

A response is required for Q#4, organization received a Minority AIDS Initiative designation for the reporting period.

Error
197Q#3aName is required.Error
198Q#3cPhone is required.Error
199Q#1cState is required.Error
200Q#1aStreet is required.Error
201Q#3bTitle is required.Error
202Q#1dZip Code is required.Error
217Q#2aEIN is required.Error
218Q#2bDUNS number is required.Error

Sub-recipient (Provider) Report Validations

Section 1: General Information
Check #Question #MessageLevel
2 Provider Profile Information: A response is required for Faith-based Organization.Error
3 Provider Profile Information: A response is required for Provider Type.Error
4 Provider Profile Information: A response is required for Section 330 Funding Received.Error
5 Provider Profile Information: A response is required for Type of Ownership.Error
215 Provider Profile Information: A response is required for the real time electronic data network question.Error
6 Service Delivery Sites: At least one service delivery site must be specified if your agency reports that it delivers any Ryan White HIV/AIDS Program funded client service in Q#7.Error
9 Organization Details: Official Mailing Address is required. Address includes the street, city, state, and Zip Code.Error
219 Organization Details: A response is required for EIN.Warning
220 Organization Details: A response is required for DUNS number.Warning
211 Service Delivery Sites: The [Service Delivery Site Name] Service Delivery Site has an incomplete address. Please include the street, city, state and Zip Code.Warning
212 Service Delivery Sites: The [Service Delivery Site Name] Service Delivery Site is missing or has an incomplete phone number. Please correct.Warning
234 

Service Delivery Sites: The [Service Category Name] service uploaded but not associated with at least one Service Delivery Site.

[Service Category Name] services were reported in the client-level data XML file(s) that was uploaded, but this service is not specified as provided at any site in the General Information page. If you delivered [Service Category Name] services as indicated in the uploaded file, please select this service for at least one of the delivery sites.

Alert
237 Service Delivery Sites: The [Service Site Name] Service Delivery Site is missing a website URL.Alert
Section 2: Program Information
Check #Question #MessageLevel
21Q#2A response is required in Q#2, clinical quality management status.Error
22Q#1dE-mail is required.Error
23Q#1aName is required.Error
26Q#1cPhone is required.Error
27Q#3You must acknowledge that the funding sources shown in Q#3 are correct.Error
28Q#1bTitle is required.Error
29Q#7

No Client records were uploaded.

At least one client record must be included in your uploaded file if the provider was funded for any Ryan White HIV/AIDS Program funded client service.

Warning
Section 3: Service Information
Check #Question #MessageLevel
30Q#7You must report that you delivered at least one service during the reporting period.Warning
32Q#7

[Service Category Name] services delivered but not uploaded.

[Service Category Name] services were reported as delivered in Q#7 of the Service Information section of the Provider Report, but your client-level data do NOT include data for this service category. Either you have not uploaded a client-level data file, OR the file you have uploaded DOES NOT include data on this service category.

If you have not uploaded your client-level data, please select the “Import Client-level Data” link in the left menu to upload your XML file. If you have uploaded a file that does not include data on this service category, please check your data. If you did not deliver the service, it should not be selected in Q#7. If you did deliver the service, data on this service category should be present in your client-level data file.

Warning
33Q#7

[Service Category Name] services funded but not delivered.

[Service Category Name] services were reported as funded by a recipient in the RSR Recipient Report, but that service is not specified as delivered in Q#7.

Warning
34Q#7

[Service Category Name] service uploaded but not delivered.

[Service Category Name] services were reported in the client-level data XML file(s) that was uploaded, but this service is not specified as delivered in Q#7 of the Service Information section of the Provider Report. If you delivered [Service Category Name] services as indicated in the uploaded file, please select this service in Q#7.

Alert
238Q#7a

[Service Category Name] services in the Additional Services Delivered section were reported as delivered but not uploaded.

[Service Category Name] services specified as delivered in the Additional Services table in Q#7a but not reported in the client-level data XML file(s) that was uploaded. If this service was not provided using your organization’s own program income and/or pharmaceutical rebates, please de-select this service in Q#7a.

Warning
Section 4: HIV Counseling and Testing Information

Check #

Question #

Validation Message

Level

11Q#12, Q#9The value reported in Q#12 (HIV Positive and referred to HIV medical care) must be greater than or equal to zero, and less than or equal to the value entered in Q#9 (Total Tests).Error
12Q#10, Q#9The value entered in Q#10 (Negative Tests) must be greater than or equal to zero AND must be less than or equal to the value entered in Q#9 (Total Tests).Error
17Q#11, Q#9The value entered in Q#11 (Positive Tests) must be greater than or equal to zero AND must be less than or equal to the value entered in Q#9 (Total Tests).Error
18Q#8A response must be entered for Q#8, HIV Counseling and Testing services were provided during the reporting period.Error
20Q#10, Q#11, Q#9The sum of the values entered in Q#11 (Positive Tests) and Q#10 (Negative Tests) must be less than or equal to the value entered in Q#9 (Total Tests).Error
35Q#8, Q#9If “yes” is reported for Q#8 (HIV Counseling and Testing services were provided during the reporting period), a response must be entered for Q#9, Number of clients tested for HIV (Total Tests).Error
36Q#8, Q#10If “yes” is reported for Q#8 (HIV Counseling and Testing services were provided during the reporting period), a response must be entered for Q#10, Number of clients who tested Negative for HIV (Negative Tests).Error
204Q#8, Q#11If “yes” is reported for Q#8 (HIV Counseling and Testing services were provided during the reporting period), a response must be entered for Q#11, Number of clients tested Positive for HIV (Positive Tests).Error
206Q#8, Q#12If “yes” is reported for Q#8 (HIV Counseling and Testing services were provided during the reporting period), a response must be entered for Q#12, Number of clients tested Positive for HIV and were referred to HIV medical care (HIV Positive and referred to HIV medical care).Error
207Q#11, Q#12The value reported in Q#12 (HIV Positive and referred to HIV medical care) must be greater than or equal to zero, and less than or equal to the value entered in Q#11 (Positive Tests).Error
Section 5: Clients by Zip Code
Check #Validation MessageLevel
213The count of clients receiving eligible services in each ZIP Code must be greater than zero.Warning
214The total number of clients reported in your CLD ([Count of Clients]) differs from the sum of clients reported by ZIP Code ([Count of Clients]).Alert

Client Report Validations

Note: Data Element numbers have been added for convenient referencing between this document and the RSR Instruction Manual.

Demographics
Check #VariableData Element(s)MessageLevel
39Birth Year4[Count of Clients] Clients whose year of birth is after the report year.Error
40Birth Year4 and 47[Count of Clients] Clients whose year of birth is after the year of first HIV Outpatient/Ambulatory Service.Error
41Sex at Birth71[Count of Clients] Clients with an “Incongruent” response for Sex at Birth in multiple client-level data XML files.Alert
42Gender7[Count of Clients] Clients with an “Incongruent” response for Gender in multiple client-level data XML files.Alert
66Status12 and 14[Count of Clients] Clients with HIV/AIDS Status of Indeterminate missing Risk Factor of Perinatal transmission.Warning
235HIV/AIDS Status12 and 14[Count of Clients] Clients identified as HIV/AIDS Negative and HIV Risk Factor reported.Warning
70HIV Diagnosis Year72[Count of Clients] Clients with HIV Diagnosis Year after the reporting period.Warning
72Gender7 and 64[Count of Clients] Male clients or clients with unknown gender with pregnancy status equal to YES.Warning
221Birth Year4[Count of Clients] Clients are missing Birth Year.Error
84Birth Year4[Count of Clients] Clients age 90 years or more.Alert
85Birth Year4 and 72[Count of Clients] Clients whose year of birth is after the year of HIV Diagnosis.Warning
86Birth Year4 and 49[Count of Clients] Clients whose year of birth is after the year of CD4 TestsAlert
88Birth Year4 and 48[Count of Clients] Clients whose year of birth is after the year of Outpatient/Ambulatory Health Service Dates.Alert
89Birth Year4 and 50[Count of Clients] Clients whose year of birth is after Viral Load Test Dates.Alert
96Poverty Level9[Count of Clients] Clients missing Poverty Level.Warning
97Housing Status10[Count of Clients] Clients missing Housing Status.Warning
216Housing Status Collected Date11[Count of Clients] Clients missing Housing Status Collected Date.Warning
99Medical Insurance15[Count of Clients] Clients missing Health coverageWarning
100HIV/AIDS Status12 and 4[Count of Clients] Clients whose HIV/AIDS status is Indeterminate and are over 2 years of age.Warning
232New Client76[Count of Clients] Clients are missing a response to capture if they are new to the service provider.Warning
233Client Received Service Previous Year77[Count of Clients] Clients are missing the response to capture if the client received at least one service in the previous year.Warning
Services
Check #VariableData Element(s)MessageLevel
38Services16 – 45, 75 and 78Clients missing Core Medical, Support or EHE Initiative Services.Warning
170OAHS Service Visits16 and 48[Count of Clients] Clients have more Outpatient/Ambulatory Health Services visits reported than Outpatient/Ambulatory Health Service Visit dates.Alert
184Service visits16 – 45, 75 and 78[Count of Clients] Clients have greater than 365 [Service Category] visits.Alert
Clinical Information
Check #VariableData Element(s)MessageLevel
37OAHS Service Dates48[Count of Clients] Clients with Outpatient/Ambulatory Health Service Dates before the reporting period.Error
44First HIV OAHS Visit Date47[Count of Clients] Clients whose First HIV Outpatient/Ambulatory Health service visit is after the reporting period.Error
45First HIV OAHS Visit Date47[Count of Clients] Clients whose First HIV Outpatient/Ambulatory Health Service Visit is after Outpatient/Ambulatory Health Service Dates.Error
48OAHS Service Dates48[Count of Clients] Clients with Outpatient/Ambulatory Health Service Dates after the Reporting Period.Error
49CD4 Test Dates49[Count of Clients] Clients with CD4 Test Dates after the reporting period.Error
50Viral Load Test Dates50[Count of Clients] Clients with Viral Load Test Dates after the reporting period.Error
67CD4 Test Dates49[Count of Clients] Clients reported with CD4 Test Dates before the reporting period.Error
68Viral Load Test Dates50[Count of Clients] Clients with Viral Load Test Dates before the reporting period.Error
209Viral Load Test Results50, 12, and 16[Count of Clients] Clients have a viral load test that is out of range (over 10,000,000).Warning
210Viral Load Test Results50, 12, and 16[Count of Clients] Clients with a Viral Load Test result who are HIV Negative.Warning
110OAHS Service Dates48 and 12[Count of Clients] HIV negative clients with Outpatient/Ambulatory Health Service Dates.Warning
118First HIV OAHS Visit Date47 and 48[Count of Clients] Clients with a First HIV Outpatient/Ambulatory Health Service Visit Date and no Outpatient/Ambulatory Health Service Visits.Warning
127OAHS Service Dates48, 12, and 16[Count of Clients] Clients have Outpatient/Ambulatory Health Service dates and no Outpatient/Ambulatory Health Service visits.Warning
147OAHS Service Dates48, 12, and 16[Count of Clients] Clients missing Outpatient/Ambulatory Health Service Dates.Warning
151Prescribed ART52, 12, and 16[Count of Clients] Clients missing a response to Prescribed ART.Warning
161

CD4 Count Test

Results

49, 12, and 16[Count of Clients] Clients missing CD4 count test results.Warning
168Viral Load Test Results50, 12, and 16[Count of Clients] Clients missing viral load test resultsWarning
208CD4 Count Test Results49, 12, and 16[Count of Clients] Clients have a CD4 count that is out of range (over 3,000).Warning
222CD4 Count Test Results49, 12, and 16[Count of Clients] Clients have two or more CD4 counts on the same date with a discrepancy in the values.Warning
223Viral Load Test Results50, 12, and 16[Count of Clients] Clients with viral load counts both over and under viral suppression threshold reported on the same test date.Warning
146Viral Load Test Results50 and 16[Count of Clients] Clients with Viral Load Test record, but no Outpatient/Ambulatory Health Service record(s).Warning
239Viral Load Test Results50, 12, and 16[Count of Clients] Clients with last viral load count under the viral suppression threshold (viral load count <200) and a missing value or "no" reported for prescribed ART.Warning
HIV Counseling and Testing
Check #VariableData Element(s)MessageLevel
171HIV Positive Test Date73[Count of Clients] Clients with an HIV Positive Test Date after the reporting period.Warning
172Birth Year4 and 73[Count of Clients] Clients whose year of birth is after their HIV Positive Test Date.Warning
173HIV Positive Test Date73 and 12[Count of Clients] Clients with an HIV Positive Test Date who are HIV NegativeWarning
174Birth Year4 and 74[Count of Clients] Clients whose year of birth is after the Outpatient/Ambulatory Health Service Linkage Date.Warning
175OAHS Linkage Date74[Count of Clients] Clients whose Outpatient/Ambulatory Health Service Linkage Date is after the reporting period.Warning
176OAHS Linkage Date74 and 12[Count of Clients] Clients with an Outpatient/Ambulatory Health Service Linkage Date who are HIV Negative.Warning
177OAHS Linkage Date74 and 73[Count of Clients] Clients Outpatient/Ambulatory Service Linkage Date is before their HIV Positive Test Date.Warning
240OAHS Linkage Date74 and 72[Count of Clients] Newly diagnosed clients with an HIV Diagnosis Year within the reporting period and OAHS Linkage date is not reported or outside the reporting period.Warning
disq logo

We'd like your feedback

Was this page helpful?
I found this page helpful because the content on the page:
Check all that apply
I did not find this page helpful because the content on the page:
Check all that apply
Please include an email address if you would like a response
Please include an email address if you would like a response
Did you use this approach in your work?
Not yet because
If no, why not?