Bug in CMS HCC Disease Factor Seed

[sarah-tuva]

Bug reported in Slack:

also noticed that for HCC 108-189, the institutional_status field is NULL. i think these should be "No" but want a second opinion. we're defaulting institutional_status to "No" for members in _int_members, coefficients for these HCCs are dropping out in this join:
from demographics_with_hccs
inner join seed_disease_factors
on demographics_with_hccs.enrollment_status = seed_disease_factors.enrollment_status
and demographics_with_hccs.medicaid_status = seed_disease_factors.medicaid_status
and demographics_with_hccs.dual_status = seed_disease_factors.dual_status
and demographics_with_hccs.orec = seed_disease_factors.orec
and demographics_with_hccs.institutional_status = seed_disease_factors.institutional_status
and demographics_with_hccs.hcc_code = seed_disease_factors.hcc_code