TeacherSurvey incomplete data [2020:O] [RMI:2021]

[Ghislain Hachey]

Some clarifications needed.

• Where is all the district codes?
• Is tchStatus the Teacher and Non-Teaching Teacher Type in the workbook?
• Why are many (most?) of the tchStatus NULL when there is definitely data int he tcheData XML?
• What eaxctly is tchSupport? I thought that was for non teaching staff. So it would seem a tchStatus of NT would means tchSupport of Support and tchStatus of T would mean schSupport of NULL. If that is the case, all good but it still does not explain the numerous tchStatus NULL as previous bullet.

[Ghislain Hachey]

I also just found [pTeacherRead].[TeacherSurveyV] which seems to have more complete tchStatus. Still not exactly clear…

[Ghislain Hachey]

Changing this to blocker as we are getting very close to the deadline of submission of the annual indicators report which rely on the data warehouse.

[Ghislain Hachey]

While this is not a block for the next upgrade it remain very high priority to fix.