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 )