HUD HMIS CSV/XML Program Data Export: FY 2024+ Updates

This article describes the revisions to CSV files associated with the 2024 HMIS Data Standards updates.

All CSV column headers are now case-sensitive.

Specification Changes

For more detailed information, please refer to the FY2024 HMIS CSV Format Specifications

Organization.csv
- Removed “Type” value ‘50’ from list ‘2.01.2’
- Updated list ‘2.01.3’ from ‘1.7’ to ‘1.10’

Project.csv
- Updated list ‘2.02.5’ from ‘1.7’ to ‘1.10’
- Replaced ‘2.02.A’ with RRHSubType
- Updated former ‘2.02.A’ to ‘2.02.B’, updated list to ‘1.10’
- Removed ‘2.02.C’ “TrackingMethod”
- Updated ‘2.02.8’ to ‘2.02.7’ to “TargetPopulation” and list to ‘2.02.7’ (TargetPopulation is now also non-nullable)
- Updated ‘2.02.9’ to ‘2.02.8’ to “HOPWAMEdAssistedLivingFac”

Inventory.csv
- Updated logic to accommodate new project code ‘15’ and ‘RRHSubType’ value
- Updated ‘ProjectID’ and ‘ResProjectID’ to include project type ‘13’ and ‘RRHSubType’ value

Added HMISParticpation.csv
- Added ‘2.08.1’
- Added ‘2.08.2’
- Added ‘2.08.3’

Added CEParticpation.csv
- Added ‘2.09.1’
- Added ‘2.09.A’
- Added ‘2.09.2’
- Added ‘2.09.3’
- Added ‘2.09.4’

Client.csv
- Updated ‘3.04 Race and Ethnicity’
- Removed ‘3.05 Ethnicity’ (Replaced by 3.04)
- Updated ‘3.04.1’
  - Added ‘HispanicLatinaeo’
  - Added ‘MidEastNAfrican’
- Removed ‘3.05.1 Ethnicity’ (Replaced by 3.04)
- Updated ‘3.06.1’
  - Added ‘DifferentIdentity’
  - Added ‘CulturallySpecific’
  - Updated ‘Female’ to ‘Woman’
  - Updated ‘Male’ to ‘Man’

Enrollment.csv
- Removed ‘U1 Worst Housing Situation’
- Removed ‘V5 Last Permanent Address’
- Added ‘3.16 EnrollmentCoC’
- Added ‘3.917.A RentalSubsidyType’
- Removed ‘U1.1 WorstHousingSituation’
- Added ‘C4 TranslationNeeded’
- Added ‘C4.A PreferredLanguage’
- Added ‘C4.B PreferredLanguageDifferent”

Removed EnrollmentCoC.csv
Exit.csv
- Added ‘3.12.A DestinationSubsidyType’
IncomeBenefits.csv
- Updated ‘4.04.6 VHAServices’
- Updated ‘4.04.6A NoVHAReason
- Removed ‘W3.2 HIVAIDSAssistance’
- Removed ‘W3.A NoHIVAIDSAsisstanceReason’

HealthAndDV.csv
- Removed ‘C1 Well-being'
- Removed ‘C1.2 LifeValue’
- Removed ‘C1.3 SupportFromOthers’
- Removed ‘C1.4 BounceBack’
- Removed ‘C1.5 FeelingFrequency’

Services.csv
- Updated logic for ‘ProjectType = 15 (“Emergency Shelter – Night-by-Night”)
- Removed ‘V3’
- Added ‘V3.1’
- Added ‘V3.2’
- Added ‘V3.4’
AssessmentResults.CSV
- AssessmentResultsID was updated to client_assessment_scores.id_NNN_AssessmentResultTypewhere NNN reflects order number to account for assessments that are linked to more than one enrollment.

Appendix A — List of Data Elements and Associated CSV Files
- Added ‘2.08 HMIS Participation’
- Added ‘2.09 CE Particpation’
- Updated ‘3.04 Race and Ethnicity’
- Removed ‘3.05 Ethnicity’
- Updated ‘3.16 Enrollment CoC’
- Updated ‘4.10 Substance Use’
- Removed ‘C1 Well-being'
- Added ‘C4 Translation Assistance Needed’
- Removed ‘U1 Worst Housing Situation’

Appendix B — Lists
- 1.4 RecordType
  - Updated ‘300 Moving On assistance provided’
- 1.6 RaceGenderNone
  - Updated ‘9 Client prefers not to answer’
- 1.8 No/Yes/Reasons for Missing Data
  - Updated ‘9 Client prefers not to answer’
- Updated 1.9 SourceType to new values:
  - Added ‘1 CoC HMIS’
  - Added ‘2 Standalone/agency-specific application’
  - Added ‘3 Data warehouse’
  - Added ‘4 Other’
- Added 1.10 No/Yes
  - Added ‘0 No’
  - Added '1 Yes’
- Updated 2.02.6 ProjectType
  - Updated value ‘0 Emergency Shelter – Entry Exit’
  - Added ‘1 Emergency Shelter – Night-by-Night'
- Added 2.02.A RRHSubType
  - Added ‘1 RRH: Services Only’
  - Added ‘RRH: Housing with or without services’
- Removed 2.02.C TrackingMethod
- Updated 2.06.1 FundingSource
  - Removed ‘12 HUD: Rural Housing Stability Assistance Program’
  - Removed ‘49 HUD CoC – Joint Component RRH/PSH’
  - Added ‘53 HUD: ESG – RUSH
  - Added ’54 HUD: Unsheltered Special NOFO’
  - Added ’55 HUD: Rural Special NOFO’
