Provider-Payer

ComponentSchema

---

-- 🪟💲🌟
-- run_id: {{ run_id }}
-- task_name: {{ task_name }}
-- Table: {{ schema_name }}.tmp_whisper_provider_payer_{{ sub_version }} 
-- Subversion: {{ sub_version }}


CREATE TABLE {{ schema_name }}.tmp_whisper_provider_payer_{{ sub_version }}
WITH (
    PARTITIONING = ARRAY['payer_id']
)
AS
SELECT 
    CAST(provider_id AS VARCHAR) as provider_id,
    CAST(tq_payer_id AS VARCHAR) as payer_id,
    claims as provider_payer_claims,
    charges as provider_payer_charges,
    pct_of_total_claims as within_provider_payer_pct_of_total_claims,
    pct_of_total_charges as within_provider_payer_pct_of_total_charges,
    payor_rank as within_provider_payer_payer_rank
FROM {{ schema_name }}.tmp_ref_definitive_hospital_payer_mix_{{ sub_version }}
WHERE provider_id IS NOT NULL