-- this file is used as part of /mstrcfmod/CRM/batch/marketAnalyzerETL.cfm and cfmod_acostaBlueToRedTerritoryMapping.cfm
select ownerType, ownerId, blueId, redId 
from (	values
	('BRO',14,7353, 4590),
	('BRO',14,7354, 4590),
	('BRO',14,7376, 5795),
	('BRO',14,7375, 5795),
	('BRO',14,7355, 5790),
	('BRO',14,7368, 5781),
	('BRO',14,7383, 5778),
	('BRO',14,7319, 4908),
	('BRO',14,7320, 4908),
	('BRO',14,7323, 5799),
	('BRO',14,7324, 5799),
	('BRO',14,7325, 5799),
	('BRO',14,7339, 5805),
	('BRO',14,7388, 4187),
	('BRO',14,7385, 4187),
	('BRO',14,7371, 5779),
	('BRO',14,7335, 5800),
	('BRO',14,7336, 5800),
	('BRO',14,7377, 10743),
	('BRO',14,7378, 10743),
	('BRO',14,7380, 5797),
	('BRO',14,7379, 5797),
	('BRO',14,7381, 5797),
	('BRO',14,7326, 5796),
	('BRO',14,7386, 4185),
	('BRO',14,7373, 5786),
	('BRO',14,7534, 5806),
	('BRO',14,7342, 5806),
	('BRO',14,7330, 5807),
	('BRO',14,7338, 5808),
	('BRO',14,7365, 5809),
	('BRO',14,7333, 5810),
	('BRO',14,7372, 5780),
	('BRO',14,7391, 4188),
	('BRO',14,7327, 5794),
	('BRO',14,7348, 4595),
	('BRO',14,7347, 4595),
	('BRO',14,7328, 5811),
	('BRO',14,7329, 5811),
	('BRO',14,7340, 5812),
	('BRO',14,7337, 5812),
	('BRO',14,7341, 5812),
	('BRO',14,7382, 5793),
	('BRO',14,7370, 5788),
	('BRO',14,7366, 5814),
	('BRO',14,7349, 4593),
	('BRO',14,7350, 4593),
	('BRO',14,7351, 4593),
	('BRO',14,7367, 4189),
	('BRO',14,7387, 5803),
	('BRO',14,7356, 5784),
	('BRO',14,7358, 5784),
	('BRO',14,7360, 5784),
	('BRO',14,7331, 5815),
	('BRO',14,7332, 5815),
	('BRO',14,7389, 4190),
	('BRO',14,7364, 5785),
	('BRO',14,7346, 4597),
	('BRO',14,7345, 4597),
	('BRO',14,7384, 4186),
	('BRO',14,7359, 5782),
	('BRO',14,7357, 5782),
	('BRO',14,7363, 5782),
	('BRO',14,7362, 5782),
	('BRO',14,7390, 5813),
	('BRO',14,7369, 5801),
	('BRO',14,7321, 4909),
	('BRO',14,7322, 4909),
	('BRO',14,7361, 5963),
	('BRO',14,7374, 6456),
	('BRO',14,7334, 5818),
	('BRO',14,7343, 5817),
	('BRO',14,7344, 5817),
	('BRO',14,10742, 5791)
) blue2Red (ownerType, ownerId, blueId, redId)