The Longitudinal Systems Analysis (LSA) upload is a .zip file containing a total of 12 CSV files generated by the HMIS application. For the HIC, the same 12 files are submitted, but LSAHousehold and LSAExit may be empty (other than headers) as they do not include any data relevant to the HIC. Files are listed below with a brief description and links to the sections of this document that define the business logic for the file.

A separate data dictionary with a complete list of the columns and values associated with each of these files is available in the LSA tool kit as an Excel workbook.

2.1 Project.csv

The structure of Project is defined by the HMIS CSV; it contains HMIS Data Element 2.02 Project Information for continuum ES, SH, TH, RRH, PSH, and/or OPH projects active since LookbackDate. It is referenced as lsa_Project in this document.

See section 4.1 Get Project.csv Records / lsa_Project.

2.2 Organization.csv

The structure of Organization is defined by the HMIS CSV; it contains HMIS data element 2.01 Organization Information for each project included in Project.csv. It is referenced as lsa_Organization in this document.

See section 4.2 Get Organization.csv Records / lsa_Organization.

2.3 Funder.csv

The structure of Funder is defined by the HMIS CSV; it contains HMIS data element 2.06 Funding Sources records active during the report period for each project included in Project.csv.

See section 4.3 Get Funder.csv Records / lsa_Funder.

2.4 ProjectCoC.csv

The structure of ProjectCoC is defined by the HMIS CSV; it contains HMIS data element 2.03 Continuum of Care Code records associated with ReportCoC for each project included in Project.csv.

See section 4.4 Get ProjectCoC.csv Records / lsa_ProjectCoC.

2.5 Inventory.csv

The structure of Inventory is defined by the HMIS CSV; it contains HMIS data element 2.07 Bed and Unit Inventory Information records active during the report period for each project included in Project.csv, except for RRH: Services Only projects.

See section 4.5 Get Inventory.csv Records / lsa_Inventory.

2.6 HMISParticipation.csv

The structure of HMISParticipation is defined by the HMIS CSV; it contains affiliation records from HMIS data element 2.08 HMIS Participation records active during the report period for each project included in Project.csv.

See section 4.6 Get HMISParticipation.csv Records / lsa_HMISParticipation.

2.7 Affiliation.csv

The structure of Affiliation is defined by the HMIS CSV; it contains HMIS data element 2.02 Project Information (field 2.02B) records for each RRH project in Project.csv with a subtype of RRH-SSO active during the report period and identified as having a residential affiliation.

See section 4.7 Get Affiliation.csv Records / lsa_Affiliation.

2.8 LSAReport.csv

LSAReport contains 32 columns, including report metadata, report parameters, and HMIS data quality reporting. The HDX 2.0 uses these data to process the upload file and to assess the reliability of the data.

The data types for columns in LSAReport are shown below; no value may be NULL.

