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

claims_elig apcd source bug #145

Open kai-fukutaki opened 2 years ago

kai-fukutaki commented 2 years ago

Currently using apcd as the source for claims_elig function doesn't work due to issues with column names specified in the sql query. There may be other problems as well when using this source.

kai-fukutaki commented 1 year ago

Issue with column geo_kc will be resolved when new extract begins. Context below from Eli:

"Thanks for rounding back on this! The planned upload of WA-APCD data to PHClaims never happened this summer and thus we are still using the old extract that does not yet have the geo_kc flag embedded in the elig_timevar table. Now that Susan is back, she is going to begin pulling in the next WA-APCD extract – this extract, once loaded in PHClaims, will have the geo_kc flag. Susan was hoping to get started on the ETL process this week and thus I’ll defer to her for an update on status. Even if Susan did begin this week, I anticipate it may take a 1.5-2 weeks to get the extract fully loaded and QA’ed in PHClaims."

Until that point, the branch from this issue can be used to circumvent the issue for anyone attempting to access APCD data using claims_elig