fix fixture generation
add new rows to all_hmis_report
add a fixture generating available locations for a given user