Versions Compared

Old Version 4

changes.mady.by.user Olena Yermolenko

Saved on

compared with

New Version Current

changes.mady.by.user Dmytro Kulibaba (Unlicensed)

Saved on

Key

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


  1. Find records in prm.legal_entities entitities 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_entities.is_suspended = trueentitities.status = Suspended, set legal_entitities.status_reason = 'auto_suspend_legal_entity' 
    2. find contracts by contractor_legal_entity_id=$legal_entity_id  and legal_entities.id and status='VERIFIED', set ops.contracts.is_suspended=true, ops.contracts.status_reason='auto_suspend_legal_entity'