{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","User Entry","DATA","errors","Export","Organization","Project","Enrollment","EnrollmentCoC","Client","Exit"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":92,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"HUD-VASH HOMES to HMIS .csv translator"]
[]
[null,"The purpose of this tool is to create an HMIS .csv export out of a HUD-VASH HOMES .csv export file. The HMIS .csv export file is a HUD standard format that can be used to import HOMES data to a local HMIS, in order to provide a more comprehensive count of persons experiencing homelessness in a community."]
[]
[null,"These are the steps to produce the HMIS export:"]
[]
[null,"First, you must have a HOMES export file in .csv (comma-separated values) format. Please contact your local HOMES database representative if you do not know how to obtain this. You will need to note the date range of the export for the next step."]
[]
[null,"Second, there are HUD-required fields in the HMIS export that are not found in the HOMES export that must be filled out. These fields include the CoC code of the jurisdiction exporting the data, the name of the HOMES database, the date range of the export, the name of the organization collecting the data in HOMES, the name of the project, and finally, the HMIS id's of the organization and project. You can obtain these id's from your local HMIS system administrator."]
[]
[null,"In addition to the required fields, you may elect to fill out your own contact information, or the contact information of the HOMES database representative who can deal with issues relating to the HMIS data import."]
[]
[null,"An entry in the \"Optional SourceName\" field will appear in the SourceName column of the Export.csv file. If no value is entered, then \"HOMES\" will be written automatically in that column. An entry in the \"Optional SourceID\" field will appear in the SourceID column of the Export.csv file. If no valued is entered, then the CoC number (eg. XX-100) will be entered according to the HMIS .csv specifications file."]
[null,"Third, after you have a HOMES .csv file and have filled out the required fields, press the \"Import HOMES data\" on the Userform tab of this workbook. You will be prompted to locate the .csv file on your computer through a dialog box. The data on the file and the information you entered on the required fields will be translated into the required format."]
[null,"HOMES data will often have missing information, compared to what is normally required in an HMIS. That is not a problem except in the following cases:\n   The PersonalID of a record is missing\n   The EnrollmentID of a record is missing\n   The FirstName or LastName of a record is missing\n   The EntryDate of a record is missing\n   The record contains an exit destination but is missing an ExitDate\nIf any of the above is true for a record within the HOMES .csv file (a single line of information), then the record will NOT be processed but rather copied to a worksheet called \"errors\", where the information may be inspected and corrected in the HOMES system before further processing."]
[null,"Finally, press the \"Export HMIS CSV\" button. You will be prompted to select a location or folder to save the HMIS .csv export. The files will be exported and compressed in a zipped folder to the selected location. This constitutes an HMIS .csv export file, which can then be imported to your local HMIS."]
[]
[null,"The zipped folder should contain the following 7 .csv files:\n     Client.csv\n     Enrollment.csv\n     EnrollmentCoC.csv\n     Exit.csv\n     Export.csv\n     Organization.csv\n     Project.csv"]

