DECLARE @RawData TABLE (EmployeeID varchar(10) NOT NULL PRIMARY KEY, BF numeric(18,4) NOT NULL, MA numeric(18,4) NOT NULL, Notes nvarchar(500) NULL)

INSERT INTO @RawData (EmployeeID, BF, MA, Notes)
    VALUES 
('21952', 0, 2, '2 Days Holiday Purchase 2021')
,('24338', 0, 2, '2 Days Holiday Purchase 2021')
,('23405', 0, 2, '2 Days Holiday Purchase 2021')
,('14395', 0, 2, '2 Days Holiday Purchase 2021')
,('22507', 0, 2, '2 Days Holiday Purchase 2021')
,('23039', 0, 3, '3 Days Holiday Purchase 2021')
,('4623', 0, 3, '3 Days Holiday Purchase 2021')
,('24796', 0, 3, '3 Days Holiday Purchase 2021')
,('16733', 0, 3, '3 Days Holiday Purchase 2021')
,('4679', 0, 3, '3 Days Holiday Purchase 2021')
,('4903', 0, 3, '3 Days Holiday Purchase 2021')
,('4915', 0, 3, '3 Days Holiday Purchase 2021')
,('17893', 0, 3, '3 Days Holiday Purchase 2021')
,('20486', 0, 3, '3 Days Holiday Purchase 2021')
,('22230', 0, 3, '3 Days Holiday Purchase 2021')
,('17854', 0, 3, '3 Days Holiday Purchase 2021')
,('21595', 0, 3, '3 Days Holiday Purchase 2021')
,('23392', 0, 3, '3 Days Holiday Purchase 2021')
,('20087', 0, 3, '3 Days Holiday Purchase 2021')
,('24422', 0, 3, '3 Days Holiday Purchase 2021')
,('23919', 0, 3, '3 Days Holiday Purchase 2021')
,('13218', 0, 4, '4 Days Holiday Purchase 2021')
,('520', 0, 4, '4 Days Holiday Purchase 2021')
,('19931', 0, 4, '4 Days Holiday Purchase 2021')
,('13609', 0, 4, '4 Days Holiday Purchase 2021')
,('8067', 0, 4, '4 Days Holiday Purchase 2021')
,('22649', 0, 4, '4 Days Holiday Purchase 2021')
,('23334', 0, 4, '4 Days Holiday Purchase 2021')
,('20510', 0, 4, '4 Days Holiday Purchase 2021')
,('10589', 0, 4, '4 Days Holiday Purchase 2021')
,('1438', 0, 4, '4 Days Holiday Purchase 2021')
,('22020', 0, 4, '4 Days Holiday Purchase 2021')
,('24416', 0, 4, '4 Days Holiday Purchase 2021')
,('10854', 0, 5, '5 Days Holiday Purchase 2021')
,('24943', 0, 5, '5 Days Holiday Purchase 2021')
,('17140', 0, 5, '5 Days Holiday Purchase 2021')
,('10711', 0, 5, '5 Days Holiday Purchase 2021')
,('16752', 0, 5, '5 Days Holiday Purchase 2021')
,('24953', 0, 5, '5 Days Holiday Purchase 2021')
,('23294', 0, 5, '5 Days Holiday Purchase 2021')
,('24932', 0, 5, '5 Days Holiday Purchase 2021')
,('22895', 0, 5, '5 Days Holiday Purchase 2021')
,('9363', 0, 5, '5 Days Holiday Purchase 2021')
,('14064', 0, 5, '5 Days Holiday Purchase 2021')
,('22408', 0, 5, '5 Days Holiday Purchase 2021')
,('22000', 0, 5, '5 Days Holiday Purchase 2021')
,('21347', 0, 5, '5 Days Holiday Purchase 2021')
,('5819', 0, 5, '5 Days Holiday Purchase 2021')
,('10140', 0, 5, '5 Days Holiday Purchase 2021')
,('7468', 0, 5, '5 Days Holiday Purchase 2021')
,('3048', 0, 5, '5 Days Holiday Purchase 2021')
,('4366', 0, 5, '5 Days Holiday Purchase 2021')
,('1741', 0, 5, '5 Days Holiday Purchase 2021')
,('20372', 0, 5, '5 Days Holiday Purchase 2021')
,('5236', 0, 5, '5 Days Holiday Purchase 2021')
,('19895', 0, 5, '5 Days Holiday Purchase 2021')
,('7067', 0, 5, '5 Days Holiday Purchase 2021')
,('18750', 0, 5, '5 Days Holiday Purchase 2021')
,('12496', 0, 5, '5 Days Holiday Purchase 2021')
,('1722', 0, 5, '5 Days Holiday Purchase 2021')
,('22585', 0, 5, '5 Days Holiday Purchase 2021')
,('20795', 0, 5, '5 Days Holiday Purchase 2021')
,('21084', 0, 5, '5 Days Holiday Purchase 2021')
,('22049', 0, 5, '5 Days Holiday Purchase 2021')
,('24978', 0, 5, '5 Days Holiday Purchase 2021')
,('19480', 0, 5, '5 Days Holiday Purchase 2021')
,('17493', 0, 5, '5 Days Holiday Purchase 2021')
,('24942', 0, 5, '5 Days Holiday Purchase 2021')
,('83', 0, 5, '5 Days Holiday Purchase 2021')
,('22818', 0, 5, '5 Days Holiday Purchase 2021')
,('5595', 0, 5, '5 Days Holiday Purchase 2021')
,('19414', 0, 5, '5 Days Holiday Purchase 2021')
,('4925', 0, 5, '5 Days Holiday Purchase 2021')
,('17483', 0, 5, '5 Days Holiday Purchase 2021')
,('6077', 0, 5, '5 Days Holiday Purchase 2021')
,('19217', 0, 5, '5 Days Holiday Purchase 2021')
,('11926', 0, 5, '5 Days Holiday Purchase 2021')
,('6063', 0, 5, '5 Days Holiday Purchase 2021')
,('8525', 0, 5, '5 Days Holiday Purchase 2021')
,('5243', 0, 5, '5 Days Holiday Purchase 2021')
,('22813', 0, 5, '5 Days Holiday Purchase 2021')
,('6392', 0, 5, '5 Days Holiday Purchase 2021')
,('4425', 0, 5, '5 Days Holiday Purchase 2021')
,('11181', 0, 5, '5 Days Holiday Purchase 2021')
,('22898', 0, 5, '5 Days Holiday Purchase 2021')
,('21867', 0, 5, '5 Days Holiday Purchase 2021')
,('6412', 0, 5, '5 Days Holiday Purchase 2021')
,('6007', 0, 5, '5 Days Holiday Purchase 2021')
,('10340', 0, 5, '5 Days Holiday Purchase 2021')
,('8562', 0, 5, '5 Days Holiday Purchase 2021')
,('1382', 0, 5, '5 Days Holiday Purchase 2021')
,('11333', 0, 5, '5 Days Holiday Purchase 2021')
,('23669', 0, 5, '5 Days Holiday Purchase 2021')
,('6547', 0, 5, '5 Days Holiday Purchase 2021')
,('20095', 0, 5, '5 Days Holiday Purchase 2021')
,('22059', 0, 5, '5 Days Holiday Purchase 2021')
,('5054', 0, 5, '5 Days Holiday Purchase 2021')
,('5051', 0, 5, '5 Days Holiday Purchase 2021')
,('2625', 0, 5, '5 Days Holiday Purchase 2021')
,('16934', 0, 5, '5 Days Holiday Purchase 2021')
,('22443', 0, 5, '5 Days Holiday Purchase 2021')
,('22057', 0, 5, '5 Days Holiday Purchase 2021')
,('23496', 0, 5, '5 Days Holiday Purchase 2021')
,('130', 0, 5, '5 Days Holiday Purchase 2021')
,('2899', 0, 5, '5 Days Holiday Purchase 2021')
,('13452', 0, 5, '5 Days Holiday Purchase 2021')
,('5044', 0, 5, '5 Days Holiday Purchase 2021')
,('22062', 0, 5, '5 Days Holiday Purchase 2021')
,('16940', 0, 5, '5 Days Holiday Purchase 2021')
,('12046', 0, 5, '5 Days Holiday Purchase 2021')
,('20330', 0, 5, '5 Days Holiday Purchase 2021')
,('22579', 0, 5, '5 Days Holiday Purchase 2021')
,('22828', 0, 5, '5 Days Holiday Purchase 2021')
,('2640', 0, 5, '5 Days Holiday Purchase 2021')
,('19469', 0, 5, '5 Days Holiday Purchase 2021')
,('3167', 0, 5, '5 Days Holiday Purchase 2021')
,('3188', 0, 5, '5 Days Holiday Purchase 2021')
,('2910', 0, 5, '5 Days Holiday Purchase 2021')
,('23369', 0, 5, '5 Days Holiday Purchase 2021')
,('1793', 0, 5, '5 Days Holiday Purchase 2021')
,('3147', 0, 5, '5 Days Holiday Purchase 2021')
,('3156', 0, 5, '5 Days Holiday Purchase 2021')
,('13383', 0, 5, '5 Days Holiday Purchase 2021')
,('13443', 0, 5, '5 Days Holiday Purchase 2021')
,('23486', 0, 5, '5 Days Holiday Purchase 2021')
,('22056', 0, 5, '5 Days Holiday Purchase 2021')
,('2967', 0, 5, '5 Days Holiday Purchase 2021')
,('2696', 0, 5, '5 Days Holiday Purchase 2021')
,('23330', 0, 5, '5 Days Holiday Purchase 2021')
,('13385', 0, 5, '5 Days Holiday Purchase 2021')
,('22615', 0, 5, '5 Days Holiday Purchase 2021')
,('23342', 0, 5, '5 Days Holiday Purchase 2021')
,('23333', 0, 5, '5 Days Holiday Purchase 2021')
,('20614', 0, 5, '5 Days Holiday Purchase 2021')
,('17097', 0, 5, '5 Days Holiday Purchase 2021')
,('5014', 0, 5, '5 Days Holiday Purchase 2021')
,('196465', 0, 5, '5 Days Holiday Purchase 2021')
,('18648', 0, 5, '5 Days Holiday Purchase 2021')
,('23350', 0, 5, '5 Days Holiday Purchase 2021')
,('22343', 0, 5, '5 Days Holiday Purchase 2021')
,('22782', 0, 5, '5 Days Holiday Purchase 2021')
,('23500', 0, 5, '5 Days Holiday Purchase 2021')
,('6502', 0, 5, '5 Days Holiday Purchase 2021')
,('23710', 0, 5, '5 Days Holiday Purchase 2021')
,('17574', 0, 5, '5 Days Holiday Purchase 2021')
,('7205', 0, 5, '5 Days Holiday Purchase 2021')
,('22824', 0, 5, '5 Days Holiday Purchase 2021')
,('24743', 0, 5, '5 Days Holiday Purchase 2021')
,('13530', 0, 5, '5 Days Holiday Purchase 2021')
,('6220', 0, 5, '5 Days Holiday Purchase 2021')
,('1413', 0, 5, '5 Days Holiday Purchase 2021')
,('19365', 0, 5, '5 Days Holiday Purchase 2021')
,('22004', 0, 5, '5 Days Holiday Purchase 2021')
,('19254', 0, 5, '5 Days Holiday Purchase 2021')
,('18252', 0, 5, '5 Days Holiday Purchase 2021')
,('7427', 0, 5, '5 Days Holiday Purchase 2021')
,('23290', 0, 5, '5 Days Holiday Purchase 2021')
,('22577', 0, 5, '5 Days Holiday Purchase 2021')
,('16340', 0, 5, '5 Days Holiday Purchase 2021')
,('24663', 0, 5, '5 Days Holiday Purchase 2021')
,('18275', 0, 5, '5 Days Holiday Purchase 2021')
,('9100', 0, 5, '5 Days Holiday Purchase 2021')
,('13014', 0, 5, '5 Days Holiday Purchase 2021')
,('24524', 0, 5, '5 Days Holiday Purchase 2021')
,('10808', 0, 5, '5 Days Holiday Purchase 2021')
,('15305', 0, 5, '5 Days Holiday Purchase 2021')
,('5064', 0, 5, '5 Days Holiday Purchase 2021')
,('20780', 0, 5, '5 Days Holiday Purchase 2021')
,('19279', 0, 5, '5 Days Holiday Purchase 2021')
,('16814', 0, 5, '5 Days Holiday Purchase 2021')
,('15607', 0, 5, '5 Days Holiday Purchase 2021')
,('10764', 0, 5, '5 Days Holiday Purchase 2021')
,('22562', 0, 5, '5 Days Holiday Purchase 2021')
,('7445', 0, 5, '5 Days Holiday Purchase 2021')
,('15560', 0, 5, '5 Days Holiday Purchase 2021')
,('17328', 0, 5, '5 Days Holiday Purchase 2021')
,('24337', 0, 5, '5 Days Holiday Purchase 2021')
,('18421', 0, 5, '5 Days Holiday Purchase 2021')
,('10228', 0, 5, '5 Days Holiday Purchase 2021')
,('9545', 0, 5, '5 Days Holiday Purchase 2021')
,('15978', 0, 5, '5 Days Holiday Purchase 2021')
,('1431', 0, 5, '5 Days Holiday Purchase 2021')
,('22436', 0, 5, '5 Days Holiday Purchase 2021')
,('22513', 0, 5, '5 Days Holiday Purchase 2021')
,('20327', 0, 5, '5 Days Holiday Purchase 2021')
,('17110', 0, 5, '5 Days Holiday Purchase 2021')
,('23917', 0, 5, '5 Days Holiday Purchase 2021')
,('14238', 0, 5, '5 Days Holiday Purchase 2021')
,('22119', 0, 5, '5 Days Holiday Purchase 2021')
,('23918', 0, 5, '5 Days Holiday Purchase 2021')
,('20193', 0, 5, '5 Days Holiday Purchase 2021')
,('19675', 0, 5, '5 Days Holiday Purchase 2021')
,('24162', 0, 5, '5 Days Holiday Purchase 2021')
,('6065', 0.5, 0, '0.5 Days carried forward from 2020')
,('10982', 0.5, 0, '0.5 Days carried forward from 2020')
,('19086', 0.5, 0, '0.5 Days carried forward from 2020')
,('24910', 0.5, 0, '0.5 Days carried forward from 2020')
,('19541', 0.5, 0, '0.5 Days carried forward from 2020')
,('2013', 0.5, 0, '0.5 Days carried forward from 2020')
,('23164', 0.5, 0, '0.5 Days carried forward from 2020')
,('21834', 0.5, 0, '0.5 Days carried forward from 2020')
,('20860', 0.5, 0, '0.5 Days carried forward from 2020')
,('13183', 0.5, 0, '0.5 Days carried forward from 2020')
,('19364', 0.5, 0, '0.5 Days carried forward from 2020')
,('20390', 0.5, 0, '0.5 Days carried forward from 2020')
,('24986', 0.5, 0, '0.5 Days carried forward from 2020')
,('24446', 0.5, 0, '0.5 Days carried forward from 2020')
,('6913', 0.5, 0, '0.5 Days carried forward from 2020')
,('8569', 0.5, 0, '0.5 Days carried forward from 2020')
,('20711', 0.5, 0, '0.5 Days carried forward from 2020')
,('18228', 0.5, 0, '0.5 Days carried forward from 2020')
,('9921', 0.5, 3, '0.5 Days carried forward from 2020, 3 Days Holiday Purchase 2021')
,('16906', 0.5, 4.5, '0.5 Days carried forward from 2020, 4.5 Days Holiday Purchase 2021')
,('17259', 0.5, 4.5, '0.5 Days carried forward from 2020, 4.5 Days Holiday Purchase 2021')
,('9378', 0.5, 4.5, '0.5 Days carried forward from 2020, 4.5 Days Holiday Purchase 2021')
,('5118', 1, 0, '1 Day carried forward from 2020')
,('8258', 1, 0, '1 Day carried forward from 2020')
,('23173', 1, 0, '1 Day carried forward from 2020')
,('15492', 1, 0, '1 Day carried forward from 2020')
,('24921', 1, 0, '1 Day carried forward from 2020')
,('11666', 1, 0, '1 Day carried forward from 2020')
,('12977', 1, 0, '1 Day carried forward from 2020')
,('23610', 1, 0, '1 Day carried forward from 2020')
,('7131', 1, 0, '1 Day carried forward from 2020')
,('17008', 1, 0, '1 Day carried forward from 2020')
,('9862', 1, 0, '1 Day carried forward from 2020')
,('19335', 1, 0, '1 Day carried forward from 2020')
,('22660', 1, 0, '1 Day carried forward from 2020')
,('19378', 1, 0, '1 Day carried forward from 2020')
,('11490', 1, 0, '1 Day carried forward from 2020')
,('11302', 1, 0, '1 Day carried forward from 2020')
,('7950', 1, 0, '1 Day carried forward from 2020')
,('10254', 1, 0, '1 Day carried forward from 2020')
,('15363', 1, 0, '1 Day carried forward from 2020')
,('4844', 1, 0, '1 Day carried forward from 2020')
,('23613', 1, 0, '1 Day carried forward from 2020')
,('22267', 1, 0, '1 Day carried forward from 2020')
,('8320', 1, 0, '1 Day carried forward from 2020')
,('18333', 1, 0, '1 Day carried forward from 2020')
,('21440', 1, 0, '1 Day carried forward from 2020')
,('8929', 1, 0, '1 Day carried forward from 2020')
,('5205', 1, 0, '1 Day carried forward from 2020')
,('22379', 1, 0, '1 Day carried forward from 2020')
,('7802', 1, 0, '1 Day carried forward from 2020')
,('14858', 1, 0, '1 Day carried forward from 2020')
,('4791', 1, 0, '1 Day carried forward from 2020')
,('24937', 1, 0, '1 Day carried forward from 2020')
,('24258', 1, 0, '1 Day carried forward from 2020')
,('24700', 1, 0, '1 Day carried forward from 2020')
,('21491', 1, 0, '1 Day carried forward from 2020')
,('2084', 1, 0, '1 Day carried forward from 2020')
,('1178', 1, 0, '1 Day carried forward from 2020')
,('4173', 1, 0, '1 Day carried forward from 2020')
,('18488', 1, 0, '1 Day carried forward from 2020')
,('7397', 1, 0, '1 Day carried forward from 2020')
,('20331', 1, 0, '1 Day carried forward from 2020')
,('8823', 1, 0, '1 Day carried forward from 2020')
,('18578', 1, 0, '1 Day carried forward from 2020')
,('16735', 1, 0, '1 Day carried forward from 2020')
,('1724', 1, 0, '1 Day carried forward from 2020')
,('6986', 1, 0, '1 Day carried forward from 2020')
,('11909', 1, 0, '1 Day carried forward from 2020')
,('19296', 1, 0, '1 Day carried forward from 2020')
,('22980', 1, 0, '1 Day carried forward from 2020')
,('15576', 1, 0, '1 Day carried forward from 2020')
,('25012', 1, 0, '1 Day carried forward from 2020')
,('4602', 1, 0, '1 Day carried forward from 2020')
,('1269', 1, 0, '1 Day carried forward from 2020')
,('24963', 1, 0, '1 Day carried forward from 2020')
,('15000', 1, 0, '1 Day carried forward from 2020')
,('18497', 1, 0, '1 Day carried forward from 2020')
,('5450', 1, 0, '1 Day carried forward from 2020')
,('14917', 1, 0, '1 Day carried forward from 2020')
,('18812', 1, 0, '1 Day carried forward from 2020')
,('24554', 1, 0, '1 Day carried forward from 2020')
,('22420', 1, 0, '1 Day carried forward from 2020')
,('7330', 1, 0, '1 Day carried forward from 2020')
,('24614', 1, 0, '1 Day carried forward from 2020')
,('11831', 1, 0, '1 Day carried forward from 2020')
,('18374', 1, 0, '1 Day carried forward from 2020')
,('22110', 1, 0, '1 Day carried forward from 2020')
,('12328', 1, 0, '1 Day carried forward from 2020')
,('23965', 1, 0, '1 Day carried forward from 2020')
,('15578', 1, 0, '1 Day carried forward from 2020')
,('23966', 1, 0, '1 Day carried forward from 2020')
,('14522', 1, 0, '1 Day carried forward from 2020')
,('8160', 1, 2, '1 Day carried forward from 2020, 2 Days Holiday Purchase 2021')
,('14083', 1, 2, '1 Day carried forward from 2020, 2 Days Holiday Purchase 2021')
,('22973', 1, 3, '1 Day carried forward from 2020, 3 Days Holiday Purchase 2021')
,('7844', 1, 3, '1 Day carried forward from 2020, 3 Days Holiday Purchase 2021')
,('11793', 1, 3, '1 Day carried forward from 2020, 3 Days Holiday Purchase 2021')
,('16342', 1, 3, '1 Day carried forward from 2020, 3 Days Holiday Purchase 2021')
,('21683', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('24738', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('16414', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('22582', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('24947', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('19128', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('7896', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('5395', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('22621', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('18070', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('21808', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('20199', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('20364', 1, 4, '1 Day carried forward from 2020, 4 Days Holiday Purchase 2021')
,('25004', 1, 5, '1 Day carried forward from 2020, 5 Days Holiday Purchase 2021')
,('19447', 1.5, 0, '1.5 Days carried forward from 2020')
,('24359', 1.5, 0, '1.5 Days carried forward from 2020')
,('19370', 1.5, 0, '1.5 Days carried forward from 2020')
,('24310', 1.5, 0, '1.5 Days carried forward from 2020')
,('5577', 1.5, 0, '1.5 Days carried forward from 2020')
,('8153', 1.5, 0, '1.5 Days carried forward from 2020')
,('16869', 1.5, 0, '1.5 Days carried forward from 2020')
,('17866', 1.5, 0, '1.5 Days carried forward from 2020')
,('24975', 1.5, 0, '1.5 Days carried forward from 2020')
,('11296', 1.5, 0, '1.5 Days carried forward from 2020')
,('17835', 1.5, 0, '1.5 Days carried forward from 2020')
,('19928', 1.5, 0, '1.5 Days carried forward from 2020')
,('19116', 1.5, 0, '1.5 Days carried forward from 2020')
,('23916', 1.5, 0, '1.5 Days carried forward from 2020')
,('14073', 1.5, 1, '1.5 Days carried forward from 2020, 1 Day Holiday Purchase 2021')
,('22514', 1.5, 2.5, '1.5 Days carried forward from 2020, 2.5 Days Holiday Purchase 2021')
,('11441', 1.5, 3.5, '1.5 Days carried forward from 2020, 3.5 Days Holiday Purchase 2021')
,('10571', 1.5, 3.5, '1.5 Days carried forward from 2020, 3.5 Days Holiday Purchase 2021')
,('24976', 1.5, 3.5, '1.5 Days carried forward from 2020, 3.5 Days Holiday Purchase 2021')
,('15282', 2, 0, '2 Days carried forward from 2020')
,('593', 2, 0, '2 Days carried forward from 2020')
,('8448', 2, 0, '2 Days carried forward from 2020')
,('23029', 2, 0, '2 Days carried forward from 2020')
,('6626', 2, 0, '2 Days carried forward from 2020')
,('9076', 2, 0, '2 Days carried forward from 2020')
,('21691', 2, 0, '2 Days carried forward from 2020')
,('23436', 2, 0, '2 Days carried forward from 2020')
,('20398', 2, 0, '2 Days carried forward from 2020')
,('24494', 2, 0, '2 Days carried forward from 2020')
,('8278', 2, 0, '2 Days carried forward from 2020')
,('23732', 2, 0, '2 Days carried forward from 2020')
,('21955', 2, 0, '2 Days carried forward from 2020')
,('24730', 2, 0, '2 Days carried forward from 2020')
,('24591', 2, 0, '2 Days carried forward from 2020')
,('23658', 2, 0, '2 Days carried forward from 2020')
,('11280', 2, 0, '2 Days carried forward from 2020')
,('22700', 2, 0, '2 Days carried forward from 2020')
,('16604', 2, 0, '2 Days carried forward from 2020')
,('20487', 2, 0, '2 Days carried forward from 2020')
,('24701', 2, 0, '2 Days carried forward from 2020')
,('19509', 2, 0, '2 Days carried forward from 2020')
,('24144', 2, 0, '2 Days carried forward from 2020')
,('24934', 2, 0, '2 Days carried forward from 2020')
,('18512', 2, 0, '2 Days carried forward from 2020')
,('24922', 2, 0, '2 Days carried forward from 2020')
,('18577', 2, 0, '2 Days carried forward from 2020')
,('25056', 2, 0, '2 Days carried forward from 2020')
,('4104', 2, 0, '2 Days carried forward from 2020')
,('23754', 2, 0, '2 Days carried forward from 2020')
,('22519', 2, 0, '2 Days carried forward from 2020')
,('24097', 2, 0, '2 Days carried forward from 2020')
,('24974', 2, 0, '2 Days carried forward from 2020')
,('6427', 2, 0, '2 Days carried forward from 2020')
,('17706', 2, 0, '2 Days carried forward from 2020')
,('11900', 2, 0, '2 Days carried forward from 2020')
,('18934', 2, 0, '2 Days carried forward from 2020')
,('3062', 2, 0, '2 Days carried forward from 2020')
,('24135', 2, 0, '2 Days carried forward from 2020')
,('24475', 2, 0, '2 Days carried forward from 2020')
,('20417', 2, 0, '2 Days carried forward from 2020')
,('7658', 2, 0, '2 Days carried forward from 2020')
,('14468', 2, 0, '2 Days carried forward from 2020')
,('24596', 2, 0, '2 Days carried forward from 2020')
,('18427', 2, 0, '2 Days carried forward from 2020')
,('15360', 2, 3, '2 Days carried forward from 2020, 3 Days Holiday Purchase 2021')
,('23437', 2, 3, '2 Days carried forward from 2020, 3 Days Holiday Purchase 2021')
,('25054', 2, 3, '2 Days carried forward from 2020, 3 Days Holiday Purchase 2021')
,('22041', 2, 3, '2 Days carried forward from 2020, 3 Days Holiday Purchase 2021')
,('7407', 2, 3, '2 Days carried forward from 2020, 3 Days Holiday Purchase 2021')
,('22384', 2.5, 0, '2.5 Days carried forward from 2020')
,('19817', 2.5, 0, '2.5 Days carried forward from 2020')
,('19848', 2.5, 0, '2.5 Days carried forward from 2020')
,('11653', 2.5, 0, '2.5 Days carried forward from 2020')
,('6019', 2.5, 0, '2.5 Days carried forward from 2020')
,('5936', 2.5, 0, '2.5 Days carried forward from 2020')
,('23765', 2.5, 0, '2.5 Days carried forward from 2020')
,('24946', 2.5, 0, '2.5 Days carried forward from 2020')
,('22239', 2.5, 0, '2.5 Days carried forward from 2020')
,('12799', 2.5, 0, '2.5 Days carried forward from 2020')
,('7701', 2.5, 0, '2.5 Days carried forward from 2020')
,('13781', 2.5, 0, '2.5 Days carried forward from 2020')
,('24709', 2.5, 0, '2.5 Days carried forward from 2020')
,('22506', 2.5, 0, '2.5 Days carried forward from 2020')
,('16800', 2.5, 0, '2.5 Days carried forward from 2020')
,('4689', 2.5, 2.5, '2.5 Days carried forward from 2020, 2.5 Days Holiday Purchase 2021')
,('24722', 2.5, 2.5, '2.5 Days carried forward from 2020, 2.5 Days Holiday Purchase 2021')
,('7798', 3, 0, '3 Days carried forward from 2020')
,('20562', 3, 0, '3 Days carried forward from 2020')
,('18182', 3, 0, '3 Days carried forward from 2020')
,('6273', 3, 0, '3 Days carried forward from 2020')
,('19085', 3, 0, '3 Days carried forward from 2020')
,('20317', 3, 0, '3 Days carried forward from 2020')
,('8411', 3, 0, '3 Days carried forward from 2020')
,('24965', 3, 0, '3 Days carried forward from 2020')
,('18875', 3, 0, '3 Days carried forward from 2020')
,('24797', 3, 0, '3 Days carried forward from 2020')
,('13856', 3, 0, '3 Days carried forward from 2020')
,('24142', 3, 0, '3 Days carried forward from 2020')
,('18986', 3, 0, '3 Days carried forward from 2020')
,('11023', 3, 0, '3 Days carried forward from 2020')
,('8335', 3, 0, '3 Days carried forward from 2020')
,('7833', 3, 0, '3 Days carried forward from 2020')
,('23704', 3, 0, '3 Days carried forward from 2020')
,('21318', 3, 0, '3 Days carried forward from 2020')
,('25014', 3, 0, '3 Days carried forward from 2020')
,('21995', 3, 0, '3 Days carried forward from 2020')
,('11791', 3, 0, '3 Days carried forward from 2020')
,('15440', 3, 0, '3 Days carried forward from 2020')
,('10656', 3, 0, '3 Days carried forward from 2020')
,('12456', 3, 0, '3 Days carried forward from 2020')
,('18022', 3, 0, '3 Days carried forward from 2020')
,('11971', 3, 0, '3 Days carried forward from 2020')
,('5220', 3, 0, '3 Days carried forward from 2020')
,('8534', 3, 0, '3 Days carried forward from 2020')
,('18242', 3, 0, '3 Days carried forward from 2020')
,('5121', 3, 0, '3 Days carried forward from 2020')
,('24950', 3, 0, '3 Days carried forward from 2020')
,('24459', 3, 0, '3 Days carried forward from 2020')
,('15289', 3, 0, '3 Days carried forward from 2020')
,('7680', 3, 0, '3 Days carried forward from 2020')
,('24708', 3, 0, '3 Days carried forward from 2020')
,('18911', 3, 0, '3 Days carried forward from 2020')
,('5857', 3, 0, '3 Days carried forward from 2020')
,('10176', 3, 0, '3 Days carried forward from 2020')
,('12605', 3, 0, '3 Days carried forward from 2020')
,('9104', 3, 0, '3 Days carried forward from 2020')
,('12524', 3, 0, '3 Days carried forward from 2020')
,('19153', 3, 0, '3 Days carried forward from 2020')
,('8207', 3, 1, '3 Days carried forward from 2020, 1 Day Holiday Purchase 2021')
,('22559', 3, 2, '3 Days carried forward from 2020, 2 Days Holiday Purchase 2021')
,('23104', 3, 2, '3 Days carried forward from 2020, 2 Days Holiday Purchase 2021')
,('7722', 3, 2, '3 Days carried forward from 2020, 2 Days Holiday Purchase 2021')
,('13350', 3, 2, '3 Days carried forward from 2020, 2 Days Holiday Purchase 2021')
,('15749', 3, 2, '3 Days carried forward from 2020, 2 Days Holiday Purchase 2021')
,('13293', 3, 2, '3 Days carried forward from 2020, 2 Days Holiday Purchase 2021')
,('22614', 3, 2, '3 Days carried forward from 2020, 2 Days Holiday Purchase 2021')
,('8980', 3, 2, '3 Days carried forward from 2020, 2 Days Holiday Purchase 2021')
,('5953', 3, 2, '3 Days carried forward from 2020, 2 Days Holiday Purchase 2021')
,('14984', 3, 2, '3 Days carried forward from 2020, 2 Days Holiday Purchase 2021')
,('25047', 3.5, 0, '3.5 Days carried forward from 2020')
,('25019', 3.5, 0, '3.5 Days carried forward from 2020')
,('25022', 3.5, 0, '3.5 Days carried forward from 2020')
,('5922', 3.5, 0, '3.5 Days carried forward from 2020')
,('22456', 3.5, 0, '3.5 Days carried forward from 2020')
,('4543', 3.5, 0, '3.5 Days carried forward from 2020')
,('25006', 3.5, 0, '3.5 Days carried forward from 2020')
,('24957', 3.5, 0, '3.5 Days carried forward from 2020')
,('24958', 3.5, 0, '3.5 Days carried forward from 2020')
,('25017', 3.5, 0, '3.5 Days carried forward from 2020')
,('12316', 3.5, 0, '3.5 Days carried forward from 2020')
,('23586', 3.5, 0, '3.5 Days carried forward from 2020')
,('4957', 3.5, 0, '3.5 Days carried forward from 2020')
,('24927', 3.5, 0, '3.5 Days carried forward from 2020')
,('17312', 3.5, 0, '3.5 Days carried forward from 2020')
,('19035', 3.5, 0, '3.5 Days carried forward from 2020')
,('16855', 3.5, 0, '3.5 Days carried forward from 2020')
,('24829', 3.5, 0, '3.5 Days carried forward from 2020')
,('21983', 3.5, 1.5, '3.5 Days carried forward from 2020, 1.5 Days Holiday Purchase 2021')
,('8882', 3.5, 1.5, '3.5 Days carried forward from 2020, 1.5 Days Holiday Purchase 2021')
,('22676', 3.5, 1.5, '3.5 Days carried forward from 2020, 1.5 Days Holiday Purchase 2021')
,('7738', 4, 0, '4 Days carried forward from 2020')
,('20628', 4, 0, '4 Days carried forward from 2020')
,('9133', 4, 0, '4 Days carried forward from 2020')
,('23298', 4, 0, '4 Days carried forward from 2020')
,('19663', 4, 0, '4 Days carried forward from 2020')
,('15224', 4, 0, '4 Days carried forward from 2020')
,('10179', 4, 0, '4 Days carried forward from 2020')
,('22424', 4, 0, '4 Days carried forward from 2020')
,('18804', 4, 0, '4 Days carried forward from 2020')
,('15763', 4, 0, '4 Days carried forward from 2020')
,('16078', 4, 0, '4 Days carried forward from 2020')
,('6950', 4, 0, '4 Days carried forward from 2020')
,('24980', 4, 0, '4 Days carried forward from 2020')
,('14006', 4, 0, '4 Days carried forward from 2020')
,('8620', 4, 0, '4 Days carried forward from 2020')
,('18817', 4, 0, '4 Days carried forward from 2020')
,('11693', 4, 0, '4 Days carried forward from 2020')
,('12737', 4, 0, '4 Days carried forward from 2020')
,('24669', 4, 0, '4 Days carried forward from 2020')
,('11723', 4, 0, '4 Days carried forward from 2020')
,('20291', 4, 0, '4 Days carried forward from 2020')
,('4638', 4, 0, '4 Days carried forward from 2020')
,('20826', 4, 0, '4 Days carried forward from 2020')
,('8676', 4, 0, '4 Days carried forward from 2020')
,('19206', 4, 0, '4 Days carried forward from 2020')
,('16881', 4, 0, '4 Days carried forward from 2020')
,('24397', 4, 0, '4 Days carried forward from 2020')
,('18498', 4, 0, '4 Days carried forward from 2020')
,('23302', 4, 0, '4 Days carried forward from 2020')
,('18851', 4, 0, '4 Days carried forward from 2020')
,('20878', 4, 0, '4 Days carried forward from 2020')
,('19274', 4, 0, '4 Days carried forward from 2020')
,('9626', 4, 0, '4 Days carried forward from 2020')
,('17573', 4, 0, '4 Days carried forward from 2020')
,('19418', 4, 0, '4 Days carried forward from 2020')
,('23106', 4, 0, '4 Days carried forward from 2020')
,('19896', 4, 0, '4 Days carried forward from 2020')
,('24926', 4, 0, '4 Days carried forward from 2020')
,('8956', 4, 0, '4 Days carried forward from 2020')
,('22999', 4, 0, '4 Days carried forward from 2020')
,('9173', 4, 0, '4 Days carried forward from 2020')
,('22725', 4, 0, '4 Days carried forward from 2020')
,('15250', 4, 0, '4 Days carried forward from 2020')
,('15554', 4, 0, '4 Days carried forward from 2020')
,('7172', 4, 1, '4 Days carried forward from 2020, 1 Day Holiday Purchase 2021')
,('9021', 4, 1, '4 Days carried forward from 2020, 1 Day Holiday Purchase 2021')
,('6129', 4, 1, '4 Days carried forward from 2020, 1 Day Holiday Purchase 2021')
,('13160', 4, 1, '4 Days carried forward from 2020, 1 Day Holiday Purchase 2021')
,('22846', 4.5, 0, '4.5 Days carried forward from 2020')
,('24925', 4.5, 0, '4.5 Days carried forward from 2020')
,('24985', 4.5, 0, '4.5 Days carried forward from 2020')
,('13035', 4.5, 0, '4.5 Days carried forward from 2020')
,('22418', 4.5, 0, '4.5 Days carried forward from 2020')
,('8174', 4.5, 0, '4.5 Days carried forward from 2020')
,('16349', 4.5, 0, '4.5 Days carried forward from 2020')
,('21810', 4.5, 0, '4.5 Days carried forward from 2020')
,('13083', 4.5, 0, '4.5 Days carried forward from 2020')
,('5129', 4.5, 0, '4.5 Days carried forward from 2020')
,('8770', 4.5, 0, '4.5 Days carried forward from 2020')
,('22094', 4.5, 0, '4.5 Days carried forward from 2020')
,('23320', 4.5, 0, '4.5 Days carried forward from 2020')
,('19407', 4.5, 0, '4.5 Days carried forward from 2020')
,('20769', 4.5, 0, '4.5 Days carried forward from 2020')
,('24948', 4.5, 0, '4.5 Days carried forward from 2020')
,('18156', 4.5, 0.5, '4.5 Days carried forward from 2020, 0.5 Days Holiday Purchase 2021')
,('22221', 4.5, 0.5, '4.5 Days carried forward from 2020, 0.5 Days Holiday Purchase 2021')
,('19271', 5, 0, '5 Days carried forward from 2020')
,('15575', 5, 0, '5 Days carried forward from 2020')
,('10801', 5, 0, '5 Days carried forward from 2020')
,('22027', 5, 0, '5 Days carried forward from 2020')
,('20789', 5, 0, '5 Days carried forward from 2020')
,('9640', 5, 0, '5 Days carried forward from 2020')
,('24292', 5, 0, '5 Days carried forward from 2020')
,('22578', 5, 0, '5 Days carried forward from 2020')
,('18407', 5, 0, '5 Days carried forward from 2020')
,('12474', 5, 0, '5 Days carried forward from 2020')
,('21308', 5, 0, '5 Days carried forward from 2020')
,('23293', 5, 0, '5 Days carried forward from 2020')
,('22620', 5, 0, '5 Days carried forward from 2020')
,('24131', 5, 0, '5 Days carried forward from 2020')
,('12679', 5, 0, '5 Days carried forward from 2020')
,('12731', 5, 0, '5 Days carried forward from 2020')
,('20475', 5, 0, '5 Days carried forward from 2020')
,('4804', 5, 0, '5 Days carried forward from 2020')
,('18279', 5, 0, '5 Days carried forward from 2020')
,('15958', 5, 0, '5 Days carried forward from 2020')
,('13184', 5, 0, '5 Days carried forward from 2020')
,('21031', 5, 0, '5 Days carried forward from 2020')
,('24484', 5, 0, '5 Days carried forward from 2020')
,('24460', 5, 0, '5 Days carried forward from 2020')
,('24609', 5, 0, '5 Days carried forward from 2020')
,('23668', 5, 0, '5 Days carried forward from 2020')
,('20879', 5, 0, '5 Days carried forward from 2020')
,('22471', 5, 0, '5 Days carried forward from 2020')
,('20824', 5, 0, '5 Days carried forward from 2020')
,('23947', 5, 0, '5 Days carried forward from 2020')
,('12550', 5, 0, '5 Days carried forward from 2020')
,('17234', 5, 0, '5 Days carried forward from 2020')
,('7452', 5, 0, '5 Days carried forward from 2020')
,('5870', 5, 0, '5 Days carried forward from 2020')
,('19564', 5, 0, '5 Days carried forward from 2020')
,('16536', 5, 0, '5 Days carried forward from 2020')
,('20985', 5, 0, '5 Days carried forward from 2020')
,('19847', 5, 0, '5 Days carried forward from 2020')
,('12025', 5, 0, '5 Days carried forward from 2020')
,('22254', 5, 0, '5 Days carried forward from 2020')
,('15408', 5, 0, '5 Days carried forward from 2020')
,('7103', 5, 0, '5 Days carried forward from 2020')
,('1366', 5, 0, '5 Days carried forward from 2020')
,('23612', 5, 0, '5 Days carried forward from 2020')
,('24666', 5, 0, '5 Days carried forward from 2020')
,('24664', 5, 0, '5 Days carried forward from 2020')
,('22281', 5, 0, '5 Days carried forward from 2020')
,('12084', 5, 0, '5 Days carried forward from 2020')
,('1428', 5, 0, '5 Days carried forward from 2020')
,('1640', 5, 0, '5 Days carried forward from 2020')
,('16677', 5, 0, '5 Days carried forward from 2020')
,('12403', 5, 0, '5 Days carried forward from 2020')
,('16097', 5, 0, '5 Days carried forward from 2020')
,('24914', 5, 0, '5 Days carried forward from 2020')
,('22257', 5, 0, '5 Days carried forward from 2020')
,('11958', 5, 0, '5 Days carried forward from 2020')
,('11898', 5, 0, '5 Days carried forward from 2020')
,('24911', 5, 0, '5 Days carried forward from 2020')
,('20983', 5, 0, '5 Days carried forward from 2020')
,('15166', 5, 0, '5 Days carried forward from 2020')
,('19910', 5, 0, '5 Days carried forward from 2020')
,('5679', 5, 0, '5 Days carried forward from 2020')
,('7563', 5, 0, '5 Days carried forward from 2020')
,('24479', 5, 0, '5 Days carried forward from 2020')
,('13226', 5, 0, '5 Days carried forward from 2020')
,('18162', 5, 0, '5 Days carried forward from 2020')
,('13810', 5, 0, '5 Days carried forward from 2020')
,('24489', 5, 0, '5 Days carried forward from 2020')
,('10269', 5, 0, '5 Days carried forward from 2020')
,('10866', 5, 0, '5 Days carried forward from 2020')
,('8993', 5, 0, '5 Days carried forward from 2020')
,('22976', 5, 0, '5 Days carried forward from 2020')
,('1691', 5, 0, '5 Days carried forward from 2020')
,('18639', 5, 0, '5 Days carried forward from 2020')
,('22843', 5, 0, '5 Days carried forward from 2020')
,('11994', 5, 0, '5 Days carried forward from 2020')
,('1593', 5, 0, '5 Days carried forward from 2020')
,('6311', 5, 0, '5 Days carried forward from 2020')
,('4360', 5, 0, '5 Days carried forward from 2020')
,('5790', 5, 0, '5 Days carried forward from 2020')
,('10307', 5, 0, '5 Days carried forward from 2020')
,('22070', 5, 0, '5 Days carried forward from 2020')
,('23163', 5, 0, '5 Days carried forward from 2020')
,('18930', 5, 0, '5 Days carried forward from 2020')
,('6905', 5, 0, '5 Days carried forward from 2020')
,('7149', 5, 0, '5 Days carried forward from 2020')
,('11318', 5, 0, '5 Days carried forward from 2020')
,('20484', 5, 0, '5 Days carried forward from 2020')
,('9043', 5, 0, '5 Days carried forward from 2020')
,('8438', 5, 0, '5 Days carried forward from 2020')
,('15326', 5, 0, '5 Days carried forward from 2020')
,('8115', 5, 0, '5 Days carried forward from 2020')
,('5460', 5, 0, '5 Days carried forward from 2020')
,('15758', 5, 0, '5 Days carried forward from 2020')
,('5349', 5, 0, '5 Days carried forward from 2020')
,('19237', 5, 0, '5 Days carried forward from 2020')
,('9383', 5, 0, '5 Days carried forward from 2020')
,('6120', 5, 0, '5 Days carried forward from 2020')
,('9294', 5, 0, '5 Days carried forward from 2020')
,('7140', 5, 0, '5 Days carried forward from 2020')
,('13090', 5, 0, '5 Days carried forward from 2020')
,('19477', 5, 0, '5 Days carried forward from 2020')
,('12155', 5, 0, '5 Days carried forward from 2020')
,('24935', 5, 0, '5 Days carried forward from 2020')
,('14025', 5, 0, '5 Days carried forward from 2020')
,('24977', 5, 0, '5 Days carried forward from 2020')
,('1184', 5, 0, '5 Days carried forward from 2020')
,('17442', 5, 0, '5 Days carried forward from 2020')
,('12689', 5, 0, '5 Days carried forward from 2020')
,('23703', 5, 0, '5 Days carried forward from 2020')
,('20107', 5, 0, '5 Days carried forward from 2020')
,('19449', 5, 0, '5 Days carried forward from 2020')
,('22402', 5, 0, '5 Days carried forward from 2020')
,('23711', 5, 0, '5 Days carried forward from 2020')
,('24739', 5, 0, '5 Days carried forward from 2020')
,('21009', 5, 0, '5 Days carried forward from 2020')
,('718', 5, 0, '5 Days carried forward from 2020')
,('23712', 5, 0, '5 Days carried forward from 2020')
,('25010', 5, 0, '5 Days carried forward from 2020')
,('18729', 5, 0, '5 Days carried forward from 2020')
,('12868', 5, 0, '5 Days carried forward from 2020')
,('8375', 5, 0, '5 Days carried forward from 2020')
,('13094', 5, 0, '5 Days carried forward from 2020')
,('24960', 5, 0, '5 Days carried forward from 2020')
,('24962', 5, 0, '5 Days carried forward from 2020')
,('24468', 5, 0, '5 Days carried forward from 2020')
,('8355', 5, 0, '5 Days carried forward from 2020')
,('24955', 5, 0, '5 Days carried forward from 2020')
,('19135', 5, 0, '5 Days carried forward from 2020')
,('24987', 5, 0, '5 Days carried forward from 2020')
,('9801', 5, 0, '5 Days carried forward from 2020')
,('24959', 5, 0, '5 Days carried forward from 2020')
,('8319', 5, 0, '5 Days carried forward from 2020')
,('24961', 5, 0, '5 Days carried forward from 2020')
,('6045', 5, 0, '5 Days carried forward from 2020')
,('8316', 5, 0, '5 Days carried forward from 2020')
,('7962', 5, 0, '5 Days carried forward from 2020')
,('4134', 5, 0, '5 Days carried forward from 2020')
,('19528', 5, 0, '5 Days carried forward from 2020')
,('1373', 5, 0, '5 Days carried forward from 2020')
,('14619', 5, 0, '5 Days carried forward from 2020')
,('4837', 5, 0, '5 Days carried forward from 2020')
,('19661', 5, 0, '5 Days carried forward from 2020')
,('24400', 5, 0, '5 Days carried forward from 2020')
,('8977', 5, 0, '5 Days carried forward from 2020')
,('24746', 5, 0, '5 Days carried forward from 2020')
,('24698', 5, 0, '5 Days carried forward from 2020')
,('19016', 5, 0, '5 Days carried forward from 2020')
,('3080', 5, 0, '5 Days carried forward from 2020')
,('17827', 5, 0, '5 Days carried forward from 2020')
,('12942', 5, 0, '5 Days carried forward from 2020')
,('6313', 5, 0, '5 Days carried forward from 2020')
,('12239', 5, 0, '5 Days carried forward from 2020')
,('17456', 5, 0, '5 Days carried forward from 2020')
,('12435', 5, 0, '5 Days carried forward from 2020')
,('16007', 5, 0, '5 Days carried forward from 2020')
,('21297', 5, 0, '5 Days carried forward from 2020')
,('13760', 5, 0, '5 Days carried forward from 2020')
,('5166', 5, 0, '5 Days carried forward from 2020')
,('10114', 5, 0, '5 Days carried forward from 2020')
,('21215', 5, 0, '5 Days carried forward from 2020')
,('8138', 5, 0, '5 Days carried forward from 2020')
,('18492', 5, 0, '5 Days carried forward from 2020')
,('10314', 5, 0, '5 Days carried forward from 2020')
,('22868', 5, 0, '5 Days carried forward from 2020')
,('21697', 5, 0, '5 Days carried forward from 2020')
,('10010', 5, 0, '5 Days carried forward from 2020')
,('24734', 5, 0, '5 Days carried forward from 2020')
,('18588', 5, 0, '5 Days carried forward from 2020')
,('24988', 5, 0, '5 Days carried forward from 2020')
,('18478', 5, 0, '5 Days carried forward from 2020')
,('21746', 5, 0, '5 Days carried forward from 2020')
,('16554', 5, 0, '5 Days carried forward from 2020')
,('21767', 5, 0, '5 Days carried forward from 2020')
,('4007', 5, 0, '5 Days carried forward from 2020')
,('15776', 5, 0, '5 Days carried forward from 2020')
,('24790', 5, 0, '5 Days carried forward from 2020')
,('23291', 5, 0, '5 Days carried forward from 2020')
,('35', 5, 0, '5 Days carried forward from 2020')
,('24966', 5, 0, '5 Days carried forward from 2020')
,('8443', 5, 0, '5 Days carried forward from 2020')
,('24741', 5, 0, '5 Days carried forward from 2020')
,('11345', 5, 0, '5 Days carried forward from 2020')
,('23902', 5, 0, '5 Days carried forward from 2020')
,('24520', 5, 0, '5 Days carried forward from 2020')
,('18899', 5, 0, '5 Days carried forward from 2020')
,('10112', 5, 0, '5 Days carried forward from 2020')
,('4664', 5, 0, '5 Days carried forward from 2020')
,('5853', 5, 0, '5 Days carried forward from 2020')
,('11510', 5, 0, '5 Days carried forward from 2020')
,('8050', 5, 0, '5 Days carried forward from 2020')
,('20936', 5, 0, '5 Days carried forward from 2020')
,('24220', 5, 0, '5 Days carried forward from 2020')
,('24151', 5, 0, '5 Days carried forward from 2020')
,('19315', 5, 0, '5 Days carried forward from 2020')
,('20969', 5, 0, '5 Days carried forward from 2020')
,('18160', 5, 0, '5 Days carried forward from 2020')
,('14870', 5, 0, '5 Days carried forward from 2020')
,('24200', 5, 0, '5 Days carried forward from 2020')
,('13748', 5, 0, '5 Days carried forward from 2020')
,('13287', 5, 0, '5 Days carried forward from 2020')
,('13938', 5, 0, '5 Days carried forward from 2020')
,('23143', 5, 0, '5 Days carried forward from 2020')
,('11426', 5, 0, '5 Days carried forward from 2020')
,('7211', 5, 0, '5 Days carried forward from 2020')
,('24928', 5, 0, '5 Days carried forward from 2020')
,('20215', 5, 0, '5 Days carried forward from 2020')
,('17410', 5, 0, '5 Days carried forward from 2020')
,('21764', 5, 0, '5 Days carried forward from 2020')
,('9852', 5, 0, '5 Days carried forward from 2020')
,('24570', 5, 0, '5 Days carried forward from 2020')
,('24716', 5, 0, '5 Days carried forward from 2020')
,('14914', 5, 0, '5 Days carried forward from 2020')
,('23582', 5, 0, '5 Days carried forward from 2020')
,('13646', 5, 0, '5 Days carried forward from 2020')
,('16963', 5, 0, '5 Days carried forward from 2020')
,('10023', 5, 0, '5 Days carried forward from 2020')
,('15787', 5, 0, '5 Days carried forward from 2020')
,('20863', 5, 0, '5 Days carried forward from 2020')
,('10616', 5, 0, '5 Days carried forward from 2020')
,('17494', 5, 0, '5 Days carried forward from 2020')
,('10097', 5, 0, '5 Days carried forward from 2020')
,('18985', 5, 0, '5 Days carried forward from 2020')
,('7754', 5, 0, '5 Days carried forward from 2020')
,('7879', 5, 0, '5 Days carried forward from 2020')
,('20493', 5, 0, '5 Days carried forward from 2020')
,('16418', 5, 0, '5 Days carried forward from 2020')
,('23038', 5, 0, '5 Days carried forward from 2020')
,('22699', 5, 0, '5 Days carried forward from 2020')
,('1809', 5, 0, '5 Days carried forward from 2020')
,('18868', 5, 0, '5 Days carried forward from 2020')
,('13159', 5, 0, '5 Days carried forward from 2020')
,('24433', 5, 0, '5 Days carried forward from 2020')
,('20947', 5, 0, '5 Days carried forward from 2020')
,('24529', 5, 0, '5 Days carried forward from 2020')
,('23105', 5, 0, '5 Days carried forward from 2020')
,('22966', 5, 0, '5 Days carried forward from 2020')
,('22021', 5, 0, '5 Days carried forward from 2020')
,('7147', 5, 0, '5 Days carried forward from 2020')
,('12404', 5, 0, '5 Days carried forward from 2020')
,('11204', 5, 0, '5 Days carried forward from 2020')
,('20918', 5, 0, '5 Days carried forward from 2020')
,('1803', 5, 0, '5 Days carried forward from 2020')
,('13246', 5, 0, '5 Days carried forward from 2020')
,('16147', 5, 0, '5 Days carried forward from 2020')
,('18827', 5, 0, '5 Days carried forward from 2020')
,('11292', 5, 0, '5 Days carried forward from 2020')
,('9630', 5, 0, '5 Days carried forward from 2020')
,('9421', 5, 0, '5 Days carried forward from 2020')
,('23120', 5, 0, '5 Days carried forward from 2020')
,('13743', 5, 0, '5 Days carried forward from 2020')
,('13704', 5, 0, '5 Days carried forward from 2020')
,('17525', 5, 0, '5 Days carried forward from 2020')
,('24585', 5, 0, '5 Days carried forward from 2020')
,('24201', 5, 0, '5 Days carried forward from 2020')
,('19744', 5, 0, '5 Days carried forward from 2020')
,('19779', 5, 0, '5 Days carried forward from 2020')
,('8671', 5, 0, '5 Days carried forward from 2020')
,('15441', 5, 0, '5 Days carried forward from 2020')
,('7043', 5, 0, '5 Days carried forward from 2020')
,('20569', 5, 0, '5 Days carried forward from 2020')
,('19806', 5, 0, '5 Days carried forward from 2020')
,('18994', 5, 0, '5 Days carried forward from 2020')
,('13890', 5, 0, '5 Days carried forward from 2020')
,('18910', 5, 0, '5 Days carried forward from 2020')
,('5289', 5, 0, '5 Days carried forward from 2020')
,('19070', 5, 0, '5 Days carried forward from 2020')
,('18198', 5, 0, '5 Days carried forward from 2020')
,('4342', 5, 0, '5 Days carried forward from 2020')
,('7682', 5, 0, '5 Days carried forward from 2020')
,('21416', 5, 0, '5 Days carried forward from 2020')
,('7683', 5, 0, '5 Days carried forward from 2020')
,('7367', 5, 0, '5 Days carried forward from 2020')
,('16907', 5, 0, '5 Days carried forward from 2020')
,('8945', 5, 0, '5 Days carried forward from 2020')
,('9727', 5, 0, '5 Days carried forward from 2020')
,('9002', 5, 0, '5 Days carried forward from 2020')
,('18408', 5, 0, '5 Days carried forward from 2020')
,('21658', 5, 0, '5 Days carried forward from 2020')
,('19986', 5, 0, '5 Days carried forward from 2020')
,('20564', 5, 0, '5 Days carried forward from 2020')
,('14283', 5, 0, '5 Days carried forward from 2020')
,('14385', 5, 0, '5 Days carried forward from 2020')
,('14519', 5, 0, '5 Days carried forward from 2020')
,('22505', 5, 0, '5 Days carried forward from 2020')
,('20454', 5, 0, '5 Days carried forward from 2020')
,('19593', 5, 0, '5 Days carried forward from 2020')
,('19860', 5, 0, '5 Days carried forward from 2020')
,('15516', 5, 0, '5 Days carried forward from 2020')
,('14645', 5, 0, '5 Days carried forward from 2020')
,('14315', 5, 0, '5 Days carried forward from 2020')
,('15429', 5, 0, '5 Days carried forward from 2020')
,('20046', 5, 0, '5 Days carried forward from 2020')
,('14487', 5, 0, '5 Days carried forward from 2020')
,('18224', 5, 0, '5 Days carried forward from 2020')
,('22501', 5, 0, '5 Days carried forward from 2020')
,('20456', 5, 0, '5 Days carried forward from 2020')
,('14371', 5, 0, '5 Days carried forward from 2020')
,('14337', 5, 0, '5 Days carried forward from 2020')
,('14352', 5, 0, '5 Days carried forward from 2020')
,('22949', 5.5, 0, '5.5 Days carried forward from 2020')
,('12434', 5.5, 0, '5.5 Days carried forward from 2020')
,('15574', 6, 0, '6 Days carried forward from 2020')
,('23074', 6, 0, '6 Days carried forward from 2020')
,('20887', 6, 0, '6 Days carried forward from 2020')
,('1414', 6, 0, '6 Days carried forward from 2020')
,('6243', 6, 0, '6 Days carried forward from 2020')
,('20497', 6, 0, '6 Days carried forward from 2020')
,('24567', 6, 0, '6 Days carried forward from 2020')
,('5523', 6, 0, '6 Days carried forward from 2020')
,('4621', 6, 0, '6 Days carried forward from 2020')
,('22799', 6, 0, '6 Days carried forward from 2020')
,('24559', 6, 0, '6 Days carried forward from 2020')
,('24575', 6, 0, '6 Days carried forward from 2020')
,('13908', 6, 0, '6 Days carried forward from 2020')
,('17552', 6, 0, '6 Days carried forward from 2020')
,('18373', 6, 0, '6 Days carried forward from 2020')
,('12738', 6, 0, '6 Days carried forward from 2020')
,('16734', 6, 0, '6 Days carried forward from 2020')
,('16980', 6, 0, '6 Days carried forward from 2020')
,('8089', 6, 0, '6 Days carried forward from 2020')
,('9042', 6, 0, '6 Days carried forward from 2020')
,('20580', 6, 0, '6 Days carried forward from 2020')
,('1801', 6, 0, '6 Days carried forward from 2020')
,('6918', 6, 0, '6 Days carried forward from 2020')
,('24129', 6, 0, '6 Days carried forward from 2020')
,('19042', 6, 0, '6 Days carried forward from 2020')
,('19294', 6, 0, '6 Days carried forward from 2020')
,('8318', 6, 0, '6 Days carried forward from 2020')
,('17043', 6, 0, '6 Days carried forward from 2020')
,('1630', 6, 0, '6 Days carried forward from 2020')
,('18509', 6, 0, '6 Days carried forward from 2020')
,('23058', 6, 0, '6 Days carried forward from 2020')
,('22167', 6, 0, '6 Days carried forward from 2020')
,('24699', 6, 0, '6 Days carried forward from 2020')
,('6520', 6, 0, '6 Days carried forward from 2020')
,('1000', 6, 0, '6 Days carried forward from 2020')
,('15544', 6, 0, '6 Days carried forward from 2020')
,('8249', 6, 0, '6 Days carried forward from 2020')
,('18527', 6, 0, '6 Days carried forward from 2020')
,('17236', 6, 0, '6 Days carried forward from 2020')
,('1750', 6, 0, '6 Days carried forward from 2020')
,('23107', 6, 0, '6 Days carried forward from 2020')
,('4433', 6, 0, '6 Days carried forward from 2020')
,('8837', 6, 0, '6 Days carried forward from 2020')
,('20574', 6, 0, '6 Days carried forward from 2020')
,('8938', 6, 0, '6 Days carried forward from 2020')
,('1831', 6, 0, '6 Days carried forward from 2020')
,('22671', 6, 0, '6 Days carried forward from 2020')
,('15266', 6, 0, '6 Days carried forward from 2020')
,('1789', 6, 0, '6 Days carried forward from 2020')
,('20894', 6, 0, '6 Days carried forward from 2020')
,('20009', 6, 0, '6 Days carried forward from 2020')
,('23654', 6, 0, '6 Days carried forward from 2020')
,('18808', 6, 0, '6 Days carried forward from 2020')
,('24584', 6, 0, '6 Days carried forward from 2020')
,('19732', 6, 0, '6 Days carried forward from 2020')
,('22512', 6, 0, '6 Days carried forward from 2020')
,('22077', 8, 5, '8 Days carried forward from 2020, 5 Days Holiday Purchase 2021')

;WITH emps(YearNdx, BF, MA, Notes) 
AS( SELECT DB.Ndx, d.BF, d.MA, d.Notes
	FROM DB_OSP_YEARLY_BREAKDOWN DB
	INNER JOIN LNK_EMPLOYEE_CONTRACT LEC
	ON LEC.Right_Join = DB.Master_Id
	INNER JOIN DT_EMPLOYEE DTE
	ON DTE.Entity_Id = LEC.Left_Join
	AND DTE.Ndx = (SELECT TOP 1 Ndx FROM DT_EMPLOYEE WHERE Entity_Id = DTE.Entity_Id ORDER BY Entity_Start_Date DESC)
	INNER JOIN @RawData d
	ON d.EmployeeID = CAST(DTE.EmployeeID as varchar(10))
	WHERE DB.Plan_Type = 'Holiday'
	AND DB.Year = 2021
)
UPDATE DB_OSP_YEARLY_BREAKDOWN 
SET Brought_Forward_Amount = isnull(b.Brought_Forward_Amount,0) + emps.BF
, Full_Adjusted = isnull(b.Full_Adjusted,0) + emps.MA
, Notes = CASE isnull(b.Notes, '') WHEN '' THEN emps.Notes ELSE b.Notes + '. ' + emps.Notes END
FROM DB_OSP_YEARLY_BREAKDOWN AS b
INNER JOIN emps ON ( b.Ndx = emps.YearNdx ) 