How Can We Help?
How do I interpret “Data Issues” and “% Error Rate” in Q6A of the APR?
The 2017 APR has expanded the sections that report on data quality.
Question 6a includes a column for data issues for several elements – Name, SSN and Date of Birth. These relate to the data quality questions in HMIS and rules that are applied to ensure that the data is valid.
1. Name: The rules for Name (Column D Row 1) is the count of clients where data entered in HMIS is recorded as an 8, client doesn’t know; or 9, client refused:
2. SSN: The rules for SSN (Column D Row 3) is the count of clients where SSN Data Quality = 2, approximate or partial SSN reported
OR if the SSN does not conform to Social Security Administration rules for a valid SSN shown below.
- Cannot contain a non-numeric character.
- Must be 9 digits long.
- First three digits cannot be “000,” “666,” or in the 900 series.
- The second group / 5th and 6th digits cannot be “00”.
- The third group / last four digits cannot be “0000”.
- There cannot be repetitive (e.g. “333333333”) or sequential (e.g. “345678901” “987654321”)
- numbers for all 9 digits.
3. Date of Birth: The rules for Date of Birth (Column D Row 3) is the count of clients where data entered in HMIS is recorded as an 8, client doesn’t know; or 9, client refused:
Error Rate: The Error Rate column indicates the percentage of records that either have a data issue, are missing data, or for which the client refused or did not know the response.