Employee Templ.

Dynamics 365 BC Table ReferenceTablesCompany TablesEEmployee Templ.

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

Table Type: Company

Table Name: Employee Templ.
Database Table Name: CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1384

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 Employee Templ. can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Description]
   ,[City]
   ,[Post Code]
   ,[County]
   ,[Gender]
   ,[Country_Region Code]
   ,[Manager No_]
   ,[Emplymt_ Contract Code]
   ,[Statistics Group Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Company E-Mail]
   ,[No_ Series]
   ,[Employee Posting Group]
   ,[Application Method]
   ,[Cost Center Code]
   ,[Cost Object Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Employee Templ.].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Employee Templ.].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Employee Statistics Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Statistics Group]
      ON
         [Employee Templ.].[Statistics Group Code] = [Employee Statistics Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Employee Templ.].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Employee Templ.].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Employee Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Posting Group]
      ON
         [Employee Templ.].[Employee Posting Group] = [Employee Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
      ON
         [Employee Templ.].[Cost Center Code] = [Cost Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
      ON
         [Employee Templ.].[Cost Object Code] = [Cost Object].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Employee Templ.].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Employee Templ.].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Employee Templ. table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
10City SearchCityNormalText30Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Employee Templ.].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Employee Templ.].[City] = [Post Code].[City]
11Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Employee Templ.].[Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Employee Templ.].[Post Code] = [Post Code].[Code]
12County SearchStateNormalText30Countynvarchar(60)
24Gender SearchGenderNormalOption4Genderint
Available options are:
  • ” “
  • “Female”
  • “Male”
25Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Employee Templ.].[Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Employee Templ.].[Country_Region Code] = [Country/Region].[Code]
26Manager No. SearchManager No.NormalCode20Manager No_nvarchar(40)
Key to join to the Employee table.

Show/hide example query

SELECT
       [Employee Templ.].[Manager No_]
       ,[Employee].[No_]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
              ON
                     [Employee Templ.].[Manager No_] = [Employee].[No_]
27Emplymt. Contract Code SearchEmplymt. Contract CodeNormalCode10Emplymt_ Contract Codenvarchar(20)
Key to join to the Employment Contract table.

Show/hide example query

SELECT
       [Employee Templ.].[Emplymt_ Contract Code]
       ,[Employment Contract].[Code]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Employment Contract$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employment Contract]
              ON
                     [Employee Templ.].[Emplymt_ Contract Code] = [Employment Contract].[Code]
28Statistics Group Code SearchStatistics Group CodeNormalCode10Statistics Group Codenvarchar(20)
Key to join to the Employee Statistics Group table.

Show/hide example query

SELECT
       [Employee Templ.].[Statistics Group Code]
       ,[Employee Statistics Group].[Code]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Employee Statistics Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Statistics Group]
              ON
                     [Employee Templ.].[Statistics Group Code] = [Employee Statistics Group].[Code]
36Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Employee Templ.].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Employee Templ.].[Global Dimension 1 Code] = [Dimension].[Code]
37Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Employee Templ.].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Employee Templ.].[Global Dimension 2 Code] = [Dimension].[Code]
50Company E-Mail SearchCompany EmailNormalText80Company E-Mailnvarchar(160)
53No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Employee Templ.].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Employee Templ.].[No_ Series] = [No. Series].[Code]
55Employee Posting Group SearchEmployee Posting GroupNormalCode20Employee Posting Groupnvarchar(40)
Key to join to the Employee Posting Group table.

Show/hide example query

SELECT
       [Employee Templ.].[Employee Posting Group]
       ,[Employee Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Employee Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Posting Group]
              ON
                     [Employee Templ.].[Employee Posting Group] = [Employee Posting Group].[Code]
80Application Method SearchApplication MethodNormalOption4Application Methodint
Available options are:
  • “Manual”
  • “Apply to Oldest”
1100Cost Center Code SearchCost Center CodeNormalCode20Cost Center Codenvarchar(40)
Key to join to the Cost Center table.

Show/hide example query

SELECT
       [Employee Templ.].[Cost Center Code]
       ,[Cost Center].[Code]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
              ON
                     [Employee Templ.].[Cost Center Code] = [Cost Center].[Code]
1101Cost Object Code SearchCost Object CodeNormalCode20Cost Object Codenvarchar(40)
Key to join to the Cost Object table.

Show/hide example query

SELECT
       [Employee Templ.].[Cost Object Code]
       ,[Cost Object].[Code]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
              ON
                     [Employee Templ.].[Cost Object Code] = [Cost Object].[Code]
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
       [Employee Templ.].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [User] AS [User]
              ON
                     [Employee Templ.].[$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
       [Employee Templ.].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Employee Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Templ.]
LEFT JOIN
       [User] AS [User]
              ON
                     [Employee Templ.].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Employee Templ. table

Post Code
Dynamics 365 BC Table ReferenceTablesCompany TablesEEmployee Templ.

Leave a Reply

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