---

SELECT
   ri.id,
   -- Клиент
   ind.last_name || ' ' || ind.first_name || 
       COALESCE(' ' || ind.middle_name, '')        AS client_name,
   ind.id                                          AS client_id,
   -- СНИЛС
   ri.snils,
   -- Вид деятельности
   CASE 
       WHEN ri.contract_type = 'NPO' THEN 'НПО'
       WHEN ri.contract_type = 'PDS' THEN 'ПДС'
   END                                             AS contract_type_name,
   -- Договор
   c.number                                        AS contract_number,
   c.id                                            AS contract_id,
   -- Размер взносов за год
   ri.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.has_fns_lk,
   -- Дата последней отправки
   ri.last_sent_date,
   -- Ошибки
   ri.error_code,
   ri.error_description,
   CASE
       WHEN ri.error_status = 'NOT_FIXED' THEN 'Не исправлено'
       WHEN ri.error_status = 'FIXED'     THEN 'Исправлено'
       ELSE null
   END                                             AS error_status_name,
   ri.error_status,
   -- Налоговый период
   ri.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 ri.registry_id = CAST(:registry_id AS integer)