Skip to content

README.md

Latest commit

 

History

History
55 lines (39 loc) · 2.66 KB

README.md

File metadata and controls

55 lines (39 loc) · 2.66 KB
Raw

LSA Sample Code Repository

The Longitudinal System Analysis (LSA) is:

  • A report to the US Department of Housing and Urban Development (HUD) as
  • A zip file containing 12 Comma-Separated Values (CSV) files
  • Generated by a Homeless Management Information System (HMIS)
  • For Continuums of Care for the Homeless (CoCs)
  • Submitted annually as a systemwide year-long report used to produce HUD's Annual Homelessness Assessment Report (AHAR) to Congress and
  • Submitted annually as a systemwide single-day report as HUD's Housing Inventory Count (HIC) and
  • Provides the data for Stella, HUD's strategy and analysis tool for CoCs, available on HDX 2.0.

This repository hosts programming specifications, sample code, and sample data specific to the LSA. Its purpose is to provide a space for reconciling the LSA specifications with HMIS data to produce accurate reporting.

Specifications

A working version of the programming specifications is maintained in markdown files in the /docs folder of this repository. The current version is hosted on GitHub pages at https://hmis.github.io/LSASampleCode/.

Code

The sample code is SQL, and written in SQL Server. Originally, it was not intended for public release -- it was written concurrent with the first version of the specs (FY2018) as a check to make sure the specs were specific enough. It was released on GitHub as a reference.

Sample Data

The Sample Data file above includes five ZIP files:

  • Sample HMIS Data - HMIS CSV files
  • Sample LSA Output - LSA CSV files generated by the LSA Sample Code based on the HMIS CSV files using general parameters
  • Sample LSA Temp Tables - CSV files of exported data from the temporary tables created by the LSA sample code
  • Sample HIC Output - LSA CSV files generated by the LSA sample code based on the HMIS CSV files using HIC parameters
  • Sample HIC Temp Tables - CSV files of exported data from the temporary tables with HIC parameters

Dependencies

In order to run the code as is, a user must have access to a SQL Server (or SQL Server Express) database with:

  • Permissions that allow creating tables, inserting records, and exporting CSV files.
  • HMIS data in tables modeled after the HMIS CSV format. Naming conventions for tables use an hmis_ prefix with the CSV file name -- e.g., hmis_Project.

Specifically, the LSA sample code requires the tables listed below. Only records where DateDeleted is NULL are relevant.

  • hmis_Organization
  • hmis_Project
  • hmis_Funder
  • hmis_ProjectCoC
  • hmis_Inventory
  • hmis_Affiliation
  • hmis_HMISParticipation
  • hmis_Client
  • hmis_Enrollment
  • hmis_Exit
  • hmis_Services
  • hmis_HealthAndDV
  • hmis_Disabilities