Enhanced query to check holiday schedule. Still working on to add transfer details