File: /www/exchange2/sql/custom/TK92904-fix-CM-role-mapping-entries.sql
/* Update Queries for TK92904 */
/* Jeremiah & Joan Kirby, Investor ID: 20211214002161 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2434 WHERE entity_id = 1144 AND entity_type = 2;
/* Bernice Galvin, Investor ID: 20190905001812 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2176 WHERE entity_id = 886 AND entity_type = 2;
/* Una Aisling Sheehan PRB, Investor ID: 20210609002069 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2358 WHERE entity_id = 1069 AND entity_type = 2;
/* Ronnie Dorney, Investor ID: 20160316000656 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 1604 WHERE entity_id = 330 AND entity_type = 2;
/* Helen and Pat Casey, Investor ID: 20131115000094 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 1288 WHERE entity_id = 40 AND entity_type = 2;
/* Catherine Murray, Investor ID: 20180607001530 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 1981 WHERE entity_id = 697 AND entity_type = 2;
/* Deirdre Seery ARF, Investor ID: 20171124001333 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 1892 WHERE entity_id = 610 AND entity_type = 2;
/* Stephen Patchett PRSA, Investor ID: 20220518002257 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2492 WHERE entity_id = 1198 AND entity_type = 2;
/* Edward McAuliffe PRSA, Investor ID: 20220506002252 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2488 WHERE entity_id = 1194 AND entity_type = 2;
/* Patrick & Laura Murphy, Investor ID: 20210513002052 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2345 WHERE entity_id = 1056 AND entity_type = 2;
/* Helena Mary Grogan PRSA, Investor ID: 20220406002236 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2473 WHERE entity_id = 1181 AND entity_type = 2;
/* Mary O'Connor, Investor ID: 20220411002241 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2477 WHERE entity_id = 1184 AND entity_type = 2;
/* Phillip Parsons, Investor ID: 20170117001004 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 1731 WHERE entity_id = 455 AND entity_type = 2;