The Code That You Want (New Picklist Values)
Trying to fix your broken ART reports? Isn't it great going through all your variables and report filters to be sure you've got all the picklist values changed to match the new standards? It's way better than a poke in the eye!
Even though it's still a lot of work, this should make things easier- you can copy/paste these into any InList() function as needed and I'm pretty sure they're correct... please comment if you find an issue. I am only including the most common ones.
Don't Know/Refused:
"Client doesn't know (HUD)";"Client refused (HUD)"
To pull Missings:
IsNull([whatever]) or InList("Data not collected (HUD)")
Any field with the Enhanced Yes/No picklist (like "Receiving Income from Any Source?" and MANY others):
"Yes (HUD)";"No (HUD)";"Client doesn't know (HUD)";"Client refused (HUD)";"Data not collected (HUD)"
Gender:
"Male"; "Female"; "Trans Male (FTM or Female to Male)"; "Trans Female (MTF or Male to Female)"; "Gender Non-Conforming (i.e. not exclusively male or female)"; "Client doesn't know"; "Client refused"; "Data not collected"
Relationship to HoH:
"Self (head of household)"; "Head of household's spouse or partner"; "Head of household's other relation member (other relation to head of household)"; "Head of household's child"; "Other: non-relation member"; "Data not collected"
Ethnicity:
"Non-Hispanic/Non-Latino (HUD)"; "Hispanic/Latino (HUD)"; "Client doesn't know (HUD)"; "Client refused (HUD)"; "Data not collected (HUD)"
Residence Prior:
"Place not meant for habitation (HUD)"; "Emergency shelter, incl. hotel/motel paid for w/ ES voucher, or RHY-funded Host Home shelter (HUD)"; "Safe Haven (HUD)"; "Foster care home or foster care group home (HUD)"; "Hospital or other residential non-psychiatric medical facility (HUD)"; "Jail, prison or juvenile detention facility (HUD)"; "Long-term care facility or nursing home (HUD)"; "Psychiatric hospital or other psychiatric facility (HUD)"; "Substance abuse treatment facility or detox center (HUD)"; "Hotel or motel paid for without emergency shelter voucher (HUD)"; "Host Home (non-crisis) (HUD)"; "Owned by client, no ongoing housing subsidy (HUD)"; "Owned by client, with ongoing housing subsidy (HUD)"; "Permanent housing (other than RRH) for formerly homeless persons (HUD)"; "Rental by client, no ongoing housing subsidy (HUD)"; "Rental by client, with VASH housing subsidy (HUD)"; "Rental by client, with GPD TIP housing subsidy (HUD)"; "Rental by client, with RRH or equivalent subsidy (HUD)"; "Rental by client, with HCV voucher (tenant or project based) (HUD)"; "Rental by client in a public housing unit (HUD)"; "Rental by client, with other ongoing housing subsidy (HUD)"; "Residential project or halfway house with no homeless criteria (HUD)"; "Staying or living in a family member's room, apartment or house (HUD)"; "Staying or living in a friend's room, apartment or house (HUD)"; "Transitional housing for homeless persons (including homeless youth) (HUD)"; "Client doesn't know (HUD)"; "Client refused (HUD)"; "Data not collected (HUD)"
Race:
"White (HUD)"; "Black or African American (HUD)"; "Asian (HUD)"; "American Indian or Alaska Native (HUD)"; "Native Hawaiian or Other Pacific Islander (HUD)"; "Client doesn't know (HUD)"; "Client refused (HUD)"; "Data not collected (HUD)"
Program Type Code:
"Emergency Shelter (HUD)";"Homelessness Prevention (HUD)";"PH - Permanent Supportive Housing (disability required for entry) (HUD)";"PH - Rapid Re-Housing (HUD)";"Transitional housing (HUD)";"Safe Haven (HUD)";"Services Only (HUD)";"Street Outreach (HUD)";"Other (HUD)";"Coordinated Assessment (HUD)";"PH - Housing only (HUD)";"PH - Housing with services (no disability required for entry) (HUD)";"Day Shelter (HUD)"
Permanent Destinations:
"Staying or living with family, permanent tenure (HUD)"; "Staying or living with friends, permanent tenure (HUD)"; "Moved from one HOPWA funded project to HOPWA PH (HUD)"; "Owned by client, with ongoing housing subsidy (HUD)"; "Owned by client, no ongoing housing subsidy (HUD)"; "Permanent housing (other than RRH) for formerly homeless persons (HUD)"; "Rental by client, with GPD TIP housing subsidy (HUD)"; "Rental by client, with VASH housing subsidy (HUD)"; "Rental by client, with RRH or equivalent subsidy (HUD)"; "Rental by client, with HCV voucher (tenant or project based) (HUD)"; "Rental by client in a public housing unit (HUD)"; "Rental by client, no ongoing housing subsidy (HUD)"; "Rental by client, with other ongoing housing subsidy (HUD)"
Temporary Destinations:
"Place not meant for habitation (HUD)"; "Emergency shelter, incl. hotel/motel paid for w/ ES voucher, or RHY-funded Host Home shelter (HUD)"; "Safe Haven (HUD)"; "Residential project or halfway house with no homeless criteria (HUD)"; "Hotel or motel paid for without emergency shelter voucher (HUD)"; "Transitional housing for homeless persons (including homeless youth) (HUD)"; "Host Home (non-crisis) (HUD)"; "Staying or living with friends, temporary tenure (HUD)"; "Staying or living with family, temporary tenure (HUD)"; "Moved from one HOPWA funded project to HOPWA TH (HUD)"
Institutional Destinations:
"Foster care home or foster care group home (HUD)"; "Hospital or other residential non-psychiatric medical facility (HUD)"; "Jail, prison or juvenile detention facility (HUD)"; "Long-term care facility or nursing home (HUD)"; "Psychiatric hospital or other psychiatric facility (HUD)"; "Substance abuse treatment facility or detox center (HUD)"
Other Destinations:
"Deceased (HUD)"; "Other (HUD)"
Missing Destinations:
"No exit interview completed (HUD)";"Data not collected (HUD)";"Client doesn't know (HUD)";"Client refused (HUD)"
All the Destinations together!
"Foster care home or foster care group home (HUD)"; "Hospital or other residential non-psychiatric medical facility (HUD)"; "Jail, prison or juvenile detention facility (HUD)"; "Long-term care facility or nursing home (HUD)"; "Psychiatric hospital or other psychiatric facility (HUD)"; "Substance abuse treatment facility or detox center (HUD)"; "Place not meant for habitation (HUD)"; "Emergency shelter, incl. hotel/motel paid for w/ ES voucher, or RHY-funded Host Home shelter (HUD)"; "Safe Haven (HUD)"; "Residential project or halfway house with no homeless criteria (HUD)"; "Hotel or motel paid for without emergency shelter voucher (HUD)"; "Transitional housing for homeless persons (including homeless youth) (HUD)"; "Host Home (non-crisis) (HUD)"; "Staying or living with friends, temporary tenure (HUD)"; "Staying or living with family, temporary tenure (HUD)"; "Moved from one HOPWA funded project to HOPWA TH (HUD)"; "Moved from one HOPWA funded project to HOPWA PH (HUD)"; "Owned by client, with ongoing housing subsidy (HUD)"; "Owned by client, no ongoing housing subsidy (HUD)"; "Permanent housing (other than RRH) for formerly homeless persons (HUD)"; "Rental by client, with GPD TIP housing subsidy (HUD)"; "Rental by client, with VASH housing subsidy (HUD)"; "Rental by client, with RRH or equivalent subsidy (HUD)"; "Rental by client, with HCV voucher (tenant or project based) (HUD)"; "Rental by client in a public housing unit (HUD)"; "Rental by client, no ongoing housing subsidy (HUD)"; "Rental by client, with other ongoing housing subsidy (HUD)"; "Staying or living with family, permanent tenure (HUD)"; "Staying or living with friends, permanent tenure (HUD)"; "No exit interview completed (HUD)"; "Other (HUD)"; "Deceased (HUD)"; "Client doesn't know (HUD)"; "Client refused (HUD)"; "Data not collected (HUD)"
Regardless of where they stayed last night, number of times homeless in past three years:
"One time (HUD)"; "Two times (HUD)"; "Three times (HUD)"; "Four or more times (HUD)"; "Client doesn't know (HUD)"; "Client refused (HUD)"; "Data not collected (HUD)"
Number of months homeless in the past three years:
"One month (this time is the first month) (HUD)"; "2"; "3"; "4"; "5"; "6"; "7"; "8"; "9"; "10"; "11"; "12"; "More than 12 Months (HUD)"; "Client doesn't know (HUD)"; "Client refused (HUD)"; "Data not collected (HUD)"
If you notice any discrepancies here or if there are other picklists you find yourself looking up a lot, please please comment!!