Messages are generated to Datahub for each employee in the system, triggered by any record amendment or new record for that employee that is related to the integration.
Each message contains all the associated data for that employee, and any changes or new entries to the message will be processed by the product receiving the message.
Messages can be viewed by the following SQL on the SelectHR database:
Select DataHub.Messages.[Message Number], DataHub.Messages.[Message Id], DataHub.Messages.[Queue Number], DataHub.Messages.[Message Body], DataHub.Messages.[Date Processed], DataHub.Messages.Acknowledged, DataHub.Messages.[Entity Number], DataHub.Messages.[Error Message], DataHub.Messages.Version, DataHub.Messages.[Created Date] From DataHub.Messages Where DataHub.Messages.[Message Body] Like '%enter employee name%' And DataHub.Messages.[Created Date] >= 'enter date for when last update was made'