fedspendingtransparency/usaspending-api

DO $$ BEGIN RAISE NOTICE '080 Adding Recipient records from FPDS and FABS parents with no name'; END $$;

INSERT INTO public.temporary_restock_recipient_lookup (
  recipient_hash,
  duns_recipient_hash,
  duns,
  uei,
  source,
  parent_duns,
  parent_uei
)
SELECT
  DISTINCT ON (parent_recipient_hash)
  parent_recipient_hash AS recipient_hash,
  duns_parent_recipient_hash AS duns_recipient_hash,
  ultimate_parent_unique_ide,
  ultimate_parent_uei as uei,
  CONCAT(source, '-parent'),
  ultimate_parent_unique_ide AS parent_duns,
  ultimate_parent_uei AS parent_uei
FROM public.temporary_transaction_recipients_view
WHERE COALESCE(ultimate_parent_uei, ultimate_parent_unique_ide) IS NOT NULL AND ultimate_parent_legal_enti IS NULL
ORDER BY parent_recipient_hash, action_date DESC, is_fpds, transaction_unique_id
ON CONFLICT (recipient_hash) DO NOTHING;