CIID 8189:
Found in Utah. In the past, AssessmentTypeAdministered is expected to be populated in the report migration. However, Utah does not have this value for students that were expected to test but did not. Changing the inner join to APP.ToggleAssessments in [RDS].[Get_CountSQL] to a left join will correct this issue.
However, this change should be more thoroughly tested before implemented to verify that it doesn’t have any unintended consequences.
CIID 8189:
Found in Utah. In the past, AssessmentTypeAdministered is expected to be populated in the report migration. However, Utah does not have this value for students that were expected to test but did not. Changing the inner join to APP.ToggleAssessments in [RDS].[Get_CountSQL] to a left join will correct this issue.
However, this change should be more thoroughly tested before implemented to verify that it doesn’t have any unintended consequences.