Page Comparison

...

1. Find records in prm.legal_entitity_types entitities for which flag nhs_verified = false and it was set 90 (config) days ago.
   1. set legal_entitity_typesentitities.status = Suspendedfind contracts by contractor_, set legal_entityentitities.status_idreason = legal'auto_entititysuspend_types.edr_legal_entity_id and ' 
   2. find contracts by contractor_legal_entity_type id= legallegal_entitity_types.id and entities.id and status='VERIFIED', set ops.contracts.is_suspended=true, ops.contracts.status_reason='auto_suspend_legal_entity'