Page 1 of 1

ProAchieve - Issue with Incorrect Number of Leavers in CL_Midpoint Table

Posted: Fri Nov 11, 2016 5:19 pm
by robinwilson16
This week we have encountered an issue with the ProAchieve CL_Midpoint table for 2016/17 summaries where it does not quite report the correct number of 15/16 leavers compared with the frontend due to additional criteria now being added. Previously this table always matched the figures displayed inside the ProAchieve application.

The reason is because the P_Count_OverallQSRExclude field does not include 15/16 learners who have exceeded the time they can complete in during the following year for overall measures so are excluded from the leaver count (i.e. funded start) even though they have completed and achieved.

Just looking at P_Count_OverallQSRExclude field as we would normally:

Code: Select all

SELECT 
	NumLeavers = SUM ( M.P_Count_OverallQSRExclude )
FROM ProAchieve.dbo.CL_Midpoint M
WHERE
	M.CL_MidpointID = 'C1116021'
	AND
	M.PG_HybridEndYearID = '15/16'
However what we now need to do is this:

Code: Select all

SELECT 
	NumLeavers = 
		SUM (
			CASE
				WHEN M.CLOverdue = 1 AND M.P_Count_OverallQSRExclude = 0 THEN 1
				ELSE M.P_Count_OverallQSRExclude
			END
		)
FROM ProAchieve.dbo.CL_Midpoint M
WHERE
	M.CL_MidpointID = 'C1116021'
	AND
	M.PG_HybridEndYearID = '15/16'
However Compass have said this is a temporary workaround and they will get around to updating the figures in CL_Midpoint so they match. They also suggested an alternative workaround of using the vCL_Summary view instead.

I just thought it was worth letting people know as it has taken us a while to figure out why our 15/16 leaver count had gone slightly out when generating new 16/17 CL summaries.

Re: ProAchieve - Issue with Incorrect Number of Leavers in CL_Midpoint Table

Posted: Mon Nov 14, 2016 3:12 pm
by AlanB
Thanks for sharing :)