 CREATE VIEW VHepSpecHistory AS
     SELECT
         site.name AS Site,
-        ServiceLevel AS HepSpec06,
+        CAST(ROUND(NormalisedWallDuration / WallDuration, 0) AS UNSIGNED) AS HepSpec06,
         SUM(NumberOfJobs) AS NumberOfJobs,
         Year,
         Month,

CREATE VIEW VSpecIntHistory AS
    SELECT
        site.name AS ExecutingSite,
        CAST(ROUND(IF((ServiceLevelType = 'HEPSPEC'),(ServiceLevel * 250),ServiceLevel),0) AS UNSIGNED) AS SpecInt2000,
        CAST(SUM(NumberOfJobs) AS UNSIGNED) AS Njobs,
        Month,
        Year,
        CAST(MIN(EarliestEndTime) AS DATE) AS RecordStart,
        CAST(MAX(LatestEndTime) AS DATE) AS RecordEnd
    FROM
        SuperSummaries JOIN Sites AS site ON SiteID = site.id
    GROUP BY
        SiteID,
        SpecInt2000,

        VOs.name AS LCGUserVO,
        CAST(SUM(NumberOfJobs) AS UNSIGNED) AS Njobs,
        ROUND((SUM(CpuDuration) / 3600), 0) AS SumCPU,
        ROUND(SUM(NormalisedCpuDuration / 3600), 0) AS NormSumCPU,
        ROUND((SUM(WallDuration) / 3600), 0) AS SumWCT,
        ROUND(SUM(NormalisedWallDuration / 3600), 0) AS NormSumWCT,
        Month,
        Year,
        CAST(MIN(EarliestEndTime) AS DATE) AS RecordStart,
