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