School Accreditation Standard Definitions

[Ghislain Hachey]

Is this a bug? Causes issues when joining and expecting only unique definitions.

‌

[Ghislain Hachey]

I don’t think it causes more issues down the line but in any case I am bringing a minor modification to the School Accreditation XML template so that the Classroom Observation 1 and Classroom Observation 2 both match. This now produces unique definitions for each code. The change was done with the following query.

BEGIN TRANSACTION;

-- Add missing element in template XML survey in lkpInspectionTypes

SELECT * FROM [dbo].[lkpInspectionTypes];
SELECT * FROM dbo.lkpInspectionTypeTerms('SCHOOL_ACCREDITATION')

UPDATE [dbo].[lkpInspectionTypes]
SET [intyTemplate].modify('
insert <shortname>Planning and Prep</shortname>          
after (/survey/category[name="Classroom Observation 2"]/standard/name)[1]')

WHERE intyCode = 'SCHOOL_ACCREDITATION';

SELECT * FROM [dbo].[lkpInspectionTypes];
SELECT * FROM dbo.lkpInspectionTypeTerms('SCHOOL_ACCREDITATION')

COMMIT;

‌