Employee Qualification

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

Table Type: Company

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

Table Number: 5203

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Employee No_]
   ,[Line No_]
   ,[Qualification Code]
   ,[From Date]
   ,[To Date]
   ,[Type]
   ,[Description]
   ,[Institution_Company]
   ,[Cost]
   ,[Course Grade]
   ,[Employee Status]
   ,[Expiration Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Employee Qualification$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Employee Qualification table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Employee No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Qualification Code Searchnvarchar(20)
5From Date Searchdatetime
6To Date Searchdatetime
7Type Searchint
8Description Searchnvarchar(200)
9Institution_Company Searchnvarchar(200)
10Cost Searchdecimal(38,38)
11Course Grade Searchnvarchar(100)
12Employee Status Searchint
13Expiration Date Searchdatetime
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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