Eheza Reports - data anomalies

[anvmn]

Problems:

1. Initial, there was no Person CT. Instead there were Mother and Child CTs. Person CT has replaced them after ~1.5 years. All Mother and Child nodes were migrated to Person nodes. The problem is that creation date of Person node did not original creation of Child/Mother node. This means that we got 6327 patients with wrong creation date.

2. Some patients got invalid Geo location fields. This causes patients to be excluded at reports.

   • While there are 3 provinces, there are 10 different values in DB:

   • While there are 5 districts, there are 8 different values in DB:

• 152 patients that do not have cell field set:

[anvmn]

Invalid Province - 'Parent':

Child with all Geo fields set to Parent':

Got a relationship with mother:

Mother got Geo fields set properly.

Resolution - setting fields per mother.

[anvmn]

Other provinces mapping:

    'AMAJYARUGU' => 'Amajyaruguru',
    'North' => 'Amajyaruguru',
    'North Province' => 'Amajyaruguru',
    'Northern Province' => 'Amajyaruguru',
    'UBURASIRAZUBA' => 'Iburasirazuba',
    'Kigali City' => 'Umujyi wa kigali',

Resolution - handled at dedicated script.

[anvmn]

Patients with empty district:

For KIVURUGA sector, district must be Gakenke. Setting manually.

For RUSHASHI sector, district must be Gakenke. Setting manually.

[anvmn]

Invalid District - 'Parent':

Resolution - single patient, handled when fixing Province.

[anvmn]

District - NYAMATA:

No such district. Province for all patients with this district is IBURASIRAZUBA.

Resolution - setting to only district of IBURASIRAZUBA province (BUGESERA). Handled at dedicated script.

[anvmn]

For sector, we have 67 distinct values, while one of them is empty and another 'Parent'.

In total, we support 66 unique sectors. Parent was handled already.

There's one patient with empty value:

For given province and sector, with village NGANWA we can resolve sector and cell:

Sector - Ntarama Cell - Kibungo

Resolution - update manually.

[anvmn]

152 patients that do not have cell field set:

144 handled at dedicated script. For remaining, opened https://github.com/Gizra/ihangane/issues/3154 and assigned to @Diama1 .

[anvmn]

Deployed to live