DECODE(UPPER(SUBSTR({entityid}, 1, 4)), 'IR -', 'Ireland Subsidiary', 'AU -', 'Australian Subsidiary', 'CA -', 'Canadian Subsidiary', NULL)