Versions Compared

Old Version 4

changes.mady.by.user Olena Yermolenko

Saved on

compared with

New Version 5

changes.mady.by.user Olena Yermolenko

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


  1. Find records in prm.legal_entitity_entities types for which flag nhs_verified = false or (question) edr_verified = false (question) and and it was set 3 months 90 (config) days ago.
    1. set legal_entitity_entitiestypes.is_suspended status = trueSuspended
    2. find contracts by contractor_legal_entity_id=$legallegal_entitity_types.edr_legal_entity_id and legal_entity_id  and type = legal_entitity_types.id and status='VERIFIED', set ops.contracts.is_suspended=true