Data Privacy Entities

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

Table Type: Company

Table Name: Data Privacy Entities
Database Table Name: CRONUS UK Ltd_$Data Privacy Entities$63ca2fa4-4f03-4f2b-a480-172fef340d3f

Table Number: 1180

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 Data Privacy Entities can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Data Privacy Entities$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide an example select of all columns by name

SELECT
   [Table No_]
   ,[Key Field No_]
   ,[Entity Filter]
   ,[Include]
   ,[Status]
   ,[Reviewed]
   ,[Status 2]
   ,[Page No_]
   ,[Similar Fields Reviewed]
   ,[Similar Fields Label]
   ,[Default Data Sensitivity]
   ,[Privacy Blocked Field No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Data Privacy Entities$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Data Privacy Entities$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Data Privacy Entities]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Privacy Entities].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Privacy Entities].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Data Privacy Entities table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Table No. Primary Key SearchTable No.NormalInteger4Table No_int
2Table Caption SearchTable CaptionFlowFieldText80
3Key Field No. SearchKey Field No.NormalInteger4Key Field No_int
4Key Field Name SearchKey Field NameFlowFieldText30
5Entity Filter SearchEntity FilterNormalBLOB8Entity Filterimage
6Include SearchIncludeNormalBoolean4Includetinyint
7Fields SearchFieldsFlowFieldInteger4
8Status SearchStatusNormalOption4Statusint
Available options are:
  • “Review Needed”
  • “Reviewed”
9Reviewed SearchReviewedNormalBoolean4Reviewedtinyint
10Status 2 SearchStatus 2NormalOption4Status 2int
Available options are:
  • “Review Needed”
  • “Reviewed”
11Page No. SearchPage No.NormalInteger4Page No_int
12Similar Fields Reviewed SearchSimilar Fields ReviewedNormalBoolean4Similar Fields Reviewedtinyint
13Similar Fields Label SearchSimilar Fields LabelNormalText120Similar Fields Labelnvarchar(240)
14Default Data Sensitivity SearchDefault Data SensitivityNormalOption4Default Data Sensitivityint
Available options are:
  • “Unclassified”
  • “Sensitive”
  • “Personal”
  • “Company Confidential”
  • “Normal”
15Privacy Blocked Field No. SearchPrivacy Blocked Field No.NormalInteger4Privacy Blocked Field No_int
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
       [Data Privacy Entities].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Data Privacy Entities$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Data Privacy Entities]
LEFT JOIN
       [User] AS [User]
              ON
                     [Data Privacy Entities].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Data Privacy Entities].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Data Privacy Entities$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Data Privacy Entities]
LEFT JOIN
       [User] AS [User]
              ON
                     [Data Privacy Entities].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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