1 - Introduction

• 1.1 Background
• 1.2 About This Document
• 1.3 Definitions/Acronyms
• 1.4 Changes Effective 11/1/2025

2 - HDX 2.0 Upload

• 2.1 Project.csv
• 2.2 Organization.csv
• 2.3 Funder.csv
• 2.4 ProjectCoC.csv
• 2.5 Inventory.csv
• 2.6 HMISParticipation.csv
• 2.7 Affiliation.csv
• 2.8 LSAReport.csv
• 2.9 LSAPerson.csv
• 2.10 LSAHousehold.csv

3 - Core Concepts and Data Universe

• 3.1 Report Parameters and Metadata (lsa_Report)
  • ReportID
  • ReportStart
  • ReportEnd
  • ReportCoC
  • LSAScope
  • User-Selected Projects (for Project-Focused LSA)
  • SoftwareVendor and SoftwareName
  • VendorContact and VendorEmail

• 3.2 LSA Reporting Cohorts and Dates (tlsa_CohortDates)

• 3.3 HMIS Household Enrollments (tlsa_HHID)
  • HMIS Data Requirements and Assumptions
  • HMISStart and HMISEnd
  • BedNightDates, FirstBedNight and LastBedNight
  • Record Selection
  • EntryDate
  • MoveInDate
  • ExitDate
  • ExitDest
• 3.4 HMIS Client Enrollments (tlsa_Enrollment)
  • Record Selection
  • EntryDate
  • MoveInDate
  • Last Bed Night for Night-by-Night Shelter Enrollments
  • ExitDate
  • DisabilityStatus
  • DVStatus
• 3.5 Enrollment Ages (tlsa_Enrollment)
  • EntryAge
  • ActiveAge
  • Exit1Age/Exit2Age
• 3.6 Household Types (tlsa_HHID)
  • EntryHHType
  • ActiveHHType
  • Exit1HHType/Exit2HHType

4 - HMIS Business Logic: Project Descriptor Data for Export

• 4.1 Get Project.csv Records / lsa_Project
• 4.2 Get Organization.csv Records / lsa_Organization
• 4.3 Get Funder.csv Records / lsa_Funder
• 4.4 Get ProjectCoC.csv Records / lsa_ProjectCoC
• 4.5 Get Inventory.csv Records / lsa_Inventory
• 4.6 Get HMISParticipation.csv Records / lsa_HMISParticipation
• 4.7 Get Affiliation.csv Records / lsa_Affiliation

5 - HMIS Business Logic - LSAPerson

• 5.1 Identify Active and Active in Residence (AIR) HouseholdIDs 5 - HMIS Business Logic - LSAPerson

• 5.1 Identify Active and Active in Residence (AIR) HouseholdIDs
  • Active
  • AIR
• 5.2 Identify Active and Active in Residence (AIR) Enrollments
  • Active
  • AIR

• 5.3 Get Active Clients for LSAPerson

• 5.4 LSAPerson Demographics
  • HoHAdult
  • RaceEthnicity
  • VetStatus
  • HIV
  • SMI
  • SUD
  • DisabilityStatus
  • DVStatus

• 5.5 Time Spent in ES/SH or on the Street – LSAPerson

• 5.6 Enrollments Relevant to Counting ES/SH/Street Dates

• 5.7 Get Dates to Exclude from Counts of ES/SH/Street Days (ch_Exclude)

• 5.8 Get Dates to Include in Counts of ES/SH/Street Days (ch_Include)
  • Enrollment in Entry/Exit ES or SH
  • Bed Nights in Night-by-Night ES
  • ES/SH/Street Dates from 3.917 Living Situation
  • Gaps of Less than Seven Days Between Two ES/SH/Street Dates

• 5.9 Get ES/SH/Street Episodes (ch_Episodes)

• 5.10 CHTime and CHTimeStatus – LSAPerson

• 5.11 EST/RRH/PSH/RRHSOAgeMin and EST/RRH/PSH/RRHSOAgeMax – LSAPerson

