You are here:
  • KB Home
  • Reporting
  • How do I interpret "Data Issues" and "% Error Rate" in Q6A of the APR?
< Back

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.