Employee – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables EEmployee

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

Table Type: Company

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

Table Number: 5200

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[First Name]
   ,[Middle Name]
   ,[Last Name]
   ,[Initials]
   ,[Job Title]
   ,[Search Name]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Post Code]
   ,[County]
   ,[Phone No_]
   ,[Mobile Phone No_]
   ,[E-Mail]
   ,[Alt_ Address Code]
   ,[Alt_ Address Start Date]
   ,[Alt_ Address End Date]
   ,[Picture]
   ,[Birth Date]
   ,[Social Security No_]
   ,[Union Code]
   ,[Union Membership No_]
   ,[Gender]
   ,[Country_Region Code]
   ,[Manager No_]
   ,[Emplymt_ Contract Code]
   ,[Statistics Group Code]
   ,[Employment Date]
   ,[Status]
   ,[Inactive Date]
   ,[Cause of Inactivity Code]
   ,[Termination Date]
   ,[Grounds for Term_ Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Resource No_]
   ,[Last Date Modified]
   ,[Extension]
   ,[Pager]
   ,[Fax No_]
   ,[Company E-Mail]
   ,[Title]
   ,[Salespers__Purch_ Code]
   ,[No_ Series]
   ,[Last Modified Date Time]
   ,[Employee Posting Group]
   ,[Bank Branch No_]
   ,[Bank Account No_]
   ,[IBAN]
   ,[SWIFT Code]
   ,[Application Method]
   ,[Image]
   ,[Privacy Blocked]
   ,[Cost Center Code]
   ,[Cost Object Code]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Employee$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$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Employee].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Employee].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Union$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Union]
      ON
         [Employee].[Union Code] = [Union].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Employee Statistics Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Statistics Group]
      ON
         [Employee].[Statistics Group Code] = [Employee Statistics Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cause of Inactivity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cause of Inactivity]
      ON
         [Employee].[Cause of Inactivity Code] = [Cause of Inactivity].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Employee].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Employee].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cause of Absence$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cause of Absence]
      ON
         [Employee].[Cause of Absence Filter] = [Cause of Absence].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Employee Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Posting Group]
      ON
         [Employee].[Employee Posting Group] = [Employee Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code]
      ON
         [Employee].[SWIFT Code] = [SWIFT Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
      ON
         [Employee].[Cost Center Code] = [Cost Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
      ON
         [Employee].[Cost Object Code] = [Cost Object].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Employee].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Employee].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Employee table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	No.	No.	Normal	Code	20	No_	nvarchar(40)
2	First Name	First Name	Normal	Text	30	First Name	nvarchar(60)
3	Middle Name	Middle Name	Normal	Text	30	Middle Name	nvarchar(60)
4	Last Name	Last Name	Normal	Text	30	Last Name	nvarchar(60)
5	Initials	Initials	Normal	Text	30	Initials	nvarchar(60)
6	Job Title	Job Title	Normal	Text	30	Job Title	nvarchar(60)
7	Search Name	Search Name	Normal	Code	250	Search Name	nvarchar(500)
8	Address	Address	Normal	Text	100	Address	nvarchar(200)
9	Address 2	Address 2	Normal	Text	50	Address 2	nvarchar(100)
10	City	City	Normal	Text	30	City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Employee].[City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Employee].[City] = [Post Code].[City]
11	Post Code	ZIP Code	Normal	Code	20	Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Employee].[Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Employee].[Post Code] = [Post Code].[Code]
12	County	State	Normal	Text	30	County	nvarchar(60)
13	Phone No.	Phone No.	Normal	Text	30	Phone No_	nvarchar(60)
14	Mobile Phone No.	Mobile Phone No.	Normal	Text	30	Mobile Phone No_	nvarchar(60)
15	E-Mail	Email	Normal	Text	80	E-Mail	nvarchar(160)
16	Alt. Address Code	Alt. Address Code	Normal	Code	10	Alt_ Address Code	nvarchar(20)
17	Alt. Address Start Date	Alt. Address Start Date	Normal	Date	4	Alt_ Address Start Date	datetime
18	Alt. Address End Date	Alt. Address End Date	Normal	Date	4	Alt_ Address End Date	datetime
19	Picture	Picture	Normal	BLOB	8	Picture	image
20	Birth Date	Birth Date	Normal	Date	4	Birth Date	datetime
21	Social Security No.	Social Security No.	Normal	Text	30	Social Security No_	nvarchar(60)
22	Union Code	Union Code	Normal	Code	10	Union Code	nvarchar(20)
	Key to join to the Union table. Show/hide example query SELECT [Employee].[Union Code] ,[Union].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Union$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Union] ON [Employee].[Union Code] = [Union].[Code]
