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

Switch to MBR_H_SID as id_mcaid #189

Open alastairmatheson opened 3 weeks ago

alastairmatheson commented 3 weeks ago

Need to update the following lines: https://github.com/PHSKC-APDE/claims_data/blob/mcaid_synapse/claims_db/phclaims/stage/tables/load_stage.mcaid_elig_timevar.R#L95 SELECT MEDICAID_RECIPIENT_ID AS 'id_mcaid', Should become SELECT MBR_H_SID AS 'id_mcaid', MEDICAID_RECIPIENT_ID AS 'mcaid_recipient_id',

Also add a new line to the YAML: https://github.com/PHSKC-APDE/claims_data/blob/mcaid_synapse/claims_db/phclaims/stage/tables/load_stage.mcaid_elig_timevar.yaml#L28 mcaid_recipient_id: VARCHAR(255)

For the following, replace this: MEDICAID_RECIPIENT_ID as id_mcaid with this: MBR_H_SID as id_mcaid https://github.com/PHSKC-APDE/claims_data/blob/mcaid_synapse/claims_db/phclaims/stage/tables/load_stage.mcaid_claim_line.R#L67 https://github.com/PHSKC-APDE/claims_data/blob/mcaid_synapse/claims_db/phclaims/stage/tables/load_stage.mcaid_claim_icdcm_header.R#L105 https://github.com/PHSKC-APDE/claims_data/blob/mcaid_synapse/claims_db/phclaims/stage/tables/load_stage.mcaid_claim_procedure.R#L71 https://github.com/PHSKC-APDE/claims_data/blob/mcaid_synapse/claims_db/phclaims/stage/tables/load_stage.mcaid_claim_pharm.R#L55 (You might want to just look for any references to 'AS id_mcaid' and get them updated) https://github.com/PHSKC-APDE/claims_data/blob/mcaid_synapse/claims_db/phclaims/stage/tables/load_stage.mcaid_claim_header.R#L133