By-Name List (BNL) Template to Homeless Management Information System (HMIS) Crosswalk
Crosswalk Overview
The table below crosswalks columns found on the VA BNL Template to fields in HMIS.
For questions, contact VHABNLSupport@va.gov.
| BNL Template Column (Bold Denotes Required) | VA BNL Template Column Name | HMIS Field Name | Notes |
|---|---|---|---|
| A | Veteran Last Name | Last Name | |
| B | Veteran First Name | First Name | |
| D | Veteran HMIS Client Identifier | Personal ID | |
| E | Veteran HOMES Client Identifier | N/A | |
| F | Continuum of Care | Enrollment CoC | |
| G | Veteran Sex | Sex | Only required for certain federally-funded programs; not mapped to previous data elements so likely missing for Veterans with older enrollments |
| H | Veteran DOB | Date of Birth | |
| I | Current Veteran Age | Can be derived from Current Date – Date of Birth | |
| J | List Status | N/A | |
| K | List Status Change Date | N/A | |
| L | Date Veteran Identified as Homeless | Can potentially be derived from other HMIS dates (Entry, approximate date of homelessness, etc.) | |
| M | Length of Time Homeless (LOT) Prior to Identification | 3.917.5 Total number of months homeless on the street, in ES, or SH in the past three years | For 3.917B (entry to projects not ES/SH/SO), question is only asked if response to “Type of Residence” is a Homeless Situation (values 100-199) |
| N | Last Review/Update | Information Date where (For non-residential project types) | |
| O | Household Size | can be derived from number of Personal IDs with same Household or Enrollment ID | |
| P | Veteran Status? | Veteran Status (Response options are yes/no/unknown in HMIS) | |
| Q | VHA HC Eligible? | N/A | |
| R | Other VHA Program Eligible? | N/A | |
| S | Assigned Agency | Organization Name of current project enrollment | |
| T | Assigned Housing Navigation Staff | N/A | |
| U | Assigned Case Manager | N/A | |
| V | Date of Initial Program Entry | Project Start Date | |
| W | Date of Placement into ES/TH | Project Start Date where Project Type is ES or TH | |
| X | Current Project Enrollment Type of Service | Project Type of current project enrollment | |
| Y | Additional Service/Enrollments | Can be derived from other project enrollments — Enrollment IDs, Project IDs, and Project types | |
| Z | Housing Pathway | N/A | |
| AA | Date Permanent Housing Plan Created | N/A | |
| AB | Permanent Housing Plan Notes | N/A | |
| AC | Expected Permanent Housing Date | N/A | |
| AD | Exit Destination – Permanent Housing | Destination where a Permanent Housing Situation (400-499) | |
| AE | Date of Permanent Housing Placement | Housing Move-in Date for PH project enrollments AND/OR Exit Date where Destination is a Permanent Housing Situation (400-499) | Housing Move-in Date only used for PH project types |
| AF | Exit Destination – Other (non-PH, non-literally homeless) | Destination where NOT a Permanent Housing Situation (400-499) or Homeless Situation (100-199) | |
| AG | Date of Other Exit | Exit Date where Destination is NOT a Permanent Housing Situation (400-499) or Homeless Situation (100-199) | |
| AH | Additional Information | N/A | |
| AI | County Location (If applicable for PHA) | N/A (Can use City, State, Zip of Project currently enrolled in) | |
| AJ | Client Phone | N/A | |
| AK | Client Email | N/A | |
| AL | Last Known Client Location/Provider | Can be derived from the last Enrollment ID-> Project ID-> Project Name and Organization Name and Enrollment CoC on that enrollment | |
| BB | Days Since Veteran Identified | Current date – Date Veteran Identified as Homeless | |
| BC | Days from Unsheltered to Interim Housing | Calculated from Date Identified to Date Placement into ES/TH | |
| BD | Days from Veteran Identification to Housing Plan Creation | N/A | |
| BE | Days Since Veteran Permanent Housing Plan Created | N/A | |
| BF | Days from Identification to Permanent Housing | Date of Permanent Housing Placement – Date Veteran Identified | |
| BG | Days Since Permanent Housing Placement | Current date – Date of Permanent Housing Placement |