23	Union Membership No.	Union Membership No.	Normal	Text	30	Union Membership No_	nvarchar(60)
24	Gender	Gender	Normal	Option	4	Gender	int
	Available options are: ” “ “Female” “Male”
25	Country/Region Code	Country/Region Code	Normal	Code	10	Country_Region Code	nvarchar(20)
26	Manager No.	Manager No.	Normal	Code	20	Manager No_	nvarchar(40)
27	Emplymt. Contract Code	Emplymt. Contract Code	Normal	Code	10	Emplymt_ Contract Code	nvarchar(20)
	Key to join to the Employment Contract table. Show/hide example query SELECT [Employee].[Emplymt_ Contract Code] ,[Employment Contract].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Employment Contract$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employment Contract] ON [Employee].[Emplymt_ Contract Code] = [Employment Contract].[Code]
28	Statistics Group Code	Statistics Group Code	Normal	Code	10	Statistics Group Code	nvarchar(20)
	Key to join to the Employee Statistics Group table. Show/hide example query SELECT [Employee].[Statistics Group Code] ,[Employee Statistics Group].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Employee Statistics Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Statistics Group] ON [Employee].[Statistics Group Code] = [Employee Statistics Group].[Code]
29	Employment Date	Employment Date	Normal	Date	4	Employment Date	datetime
31	Status	Status	Normal	Option	4	Status	int
	Available options are: “Active” “Inactive” “Terminated”
32	Inactive Date	Inactive Date	Normal	Date	4	Inactive Date	datetime
33	Cause of Inactivity Code	Cause of Inactivity Code	Normal	Code	10	Cause of Inactivity Code	nvarchar(20)
	Key to join to the Cause of Inactivity table. Show/hide example query SELECT [Employee].[Cause of Inactivity Code] ,[Cause of Inactivity].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Cause of Inactivity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cause of Inactivity] ON [Employee].[Cause of Inactivity Code] = [Cause of Inactivity].[Code]
34	Termination Date	Termination Date	Normal	Date	4	Termination Date	datetime
35	Grounds for Term. Code	Grounds for Term. Code	Normal	Code	10	Grounds for Term_ Code	nvarchar(20)
	Key to join to the Grounds for Termination table. Show/hide example query SELECT [Employee].[Grounds for Term_ Code] ,[Grounds for Termination].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Grounds for Termination$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Grounds for Termination] ON [Employee].[Grounds for Term_ Code] = [Grounds for Termination].[Code]
36	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Employee].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Employee].[Global Dimension 1 Code] = [Dimension].[Code]
37	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Employee].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Employee].[Global Dimension 2 Code] = [Dimension].[Code]
38	Resource No.	Resource No.	Normal	Code	20	Resource No_	nvarchar(40)
	Key to join to the Resource table. Show/hide example query SELECT [Employee].[Resource No_] ,[Resource].[No_] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource] ON [Employee].[Resource No_] = [Resource].[No_]