• 5.12 Set Population Identifiers for Active HMIS Households
  • HHChronic
  • HHVet
  • HHDisability
  • HHFleeingDV
  • HHAdultAge
  • HHParent
  • AC3Plus

• 5.13 Project Group and Population Household Types - LSAPerson

• 5.14 Adult Age Population Identifiers - LSAPerson

• 5.15 LSAPerson

• 6.1 Get Distinct Households for LSAHousehold

• 6.2 Set Population Identifiers for LSAHousehold
  • HHAdult
  • HHChild
  • HoHRaceEthnicity
  • HHVet, HHDisability, and HHParent
  • HHFleeingDV
  • HHChronic
  • HHAdultAge

• 6.3 EST/RRH/PSH/RRHSOStatus – LSAHousehold

• 6.4 RRH/PSH/RRHSOMoveIn – LSAHousehold

• 6.5 EST/RRH/PSHGeography – LSAHousehold

• 6.6 EST/RRH/PSHLivingSit – LSAHousehold

• 6.7 EST/RRH/PSHDestination – LSAHousehold

• 6.8 EST/RRH/PSH Population Identifiers
  • EST/RRH/PSHAC3Plus
  • EST/RRH/PSHVet
  • EST/RRH/PSHChronic
  • EST/RRH/PSHDisability
  • EST/RRH/PSHFleeingDV
  • EST/RRH/PSHParent
  • EST/RRH/PSHAdultAge
• 6.9 System Engagement Status and Return Time
  • FirstEntry
  • Previous Activity / StatEnrollmentID
  • ReturnTime
  • Stat

• 6.10 RRHPreMoveInDays – LSAHousehold

• 6.11 Dates Housed in PSH or RRH (sys_Time)
  • Dates Housed in PSH
  • Dates Housed in RRH

• 6.12 Get Last Inactive Date (sys_TimePadded)

• 6.13 Get Dates of Other System Use (sys_Time)

• 6.14 Get Other Dates Homeless from 3.917A/B Living Situation

• 6.15 Set System Use Days for LSAHousehold
  • ESDays
  • THDays
  • ESTDays
  • RRHPSHPreMoveInDays
  • SystemHomelessDays
  • RRHHousedDays
  • SystemDaysNotPSHHoused
  • PSHHousedDays
  • Other3917Days

• 6.16 Update EST/RRH/PSH/RRHSOStatus

• 6.17 Set EST/RRH/PSHAIR

• 6.18 Set SystemPath for LSAHousehold

• 6.19 LSAHousehold

• 7.1 Identify Qualifying Exits in Exit Cohort Periods
  • Qualifying Exits
• 7.2 Select Reportable Exits
  • Exit Households
  • QualifyingExitHHID
  • ExitFrom
• 7.3 Set ReturnTime for Exit Cohort Households
  • Household Returns
  • ReturnTime
• 7.4 Identify HoH and Adult Members of Exit Cohorts
  • Record Selection
  • DisabilityStatus
  • LastActive
  • CHStart
  • CHTime and CHTimeStatus

• 7.5 Get Dates to Exclude from Counts of ES/SH/Street Days (ch_Exclude_exit)

• 7.6 Get Dates to Include in Counts of ES/SH/Street Days (ch_Include_exit)
  • Enrollment in Entry/Exit ES or SH
  • Bed Nights in Night-by-Night ES
  • ES/SH/Street Dates from 3.917 Living Situation
  • Gaps of Less than Seven Days Between Two ES/SH/Street Dates

• 7.7 Get ES/SH/Street Episodes (ch_Episodes_exit)

• 7.8 CHTime and CHTimeStatus for Exit Cohorts

• 7.9 Set Population Identifiers for Exit Cohort Households
  • HHVet
  • HHChronic
  • HHDisability
  • HHFleeingDV
  • HoHRaceEthnicity
  • HHAdultAge
  • HHParent
  • AC3Plus
• 7.10 Set System Engagement Status for Exit Cohort Households
  • Previous Activity
  • Stat

• 7.11 Last Inactive Date for Exit Cohorts

• 7.12 Set SystemPath for LSAExit

• 7.13 LSAExit

