SPR_WithdrawalReasonMapping

For sharing any stored procedures
Post Reply [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable
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
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

SPR_WithdrawalReasonMapping

Post by robinwilson16 » Fri Mar 03, 2017 12:06 am

Maps detailed college withdrawal reasons back to the ILR withdrawal reasons

Code: Select all

CREATE PROCEDURE [dbo].[SPR_WithdrawalReasonMapping] 

AS
BEGIN

SET NOCOUNT ON;

UPDATE ISR
SET 
	ei_ilrh31 = WDR.vc_national,
	ei_ilrh16 = 
		CASE
			WHEN ME.e_enrolprogaction = 'L1' THEN '1'
			ELSE '2'
		END,
	ei_ilrwithdrawalreason = WDR.vc_national2

FROM
	ulive.dbo.capd_moduleenrolment ME
INNER JOIN ulive.dbo.capd_enrolmentisr ISR
	ON ISR.ei_id = ME.e_id
INNER JOIN ulive.dbo.caps_valid_codes WDR
	ON WDR.vc_code = ME.e_enrolprogaction
	AND WDR.vc_domain = 'enrolprogaction'
END

Post Reply [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

Who is online

Users browsing this forum: No registered users and 0 guests