SPR_WithdrawalReasonMapping

[robinwilson16]

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