User Security Status – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables UUser Security Status

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

Table Type: System

Table Name: User Security Status
Database Table Name:

Table Number: 9062

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 Security Status can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

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

SELECT
   *
FROM
   [] AS [User Security Status]
LEFT JOIN
   [User] AS [User]
      ON
         [User Security Status].[User Security ID] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [User Security Status].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [User Security Status].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in User Security Status table

Field No.	Field Name	Field Caption	Class	Type	Length
1	User Security ID	User Security ID	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [User Security Status].[] ,[User].[User Security ID] FROM [] AS [User Security Status] LEFT JOIN [User] AS [User] ON [User Security Status].[] = [User].[User Security ID]
2	User Name	User Name	FlowField	Code	50
3	Full Name	Full Name	FlowField	Text	80
13	Reviewed	Reviewed	Normal	Boolean	4
14	Belongs To Subscription Plan	Belongs To Subscription Plan	FlowField	Boolean	4
15	Belongs to User Group	Belongs to User Group	FlowField	Boolean	4
20	Users – To review	Users – To review	FlowField	Integer	4
21	Users – Without Subscriptions	Users – Without Subscriptions	FlowField	Integer	4
22	Users – Not Group Members	Users – Not Group Members	FlowField	Integer	4
25	CDS Integration Errors	Dataverse Integration Errors	FlowField	Integer	4
26	Coupled Data Synch Errors	Coupled Data Synch Errors	FlowField	Integer	4
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [User Security Status].[] ,[User].[User Security ID] FROM [] AS [User Security Status] LEFT JOIN [User] AS [User] ON [User Security Status].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16