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.