Rerun IHMP restore fix

[mahalakshme]

Need:

This will help restoring around 150 registeration details and around 20 enrolment details.

Acceptance criteria:

Rerun the data restore run for IHMP as part of this card, for individual and enrolment tables.

[mahalakshme]

@petmongrels was it run both for oct29 and nov29 backup? From the testing found, when compared to the time this card was created, more data is lost. checked for mother enrolment alone - data for 17 more mother enrolments were lost.

select individual.id, first_name,
       address_level.title,
       individual.observations->>'24dabc3a-6562-4521-bd42-5fff11ea5c46',
       individual.observations->>'82fa0dbb-92f9-4ec2-9263-49054e64d909',
       program_enrolment.created_date_time,
       program_enrolment.last_modified_date_time
from program_enrolment join individual on program_enrolment.individual_id = individual.id
join address_level on individual.address_id = address_level.id
         where program_id=1 and program_enrolment.observations->>'1cc6fd5d-1359-483e-a971-4bf36e34a72d' is null
and program_enrolment.last_modified_date_time > '2023-10-01'::timestamptz;

[petmongrels]

only nov29 backup. do we have to run for oct29 backup also.

[mahalakshme]

yes yes if its less work will be helpful