
--SELECT * FROM tbEntity      
--1041 -- Denton
--386 -- Pelham

--check the log
select TOP 100 * from tbaudit with(nolock)
where EventEntityID = 386--1041
and AuditCategoryID IN (3, 23, 24)
ORDER BY 1 DESC

--check the forecast
SELECT ExternalGenerationDate, * FROM forecasting.forecast WHERE EntityID=386 AND businessDay = '2020-07-18'
ORDER BY BusinessDay DESC