39	Comment	Comment	FlowField	Boolean	4
40	Last Date Modified	Last Date Modified	Normal	Date	4	Last Date Modified	datetime
41	Date Filter	Date Filter	FlowFilter	Date	4
42	Global Dimension 1 Filter	Global Dimension 1 Filter	FlowFilter	Code	20
43	Global Dimension 2 Filter	Global Dimension 2 Filter	FlowFilter	Code	20
44	Cause of Absence Filter	Cause of Absence Filter	FlowFilter	Code	10
	Key to join to the Cause of Absence table. Show/hide example query SELECT [Employee].[] ,[Cause of Absence].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Cause of Absence$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cause of Absence] ON [Employee].[] = [Cause of Absence].[Code]
45	Total Absence (Base)	Total Absence (Base)	FlowField	Decimal	12
46	Extension	Extension	Normal	Text	30	Extension	nvarchar(60)
47	Employee No. Filter	Employee No. Filter	FlowFilter	Code	20
48	Pager	Pager	Normal	Text	30	Pager	nvarchar(60)
49	Fax No.	Fax No.	Normal	Text	30	Fax No_	nvarchar(60)
50	Company E-Mail	Company Email	Normal	Text	80	Company E-Mail	nvarchar(160)
51	Title	Title	Normal	Text	30	Title	nvarchar(60)
52	Salespers./Purch. Code	Salespers./Purch. Code	Normal	Code	20	Salespers__Purch_ Code	nvarchar(40)
53	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Employee].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Employee].[No_ Series] = [No. Series].[Code]
54	Last Modified Date Time	Last Modified Date Time	Normal	DateTime	8	Last Modified Date Time	datetime
55	Employee Posting Group	Employee Posting Group	Normal	Code	20	Employee Posting Group	nvarchar(40)
	Key to join to the Employee Posting Group table. Show/hide example query SELECT [Employee].[Employee Posting Group] ,[Employee Posting Group].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Employee Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Posting Group] ON [Employee].[Employee Posting Group] = [Employee Posting Group].[Code]
56	Bank Branch No.	Bank Branch No.	Normal	Text	20	Bank Branch No_	nvarchar(40)
57	Bank Account No.	Bank Account No.	Normal	Text	30	Bank Account No_	nvarchar(60)
	Key to join to the Bank Account table. Show/hide example query SELECT [Employee].[Bank Account No_] ,[Bank Account].[No_] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] ON [Employee].[Bank Account No_] = [Bank Account].[No_]
58	IBAN	IBAN	Normal	Code	50	IBAN	nvarchar(100)
59	Balance	Balance	FlowField	Decimal	12
60	SWIFT Code	SWIFT Code	Normal	Code	20	SWIFT Code	nvarchar(40)
	Key to join to the SWIFT Code table. Show/hide example query SELECT [Employee].[SWIFT Code] ,[SWIFT Code].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code] ON [Employee].[SWIFT Code] = [SWIFT Code].[Code]
80	Application Method	Application Method	Normal	Option	4	Application Method	int
	Available options are: “Manual” “Apply to Oldest”
140	Image	Image	Normal	Media	16	Image	uniqueidentifier
150	Privacy Blocked	Privacy Blocked	Normal	Boolean	4	Privacy Blocked	tinyint
1100	Cost Center Code	Cost Center Code	Normal	Code	20	Cost Center Code	nvarchar(40)
	Key to join to the Cost Center table. Show/hide example query SELECT [Employee].[Cost Center Code] ,[Cost Center].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center] ON [Employee].[Cost Center Code] = [Cost Center].[Code]
1101	Cost Object Code	Cost Object Code	Normal	Code	20	Cost Object Code	nvarchar(40)
	Key to join to the Cost Object table. Show/hide example query SELECT [Employee].[Cost Object Code] ,[Cost Object].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object] ON [Employee].[Cost Object Code] = [Cost Object].[Code]
8000	Id	Id	Normal	GUID	16	Id	uniqueidentifier
10023	RFC No.	RFC No.	Normal	Code	13
10025	License No.	License No.	Normal	Code	20
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Employee].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [User] AS [User] ON [Employee].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Employee table

Post Code

Dynamics 365 BC Table Reference Tables Company Tables EEmployee

Leave a Reply Cancel reply