Check Recipient record edits
This will return details of who last edited a recipient record - note that if it's some variation on Service then its been modified by the HL7 channel and it's probably not useful SELECT [AuthorCode] ,[SiteCode] ,[FirstName] ,[MiddleName] ,[LastName] ,[Specialty] ,[Title] ,[Esig] ,[DifficultyFactor] ,[LastUpdated] ,[UpdatedBy] FROM [WinscribeText].[dbo].[Author] --where LicenseNumber in ('478417S', '423143S') where AuthorCode in ('478416S', '423142S')