Notification Schedule – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables NNotification Schedule

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

Table Type: Company

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

Table Number: 1513

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [User ID]
   ,[Notification Type]
   ,[Recurrence]
   ,[Time]
   ,[Daily Frequency]
   ,[Monday]
   ,[Tuesday]
   ,[Wednesday]
   ,[Thursday]
   ,[Friday]
   ,[Saturday]
   ,[Sunday]
   ,[Date of Month]
   ,[Monthly Notification Date]
   ,[Last Scheduled Job]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Notification Schedule$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Notification Schedule]
LEFT JOIN
   [CRONUS UK Ltd_$Job Queue Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Entry]
      ON
         [Notification Schedule].[Last Scheduled Job] = [Job Queue Entry].[ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Notification Schedule].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Notification Schedule].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Notification Schedule table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
2	Notification Type	Notification Type	Normal	Option	4	Notification Type	int
	Available options are: “New Record” “Approval” “Overdue”
3	Recurrence	Recurrence	Normal	Option	4	Recurrence	int
	Available options are: “Instantly” “Daily” “Weekly” “Monthly”
4	Time	Time	Normal	Time	4	Time	datetime
5	Daily Frequency	Daily Frequency	Normal	Option	4	Daily Frequency	int
	Available options are: “Weekday” “Daily”
6	Monday	Monday	Normal	Boolean	4	Monday	tinyint
7	Tuesday	Tuesday	Normal	Boolean	4	Tuesday	tinyint
8	Wednesday	Wednesday	Normal	Boolean	4	Wednesday	tinyint
9	Thursday	Thursday	Normal	Boolean	4	Thursday	tinyint
10	Friday	Friday	Normal	Boolean	4	Friday	tinyint
11	Saturday	Saturday	Normal	Boolean	4	Saturday	tinyint
12	Sunday	Sunday	Normal	Boolean	4	Sunday	tinyint
13	Date of Month	Date of Month	Normal	Integer	4	Date of Month	int
14	Monthly Notification Date	Monthly Notification Date	Normal	Option	4	Monthly Notification Date	int
	Available options are: “First Workday” “Last Workday” “Custom”
15	Last Scheduled Job	Last Scheduled Job	Normal	GUID	16	Last Scheduled Job	uniqueidentifier
	Key to join to the Job Queue Entry table. Show/hide example query SELECT [Notification Schedule].[Last Scheduled Job] ,[Job Queue Entry].[ID] FROM [CRONUS UK Ltd_$Notification Schedule$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Notification Schedule] LEFT JOIN [CRONUS UK Ltd_$Job Queue Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Entry] ON [Notification Schedule].[Last Scheduled Job] = [Job Queue Entry].[ID]
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 [Notification Schedule].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Notification Schedule$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Notification Schedule] LEFT JOIN [User] AS [User] ON [Notification Schedule].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier