Загрузка данных


select
    et.id as eps_transaction_id,
    s.operation_id,
    s.incoming_order_id,
    e.id as eps_id,
    e.code as eps_code,
    et.oper_date,
    et.operation_sum,
    et.pens_schema_dt,
    et.pens_schema_ct,
    et.strategy_id
from back_office.eps_transaction et
join back_office.eps_transaction_source s
    on s.id = et.eps_transaction_source_id
join ourpension.eps e
    on e.id = et.eps_id
where e.service_type = 'NPO'
  and et.oper_date >= date '2026-08-01'
  and et.oper_date < date '2026-09-01'
  and et.operation_sum is not null
limit 1;