inspectomop.queries.payer_plan.patient_distribution_by_plan_type

inspectomop.queries.payer_plan.patient_distribution_by_plan_type(inspector)

Returns counts of payer coverage by plan type.

Parameters:inspector (inspectomop.inspector.Inspector) – Returns:results Return type:inspectomop.results.Results

Notes

Original SQL

PP02: Patient distribution by plan type:

SELECT
  t.plan_source_value,
  t.pat_cnt AS num_patients,
  100.00\*t.pat_cnt/ (sum(t.pat_cnt) over()) perc_of_total_count
FROM (
    SELECT
        p.plan_source_value,
        count(1) AS pat_cnt
    FROM
        payer_plan_period p
    GROUP BY
        p.plan_source_value
    ) t
ORDER BY
    t.plan_source_value;