# Column Name DataType List Description Max Length
1 ReportID int   Unique identifier 10
2 ReportDate datetime   The date and time that reporting procedures completed the process of generating the LSA. 19
3 ReportStart date   User-entered report parameter 19
4 ReportEnd date   User-entered report parameter 19
5 ReportCoC nvarchar(6)   User-entered report parameter 6
6 SoftwareVendor nvarchar(50)   The name of the HMIS vendor 50
7 SoftwareName nvarchar(50)   The name of the HMIS application 50
8 VendorContact nvarchar(50)   Optional name of a vendor contact point for HDX 2.0 staff (department or person) 50
9 VendorEmail nvarchar(50)   Optional email for vendor contact 50
10 LSAScope int 1 Identifies whether LSA is systemwide (clients of all relevant continuum projects are included based on project types); project-focused (only clients of projects selected by the user generating the LSA are included); or HIC (systemwide single day) 1
11 LookbackDate date   ReportStart - 7 years 19
12 NoCoC int   Systemwide count of HouseholdIDs served in continuum ES/SH/TH/RRH/PSH projects during the report period and excluded from the LSA because there is no record of the CoC in which the households were served. 10
13 NotOneHoH int   Systemwide count of HouseholdIDs active in continuum ES/SH/TH/RRH/PSH projects during the report period but excluded from the LSA due to improper designation of a head of household. 10
14 RelationshipToHoH int   Count of enrollments associated with households active during the LSA report period but excluded from the LSA due to missing/invalid RelationshipToHoH values. 10
15 MoveInDate int   Count of RRH/PSH enrollments with move-in dates recorded in HMIS that fall either prior to project entry or after project exit. 10
16 UnduplicatedClient int   A count of distinct PersonalIDs in LSAPerson 10
17 HouseholdEntry int   A count of distinct HouseholdIDs for the active cohort with enrollment dates that fall within the report period. 10
18 ClientEntry int   A count of distinct EnrollmentIDs for the active cohort with enrollment dates that fall within the report period. 10
19 AdultHoHEntry int   A count of distinct EnrollmentIDs for adults and heads of household in the active cohort with enrollment dates that fall within the report period. 10
20 ClientExit int   A count of distinct EnrollmentIDs for the active cohort with an exit date within the report period. 10
21 SSN4Digit int   The total number of PersonalIDs reported in LSAPerson where the value for SSNDataQuality is Approximate or partial SSN collected (2), the first five characters of SSN are all x and/or X, and the last 4 are a combination of digits other than ‘0000’. 10
22 SSNNotProvided int   The total number of PersonalIDs reported in LSAPerson where the value for SSNDataQuality is Client doesn’t know (8) or Client refused (9). 10
23 SSNMissingOrInvalid int   The total number of PersonalIDs reported in LSAPerson where the value for SSNDataQuality is NOT Client doesn’t know (8) or Client refused (9), and the value for SSN is either the system default or the value is not valid per SSA guidelines. 10
24 ClientSSNNotUnique int   The total number of PersonalIDs reported in LSAPerson where there is at least one record in HMIS for a different PersonalID with the same value for SSN, excluding the system default value (if any) for missing SSN. 10
25 DistinctSSNValueNotUnique int   The total number of distinct SSN values (excluding the system default, if any) that are associated with PersonalIDs reported in LSAPerson and the distinct SSN value is shared by one or more PersonalIDs in HMIS. 10
26 DisablingCond int   A count of distinct EnrollmentIDs active in the report period with missing or invalid values for DisablingCondition 10
27 LivingSituation int   A count of distinct EnrollmentIDs for HoH/adults active in the report period with missing or invalid values for LivingSituation 10
28 LengthOfStay int   A count of distinct EnrollmentIDs for HoH/adults active in the report period with missing or invalid values for LengthOfStay 10
29 HomelessDate int   A count of distinct EnrollmentIDs for HoH/adults active in the report period with missing or invalid values for DateToStreetESSH 10
30 TimesHomeless int   A count of distinct EnrollmentIDs for HoH/adults active in the report period with missing or invalid values for TimesHomelessPastThreeYears 10
31 MonthsHomeless int   A count of distinct HMIS EnrollmentIDs active in the report period with missing or invalid values for MonthsHomelessPastThreeYears 10
32 Destination int   A count of distinct EnrollmentIDs with exits in the report period with missing or invalid values for Destination 10

2.9 LSAPerson.csv

LSAPerson contains 66 columns and includes reporting on people active during the report period. Columns include the following types of data:

  • Identifiers for project types, household types, and populations in which clients were served.
  • Age categories for all clients; age is the only demographic reported for children who are not heads of household.
  • Demographics reported for adults and heads of household, including race/ethnicity, veteran status, disability status, and domestic violence status.

Rows represent specific combinations of these data points. Each active client is counted in one row; the sum of RowTotal values in the file is equal to the total number of active clients in the report period.

It is critical that all values in this column are integers > 0. The largest possible number of rows – when each row includes a count of one or more people represented by the distinct combination of column values – is limited to the number of active clients. However, there are billions of possible combinations of column values, and including rows that that do not represent any clients would result in files of unmanageable size.

The data type for every column in LSAPerson is integer; no value may be NULL.

