ABCDEFGHIJKLMNOPQRSTUVWXY
1
Row #FieldChecked ForIssuesFile Used to Find ClientsReport Used to Find ClientsCommentsValues used to filter in the CSVData Entry Collection Stage
2
1Social Security Number (SSN): All clientsClient.csv (value = 8-DK/9-Ref/99-DNC/blank)Client Data Quality Report/SubNot on SSVF Sub8 = Client doesn't know1 = Entry
3
2Veteran SSN: VeteransClient.csv (value = 8-DK/9-Ref/99-DNC/blank, Veteran Status = 1 - Yes)Client Data Quality Report/SubNot on SSVF Sub9 = Ref (Client refused)2 = Annual
4
3Date of Birth: AllClient.csv (value = 8-DK/9-Ref/99-DNC/blank)Not on SSVF Sub99 = DNC (DataNot Collected)3 = Exit
5
4Gender: AllClient.csv (value = 8-DK/9-Ref/99-DNC/blank)Not on SSVF Sub0 = No
6
5Race: AllClient.csv (value = 8-DK/9-Ref/99-DNC/blank)Client Data Quality Report/SubNot on SSVF Sub1 = Yes
7
6Ethnicity: AllClient.csv (value = 8-DK/9-Ref/99-DNC/blank)SSVF SUB - SSVF Percent of AMINot on SSVF Sub
8
7Client Location - CoC Code: HOH at EntryEnrollment CoC.CSV (Relation to HoH = 1, CoCCode = BLANK, Data Collection Stage value = 1 (Entry))Not on SSVF Sub
9
8Income as Percent of AMI: HOH at EntryEnrollment.csv (Relation to HoH = 1, PercentAMI = 99/blank)SSVF SUB - SSVF Percent of AMI
10
9HP Targeting Criteria (V7): HP HOH at EntryEnrollment.csv (Project ID = HP Projects only, Relation to HoH = 1, HPScreeningScore = BLANK)Not on SSVF Sub
11
10VAMC Station Code: HOH at EntryEnrollment.csv (Relation to HoH = 1, VAMCStation = blank)Coc Apr - Client Detail Sub ReportNot on SSVF Sub
12
11Veteran Status: AdultsClient.csv (value = 8-DK/9-Ref/99-DNC/blank, Veteran Status = 1 - Yes, DOB filter must exclude dates that would make the client child)On SSVF Sub
13
12Last Grade Completed: HoH/Adults at EntryEmploymentEducation.csv (Relation to HoH = 1, LastGradeCompleted = 8-DK/9-Ref/99-DNC/blank, DOB filter must exclude dates that would make the client child)Client Data Quality Report/Sub & Coc Apr - Client Detail Sub ReportNot on SSVF Sub
14
13Living Situation: HoH/Adults at EntryEnrollment CoC.CSV (Relation to HoH = 1, LivingSituation = 8/9/99/blank, Data Collection Stage value = 1 (Entry)Coc Apr - Client Detail Sub ReportNot on SSVF Sub
15
14Homeless HP
: HP HoH/Adults at Entry
Enrollment CoC.CSV (Relation to HoH = 1, LivingSituation = Not a Homeless Setting (and it should be), Data Collection Stage value = 1 (Entry)Coc Apr - Client Detail Sub ReportNot on SSVF Sub
16
15Housed RRH
: RRH HoH/Adults at Entry
Enrollment CoC.CSV (Relation to HoH = 1, LivingSituation = Not a Homeless Setting (and it should be), Data Collection Stage value = 1 (Entry)Coc Apr - Client Detail Sub ReportNot on SSVF Sub
17
16Disabling Condition: All at EntryEnrollment CoC.CSV (Data Collection Stage value = 1 (Entry), DisablingCondition = 8/9/99 or blank)Coc Apr - Client Detail Sub ReportNot on SSVF Sub
18
17Homeless Date Missing
: RRH HoH/Adults at Entry
Not on SSVF Sub
19
18Months Homeless Missing
: RRH HoH/Adults at Entry
Exit.csvClient Data Quality Report/Sub & Coc Apr - Client Detail Sub ReportNot on SSVF Sub
20
19Times Homeless Missing
: RRH HoH/Adults at Entry
Enrollment.CSV (Relation to HoH = 1, LivingSituation = 1/16/18/27, Times Homeless Missing = Blank, Project ID = 907/908/909/910/1453)Enrollment.csvNot on SSVF Sub
21
20SOAR Entry: HoH/Adults at EntryIncomeBenefits.csv - Data Collection Stage value = 1 (Entry)Coc Apr - Client Detail Sub ReportNot on SSVF Sub
22
21Missing Income at Entry: HoH/Adults at EntryIncomeBenefits.csv - Data Collection Stage value = 1 (Entry), IncomeFromAnySource (value = 8-DK/9-Ref/99-DNC/blank)Coc Apr - Client Detail Sub Report
23
22
Missing Income Amount at Entry
: HoH/Adults at EntryIncomeBenefits.csv - Data Collection Stage value = 1 (Entry), TotalMonthyIncome value = 8-DK/9-Ref/99-DNC/blank)Coc Apr - Client Detail Sub Report
24
23
Incorrect Income Amount at Entry
: HoH/Adults at EntryIncomeBenefits.csv - Data Collection Stage value = 1 (Entry), TotalMonthyIncome value = blank)
25
24Missing Benefits at Entry: HoH/Adults at EntryIncomeBenefits.csv - Data Collection Stage value = 1 (Entry), BenefitsFromAnySource value = 8-DK/9-Ref/99-DNC/blank)
26
25
Missing Health Insurance at Entry
: All at EntryIncomeBenefits.csv - Data Collection Stage value = 1 (Entry), InsuranceFromAnySource value = 8-DK/9-Ref/99-DNC/blank)
27
26Very High Income at Entry: HoH/Adults at EntryIncomeBenefits.csv - Data Collection Stage value = 1 (Entry)
28
27Missing Destination: All at ExitExit.csv - Destination value = 8-DK/9-Ref/99-DNC/blank
29
28Missing Move In Date: RRH HOH Exited to PHExit.csv & Enrollment.csv using the same filters in the next column but you'd have to combine the two spreadsheets to figure it outCoc Apr - Client Detail Sub Report - apply the following filters: Relation to HoH = Self/Program Name = RRH Projects Only/Destinations = PH destinations only/Move In Date = Blank/Move In Info = Leaver, no move in date
30
29SOAR Exit: HoH/Adults at ExitIncomeBenefits.csv - Data Collection Stage value = 3 (Exit), ConnectionWithSOAR value = 8-DK/9-Ref/99-DNC/blank)
31
30Missing Income at Exit: HoH/Adults at ExitIncomeBenefits.csv - Data Collection Stage value = 3 (Exit), IncomeFromAnySource value = 8-DK/9-Ref/99-DNC/blank, RelationToHoH = 1DOB filter must exclude dates that would make the client child))
32
31Missing Income Amount at Exit: HoH/Adults at ExitIncomeBenefits.csv - Data Collection Stage value = 3 (Exit), TotalMonthlyIncome value = 8-DK/9-Ref/99-DNC/blank, RelationToHoH = 1DOB filter must exclude dates that would make the client child))
33
32
Incorrect Income Amount at Exit
: HoH/Adults at ExitIncomeBenefits.csv - Data Collection Stage value = 3 (Exit), TotalMonthlyIncome value = 8-DK/9-Ref/99-DNC/blank, RelationToHoH = 1DOB filter must exclude dates that would make the client child))
34
33Missing Benefits at Exit: HoH/Adults at ExitIncomeBenefits.csv - Data Collection Stage value = 3 (Exit), BenefitsFromAnySource value = 8-DK/9-Ref/99-DNC/blank, RelationToHoH = 1DOB filter must exclude dates that would make the client child))
35
34
Missing Health Insurance at Exit
: All at ExitIncomeBenefits.csv - Data Collection Stage value = 3 (Exit), InsuranceFromAnySource value = 8-DK/9-Ref/99-DNC/blank, RelationToHoH = 1DOB filter must exclude dates that would make the client child))
36
35Very High Income at Exit: HoH/Adults at ExitIncomeBenefits.csv - Data Collection Stage value = 3 (Exit), TotalMonthlyIncome value = very high, RelationToHoH = 1DOB filter must exclude dates that would make the client child))
37
36OEF: VeteransClient.csv AfghanistanOEF = value = 8-DK/9-Ref/99-DNC/blank
38
37OIF: VeteransClient.csv IraqOIF = value = 8-DK/9-Ref/99-DNC/blank
39
38OND: VeteransClient.csv IraqOND = value = 8-DK/9-Ref/99-DNC/blank
40
39Military Branch: VeteransClient.csv MilitaryBranch = value = 8-DK/9-Ref/99-DNC/blank
41
40Discharge Status: VeteransClient.csv VeteranStatus value = 1, DischargeStatus = value = 8-DK/9-Ref/99-DNC/blank
42
41No Vet in HH: HouseholdsEnrollment.csv or SSVF Sub
43
42No Head of Household: HouseholdsEnrollment.csv or SSVF SubEnrollment CoC.CSV (Relation to HoH = 1 - Self, Data Collection Stage value = 1 (Entry))
44
43Multiple Heads of Household: HouseholdsEnrollment.csvEnrollment CoC.CSV (Relation to HoH = 1 - Self, Data Collection Stage value = 1 (Entry)) - check for duplicate household id's after filtering out the non HoH's
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100