Restore data restored incorrectly

[mahalakshme]

Issue:

As part of this card when we did the data restore from downloaded reports, we copied the floor name directly from the report. But floor is a coded concept. So we should have actually copied the uuid of the floor name. So on executing the below query it returns 532 rows in prod, but in oct29 dump 0 rows which shows that we have introduced the issue during the data restore.

Query to search for floor values in the floor concept:

select count(*) from individual where
observations->>'dd5b53f1-7508-4be8-aec2-ef782946e0f2'::text not in (
    '91e6a6af-2b68-455c-8608-29fa5169860a',
'1c6f143b-3361-482d-a30b-d458b9e8114d',
'bfdc6f85-f263-4968-b947-42fda5f98464',
'0c001c12-1dc8-4f62-8130-430f6a396c24',
'ed73694b-9aad-4a58-bc59-905b3e946177',
'd5e0617c-bb7e-4876-b1fb-3c909cbe63d8',
'fdcb3459-f850-4e88-8f67-ea16fe51fedc',
'a4f2ee4e-b2c2-46f9-85a1-e72f7401b250'
        );

Acceptance criteria:

Write a SQL to replace the name of the floor in the individual observations for the org in focus with uuid of the floor for all the 532 rows.

Process:

Same as for other data restores

[mahalakshme]

@petmongrels In prod it returned only 532 rows for me, not 546, verify the same when executing on prod.