Employee

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: 0

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
   [timestamp]
   ,[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_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Employee].[Country_Region Code] = [Country_Region].[Code]

Show/hide columns in Employee table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3First Name Searchnvarchar(60)
4Middle Name Searchnvarchar(60)
5Last Name Searchnvarchar(60)
6Initials Searchnvarchar(60)
7Job Title Searchnvarchar(60)
8Search Name Searchnvarchar(500)
9Address Searchnvarchar(200)
10Address 2 Searchnvarchar(100)
11City Searchnvarchar(60)
12Post Code Searchnvarchar(40)
13County Searchnvarchar(60)
14Phone No_ Searchnvarchar(60)
15Mobile Phone No_ Searchnvarchar(60)
16E-Mail Searchnvarchar(160)
17Alt_ Address Code Searchnvarchar(20)
18Alt_ Address Start Date Searchdatetime
19Alt_ Address End Date Searchdatetime
20Picture Searchimage
21Birth Date Searchdatetime
22Social Security No_ Searchnvarchar(60)
23Union Code Searchnvarchar(20)
24Union Membership No_ Searchnvarchar(60)
25Gender Searchint
26Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Employee].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Employee].[Country_Region Code] = [Country_Region].[Code]
27Manager No_ Searchnvarchar(40)
28Emplymt_ Contract Code Searchnvarchar(20)
29Statistics Group Code Searchnvarchar(20)
30Employment Date Searchdatetime
31Status Searchint
32Inactive Date Searchdatetime
33Cause of Inactivity Code Searchnvarchar(20)
34Termination Date Searchdatetime
35Grounds for Term_ Code Searchnvarchar(20)
36Global Dimension 1 Code Searchnvarchar(40)
37Global Dimension 2 Code Searchnvarchar(40)
38Resource No_ Searchnvarchar(40)
39Last Date Modified Searchdatetime
40Extension Searchnvarchar(60)
41Pager Searchnvarchar(60)
42Fax No_ Searchnvarchar(60)
43Company E-Mail Searchnvarchar(160)
44Title Searchnvarchar(60)
45Salespers__Purch_ Code Searchnvarchar(40)
46No_ Series Searchnvarchar(40)
47Last Modified Date Time Searchdatetime
48Employee Posting Group Searchnvarchar(40)
49Bank Branch No_ Searchnvarchar(40)
50Bank Account No_ Searchnvarchar(60)
51IBAN Searchnvarchar(100)
52SWIFT Code Searchnvarchar(40)
53Application Method Searchint
54Image Searchuniqueidentifier
55Privacy Blocked Searchtinyint
56Cost Center Code Searchnvarchar(40)
57Cost Object Code Searchnvarchar(40)
58Id Searchuniqueidentifier
59$systemId Searchuniqueidentifier
60$systemCreatedAt Searchdatetime
61$systemCreatedBy Searchuniqueidentifier
62$systemModifiedAt Searchdatetime
63$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Employee table

Leave a Reply

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