{"sheet":"User Entry","index":1,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Required information"]
["UserID"]
[]
["HUD CoC code (SourceID)"]
["Name of source database","HOMES"]
["Export start date"]
["Export end date"]
["Organization name"]
["Project name"]
["HMIS Project ID"]
["HMIS Organization ID"]
[]
[null,"Optional contact information"]
["First Name"]
["Last Name"]
["Phone Number"]
["Ext. (if applicable)"]
["E-mail address"]
[]
["Optional SourceName"]
["Optional SourceID"]
[]
[]
["Export.csv"]
["Organization.csv"]
["Project.csv"]
["Enrollment.csv"]
["EnrollmentCoC.csv"]
["Client.csv"]
["Exit.csv"]

{"sheet":"DATA","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"errors","index":3,"n_rows":1,"n_cols":2023,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIPacific","White","Ethnicity","Female","Male","NoSingleGender","Transgender","Questioning","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated",null,null,null,null,null,null,null,null,null,null,"PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated","PersonalID","EnrollmentID","FirstName","MiddleName","LastName","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIOtherPacific","White","Ethnicity","Gender","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","AssessmentFormDateCreated","AssessmentFormDateUpdated","VAMCStation","RelationshipToHoH","DisablingCondition","EntryFormDateCreated","EntryFormDateUpdated","EntryDate","PHACode","PHAName","LivingSituation","LengthOfStay","LOSUnderThreshold","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","MoveInDate","HPFDateCreated","HPFDateUpdated","ExitDate","Destination","ExitDateCreated"]

{"sheet":"Export","index":4,"n_rows":1,"n_cols":18,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["ExportID","SourceType","SourceID","SourceName","SourceContactFirst","SourceContactLast","SourceContactPhone","SourceContactExtension","SourceContactEmail","ExportDate","ExportStartDate","ExportEndDate","SoftwareName","SoftwareVersion","CSVVersion","ExportPeriodType","ExportDirective","HashStatus"]

{"sheet":"Organization","index":5,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrganizationID","OrganizationName","VictimServiceProvider","OrganizationCommonName","DateCreated","DateUpdated","UserID","DateDeleted","ExportID"]

{"sheet":"Project","index":6,"n_rows":1,"n_cols":20,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["ProjectID","OrganizationID","ProjectName","ProjectCommonName","OperatingStartDate","OperatingEndDate","ContinuumProject","ProjectType","HousingType","ResidentialAffiliation","TrackingMethod","HMISParticipatingProject","TargetPopulation","HOPWAMedAssistedLivingFac","PITCount","DateCreated","DateUpdated","UserID","DateDeleted","ExportID"]

{"sheet":"Enrollment","index":7,"n_rows":1,"n_cols":72,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["EnrollmentID","PersonalID","ProjectID","EntryDate","HouseholdID","RelationshipToHoH","LivingSituation","LengthOfStay","LOSUnderThreshold","PreviousStreetESSH","DateToStreetESSH","TimesHomelessPastThreeYears","MonthsHomelessPastThreeYears","DisablingCondition","DateOfEngagement","MoveInDate","DateOfPATHStatus","ClientEnrolledInPATH","ReasonNotEnrolled","WorstHousingSituation","PercentAMI","LastPermanentStreet","LastPermanentCity","LastPermanentState","LastPermanentZIP","AddressDataQuality","ReferralSource","CountOutreachReferralApproaches","DateOfBCPStatus","EligibleForRHY","ReasonNoServices","RunawayYouth","SexualOrientation","SexualOrientationOther","FormerWardChildWelfare","ChildWelfareYears","ChildWelfareMonths","FormerWardJuvenileJustice","JuvenileJusticeYears","JuvenileJusticeMonths","UnemploymentFam","MentalHealthDisorderFam","PhysicalDisabilityFam","AlcoholDrugUseDisorderFam","InsufficientIncome","IncarceratedParent","VAMCStation","TargetScreenReqd","TimeToHousingLoss","AnnualPercentAMI","LiteralHomelessHistory","ClientLeaseholder","HOHLeaseholder","SubsidyAtRisk","EvictionHistory","CriminalRecord","IncarceratedAdult","PrisonDischarge","SexOffender","DisabledHoH","CurrentPregnant","SingleParent","DependentUnder6","HH5Plus","CoCPrioritized","HPScreeningScore","ThresholdScore","DateCreated","DateUpdated","UserID","DateDeleted","ExportID"]

{"sheet":"EnrollmentCoC","index":8,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["EnrollmentCoCID","EnrollmentID","HouseholdID","ProjectID","PersonalID","InformationDate","CoCCode","DataCollectionStage","DateCreated","DateUpdated","UserID","DateDeleted","ExportID"]

{"sheet":"Client","index":9,"n_rows":1,"n_cols":41,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["PersonalID","FirstName","MiddleName","LastName","NameSuffix","NameDataQuality","SSN","SSNDataQuality","DOB","DOBDataQuality","AmIndAKNative","Asian","BlackAfAmerican","NativeHIPacific","White","RaceNone","Ethnicity","Female","Male","NoSingleGender","Transgender","Questioning","GenderNone","VeteranStatus","YearEnteredService","YearSeparated","WorldWarII","KoreanWar","VietnamWar","DesertStorm","AfghanistanOEF","IraqOIF","IraqOND","OtherTheater","MilitaryBranch","DischargeStatus","DateCreated","DateUpdated","UserID","DateDeleted","ExportID"]

{"sheet":"Exit","index":10,"n_rows":1,"n_cols":43,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["ExitID","EnrollmentID","PersonalID","ExitDate","Destination","OtherDestination","HousingAssessment","SubsidyInformation","ProjectCompletionStatus","EarlyExitReason","ExchangeForSex","ExchangeForSexPastThreeMonths","CountOfExchangeForSex","AskedOrForcedToExchangeForSex","AskedOrForcedToExchangeForSexPastThreeMonths","WorkPlaceViolenceThreats","WorkplacePromiseDifference","CoercedToContinueWork","LaborExploitPastThreeMonths","CounselingReceived","IndividualCounseling","FamilyCounseling","GroupCounseling","SessionCountAtExit","PostExitCounselingPlan","SessionsInPlan","DestinationSafeClient","DestinationSafeWorker","PosAdultConnections","PosPeerConnections","PosCommunityConnections","AftercareDate","AftercareProvided","EmailSocialMedia","Telephone","InPersonIndividual","InPersonGroup","CMExitReason","DateCreated","DateUpdated","UserID","DateDeleted","ExportID"]