• 8.1 LSACalculated Columns

• 8.2 Report Rows for LSACalculated Averages

• 8.3 Populations for Average Days from LSAHousehold and LSAExit

• 8.4 Get Average Days for Length of Time Homeless

• 8.5 Get Average Days for Length of Time Homeless by System Path

• 8.6 Get Average Days for Cumulative Length of Time Housed in PSH

• 8.7 Get Average Days for Length of Time in RRH Projects

• 8.8 Get Average Days to Return/Re-engage by Last Project Type

• 8.9 Get Average Days to Return/Re-engage by Population

• 8.10 Get Average Days to Return/Re-engage by System Path

• 8.11 Get Average Days to Return/Re-engage by Exit Destination

• 9.1 Report Rows for LSACalculated Counts

• 9.2 Identify Active and Point in Time Cohorts for LSACalculated Counts

• 9.3 Counts of People and Households by Project and Household Characteristics

• 9.4 Get Counts of People by Project and Personal Characteristics

• 9.5 Get Counts of Bednights

• 9.6 Get OPH Point-in-Time Counts for HIC

• 10.1 Static Column Values

• 10.2 DQ - Enrollments Active After Project Operating End Date by Project

• 10.3 DQ - Night-by-Night Enrollments with Exit Date Discrepancies by Project

• 10.4 DQ - Counts of Households with no EnrollmentCoC by Project

• 10.5 DQ – Enrollments in Non-Participating Projects

• 10.6 DQ – Enrollments Active in LSA Projects During the Report Period without Exactly One HoH

• 10.7 DQ – Enrollments Active in LSA Projects without a Valid Relationship to HoH

• 10.8 DQ – Household Entry

• 10.9 DQ – Client Entry

• 10.10 DQ – Adult/HoH Entry

• 10.11 DQ – Client Exit

• 10.12 DQ – Disabling Condition

• 10.13 DQ – Living Situation

• 10.14 DQ – Length of Stay

• 10.15 DQ – Date ES/SH/Street Homelessness Started

• 10.16 DQ – Times ES/SH/Street Homeless Last 3 Years

• 10.17 DQ – Months ES/SH/Street Homeless Last 3 Years

• 10.18 DQ – Destination

• 10.19 DQ – Date of Birth

• 10.20 LSACalculated

• 11.1 Data Quality: HMIS Household Enrollments Not Associated with a CoC
  • NoCoC
• 11.2 Data Quality: Households Excluded from the LSA Due to HoH Errors
  • NotOneHoH
• 11.3 Data Quality: Enrollments Excluded from the LSA Due to Invalid RelationshipToHoH
  • RelationshipToHoH
• 11.4 Data Quality: Invalid Move-In Dates
  • MoveInDate
• 11.5 Data Quality: Baseline Counts of Clients / HouseholdIDs / EnrollmentIDs
  • UnduplicatedClient
  • HouseholdEntry
  • ClientEntry
  • AdultHoHEntry
  • ClientExit
• 11.6 Data Quality: SSN Issues
  • SSN4Digit
  • SSNValid
  • SSNNotProvided
  • SSNMissingOrInvalid
  • ClientSSNNotUnique
  • DistinctSSNValueNotUnique
• 11.7 Data Quality: Counts of Enrollment Issues
  • DisablingCond
  • LivingSituation
  • LengthOfStay
  • HomelessDate
  • TimesHomeless
  • MonthsHomeless
  • Destination

• 11.8 Set LSAReport ReportDate

• 11.9 LSAReport

---

Table of contents

• 1 - Introduction
• 2 - HDX 2.0 Upload
• 3 - Core Concepts and Data Universe
• 4 - HMIS Business Logic: Project Descriptor Data for Export
• 5 - LSAPerson
• 6 - LSAHousehold
• 7 - LSAExit
• 8 - LSA Calculated Averages
• 9 - LSA Calculated Counts
• 10 - LSA Calculated Project Level Data Quality Counts
• 11 - LSAReport Data Quality and ReportDate
• LSA Data Dictionary - Files and Columns
• LSA Data Dictionary - Lists