APR Unit Testing FY2020 - servinglynk/hslynk-open-source-docs GitHub Wiki

Q5 Report Validations

Validations
Total number of persons served >= Number of adults (age 18 or over)
Total number of persons served >= Number of children (under age 18)
Total number of persons served >= Number of persons with unknown age
Total number of persons served >= Number of leavers
Total number of persons served >= Number of adult leavers
Total number of persons served >= Number of adult and head of household leavers
Total number of persons served >= Number of stayers
Total number of persons served >= Number of adult stayers
Total number of persons served >= Number of veterans
Total number of persons served >= Number of chronically homeless persons
Total number of persons served >= Number of youth under age 25
Total number of persons served >= Number of parenting youth under age 25 with children
Total number of persons served >= Number of adults heads of household
Total number of persons served >= Number of child and unknown-age heads of household
Total number of persons served >= Heads of households and adult stayers in the project 365 days or more
Number of adults (age 18 or over) + Number of children (under age 18) + Number of persons with unknown age = Total number of persons served
Number of youth under age 25 >= Number of parenting youth under age 25 with children

Q6 Data Quality

Validations
Name (3.01) Client DKR + Name (3.01) Information Missing + Name (3.01) Data Issues = Name (3.01) Total
SSN (3.02) Client DKR + SSN (3.02) Information Missing + SSN (3.02) Data Issues = SSN (3.02) Total
Date of Birth (3.03) Client DKR + Date of Birth (3.03) Information Missing + Date of Birth (3.03) Data Issues = Date of Birth (3.03) Total
Race (3.04) Client DKR + Race (3.04) Information Missing = Race (3.04) Total
Ethnicity (3.05) Client DKR + Ethnicity (3.05) Information Missing = Ethnicity (3.05) Total
Gender (3.06) Client DKR + Gender (3.06) Information Missing = Gender (3.06) Total
(Name (3.01) Client DKR + Name (3.01) Information Missing + Name (3.01) Data Issues) / Total number of persons served = Name (3.01) Error Rate
(SSN (3.02) Client DKR + SSN (3.02) Information Missing+SSN (3.02) Data Issues) / Total number of persons served = SSN (3.02) Error Rate
(Date of Birth (3.03) Client DKR + Date of Birth (3.03) Information Missing+Date of Birth (3.03) Data Issues) / Total number of persons served = Date of Birth (3.03) Error Rate
(Race (3.04) Client DKR + Race (3.04) Information Missing) / Total number of persons served = Race (3.04) Error Rate
(Ethnicity (3.05) Client DKR + Ethnicity (3.05) Information Missing) / Total number of persons served = Ethnicity (3.05) Error Rate
(Gender (3.06) Client DKR + Gender (3.06) Information Missing) / Total number of persons served = Gender (3.06) Error Rate
Veteran Status (3.07) Error Count / Total number of persons served = Veteran Status (3.07) Error Rate
Project Start Date (3.10) Error Count / Total number of persons served = Project Start Date (3.10) Error Rate
Relationship to Head of Household (3.15) Error Count / Total number of persons served = Relationship to Head of Household (3.15) Error Rate
Client Location (3.16) Error Count / Total number of persons served = Client Location (3.16) Error Rate
Disabling Condition (3.08) Error Count / Total number of persons served = Disabling Condition (3.08) Error Rate
Destination (3.12) Error Count / Total number of persons served = Destination (3.12) Error Rate
Income and Sources (4.02) at Start Error Count / Total number of persons served = Income and Sources (4.02) at Start Error Rate
Income and Sources (4.02) at Annual Assessment Error Count / Total number of persons served = Income and Sources (4.02) at Annual Assessment Error Rate
Income and Sources (4.02) at Exit Error Count / Total number of persons served = Income and Sources (4.02) at Exit Error Rate
(ES, SH, OUT Approx Date (3.917.3) DKR/Missing + ES, SH, OUT Number of Times (3.917.4) DKR/Missing + ES, SH, OUT Number of Months (3.917.5) DKR/Missing) / ES, SH, OUT Total Records = ES, SH, OUT % Records Unable to Calculate
(TH Missing Time in Institution (3.917.2) + TH missing time in housing (3.917.2) DKR/Missing + TH Approx Date (3.917.3) DKR/Missing + TH Number of Times (3.917.4) DKR/Missing + TH Number of Months (3.917.5) DKR/Missing) / TH Total Records = TH % Records Unable to Calculate
(PH Missing Time in Institution (3.917.2) + PH missing time in housing (3.917.2) DKR/Missing + PH Approx Date (3.917.3) DKR/Missing + PH Number of Times (3.917.4) DKR/Missing + PH Number of Months (3.917.5) DKR/Missing) / PH Total Records = PH % Records Unable to Calculate
ES, SH, OUT Total Records + TH Total Records + PH Total Records = Total Records
0 days Project Exit + 1-3 days Project Exit + 4-6 days Project Exit + 7-10 days Project Exit + 11+ days Project Exit = Number of adult leavers
Contact (Adults & HoH in OUT or ES-NBN) Inactive Records / Contact (Adults & HoH in OUT or ES-NBN) Total Records = Contact (Adults & HoH in OUT or ES-NBN) % Inactive
Bed Night (All clients in ES-NBN) Inactive Records / Bed Night (All clients in ES-NBN) Total Records = Bed Night (All clients in ES-NBN) % Inactive