# Column Name Notes
1 RowTotal A count of distinct PersonalIDs for active clients, grouped by all values in the other columns. Must be > 0.
2 RaceEthnicity See 5.4 LSAPerson Demographics
3 VetStatus See 5.4 LSAPerson Demographics
4 DisabilityStatus See See 5.4 LSAPerson Demographics
5 CHTime See 5.5 Time Spent in ES/SH or on the Street through 5.10 CHTime and CHTimeStatus
6 CHTimeStatus See See 5.5 Time Spent in ES/SH or on the Street through 5.10 CHTime and CHTimeStatus – LSAPerson
7 DVStatus See 5.4 LSAPerson Demographics
8 ESTAgeMin See 5.11 EST/RRH/PSH/RRHSOAgeMin and EST/RRH/PSH/RRHSOAgeMax
9 ESTAgeMax See 5.11 EST/RRH/PSH/RRHSOAgeMin and EST/RRH/PSH/RRHSOAgeMax
10 HHTypeEST See 5.13 Project Group and Population Household Types
11 HoHEST See 5.13 Project Group and Population Household Types
12 AdultEST See 5.13 Project Group and Population Household Types
13 AIRAdultEST See 5.13 Project Group and Population Household Types
14 HHChronicEST See 5.13 Project Group and Population Household Types
15 HHVetEST See 5.13 Project Group and Population Household Types
16 HHDisabilityEST See 5.13 Project Group and Population Household Types
17 HHFleeingDVEST See 5.13 Project Group and Population Household Types
18 HHAdultAgeAOEST See 5.14 Adult Age Population Identifiers
19 HHAdultAgeACEST See 5.14 Adult Age Population Identifiers
20 HHParentEST See 5.13 Project Group and Population Household Types
21 AC3PlusEST See 5.13 Project Group and Population Household Types
22 AIREST See 5.13 Project Group and Population Household Types
23 AIRHoHEST See 5.13 Project Group and Population Household Types
24 RRHAgeMin See 5.11 EST/RRH/PSH/RRHSOAgeMin and EST/RRH/PSH/RRHSOAgeMax
25 RRHAgeMax See 5.11 EST/RRH/PSH/RRHSOAgeMin and EST/RRH/PSH/RRHSOAgeMax
26 HHTypeRRH See 5.13 Project Group and Population Household Types
27 HoHRRH See 5.13 Project Group and Population Household Types
28 AdultRRH See 5.13 Project Group and Population Household Types
29 AIRAdultRRH See 5.13 Project Group and Population Household Types
30 HHChronicRRH See 5.13 Project Group and Population Household Types
31 HHVetRRH See 5.13 Project Group and Population Household Types
32 HHDisabilityRRH See 5.13 Project Group and Population Household Types
33 HHFleeingDVRRH See 5.13 Project Group and Population Household Types
34 HHAdultAgeAORRH See 5.14 Adult Age Population Identifiers
35 HHAdultAgeACRRH See 5.14 Adult Age Population Identifiers
36 HHParentRRH See 5.13 Project Group and Population Household Types
37 AC3PlusRRH See 5.13 Project Group and Population Household Types
38 AIRRRH See 5.13 Project Group and Population Household Types
39 AIRHoHRRH See 5.13 Project Group and Population Household Types
40 PSHAgeMin See 5.11 EST/RRH/PSH/RRHSOAgeMin and EST/RRH/PSH/RRHSOAgeMax
41 PSHAgeMax See 5.11 EST/RRH/PSH/RRHSOAgeMin and EST/RRH/PSH/RRHSOAgeMax
42 HHTypePSH See 5.13 Project Group and Population Household Types
43 HoHPSH See 5.13 Project Group and Population Household Types
44 AdultPSH See 5.13 Project Group and Population Household Types
45 AIRAdultPSH See 5.13 Project Group and Population Household Types
46 HHChronicPSH See 5.13 Project Group and Population Household Types
47 HHVetPSH See 5.13 Project Group and Population Household Types
48 HHDisabilityPSH See 5.13 Project Group and Population Household Types
49 HHFleeingDVPSH See 5.13 Project Group and Population Household Types
50 HHAdultAgeAOPSH See 5.14 Adult Age Population Identifiers
51 HHAdultAgeACPSH See 5.14 Adult Age Population Identifiers
52 HHParentPSH See 5.13 Project Group and Population Household Types
53 AC3PlusPSH See 5.13 Project Group and Population Household Types
54 AIRPSH See 5.13 Project Group and Population Household Types
55 AIRHoHPSH See 5.13 Project Group and Population Household Types
56 RRHSOAgeMin See 5.11 EST/RRH/PSH/RRHSOAgeMin and EST/RRH/PSH/RRHSOAgeMax
57 RRHSOAgeMax See 5.11 EST/RRH/PSH/RRHSOAgeMin and EST/RRH/PSH/RRHSOAgeMax
58 HHTypeRRHSONoMI See 5.13 Project Group and Population Household Types
59 HHTypeRRHSOMI See 5.13 Project Group and Population Household Types
60 HHTypeES See 5.13 Project Group and Population Household Types
61 HHTypeSH See 5.13 Project Group and Population Household Types
62 HHTypeTH See 5.13 Project Group and Population Household Types
63 HIV See 5.4 LSAPerson Demographics
64 SMI See 5.4 LSAPerson Demographics
65 SUD See 5.4 LSAPerson Demographics
66 ReportID Must match ReportID in LSAReport; see 3.1 Report Metadata for LSAReport

