Changes for new format - dual elig - Githubissues

PHSKC-APDE / claims_data

Process and analyze WA State Medicaid, Medicare, and All-Payer Claims Database eligibility and claims data

21 stars 4 forks source link

Changes for new format - dual elig #187

Open alastairmatheson opened 4 weeks ago

alastairmatheson commented 4 weeks ago

Need to update column name renaming from DUAL_ELIG to DUALELIGIBLE_INDICATOR https://github.com/PHSKC-APDE/claims_data/blob/44a68d7b57504a3311d7199e13e057571191d382/claims_db/phclaims/stage/tables/load_stage.mcaid_elig_timevar.R#L97

Change CASE_WHEN logic to account for new values in dual column: https://github.com/PHSKC-APDE/claims_data/blob/44a68d7b57504a3311d7199e13e057571191d382/claims_db/phclaims/stage/tables/load_stage.mcaid_elig_timevar.R#L436

CASE WHEN a.dual in ('DuelEligible', 'PartialDual', 'Y') THEN 1 ELSE 0 END AS dual