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


select
    t.period_date,
    t.operation_type_name,
    t.amount
from mgr.ft_dwh_get__pension_account_operation(
    cast(
        '{"p_sPensionAccountId":"НУЖНЫЙ_SHARER_ID_1C",
          "p_sServiceType":"NPO"}'
        as jsonb
    )
) t
order by t.period_date;