2.10 LSAHousehold.csv

LSAHousehold contains 67 columns and includes reporting on households active during the report period. Columns include the following types of data:

  • Identifiers for project types and populations in which each household was served.
  • Demographics plus living situation, destination, household composition, project geography, and system engagement.
  • Lengths of time homeless (LOTH) and enrolled in RRH/PSH during the report period and any continuous episode of homelessness prior to ReportStart that overlaps with the report period.

Rows represent specific combinations of these data points. Each active household is counted in one row; the sum of RowTotal values in the file is equal to the total number of households active in the report period.

This file may empty (other than headers) for the HIC.

It is critical that all values in the RowTotal column are integers > 0. When each row includes a count of one or more households represented by the distinct combination of column values, the total number of rows– is limited to the number of active households. However, the number of possible distinct combinations of column values is massive and including rows that do not represent any households could result in unmanageable file sizes.

For business logic, see Section 6 - LSAHousehold.

# Column Name DataType List Nullable Description Max Length
1 RowTotal int   0 The total number of households served in continuum ES, SH, TH, RRH, and/or PSH projects during the report period with the characteristics represented by the values in each column of the row. All values must be integers > 0. 10
2 Stat int 2 0 The household status related to continuum engagement on the first day of the earliest enrollment active during the report period. 1
3 ReturnTime int 3 0 When Stat = (2,3,4), the length of time in days between exit and the earliest active enrollment. 3
4 HHType int 4 0 The household type. 2
5 HHChronic int 43 0 Identifies household status related to long-term/chronic homelessness 1
6 HHVet int 5 0 Identifies whether or not the household includes a veteran. Based on VetStatus value, as determined for LSAPerson reporting. 1
7 HHDisability int 5 0 Identifies whether or not the head of household or any adult member was identified as having a disabling condition on any active enrollment. 1
8 HHFleeingDV int 48 0 Identifies whether or not the head of household or any adult member was identified as fleeing domestic violence or impacted by domestic violence on any active enrollment. Based on DVStatus value, as determined for LSAPerson reporting. 1
9 HoHRaceEthnicity int 6 0 Identifies race and ethnicity for head of household as reported in LSAPerson. 7
10 HHAdult int 8 0 Number of people (including the head of household) 18 and older served with the head of household in the household type reflected in the HHType column. 1
11 HHChild int 8 0 Number of people (including the head of household) under the age of 18 served with the head of household in the household type reflected in the HHType column. 1
12 HHNoDOB int 8 0 Number of people (including the head of household) with no valid date of birth served with the head of household. 1
13 HHAdultAge int 9 0 The age groups of adult household members. The categories are mutually exclusive (a household can only fall into one group) and inclusive (every household with adults will fall into one group). 2
14 HHParent int 5 0 Identifies whether or not any household member has RelationshiptoHoH = 2 (child of the HoH). 1
15 ESTStatus int 10 0 Identifies whether the household was served in ES, SH, and/or TH during the report period or prior to the report period during a period of continuous system use. If served, the status indicates how the enrollment timeframe relates to the report period. 2
16 ESTGeography int 13 0 For households with active EST enrollments (ESTStatus > 2) during the report period, the Geography of the most recent project in which the household was enrolled. 2
17 ESTLivingSit int 14 0 For households with active EST enrollments (ESTStatus > 2) during the report period, the LivingSituation associated with the earliest active enrollment. 3
18 ESTDestination int 15 0 For households who exited an EST enrollment during the report period and were not active in an EST project as of ReportEnd (ESTStatus in (12,22)), the Destination associated with the most recent exit. 2
19 ESTChronic int 5 0 Population identifier specific to EST; see HHChronic. 1
20 ESTVet int 5 0 Population identifier specific to EST; see HHVet. 1
21 ESTDisability int 5 0 Population identifier specific to EST; see HHDisability. 1
22 ESTFleeingDV int 48 0 Population identifier specific to EST; see HHFleeingDV. 1
23 ESTAC3Plus int 5 0 Population identifier; for AC households, specifies whether or not there were at least three household members under the age of 18 served with the HoH in EST. 1
24 ESTAdultAge int 9 0 Population identifier specific to EST; see HHAdultAge. 2
25 ESTParent int 5 0 Population identifier specific to EST; see HHParent. 1
26 RRHStatus int 10 0 Identifies whether the household was served in RRH during the report period or in an episode of homelessness that overlaps with the report period. If served, the status indicates how the enrollment timeframe relates to the report period. 2
27 RRHMoveIn int 11 0 For households served in RRH during the report period, indicates if the household has a move-in date. If so, indicates whether it was before or during the report period. 2
28 RRHGeography int 13 0 For households with active RRH enrollments (RRHStatus > 2) during the report period, the Geography of the most recent project in which the household was enrolled. 2
29 RRHLivingSit int 14 0 For households with active RRH enrollments (RRHStatus > 2) during the report period, the LivingSituation associated with the earliest active enrollment. 3
30 RRHDestination int 15 0 For households who exited an RRH enrollment during the report period and were not active in an RRH project as of ReportEnd (RRHStatus in (12,22)), the Destination associated with the most recent exit. 2
31 RRHPreMoveInDays int 12 0 For households who were housed in RRH at any point in the report period, including those with a MoveInDate prior to ReportStart, the total number of days between EntryDate and MoveInDate for any active RRH enrollment. It differs from other day counts in that it includes all days in RRH prior to move-in, even if the household was simultaneously enrolled in ES/SH/TH/PSH. 4
32 RRHChronic int 5 0 Population identifier specific to RRH; see HHChronic. 1
33 RRHVet int 5 0 Population identifier specific to RRH; see HHVet. 1
34 RRHDisability int 5 0 Population identifier specific to RRH; see HHDisability. 1
35 RRHFleeingDV int 48 0 Population identifier specific to RRH; see HHFleeingDV. 1
36 RRHAC3Plus int 5 0 Population identifier; for AC households, specifies whether or not there were at least three household members under the age of 18 served with the HoH in RRH. 1
37 RRHAdultAge int 9 0 Population identifier specific to RRH; see HHAdultAge. 2
38 RRHParent int 5 0 Population identifier specific to RRH; see HHParent. 1
39 PSHStatus int 10 0 Identifies whether the household was served in PSH during the report period or in an episode of homelessness that overlaps with the report period. If served, the status indicates how the enrollment timeframe relates to the report period. 2
40 PSHMoveIn int 11 0 For households served in PSH during the report period, indicates if the household has a move-in date. If so, indicates whether it was before or during the report period. 2
41 PSHGeography int 13 0 For households with active PSH enrollments (PSHStatus > 2) during the report period, the Geography of the most recent project in which the household was enrolled. 2
42 PSHLivingSit int 14 0 For households with active PSH enrollments (PSHStatus > 2) during the report period, the LivingSituation associated with the earliest active enrollment. 3
43 PSHDestination int 15 0 For households who exited a PSH enrollment during the report period and were not active in PSH as of ReportEnd (PSHStatus in (12,22)), the Destination associated with the most recent exit. 2
44 PSHHousedDays int 16 0 From active enrollments, days spent housed in PSH. (Note that this differs from other day counts in that it does not include continuous enrollments prior to the report period.) 3
45 PSHChronic int 5 0 Population identifier specific to PSH; see HHChronic. 1
46 PSHVet int 5 0 Population identifier specific to PSH; see HHVet. 1
47 PSHDisability int 5 0 Population identifier specific to PSH; see HHDisability. 1
48 PSHFleeingDV int 48 0 Population identifier specific to PSH; see HHFleeingDV. 1
49 PSHAC3Plus int 5 0 Population identifier; for AC households, specifies whether or not there were at least three household members under the age of 18 served with the HoH in PSH. 1
50 PSHAdultAge int 9 0 Population identifier specific to PSH; see HHAdultAge. 2
51 PSHParent int 5 0 Population identifier specific to PSH; see HHParent. 1
52 ESDays int 12 0 Days spent in ES or SH during the report period and/or in any continuous episode of homelessness/system use prior to the report period when the household was not in TH or housed in RRH/PSH. 4
53 THDays int 12 0 Days spent in TH during the report period and/or in any continuous episode of engagement/homelessness prior to report period when the household was not in housed in RRH/PSH. 4
54 ESTDays int 12 0 Days spent in ES/SH/TH in the report period and/or in any continuous episode of homelessness prior to report period when the household was not housed in RRH/PSH. 4
55 RRHPSHPreMoveInDays int 12 0 For households served in RRH and/or PSH, the total number of days spent homeless in RRH/PSH in the report period or in any continuous episode of engagement/homelessness prior to report period when household was not housed in RRH/PSH and not active in ES/SH/TH. 4
56 RRHHousedDays int 12 0 Days spent housed in RRH in the report period and/or in any continuous episode of engagement/homelessness prior to report period when the household was not housed in PSH. 4
57 SystemDaysNotPSHHoused int 12 0 The total number of days spent in ES, SH, TH, RRH, or PSH (pre-move-in) in the report period or in any continuous episode of homelessness prior to the report period while not housed in PSH. 4
58 SystemHomelessDays int 12 0 The combined total number of days in the report period or in any episode of continuous homelessness that overlaps the report period when the household was in ES/SH/TH or was enrolled, but not housed in RRH/PSH (i.e. does not have a move-in date). 4
59 Other3917Days int 12 0 The total number of days in the report period or in any episode of continuous homelessness that overlaps the report period when the household was on the street or in ES/SH based on 3.917 Living Situation records for any System Path enrollment, but was not active in a continuum ES/SH/TH/RRH/PSH project. 4
60 TotalHomelessDays int 12 0 The combined total number of days in the report period or in any episode of continuous homelessness that overlaps the report period when the household was in ES/SH/TH; was enrolled, but not housed in RRH/PSH (i.e. does not have a move-in date); or on the street or in ES/SH based on 3.917 Living Situation records for any System Path enrollment and was not housed in RRH/PSH. 4
61 SystemPath int 17 0 The combinations of system use during the report period and in the contiguous periods of service prior to the report period – i.e., the ‘path’ through the system. It is not dependent on the sequence of service. System Paths are mutually exclusive. 2
62 ESTAIR int 5 0 Identifies households active in residence for ES/SH/TH (with 1 or more ES/SH/TH bednights in the report period). 1
63 RRHAIR int 5 0 Identifies households active in residence for RRH (with 1 or more RRH bednights in the report period). 1
64 PSHAIR int 5 0 Identifies households active in residence for PSH (with 1 or more PSH bednights in the report period). 1
65 RRHSOStatus int 10 0 Identifies whether the household was served in RRH-SO during the report period or in an episode of homelessness that overlaps with the report period. If served, the status indicates how the enrollment timeframe relates to the report period. 2
66 RRHSOMoveIn int 11 0 For households served in RRH-SO during the report period, indicates if the household has a move-in date. If so, indicates whether it was before or during the report period. 2
67 ReportID int   0 Must match LSAReport.ReportID 10

