Missing level for some school accreditations

[Ghislain Hachey]

Something bizarre happening. Some approved and loaded school accreditations do not show a calculated level in the School Accreditation - List. They are usually what look like duplicates. However, when looking at the loaded files only one is there. It almost looks like the system creates two school accreditation when approving one. I will do the cleanup but we need to investigate this.

‌

‌

[Brian Lewis]

You’re right they are duplicates. The issue is that there are currently multiple records in InspectionSet with the same year and inspection type code - on insert, this join creates multiple new records for each of these.

Will clean the data in Inspections, and change the trigger i think is best rather than just remove the dups from InspectionSet; theoretically we may want to have multiple inspection sets ( ie 1 per state); that’s how it was designed.

Should resolve today.

‌

‌

[Brian Lewis]

→ <<cset f9fbbbfe7892>>