HUD HMIS CSV/XML Program Data Export: FY 2022+ Updates

Old (Clarity) Report

Reworked (Pentaho) Report

Headers in all CSV files

Each column name is in double quotes

Double quotes are not used

ExportID in all CSV files

Unique

Unique per instance 

Based on Report Execution ID

Dates in all CSV files

Quotes have been removed

Export.csv

SoftwareName = “Clarity Human Services” hardcoded to be consistent with other Federal reports

Organization.csv

OrganizationName and OrganizationCommonName are not limited to 50 symbols but spec requires this limit

OrganizationName and OrganizationCommonName are limited to 50 symbols according to the spec

ProjectCoC.csv

ProjectCoCID has 2 formats:

• If Project Site exists, then ProjectCoCID is a “ClarityProjectCoCId_ClarityProjectSiteId” hybrid
• If Project Site does not exist, then ProjectCoCID = “ClarityProjectCoCId”

ProjectCoCID = ClarityProjectCoCId

Inventory.csv

InventoryID is a “ClarityInventoryID_ProjectID” hybrid

InventoryID = ClarityInventoryID because it is not possible to link an inventory report with multiple programs

Affiliation.csv

AffiliationID is auto increment with step = 1 started with 1

AffiliationID is a hybrid “ProjectID_ResProjectID”

EnrollmentCoC.csv

EnrollmentCoCID = EnrollmentID and it was unique because only enroll screen was checked

EnrollmentCoCID is ID of the client program screen where client location was entered because client location can be entered not on enrollment screen only

Disabilities.csv

DisabilitiesID is auto increment with step = 1 started with 1

DisabilitiesID is a hybrid “XXX_YYY” where:

• “XXX” is the first letter of disability in upper case. (P/D/C/H/M/S)
• “YYY” is ID of the client program screen

Services.csv

ServicesID = either ClientServiceId or ClientServiceDateId, but it can be a situation when ClientServiceId = ClientServiceDateId so ServicesID unique logic is broken

To ensure ServicesID are unique,  a hybrid is used (“XXX_YYY”), where:

• “XXX” is either “d” (for attendance services) or “s” for long-term or single-event services;
  • 2023 Update
    • Night by Night Emergency Shelter Bed Nights have a "d" or "s" prefix. "d" prefix represents daily attendance delivery type and "s" represents single event delivery type. 

• “YYY” is either ClientServiceDateId  (for attendance services) or  ClientServiceId for long-term or single-event services

Assessment.csv

AssessmentID = ClarityClientAssessmentId

AssessmentID is a hybrid “ClarityClientAssessmentId_EnrollmentId”

AssessmentQuestions.csv

AssessmentID = ClarityClientAssessmentId;

AssessmentQuestionID  is a hybrid “AssessmentID_ScreenFieldId”

AssessmentID is a hybrid “ClarityClientAssessmentId_EnrollmentId”

AssessmentQuestionID  is a hybrid “ClarityClientAssessmentId_EnrollmentId_ScreenFieldPosition”

AssessmentResults.csv

AssessmentID = ClarityClientAssessmentId;

AssessmentResultID  is a hybrid “ClarityClientAssessmentId_ScoreName”

AssessmentID is a hybrid “ClarityClientAssessmentId_EnrollmentId”;

AssessmentResultID =
UniqueIdentifier_ScoreName