2.11 LSAExit.csv

LSAExit contains 17 columns. The file identifies households with system exits – i.e., exits from a continuum project followed by at least two weeks without an active enrollment – in three distinct periods:

  • Cohort -2 – Begins two years prior to the report start date and ends two years prior to the end date.
  • Cohort -1 – Begins one year prior to the report start date and ends one year prior to the end date.
  • Cohort 0 – Begins on the report start date; if the report period is at least six months, the cohort period ends at six months; otherwise, the cohort period is the same as the report period.

Columns include the following types of data:

  • Identifiers for project types, household types, and populations in which clients were served;
  • Destination types; and
  • For clients that returned to a continuum ES, SH, TH, RRH, or PSH project, the length of time to return.

Rows represent specific combinations of these data points. Unlike LSAHousehold, LSAExit may include more than one row for any given household if the household has qualifying exits in more than one cohort period. Each household is counted in one row for each exit cohort in which they occur. The sum of RowTotal values in the file, grouped by Cohort, is equal to the total number of households in each of the respective cohorts. It is critical that all values in this column are integers > 0. The largest possible number of rows – when each row includes a count of one or more households represented by the distinct combination of column values – is limited to the number of active households. However, there are billions of possible distinct combinations of column values and including rows that do not represent any households could result in files of unmanageable size.

