Querying Fault Selection

Fault configurations are stored in the Timed_Event_Faults table.

SELECT	ted.PU_Id, 
        ted.Start_Time, 
        ted.End_Time, 
        tef.Fault_Desc
FROM Timed_Event_Details ted
     LEFT JOIN Timed_Event_Faults tef ON ted.TEFault_Id = tef.TEFault_Id 
WHERE	      ted.PU_Id = @PUId
              AND ted.Start_Time < @ReportEndTime 
              AND (	ted.End_Time > @ReportStartTime
                        OR ted.End_Time IS NULL)