Q7 Persons Served

Validations
Total number of persons served = Total
Adults Total + Children Total + Client DKR Total + Data not Collected Total = Total
Total >= PSH & RRH: Total Served Who Moved Into Housing
January Individuals in HHs Without Children + January Individuals in HHs With Children and Adults + January Individuals in HHs With Only Children + January Individuals in HHs of Unknown Type = January Total
April Individuals in HHs Without Children + April Individuals in HHs With Children and Adults + April Individuals in HHs With Only Children + April Individuals in HHs of Unknown Type = April Total
July Individuals in HHs Without Children + July Individuals in HHs With Children and Adults + July Individuals in HHs With Only Children + July Individuals in HHs of Unknown Type = July Total
October Individuals in HHs Without Children + October Individuals in HHs With Children and Adults + October Individuals in HHs With Only Children + October Individuals in HHs of Unknown Type = October Total

Q8 Households Served

Validations
Total Households = Number of adults heads of household + Number of child and unknown-age heads of household
Households Without Children + Households with Children and Adults + Households with Only Children + Households of Unknown Type = Total Households
PSH & RRH: Households Without Children Who Moved Into Housing + PSH & RRH: Households With Children and Adults Who Moved Into Housing + PSH & RRH: Households With Only Children Who Moved Into Housing + PSH & RRH: Households of Unknown Type Who Moved Into Housing = PSH & RRH: Households Who Moved Into Housing
January HHs Without Children + January HHs With Children and Adults + January HHs With Only Children + January HHs of Unknown Type = January Total
April HHs Without Children + April HHs With Children and Adults + April HHs With Only Children + April HHs of Unknown Type = April Total
July HHs Without Children + July HHs With Children and Adults + July HHs With Only Children + July HHs of Unknown Type = July Total
October HHs Without Children + October HHs With Children and Adults + October HHs With Only Children + October HHs of Unknown Type = October Total

Q9 Persons Contacted/Engaged

Validations
All Persons Contacted & Engaged / All Persons Contacted = All Persons Contacted Rate of Engagement
First Contact NOT Literally Homeless & Engaged / First Contact NOT Literally Homeless = First Contact NOT Literally Homeless Rate of Engagement
First Contact Literally Homeless & Engaged / First Contact Literally Homeless = First Contact Literally Homeless Rate of Engagement
First Contact Unknown & Engaged / First Contact Unknown = First Contact Unknown Rate of Engagement

Q10 Gender

Q11 Age

Q12 Race/Ethnicity

Q13 Disabilities

Q14 Domestic Violence

Q15 Living Situation

Q16 Income Ranges

Q17 Income Sources

Q18 Income Categories

Q19 Income Change

Q20 Non-Cash Benefits

Q21 Health Insurance

Q22 Length of Stay

Q23 Destinations

Q24 Prevention Housing Assessment at Exit

Q25 Veterans

Q26 Chronic

Q27 Youth

⚠️ **GitHub.com Fallback** ⚠️