// Statement for reading KAMCO faults from QuetzalSC for possible KAMCO Annual rebates.
Select c.CallNumber, c.LastName, c.FirstName,
 c.Ref2, c.CallSubject1, c.CallSubject2, c.CallSubject3,
 c.Logon, c.ConfigId, c.ConfigCallPrompt, c.SupportGroup,
 c.ResolutionCode1, c.ResolutionCode2, c.ResolutionCode3,
 c.LogDatTim, c.AllDatTim, c.LastDatTim, c.SLT1,
 ce.EventCode, ce.IthelpUser, ce.EventDateTime,
 ce.IsCurrentEvent, c.comments,
 s.TarFixWks, s.TarFixHrs, s.TarFixMins, s.TarResWks, s.TarResHrs,
 s.TarResMins, custe.EventName, cf.Ref3, (11111) AS "BatchID", ('2007/04') AS "BillingPeriod"
FROM Call c
 INNER JOIN Call_Event ce ON c.CallNumber = ce.CallNumber
 INNER JOIN Custom_Event custe ON ce.EventCode = custe.EventCode
 INNER JOIN Configuration cf ON c.ConfigId = cf.ConfigId
 INNER JOIN SLT s ON c.SLTUnique1 = s.SLTUnique
 WHERE (cf.ConfigClassificationUnique = 11
 OR c.CallSubject2 LIKE 'KAMCO')
 AND (CAST(DATEPART(yyyy,c.LogDatTim) AS varchar) + '/' + RIGHT('0' + CAST(DATEPART(mm,c.LogDatTim) AS varchar),2)) LIKE '2007/04'
 AND ce.EventCode > 100
 AND ce.IsCurrentEvent = 1