Lookups
Lookups & related objects
Reference collections used by user profiles and settings: UI themes, date/time formats, time zones, countries, spaces, and profile field metadata.
UserProfilesAccountSettings
Profile field metadata (editability, requiredness, visibility in the Instance).
Themes
| Field | Type | Description |
|---|---|---|
| ThemeID | NVARCHAR | Theme identifier |
| ThemeText | NVARCHAR | Name |
DateFormats / TimeFormats / StartWeekOns
References for date formats, time formats, and the first day of the week. Fields: the corresponding ID and a text description of the format.
TimeZones
| Field | Type | Description |
|---|---|---|
| TimeZoneID | NVARCHAR | Identifier |
| TimeZoneText | NVARCHAR | Name |
| TimeOffsetSeconds | INTEGER | Offset from UTC in seconds |
Countries
A list of countries. Key — CountryID, text — CountryText.
Spaces
"Spaces" (top-level data isolation) available to the current user. Contains only the SpaceIDs the user has access to; the service value 'All' is excluded.
| Field | Type | Description |
|---|---|---|
| SpaceID | NVARCHAR | Identifier |
| SpaceText | NVARCHAR | Name |