Employee Absence

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

Table Type: Company

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

Table Number: 5207

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Employee No_]
   ,[Entry No_]
   ,[From Date]
   ,[To Date]
   ,[Cause of Absence Code]
   ,[Description]
   ,[Quantity]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Qty_ per Unit of Measure]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Employee Absence$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 Absence$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Absence]
LEFT JOIN
   [CRONUS UK Ltd_$Cause of Absence$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cause of Absence]
      ON
         [Employee Absence].[Cause of Absence Code] = [Cause of Absence].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Employee Absence].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Employee Absence].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Employee Absence table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Employee No. SearchEmployee No.NormalCode20Employee No_nvarchar(40)
Key to join to the Employee table.

Show/hide example query

SELECT
       [Employee Absence].[Employee No_]
       ,[Employee].[No_]
FROM
       [CRONUS UK Ltd_$Employee Absence$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Absence]
LEFT JOIN
       [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
              ON
                     [Employee Absence].[Employee No_] = [Employee].[No_]
2Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
3From Date SearchFrom DateNormalDate4From Datedatetime
4To Date SearchTo DateNormalDate4To Datedatetime
5Cause of Absence Code SearchCause of Absence CodeNormalCode10Cause of Absence Codenvarchar(20)
Key to join to the Cause of Absence table.

Show/hide example query

SELECT
       [Employee Absence].[Cause of Absence Code]
       ,[Cause of Absence].[Code]
FROM
       [CRONUS UK Ltd_$Employee Absence$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Absence]
LEFT JOIN
       [CRONUS UK Ltd_$Cause of Absence$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cause of Absence]
              ON
                     [Employee Absence].[Cause of Absence Code] = [Cause of Absence].[Code]
6Description SearchDescriptionNormalText100Descriptionnvarchar(200)
7Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
8Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
11Comment SearchCommentFlowFieldBoolean4
12Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
13Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
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 Absence].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Employee Absence$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Absence]
LEFT JOIN
       [User] AS [User]
              ON
                     [Employee Absence].[$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 Absence].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Employee Absence$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Absence]
LEFT JOIN
       [User] AS [User]
              ON
                     [Employee Absence].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Employee Absence table

Leave a Reply

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