This file may be empty (other than headers) for the HIC.

For business logic, see Section 7 - LSAExit.

# Column Name DataType List Nullable Description Max Length
1 RowTotal int   0 The total number of households served in the continuum with the characteristics represented by the values in each column of the row. All values must be integers >0. 10
2 Cohort int 27 0 Identifies which return cohort the household is in. These categories are not mutually exclusive. 2
3 Stat int 2 0 Identifies the status of households at the start of the cohort period. 1
4 ExitFrom int 28 0 Identifies the project type from which household exited. 1
5 ExitTo int 15 0 Identifies the exit destination. 3
6 ReturnTime int 3 0 The number of days between exiting to the destination identified in ExitTo and an EntryDate for any continuum ES, SH, TH, RRH, or PSH project. 3
7 HHType int 4 0 The household type. 2
8 HHVet int 5 0 Identifies whether or not the household includes a veteran. 1
9 HHChronic int 43 0 Identifies household status related to long-term/chronic homelessness 1
10 HHDisability int 5 0 Identifies households with a disabled adult or HoH 1
11 HHFleeingDV int 48 0 Identifies households fleeing domestic violence 1
12 HoHRaceEthnicity int 6 0 Identifies race and ethnicity for head of household. 7
13 HHAdultAge int 9 0 The age groups of adult household members. The categories are mutually exclusive (a household can only fall into one group) and inclusive (every household with adults will fall into one group). 2
14 HHParent int 5 0 Identifies whether or not any household member has RelationshiptoHoH = 2 (child of the HoH) on any active enrollment in the cohort period. 1
15 AC3Plus int 5 0 Identifies AC (adult-child) households that include 3 or more children on any active enrollment in the cohort period. 1
16 SystemPath int 17 0 The combinations of system use during the cohort period and in the continuous periods of service prior to the cohort period – i.e., the ‘path’ through the system. It is not dependent on the sequence of service. Categories are mutually exclusive. 2
17 ReportID int   0 Must match LSAReport.ReportID 10

