---

INSERT INTO report.unv_registry_item (
    registry_id,
    client_id,
    snils,
    contract_id,
    contract_type,
    tax_period_year,
    contributions_amount,
    preliminary_deduction_amount,
    annual_deduction_flag,
    status,
    send_count
)
SELECT
    7842430,
    11232579,
    '088-661-595 26',
    13649368,
    'PDS',
    CAST(2025 AS smallint),
    CAST(3000.00 AS numeric),
    CAST(390.00 AS numeric),
    1,
    'Сформирован',
    0
WHERE NOT EXISTS (
    SELECT 1
    FROM report.unv_registry_item ri
    WHERE ri.registry_id = 7842430
      AND ri.client_id = 11232579
      AND ri.contract_id = 13649368
      AND ri.tax_period_year = 2025
)
RETURNING
    id,
    registry_id,
    client_id,
    contract_id,
    contributions_amount,
    preliminary_deduction_amount;