Currently there is a problem with how this is being calculated. Below is the example I went through with Savage Fire. The data in the dB is right, but it seems when you are converting minutes to hours, something is happening.
Query and details below on what I used to look this up in PROD.
SELECT ims.Training.Date, ims.Training.Title, ims.Agent.Surname, ims.StateProgram.Name, ims.TrainingStateProgram.Minutes
FROM ims.TrainingStateProgram INNER JOIN
ims.StateProgram ON ims.TrainingStateProgram.StateProgramId = ims.StateProgram.Id INNER JOIN
ims.Attendee ON ims.TrainingStateProgram.TrainingId = ims.Attendee.TrainingId INNER JOIN
ims.Agent ON ims.Attendee.AgentId = ims.Agent.Id INNER JOIN
ims.Training ON ims.TrainingStateProgram.TrainingId = ims.Training.Id AND ims.Attendee.TrainingId = ims.Training.Id
WHERE (ims.Agent.AgencyId = 3) AND (ims.Agent.Surname = N'Burns')
Need this fixed ASAP.
Currently there is a problem with how this is being calculated. Below is the example I went through with Savage Fire. The data in the dB is right, but it seems when you are converting minutes to hours, something is happening.
Query and details below on what I used to look this up in PROD. SELECT ims.Training.Date, ims.Training.Title, ims.Agent.Surname, ims.StateProgram.Name, ims.TrainingStateProgram.Minutes FROM ims.TrainingStateProgram INNER JOIN ims.StateProgram ON ims.TrainingStateProgram.StateProgramId = ims.StateProgram.Id INNER JOIN ims.Attendee ON ims.TrainingStateProgram.TrainingId = ims.Attendee.TrainingId INNER JOIN ims.Agent ON ims.Attendee.AgentId = ims.Agent.Id INNER JOIN ims.Training ON ims.TrainingStateProgram.TrainingId = ims.Training.Id AND ims.Attendee.TrainingId = ims.Training.Id WHERE (ims.Agent.AgencyId = 3) AND (ims.Agent.Surname = N'Burns')