search

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

Add all component vars to combined mcaid_mcare_elig tables #43

Closed alastairmatheson closed 4 years ago

alastairmatheson commented 4 years ago

Right now the elig_timevar tables have an apde_dual field, which signifies when we observed people to be concurrently enrolled in Medicaid and Medicare. However, since the Medicare data lags Medicaid, that field is always 0 after the end of the Medicare date range (currently '2016-12-31'), even when the person likely remains a dual (e.g., look at IDs where from_date = '2017-01-01' and contiguous = 1 and mcaid = 1).

We need a way to remove duals from more recent analyses. Can we add another dual column in that keeps the P1/Medicaid dual flag in these timevar tables?

alastairmatheson commented 4 years ago

Since we are moving to just using combined mcaid_mcare[_pha]_elig tables, we want all components to come through. Currently missing:

elikern-kc commented 4 years ago

Thanks for pointing this out. I think the idea of keeping the ProviderOne Medicaid dual flag in the mcaid_mcare_elig_timevar table is a great idea.

Best, Eli

Eli Kern MPH RN | Epidemiologist Assessment, Policy Development, and Evaluation Public Health - Seattle and King Countyhttps://owa.kingcounty.gov/owa/redir.aspx?C=TNuruUR_x0mMeOqn6rueKCfnLzCcxdAICR3iDfSS8atu12V25XSLIp_1k_j_A9NKOb-a_2dkPVw.&URL=http%3a%2f%2fwww.kingcounty.gov%2fhealthservices%2fhealth.aspx phone: 206.263.8727 | email: eli.kern@kingcounty.govhttps://owa.kingcounty.gov/owa/redir.aspx?C=TNuruUR_x0mMeOqn6rueKCfnLzCcxdAICR3iDfSS8atu12V25XSLIp_1k_j_A9NKOb-a_2dkPVw.&URL=mailto%3aeli.kern%40kingcounty.gov

From: Alastair Matheson notifications@github.com Sent: Wednesday, November 13, 2019 12:07 AM To: PHSKC-APDE/claims_data claims_data@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Subject: [PHSKC-APDE/claims_data] Add another dual column to mcaidmcare[pha]_elig_timevar table(s) (#43)

[EXTERNAL Email Notice! ] External communication is important to us. Be cautious of phishing attempts. Do not click or open suspicious links or attachments.

Right now the elig_timevar tables have an apde_dual field, which signifies when we observed people to be concurrently enrolled in Medicaid and Medicare. However, since the Medicare data lags Medicaid, that field is always 0 after the end of the Medicare date range (currently '2016-12-31'), even when the person likely remains a dual (e.g., look at IDs where from_date = '2017-01-01' and contiguous = 1 and mcaid = 1).

We need a way to remove duals from more recent analyses. Can we add another dual column in that keeps the P1/Medicaid dual flag in these timevar tables?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FPHSKC-APDE%2Fclaims_data%2Fissues%2F43%3Femail_source%3Dnotifications%26email_token%3DABL6ZKQZVTCJ3ZBVYZQ6J63QTOYSBA5CNFSM4JMU5TXKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HY5QEIQ&data=02%7C01%7Celi.kern%40kingcounty.gov%7C661594b35d5340a44d5f08d768107426%7Cbae5059a76f049d7999672dfe95d69c7%7C0%7C1%7C637092292194887214&sdata=Ak28XyqaQTQ1aQSiGyJ9aYGnStq2Ny06MR1OCNrViT4%3D&reserved=0, or unsubscribehttps://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FABL6ZKTS6TEJ7IMC2HXK5TTQTOYSBANCNFSM4JMU5TXA&data=02%7C01%7Celi.kern%40kingcounty.gov%7C661594b35d5340a44d5f08d768107426%7Cbae5059a76f049d7999672dfe95d69c7%7C0%7C1%7C637092292194897203&sdata=5%2B5FYj7pJlCV0Bk0nAUit5eOE%2Fzn51GvOAnFqD%2FRPXI%3D&reserved=0.

alastairmatheson commented 4 years ago

Dual added to timevar in https://github.com/PHSKC-APDE/claims_data/pull/69/commits/dc01eac34725886dd8218bcc5d9a04754a647497. Language added to demo in https://github.com/PHSKC-APDE/claims_data/commit/cdec2bc102d131e0f2d4d63a7ae1ccdc5b77e3ce.