Payment

select
    p.practice_id
  , date_trunc('month', p.payment_date) as payment_month
  , count(*) as payments
  , sum(p.amount) as total_amount
from payment p
where p.is_deleted = false
group by p.practice_id, payment_month
order by payment_month desc;

select
    p.practice_id
  , p.id as payment_id
  , p.amount
  , p.applied_amount
  , p.unapplied_amount
from payment p
where p.is_deleted = false
  and p.unapplied_amount > 0
order by p.unapplied_amount desc;

select
    p.id as payment_id
  , p.claim_id
  , p.amount
  , e.adjustment_group
  , e.adjustment_code
  , e.adjustment_amount
from payment p
  join era_matched_adjustment e on e.claimmd_era_id = p.claimmd_era_id
where p.is_deleted = false
  and p.claimmd_era_id is not null;