2.12 LSACalculated.csv

This file is used to upload calculated values for report output that cannot be derived from the aggregate data.

It is used to populate columns that report on average number of days in:

  • System Use – Length of Time Homeless
  • System Use – Length of Time Homeless
  • System Use - Cumulative Length of Time in PSH
  • System Use – Length of Time in RRH Projects
  • Returns – Days to Return/Re-engage by Exit Destination
  • Days to Return/Re-engage by Last Project Type
  • Days to Return/Re-engage by System Path
  • Days to Return/Re-engage by Population

The averages are related to data in LSAHousehold and LSAExit; they are not relevant for HIC submissions.

It is also used for counts of persons, households, and bed nights grouped by project IDs and project types, including:

  • Counts of households and clients active in residence in the report period and on four specific dates during the report period;
  • Counts of total bed nights in the report period; and
  • HMIS data quality issues that may impact the integrity of LSA reporting.

The Value column holds the average or count. Other columns identify the report row, household type, population, etc.

For business logic, see:

ColumnNumber Column Name DataType List Nullable Description Max Length
1 Value int   0 The calculated report row value (average or count) 10
2 Cohort int 29 0   2
3 Universe int 30 0   2
4 HHType int 31 0   2
5 Population int 32 0   4
6 SystemPath int 17 0   2
7 ProjectID nvarchar(32)   1 If ReportRow between 53 and 57 and Universe = 10, must match Project.csv.ProjectID; otherwise, must be NULL. 32
8 ReportRow int 33 0   3
9 ReportID int   0 Must match LSAReport.ReportID 10
This site uses Just the Docs, a documentation theme for Jekyll.