User Personalization

Dynamics 365 BC Table ReferenceTablesSystem TablesUUser Personalization

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000073

Table Type: System

Table Name: User Personalization
Database Table Name: User Personalization

Table Number: 2000000073

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how User Personalization can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [User Personalization]

Show/hide an example select of all columns by name

SELECT

   [User SID]
   ,[Profile ID]
   ,[App ID]
   ,[Scope]
   ,[Language ID]
   ,[Company]
   ,[Debugger Break On Error]
   ,[Debugger Break On Rec Changes]
   ,[Locale ID]
   ,[Time Zone]
   ,[Customization Status]
   ,[Emit Version]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [User Personalization]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [User Personalization] AS [User Personalization]
LEFT JOIN
   [User] AS [User]
      ON
         [User Personalization].[User SID] = [User].[User Security ID]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [User Personalization].[Language ID] = [Language].[Windows Language ID]
LEFT JOIN
   [Company] AS [Company]
      ON
         [User Personalization].[Company] = [Company].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [User Personalization].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [User Personalization].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in User Personalization table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
3User SID SearchUser SIDNormalGUID16User SIDuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [User Personalization].[User SID]
	       ,[User].[User Security ID]
	FROM
	       [User Personalization] AS [User Personalization]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [User Personalization].[User SID] = [User].[User Security ID]
6User ID Primary Key SearchUser IDFlowFieldCode50
7Full Name SearchFull NameFlowFieldText80
9Profile ID SearchProfile IDNormalCode30Profile IDnvarchar(60)
10App ID SearchApp IDNormalGUID16App IDuniqueidentifier
11Scope SearchScopeNormalOption4Scopeint
Available options are:
  • “System”
  • “Tenant”
12Language ID SearchLanguage IDNormalInteger4Language IDint
Key to join to the Language table.

Show/hide example query

SELECT
	       [User Personalization].[Language ID]
	       ,[Language].[Windows Language ID]
	FROM
	       [User Personalization] AS [User Personalization]
	LEFT JOIN
	       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
	              ON
	                     [User Personalization].[Language ID] = [Language].[Windows Language ID]
13Language Name SearchLanguageFlowFieldText80
15Company SearchCompanyNormalText30Companynvarchar(60)
Key to join to the Company table.

Show/hide example query

SELECT
	       [User Personalization].[Company]
	       ,[Company].[Name]
	FROM
	       [User Personalization] AS [User Personalization]
	LEFT JOIN
	       [Company] AS [Company]
	              ON
	                     [User Personalization].[Company] = [Company].[Name]
18Debugger Break On Error SearchDebugger Break On ErrorNormalBoolean4Debugger Break On Errortinyint
21Debugger Break On Rec Changes SearchDebugger Break On Rec ChangesNormalBoolean4Debugger Break On Rec Changestinyint
24Debugger Skip System Triggers SearchDebugger Skip System TriggersNormalBoolean4
27Locale ID SearchLocale IDNormalInteger4Locale IDint
28Region SearchRegionFlowFieldText80
30Time Zone SearchTime ZoneNormalText180Time Zonenvarchar(360)
31License Type SearchLicense TypeFlowFieldOption4
32Customization Status SearchCustomization StatusNormalOption4Customization Statusint
Available options are:
  • “Updated”
  • “Recompilation Needed”
  • “Recompilation Failed”
33Role SearchRoleFlowFieldText100
34Emit Version SearchEmit VersionNormalInteger4Emit Versionint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [User Personalization].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [User Personalization] AS [User Personalization]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [User Personalization].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesSystem TablesUUser Personalization

Leave a Reply

Your email address will not be published. Required fields are marked *