Versions Compared

Old Version 2

changes.mady.by.user Serhii Boldin (SoE eHealth)

Saved on

compared with

New Version Current

changes.mady.by.user Serhii Boldin (SoE eHealth)

Saved on

Key

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

  • Purpose

  • Process configuration

  • Job logic

...

  1. Fetch records from OPS.declarations, where:

    1. is_active = TRUE

    2. status not in [closed, terminated, rejected]

    3. end_date < current_date()

  2. Update all records to:

    1. status = ‘closed’

    2. updated_at = now()

    3. updated_by = SYSTEM_USER