LSA Data Dictionary - Files and Columns
Data Types
| Abbreviation | Data Type | Notes |
|---|---|---|
| D | Date | The maximum number of characters allowed for a date column is 10. |
| DT | Datetime (system-generated) | The maximum number of characters allowed for a datetime column is 19. |
| I | Integer | Integer columns not associated with a list have a maximum length of 10 digits. |
| L(#) | List | All list columns have a data type of integer and are limited to values included in the list. The list number in parentheses is a clickable link to the relevant list. |
| S | String/varchar | Maximum number of characters are in parentheses in Type columns below. For example: S(50) |
1 - LSAReport
| # | Column | Type | Description |
|---|---|---|---|
| 1 | ReportID | I | Unique identifier |
| 2 | ReportDate | DT | The date and time that reporting procedures completed the process of generating the LSA. |
| 4 | ReportEnd | D | User-entered report parameter |
| 5 | ReportCoC | S(6) | User-entered report parameter |
| 6 | SoftwareVendor | S(50) | The name of the HMIS vendor |
| 7 | SoftwareName | S(50) | The name of the HMIS application |
| 8 | VendorContact | S(50) | Optional name of a vendor contact point for HDX 2.0 staff (department or person) |
| 9 | VendorEmail | S(50) | Optional email for vendor contact |
| 10 | LSAScope | I(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) |
| 11 | LookbackDate | D | ReportStart - 7 years |
| 12 | NoCoC | I | Systemwide count of _HouseholdID_s 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. |
| 13 | NotOneHoH | I | Systemwide count of _HouseholdID_s 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. |
| 14 | RelationshipToHoH | I | Count of enrollments associated with households active during the LSA report period but excluded from the LSA due to missing/invalid RelationshipToHoH values. |
| 15 | MoveInDate | I | Count of RRH/PSH enrollments with move-in dates recorded in HMIS that fall either prior to project entry or after project exit. |
| 16 | UnduplicatedClient | I | A count of distinct PersonalIDs in LSAPerson |
| 17 | HouseholdEntry | I | A count of distinct HouseholdIDs for the active cohort with entry dates in the report period. |
| 18 | ClientEntry | I | A count of distinct EnrollmentIDs for the active cohort with entry dates in the report period. |
| 19 | AdultHoHEntry | I | A count of distinct EnrollmentIDs for adults and heads of household in the active cohort with entry dates in the report period. |
| 20 | ClientExit | I | A count of distinct EnrollmentIDs for the active cohort with exit dates in the report period. |
| 21 | SSN4Digit | I | 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’. |
| 22 | SSNNotProvided | I | The total number of PersonalIDs reported in LSAPerson where the value for SSNDataQuality is ‘Client doesn’t know’ (8) or ‘Client prefers not to answer’ (9). |
| 23 | SSNMissingOrInvalid | I | The total number of PersonalIDs reported in LSAPerson where the value for SSNDataQuality is NOT 8 or 9 and the value for SSN is the system default or is not valid per SSA guidelines. |
| 24 | ClientSSNNotUnique | I | 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. |
| 25 | DistinctSSNValueNotUnique | I | The total number of distinct SSN values, excluding the system default value (if any) that are associated with PersonalIDs reported in LSAPerson where the distinct SSN value is shared by one or more PersonalIDs. |
| 26 | DisablingCond | I | A count of distinct EnrollmentIDs with missing or invalid values for DisablingCondition |
| 27 | LivingSituation | I | A count of distinct EnrollmentIDs with missing or invalid values for LivingSituation |
| 28 | LengthOfStay | I | A count of distinct EnrollmentIDs with missing or invalid values for LengthOfStay |
| 29 | HomelessDate | I | A count of distinct EnrollmentIDs with missing or invalid values for DateToStreetESSH |
| 30 | TimesHomeless | I | A count of distinct EnrollmentIDs with missing or invalid values for TimesHomelessPastThreeYears |
| 31 | MonthsHomeless | I | A count of distinct EnrollmentIDs with missing or invalid values for MonthsHomelessPastThreeYears |
| 32 | Destination | I | A count of distinct EnrollmentIDs with exits in the report period with missing or invalid values for Destination |
2 - LSAHousehold
All columns in LSAHousehold have a data type of integer; there must be a value present in every column of every row.
| # | Column Name | List | Description |
|---|---|---|---|
| 1 | RowTotal | 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. Must be > 0. | |
| 2 | Stat | 2 | The household status related to continuum engagement on the first day of the earliest enrollment active during the report period. |
| 3 | ReturnTime | 3 | When Stat = (2,3,4), the length of time in days between exit and the earliest active enrollment. |
| 4 | HHType | 4 | The household type. |
| 5 | HHChronic | 43 | Identifies household status related to long-term/chronic homelessness |
| 6 | HHVet | 5 | Identifies whether or not the household includes a veteran. Based on VetStatus value, as determined for LSAPerson reporting. |
| 7 | HHDisability | 5 | Identifies whether or not the head of household or any adult member was identified as having a disabling condition on any active enrollment. |
| 8 | HHFleeingDV | 48 | 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. |
| 9 | HoHRaceEthnicity | 6 | Identifies race and ethnicity for head of household as reported in LSAPerson. |
| 10 | HHAdult | 8 | 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. |
| 11 | HHChild | 8 | 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. |
| 12 | HHNoDOB | 8 | Number of people (including the head of household) with no valid date of birth served with the head of household. |
| 13 | HHAdultAge | 9 | 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). |
| 14 | HHParent | 5 | Identifies whether or not any household member has RelationshiptoHoH = 2 (child of the HoH). |
| 15 | ESTStatus | 10 | 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. |
| 16 | ESTGeography | 13 | 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. |
| 17 | ESTLivingSit | 14 | For households with active EST enrollments (ESTStatus > 2) during the report period, the LivingSituation associated with the earliest active enrollment. |
| 18 | ESTDestination | 15 | 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. |
| 19 | ESTChronic | 5 | Population identifier specific to EST; see HHChronic. |
| 20 | ESTVet | 5 | Population identifier specific to EST; see HHVet. |
| 21 | ESTDisability | 5 | Population identifier specific to EST; see HHDisability. |
| 22 | ESTFleeingDV | 48 | Population identifier specific to EST; see HHFleeingDV. |
| 23 | ESTAC3Plus | 5 | 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. |
| 24 | ESTAdultAge | 9 | Population identifier specific to EST; see HHAdultAge. |
| 25 | ESTParent | 5 | Population identifier specific to EST; see HHParent. |
| 26 | RRHStatus | 10 | 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. |
| 27 | RRHMoveIn | 11 | 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. |
| 28 | RRHGeography | 13 | 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. |
| 29 | RRHLivingSit | 14 | For households with active RRH enrollments (RRHStatus > 2) during the report period, the LivingSituation associated with the earliest active enrollment. |
| 30 | RRHDestination | 15 | 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. |
| 31 | RRHPreMoveInDays | 12 | 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. |
| 32 | RRHChronic | 5 | Population identifier specific to RRH; see HHChronic. |
| 33 | RRHVet | 5 | Population identifier specific to RRH; see HHVet. |
| 34 | RRHDisability | 5 | Population identifier specific to RRH; see HHDisability. |
| 35 | RRHFleeingDV | 48 | Population identifier specific to RRH; see HHFleeingDV. |
| 36 | RRHAC3Plus | 5 | 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. |
| 37 | RRHAdultAge | 9 | Population identifier specific to RRH; see HHAdultAge. |
| 38 | RRHParent | 5 | Population identifier specific to RRH; see HHParent. |
| 39 | PSHStatus | 10 | 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. |
| 40 | PSHMoveIn | 11 | 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. |
| 41 | PSHGeography | 13 | 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. |
| 42 | PSHLivingSit | 14 | For households with active PSH enrollments (PSHStatus > 2) during the report period, the LivingSituation associated with the earliest active enrollment. |
| 43 | PSHDestination | 15 | 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. |
| 44 | PSHHousedDays | 16 | 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.) |
| 45 | PSHChronic | 5 | Population identifier specific to PSH; see HHChronic. |
| 46 | PSHVet | 5 | Population identifier specific to PSH; see HHVet. |
| 47 | PSHDisability | 5 | Population identifier specific to PSH; see HHDisability. |
| 48 | PSHFleeingDV | 48 | Population identifier specific to PSH; see HHFleeingDV. |
| 49 | PSHAC3Plus | 5 | 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. |
| 50 | PSHAdultAge | 9 | Population identifier specific to PSH; see HHAdultAge. |
| 51 | PSHParent | 5 | Population identifier specific to PSH; see HHParent. |
| 52 | ESDays | 12 | 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. |
| 53 | THDays | 12 | 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. |
| 54 | ESTDays | 12 | 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. |
| 55 | RRHPSHPreMoveInDays | 12 | 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. |
| 56 | RRHHousedDays | 12 | 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. |
| 57 | SystemDaysNotPSHHoused | 12 | 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. |
| 58 | SystemHomelessDays | 12 | 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). |
| 59 | Other3917Days | 12 | 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. |
| 60 | TotalHomelessDays | 12 | 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. |
| 61 | SystemPath | 17 | 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. |
| 62 | ESTAIR | 5 | Identifies households active in residence for ES/SH/TH (with 1 or more ES/SH/TH bednights in the report period). |
| 63 | RRHAIR | 5 | Identifies households active in residence for RRH (with 1 or more RRH bednights in the report period). |
| 64 | PSHAIR | 5 | Identifies households active in residence for PSH (with 1 or more PSH bednights in the report period). |
| 65 | RRHSOStatus | 10 | 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. |
| 66 | RRHSOMoveIn | 11 | 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. |
| 67 | ReportID | Must match LSAReport.ReportID |
3 - LSAPerson
All columns in LSAHousehold have a data type of integer; there must be a value present in every column of every row.
| # | Column Name | List | Description |
|---|---|---|---|
| 1 | RowTotal | The total number of people 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 > 0. | |
| 2 | RaceEthnicity | 6 | Race and Ethnicity for all persons |
| 3 | VetStatus | 20 | Veteran Status for adults; not applicable (value = -1) for children |
| 4 | DisabilityStatus | 20 | Disability Status for adults and heads of household based on records of 3.08 Disabling Condition for all active enrollments; not applicable (value = -1) for non-HoH children. |
| 5 | CHTime | 21) | For adults and heads of household, the total number of days in ES/SH or on the street in the three years prior to the client’s last active date in the report period. Based on data from active and inactive enrollments, the count of days excludes any time enrolled in continuum TH projects or housed in RRH/PSH, but otherwise includes: - Dates between entry and exit in continuum entry-exit ES and SH projects; and - Bed-night dates in night-by-night shelters; and - Dates between 3.917 DateToStreetESSH and EntryDate for ES/SH/TH/RRH/PSH projects; and - Dates between any RRH/PSH EntryDate and the earlier of MoveInDate or ExitDate when LivingSituation is ES/SH/Street; or -May be set based on 3.917 number of months and number of times homeless in the past three years from ES/SH/TH/RRH/PSH enrollments with entry dates in the year ending on the client’s last active date. |
| 6 | CHTimeStatus | 22 | For clients with 365+ days of ES/SH/Street time in the three years prior to their last active date (CHTime), specifies whether the dates are grouped so that the client meets the time criteria for chronic homelessness. Otherwise not applicable. |
| 7 | DVStatus | 23 | DV Status for adults and heads of household based on records of 4.11 Domestic Violence for all active enrollments; not applicable (value = -1) for non-HoH children |
| 8 | ESTAgeMin | 18 | The minimum age at the later of ReportStart and EntryDate for any ES/SH/TH enrollment. |
| 9 | ESTAgeMax | 18 | The maximum age at the later of ReportStart and EntryDate for any ES/SH/TH enrollment. |
| 10 | HHTypeEST | 24 | The combination of household types in which clients were served in ES/SH/TH projects. |
| 11 | HoHEST | 24 | The combination of household types in which clients were served in ES/SH/TH projects as HoH. |
| 12 | AdultEST | 25 | The combination of household types in which clients were served in ES/SH/TH projects as an adult. |
| 13 | AIRAdultEST | 25 | The combination of household types in which adults had at least one ES/SH/TH bednight in the report period. |
| 14 | HHChronicEST | 24 | Population identifier; the combination of household types in which clients were served in ES/SH/TH projects in household with a chronically homeless adult or HoH. |
| 15 | HHVetEST | 25 | Population identifier; the combination of household types in which clients were served in ES/SH/TH projects in household with a veteran. |
| 16 | HHDisabilityEST | 24 | Population identifier; the combination of household types in which clients were served in ES/SH/TH projects in household with a disabled adult or HoH. |
| 17 | HHFleeingDVEST | 24 | Population identifier; the combination of household types in which clients were served in ES/SH/TH projects in household with an adult or HoH fleeing domestic violence. |
| 18 | HHAdultAgeAOEST | 9 | Population identifier (see list values); for AO households served in ES/SH/TH projects. |
| 19 | HHAdultAgeACEST | 9 | Population identifier (see list values); for AC households served in ES/SH/TH projects. |
| 20 | HHParentEST | 24 | Population identifier; the combination of household types in which clients were served in ES/SH/TH projects in a household that includes at least one member whose RelationshipToHoH is ‘Child’. |
| 21 | AC3PlusEST | 44 | Population identifier; indicates whether or not clients were served in ES/SH/TH projects in an AC household with 3 or more household members under 18. |
| 22 | AIREST | 24 | The combination of household types in which clients were active in residence for ES/SH/TH (i.e., were active in the report period other than an exit on ReportStart). |
| 23 | AIRHoHEST | 24 | The combination of household types in which clients were active in residence for ES/SH/TH (i.e., were active in the report period other than an exit on ReportStart) as head of household. |
| 24 | RRHAgeMin | 18 | The minimum age at the later of ReportStart and EntryDate for any RRH enrollment. |
| 25 | RRHAgeMax | 18 | The maximum age at the later of ReportStart and EntryDate for any RRH enrollment. |
| 26 | HHTypeRRH | 24 | The combination of household types in which clients were served in RRH projects. |
| 27 | HoHRRH | 24 | The combination of household types in which clients were served in RRH projects as HoH. |
| 28 | AdultRRH | 25 | The combination of household types in which clients were served in RRH projects as an adult. |
| 29 | AIRAdultRRH | 25 | The combination of household types in which adults had at least one RRH bednight in the report period. |
| 30 | HHChronicRRH | 24 | Population identifier; the combination of household types in which clients were served in RRH projects in household with a chronically homeless adult or HoH. |
| 31 | HHVetRRH | 25 | Population identifier; the combination of household types in which clients were served in RRH projects in household with a veteran. |
| 32 | HHDisabilityRRH | 24 | Population identifier; the combination of household types in which clients were served in RRH projects in household with a disabled adult or HoH. |
| 33 | HHFleeingDVRRH | 24 | Population identifier; the combination of household types in which clients were served in RRH projects in household with an adult or HoH fleeing domestic violence. |
| 34 | HHAdultAgeAORRH | 9 | Population identifier (see list values); for AO households served in RRH projects. |
| 35 | HHAdultAgeACRRH | 9 | Population identifier (see list values); for AC households served in RRH projects. |
| 36 | HHParentRRH | 24 | Population identifier; the combination of household types in which clients were served in RRH projects in a household that includes at least one member whose RelationshipToHoH is ‘Child’. |
| 37 | AC3PlusRRH | 44 | Population identifier; indicates whether or not clients were served in RRH projects in an AC household with 3 or more household members under 18. |
| 38 | AIRRRH | 24 | The combination of household types in which clients were active in residence for RRH (had at least one bed night during the report period in an RRH project). |
| 39 | AIRHoHRRH | 24 | The combination of household types in which clients were active in residence for RRH (had at least one bed night during the report period in an RRH project) as head of household. |
| 40 | PSHAgeMin | 18 | The minimum age at the later of ReportStart and EntryDate for any PSH enrollment. |
| 41 | PSHAgeMax | 18 | The maximum age at the later of ReportStart and EntryDate for any PSH enrollment. |
| 42 | HHTypePSH | 24 | The combination of household types in which clients were served in PSH projects. |
| 43 | HoHPSH | 24 | The combination of household types in which clients were served in PSH projects as HoH. |
| 44 | AdultPSH | 25 | The combination of household types in which clients were served in PSH projects as an adult. |
| 45 | AIRAdultPSH | 25 | The combination of household types in which adults had at least one PSH bednight in the report period. |
| 46 | HHChronicPSH | 24 | Population identifier; the combination of household types in which clients were served in PSH projects in household with a chronically homeless adult or HoH. |
| 47 | HHVetPSH | 25 | Population identifier; the combination of household types in which clients were served in PSH projects in household with a veteran. |
| 48 | HHDisabilityPSH | 24 | Population identifier; the combination of household types in which clients were served in PSH projects in household with a disabled adult or HoH. |
| 49 | HHFleeingDVPSH | 24 | Population identifier; the combination of household types in which clients were served in PSH projects in household with an adult or HoH fleeing domestic violence. |
| 50 | HHAdultAgeAOPSH | 9 | Population identifier (see list values); for AO households served in PSH projects. |
| 51 | HHAdultAgeACPSH | 9 | Population identifier (see list values); for AC households served in PSH projects. |
| 52 | HHParentPSH | 24 | Population identifier; the combination of household types in which clients were served in PSH projects in a household that includes at least one member whose RelationshipToHoH is ‘Child’. |
| 53 | AC3PlusPSH | 44 | Population identifier; indicates whether or not clients were served in PSH projects in an AC household with 3 or more household members under 18. |
| 54 | AIRPSH | 24 | The combination of household types in which clients were active in residence for PSH (had at least one bed night during the report period in a PSH project). |
| 55 | AIRHoHPSH | 24 | The combination of household types in which clients were active in residence for PSH (had at least one bed night during the report period in a PSH project) as HoH. |
| 56 | RRHSOAgeMin | 18 | The minimum age at the later of ReportStart and EntryDate for any RRH-SO enrollment. |
| 57 | RRHSOAgeMax | 18 | The maximum age at the later of ReportStart and EntryDate for any RRH-SO enrollment. |
| 58 | HHTypeRRHSONoMI | 24 | The combination of household types in which clients were served in RRH-SO projects with no move-in date |
| 59 | HHTypeRRHSOMI | 24 | The combination of household types in which clients were served in RRH-SO projects with a move-in date |
| 60 | HHTypeES | 24 | The combination of household types in which clients were served in ES projects. |
| 61 | HHTypeSH | 24 | The combination of household types in which clients were served in SH projects. |
| 62 | HHTypeTH | 24 | The combination of household types in which clients were served in TH projects. |
| 63 | HIV | 44 | Population identifier for adults diagnosed with HIV or AIDS and active in residence during the report period |
| 64 | SMI | 44 | Population identifier for adults with Serious Mental Illness and active in residence during the report period |
| 65 | SUD | 44 | Population identifier for adults with a Substance Use Disorder and active in residence during the report period |
| 66 | ReportID | Must match LSAReport.ReportID |
4 - LSAExit
All columns in LSAExit have a data type of integer; there must be a value present in every column of every row.
| # | Column Name | List | Description |
|---|---|---|---|
| 1 | RowTotal | 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. | |
| 2 | Cohort | 27 | Identifies which return cohort the household is in. These categories are not mutually exclusive. |
| 3 | Stat | 2 | Identifies the status of households at the start of the cohort period. |
| 4 | ExitFrom | 28 | Identifies the project type from which household exited. |
| 5 | ExitTo | 15 | Identifies the exit destination. |
| 6 | ReturnTime | 3 | 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. |
| 7 | HHType | [4](LSA Data Dictionary - Lists.md#4—hhtype | The household type. |
| 8 | HHVet | 5 | Identifies whether or not the household includes a veteran. |
| 9 | HHChronic | 43 | Identifies household status related to long-term/chronic homelessness |
| 10 | HHDisability | 5 | Identifies households with a disabled adult or HoH |
| 11 | HHFleeingDV | 48 | Identifies households fleeing domestic violence |
| 12 | HoHRaceEthnicity | 6 | Identifies race and ethnicity for head of household. |
| 13 | HHAdultAge | 9 | 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). |
| 14 | HHParent | 5 | Identifies whether or not any household member has RelationshiptoHoH = 2 (child of the HoH) on any active enrollment in the cohort period. |
| 15 | AC3Plus | 5 | Identifies AC households that include 3 or more children on any active enrollment in the cohort period. |
| 16 | SystemPath | 17 | 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. |
| 17 | ReportID | Must match LSAReport.ReportID |
5 - LSACalculated
All columns other than ProjectID (see below) have a data type of integer and must have a value.
| # | Column Name | List | Description |
|---|---|---|---|
| 1 | Value | The calculated report row value (average or count) as an integer | |
| 2 | Cohort | 29 | |
| 3 | Universe | 30 | |
| 4 | HHType | 31 | |
| 5 | Population | 32 | |
| 6 | SystemPath | 17 | |
| 7 | ProjectID | This is the only non-integer column in LSACalculated. Project-level counts (Universe = 10) for ReportRows 53-57 must include a ProjectID. Otherwise, this column must be NULL. | |
| 8 | ReportRow | 33 | |
| 9 | ReportID | Must match LSAReport.ReportID |
10 - Organization
| # | Column Name | DataType | Nullable | Description |
|---|---|---|---|---|
| 1 | OrganizationID | S(32) | 0 | |
| 2 | OrganizationName | S(200) | 0 | |
| 3 | VictimServiceProvider | L(5) | 0 | There must be a valid (0 or 1) response in this column. Neither NULL nor 99 are acceptable. |
| 4 | OrganizationCommonName | S(200) | 1 | n/a - will not be imported |
| 5 | DateCreated | DT | 0 | |
| 6 | DateUpdated | DT | 0 | |
| 7 | UserID | S(32) | 1 | n/a - will not be imported |
| 8 | DateDeleted | DT | 1 | Must be NULL |
| 9 | ExportID | S(32) | 0 | Must match LSAReport.ReportID |
11 - Project
| # | Column Name | DataType | Nullable | Description |
|---|---|---|---|---|
| 1 | ProjectID | S(32) | 0 | |
| 2 | OrganizationID | S(32) | 0 | |
| 3 | ProjectName | S(200) | 0 | |
| 4 | ProjectCommonName | S(200) | 1 | n/a - will not be imported |
| 5 | OperatingStartDate | D | 0 | |
| 6 | OperatingEndDate | D | 1 | |
| 7 | ContinuumProject | I | 0 | Must = 1 |
| 8 | ProjectType | L(34) | 0 | |
| 9 | HousingType | L(37) | 1 | |
| 10 | RRHSubType | L(35) | 1 | Must be NULL unless ProjectType = 13; if not NULL, must be in (1,2) |
| 11 | ResidentialAffiliation | L(5) | 1 | Must be NULL unless RRHSubType = 1; if not NULL, must be in (0,1) |
| 12 | TargetPopulation | L(36) | 1 | |
| 13 | HOPWAMedAssistedLivingFac | L(45) | 1 | |
| 14 | PITCount | I | 1 | |
| 15 | DateCreated | DT | 0 | |
| 16 | DateUpdated | DT | 0 | |
| 17 | UserID | S(32) | 1 | n/a - will not be imported |
| 18 | DateDeleted | DT | 1 | Must be NULL |
| 19 | ExportID | S(32) | 0 | Must match LSAReport.ReportID |
12 - Funder
| # | Column Name | DataType | Nullable | Description |
|---|---|---|---|---|
| 1 | FunderID | S(32) | 0 | |
| 2 | ProjectID | S(32) | 0 | |
| 3 | Funder | L(38) | 0 | |
| 4 | OtherFunder | S(100) | 1 | |
| 5 | GrantID | S(100) | 1 | n/a - will not be imported |
| 6 | StartDate | D | 0 | |
| 7 | EndDate | D | 1 | |
| 8 | DateCreated | DT | 0 | |
| 9 | DateUpdated | DT | 0 | |
| 10 | UserID | S(32) | 1 | n/a - will not be imported |
| 11 | DateDeleted | DT | 1 | Must be NULL |
| 12 | ExportID | S(32) | 0 | Must match LSAReport.ReportID |
13 - ProjectCoC
| # | Column Name | DataType | Nullable | Description |
|---|---|---|---|---|
| 1 | ProjectCoCID | S(32) | 0 | |
| 2 | ProjectID | S(32) | 0 | |
| 3 | CoCCode | S(6) | 0 | Must match LSAReport. ReportCoC |
| 4 | Geocode | S(6) | 0 | |
| 5 | Address1 | S(100) | 1 | |
| 6 | Address2 | S(100) | 1 | |
| 7 | City | S(50) | 1 | |
| 8 | State | S(2) | 1 | |
| 9 | ZIP | S(5) | 0 | |
| 10 | GeographyType | L(42) | 0 | |
| 11 | DateCreated | DT | 0 | |
| 12 | DateUpdated | DT | 0 | |
| 13 | UserID | S(32) | 1 | n/a - will not be imported |
| 14 | DateDeleted | DT | 1 | Must be NULL |
| 15 | ExportID | S(32) | 0 | Must match LSAReport.ReportID |
14 - Inventory
| # | Column Name | DataType | Nullable | Description |
|---|---|---|---|---|
| 1 | InventoryID | S(32) | 0 | |
| 2 | ProjectID | S(32) | 0 | |
| 3 | CoCCode | S(6) | 0 | Must match LSAReport. ReportCoC |
| 4 | HouseholdType | L(39) | 0 | |
| 5 | Availability | L(40) | 1 | |
| 6 | UnitInventory | I | 0 | |
| 7 | BedInventory | I | 0 | |
| 8 | CHVetBedInventory | I | 0 | |
| 9 | YouthVetBedInventory | I | 0 | |
| 10 | VetBedInventory | I | 0 | |
| 11 | CHYouthBedInventory | I | 0 | |
| 12 | YouthBedInventory | I | 0 | |
| 13 | CHBedInventory | I | 0 | |
| 14 | OtherBedInventory | I | 0 | |
| 15 | ESBedType | L(41) | 1 | |
| 16 | InventoryStartDate | D | 0 | |
| 17 | InventoryEndDate | D | 1 | |
| 18 | DateCreated | DT | 0 | |
| 19 | DateUpdated | DT | 0 | |
| 20 | UserID | S(32) | 1 | n/a - will not be imported |
| 21 | DateDeleted | DT | 1 | Must be NULL |
| 22 | ExportID | S(32) | 0 | Must match LSAReport.ReportID |
15 - HMISParticipation
| # | Column Name | DataType | Nullable | Description |
|---|---|---|---|---|
| 1 | HMISParticipationID | S(32) | 0 | |
| 2 | ProjectID | S(32) | 0 | Must match a ProjectID in Project.csv |
| 3 | HMISParticipationType | L(47) | 0 | |
| 4 | HMISParticipationStatusStartDate | DT | 0 | |
| 5 | HMISParticipationStatusEndDate | DT | 1 | |
| 6 | DateCreated | DT | 0 | |
| 7 | DateUpdated | DT | 0 | |
| 8 | UserID | S(32) | 1 | n/a - will not be imported |
| 9 | DateDeleted | DT | 1 | Must be NULL |
| 10 | ExportID | S(32) | 0 | Must match LSAReport.ReportID |
16 - Affiliation
| # | Column Name | DataType | Nullable | Description |
|---|---|---|---|---|
| 1 | AffiliationID | S(32) | 0 | |
| 2 | ProjectID | S(32) | 0 | Must match a ProjectID in Project.csv where RRHSubType = 1 |
| 3 | ResProjectID | S(32) | 0 | Must match a ProjectID in Project.csv where RRHSubType is null or 0 |
| 4 | DateCreated | DT | 0 | |
| 5 | DateUpdated | DT | 0 | |
| 6 | UserID | S(32) | 1 | n/a - will not be imported |
| 7 | DateDeleted | DT | 1 | Must be NULL |
| 8 | ExportID | S(32) | 0 | Must match LSAReport.ReportID |