- Updated 2.02.7 TargetPopulation
  - Updated ‘1 DV: Survivor of Domestic Violence
- Added 2.08.1 HMISParticipationType
  - Added ‘0 Not Participating’
  - Added ‘1 HMIS Participating’
  - Added ‘2 Comparable Database Participating’
- Updated 3.01.5 NameDataQuality
  - Updated ‘9 Client prefers not to answer’
- Updated 3.02.2 SSNDataQuality
  - Updated ‘9 Client prefers not to answer’
- Updated 3.03.2 DOBDataQuality
  - Updated ‘9 Client prefers not to answer’
- Removed 3.05.1 Ethnicity

Updated 3.12.1 Living Situation Option List
- Organization and numbering updated throughout; established categories:
  - Homeless Situations (100-199)
  - Institutional Situations (200-299)
  - Permanent Housing Situations (400-499)
  - Other (1-99)
Added 3.12.A RentalSubsidyTypes
- Added ‘428 GPD TIP housing subsidy’
- Added ‘419 VASH housing subsidy’
- Added ‘431 RRH or equivalent subsidy’
- Added ‘433 HCV voucher (tenant or project based) (not dedicated)
- Added ‘434 Public housing unit
- Added ‘420 Rental by client, with other ongoing housing subsidy’
- Added ‘436 Emergency Housing Voucher’
- Added ‘437 Family Unification Program Voucher (FUP)
- Added ‘438 Foster Youth to Independence Initiative (FYI)
- Added ‘439 Permanent Supportive Housing’
- Added ‘440 Other permanent housing dedicated for formerly homeless persons’
Updated 3.917.2 LengthOfStay
- Updated ‘9 Client prefers not to answer’
Updated 3.917.4 TimesHomelessPastThreeYears
- Updated ‘9 Client prefers not to answer’
Updated 3.917.5 MonthsHomelessPastThreeYears
- Updated ‘9 Client prefers not to answer’
Updated 4.04.A ReasonNotInsured
- Updated ‘9 Client prefers not to answer’
Updated 4.10.2 DisabilityResponse
- Updated ‘9 Client prefers not to answer’
Updated 4.11.A WhenDVOcurred
- Updated ‘9 Client prefers not to answer’
Updated R1.1 ReferralSource
- Updated ‘9 Client prefers not to answer’
Updated R3.1 SexualOrientation
- Updated ‘9 Client prefers not to answer’
Updated R4.1 LastGradeCompleted
- Updated ‘9 Client prefers not to answer’
Updated R5.1 SchoolStatus
- Updated ‘9 Client prefers not to answer’
Updated R7.1 HealthStatus
- Updated ‘9 Client prefers not to answer’
Updated R14.2 RHYServices
- Updated ‘12 Post-natal care for client (person who gave birth)’

Updated R15.B CountExchangeForSex
- Updated ‘9 Client prefers not to answer’
Updated R17.1 ProjectCompletionStatus
- Updated ‘2 Client voluntarily left early’
- Updated ‘3 Client was expelled or otherwise involuntarily discharged from project’
Updated R20.2 AftercareProvided
- Updated ‘9 Client prefers not to answer’
Update V1.11 MilitaryBranch
- Updated ‘9 Client prefers not to answer’
- Added ‘7 Space Force’
Updated V1.12 DischargeStatus
- Updated ‘9 Client prefers not to answer’
Updated V2.2 SSVFServices
- Updated ‘7 Shallow Subsidy’
Updated V3.3 SSVFFinancialAssistance
- Updated ‘15 Shallow Subsidy –Financial Assistance’
- Added ‘17 Landlord Incentive’
- Added ‘18 Tenant Incentive’
Updated V4.1 PercentAMI
- Updated ‘1 30% or less’
- Updated ‘2 31% to 50%’
- Updated ‘3 51% to 80%’
- Added ‘4 81% or greater
Removed V5.5 AddressDataQuality
Updated W1.2 HOPWAServices
- Updated ‘12 Substance use services/treatment’
Updated W3 NoAssistanceReason
- Updated ‘9 Client prefers not to answer’
Updated W4.3 ViralLoadAvailable
- Updated ‘9 Client prefers not to answer’
Updated W5.1 HousingAssessmentAtExit
- Updated ‘7 Jail/prison’
- Updated ‘9 Client prefers not to answer’
- Updated ‘10 Deceased’
Removed C1.1 WellbeingAgreement
Removed C1.2 FeelingFrequency
Updated C3.2 CurrentSchoolAttend
- Updated ‘9 Client prefers not to answer’
Updated C3.A MostRecentEdStatus
- Updated ‘9 Client prefers not to answer’
Updated C3.B CurrentEdStatus
- Updated ‘9 Client prefers not to answer’

CSV Files with No Changes

The following CSV files had no changes with the FY2024 release:

Export.CSV
User.CSV
Funder.CSV (Only picklist changes)
ProjectCoC.CSV
Affiliation.CSV
Exit.CSV (Only picklist changes)
IncomeBenefits.CSV
EmploymentEducation.CSV
Disabilities.CSV
CurrentLivingSituation.CSV
Assessment.CSV
AssessmentQuestions.CSV
Event.CSV
YouthEducationStatus.CSV

Updated: 03/12/2024