ProAchieve - Issue with Incorrect Number of Leavers in CL_Midpoint Table

These require Visual Studio 2015 unless stated otherwise
VS 2015 should be available as part of your campus agreement
Post Reply
User avatar
robinwilson16
Site Admin
Posts: 185
Joined: Sun Oct 16, 2016 6:46 pm
Forename: Robin
Surname: Wilson
College Name: FEA
Position: MIS Consultant
LinkedIn Profile: https://www.linkedin.com/in/robinwilson16

ProAchieve - Issue with Incorrect Number of Leavers in CL_Midpoint Table

Post by robinwilson16 » Fri Nov 11, 2016 5:19 pm

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.

AlanB
Posts: 4
Joined: Mon Oct 17, 2016 9:09 am
Forename: Alan
Surname: Bradley
College Name: The Isle of Wight College
Position: Information Systems Developer

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

Post by AlanB » Mon Nov 14, 2016 3:12 pm

Thanks for sharing :)

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests