Matt et al,

The SQL for the multi-tenacy support is stashed in the derived tables in the Universe definition e.g. HPD_HELP_DESK

SELECT *
FROM   HPD_HELP_DESK
WHERE  HPD_HELP_DESK.CONTACT_COMPANY IN (SELECT DISTINCT COMPANY
                                         FROM   CTM_PEOPLE_PERMISSION_GROUPS
                                         WHERE  REMEDY_LOGIN_ID = @VARIABLE('BOUSER')
                                                AND COMPANY IS NOT NULL
                                         UNION
                                         SELECT DISTINCT COMPANY
                                         FROM   CTM_PEOPLE_ORGANIZATION
                                         WHERE  (SELECT 1
                                                 FROM   CTM_PEOPLE_PERMISSION_GROUPS
                                                 WHERE  REMEDY_LOGIN_ID = @VARIABLE('BOUSER')
                                                        AND PERMISSION_GROUP = 'Unrestricted Access') = 1
                                                AND COMPANY IS NOT NULL)

I found this when trying to resolve a case mismatch problem between REMEDY_LOGIN_ID and @VARIABLE('BOUSER')

It turns out that there is a significant number of these derived tables so it isn't practical to modify them all as upgrading the Universe (2.5.0.1 is now available) will remove all of your customizations

I would suggest that this multi-tenancy code should exist in a single derived table, that is used throughout the Universe so only one place needs to be customized

Roger