---

select
    et.id as eps_transaction_id,
    o.id as operation_id,
    o.operation_date,
    et.oper_date as eps_date,
    (
        o.operation_date between
        date '2026-08-01' and date '2026-08-31'
    ) as included_in_august_report,
    ed.id as eps_detail_id,
    ed.account_dt,
    ed.account_ct,
    ed.pension_scheme_id as setting_scheme_id,
    coalesce(
        ed.pension_scheme_id,
        et.pens_schema_dt
    ) as report_debit_scheme_id,
    coalesce(
        ed.pension_scheme_id,
        et.pens_schema_ct
    ) as report_credit_scheme_id
from back_office.eps_transaction et
join back_office.eps_transaction_source s
    on s.id = et.eps_transaction_source_id
join back_office.operation o
    on o.id = s.operation_id
join ourpension.eps_detail ed
    on ed.eps_id = et.eps_id
where et.id = 6355761;