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 mcaid_full_criteria flag to mcaid timevar tables #83

Closed alastairmatheson closed 4 years ago

alastairmatheson commented 4 years ago

For each time period in the mcaid_elig_timevar and mcaid_mcare_elig_timevar tables, add in a mcaid_full_criteria flag (0/1). Definition for mcaid_full_criteria = 1: full_benefit = 1 AND dual = 0 AND tpl = 0 Definition for mcaid_full_criteria = 0: full_benefit = 0 OR dual = 1 OR tpl = 1

alastairmatheson commented 4 years ago

@dcolombara in case you're doing any work on the mcaid_mcare_elig_timevar table in the near future

alastairmatheson commented 4 years ago

Added flags for mcaid and mcaid_mcare timevar tables