---

SELECT
  ri.id as id,
  ind.last_name || ' ' || ind.first_name || 
       COALESCE(' ' || ind.middle_name, '') as client_name,
  ri.snils as snils,
  CASE 
       WHEN ri.contract_type = 'NPO' THEN 'НПО'
       WHEN ri.contract_type = 'PDS' THEN 'ПДС'
   END as contract_type_name,
  c.number as contract_number,
  ri.contributions_amount as contributions_amount,
  CASE
       WHEN ri.has_fns_lk = 1  THEN 'Есть'
       WHEN ri.has_fns_lk = 0  THEN 'Нет'
       WHEN ri.has_fns_lk = 99 THEN 'Ошибка проверки'
       ELSE 'Не проверялось'
   END as has_fns_lk_name,
  ri.last_sent_date as last_sent_date,
  ri.error_code as error_code,
  ri.error_description as error_description,
  CASE
       WHEN ri.error_status = 'NOT_FIXED' THEN 'Не исправлено'
       WHEN ri.error_status = 'FIXED'     THEN 'Исправлено'
       ELSE null
   END as error_status,
  ri.tax_period_year as tax_period_year 
FROM report.unv_registry_item ri
JOIN ourpension.individual ind
    ON ind.id = ri.client_id
JOIN ourpension.contract c
    ON c.id = ri.contract_id
WHERE WHERE ri.registry_id = CAST(:registry_id AS integer)