School Accreditation Tools

[Ghislain Hachey]

Need the ability to easily do the follow (not necessarily from the Web UI but at least some technical tools like a stored proc or template code)

• Cleanly delete a previously loaded school inspection (School accreditation, WASH, etc.)
• Cleanly load bulk data for past school accreditations

I believe we already have those tools, they need to be shared and documented.

‌

[Ghislain Hachey]

@Brian Lewis

for the first required “tool” (cleanly delete an inspection) we already had a trigger on view [pInspectionRead].[SchoolInspections] to handle this. Perhaps we could have a protected API to delete inspections from the UI?! In any case, low priority since we can if needed go in the DB and easily delete erroneously loaded inspections if needed. I’ve documented this for posterity.

Only issue I see so far with the delete inspection from the trigger on view [pInspectionRead].[SchoolInspections] is that it does not remove any documents (photos) associated with it. Properly should cascade that.

[Ghislain Hachey]

@Brian Lewis I am taking this issue.

[Ghislain Hachey]

@Brian Lewis I believe we have everything we need with this issue. The only work remaining was to write a stored proc to load school accreditation from parameters (excel data) but with the new survey format. I just finished a rough first draft of this which seems to work well. I will document all of this and at some point if you can double check this stored proc and sync to the pacificemisdb.

[Ghislain Hachey]

SQL changes already committed.