A user account has settings for their locale, preferred calendar and timezone. Those same settings are available in a group's "preferences" settings and can, theoretically, apply to all members of that group. In addition, the SBM AE server's TimeZone is available in the System Settings table (ts_SystemSettings). This setting could be considered a "last resort" when trying to determine a user's TimeZone. No such defaults are available for locale or calendar ID, but could be added for reference purposes to the System Settings table (not supported by OpenText).
Given a user account where the locale, calendar or timezone is NOT set in the user settings, and where the user is a member of multiple groups and several of those groups have conflicting local, calendar or timezone settings, what is the search order of those groups to determine the user's locale, calendar or timezone???
The TS_USERS table entry for User ID 123 ("W. Flintstone") does not have "locale", calendarID or TimeZone selected.
User ID 123 is a member of the "Bedrock" Group ID #321 where locale="EN-US", CalendarID=1 and TimeZone="EST5EDT". That user is also a member of the "bowling league" Group ID #987 where locale is not set, CalendarID=2 and TimeZone="Africa/Casablanca". Which Group takes precedence, and therefore which calendarID and Timezone are selected for the user?