Daily QA: BB by EPID Composite Database Query

Back to Database Queries

Note that this query is in Sequel Server syntax.

         
        SELECT TOP (10)
          "institution"."name",                        -- anonymized name of institution
          "machine"."id",                              -- anonymized name of machine
          "machineType"."model",                       -- type of machine
          "multileafCollimator"."model",               -- HD or Millenium
          "output"."dataDate",                         -- time and date that data was collected
       -- "output"."analysisDate",                     -- time and date that data was analyzed
          "bbByEPIDComposite"."offset_mm",             -- distance between measured EPID position and expected (plan) location (aka: positioning error)
          "bbByEPIDComposite"."x_mm",                  -- X position in EPID in 3D plan space
          "bbByEPIDComposite"."y_mm",                  -- Y position in EPID in 3D plan space
          "bbByEPIDComposite"."z_mm",                  -- Z position in EPID in 3D plan space
          "bbByEPIDComposite"."bbByCBCTPK",            -- referenced CBCT measurement
          "bbByEPIDComposite"."offsetAdjusted_mm",     -- total distance in 3D plan space adjusted for corresponding CBCT location
          "bbByEPIDComposite"."xAdjusted_mm",          -- X position in 3D plan space adjusted for corresponding CBCT location
          "bbByEPIDComposite"."yAdjusted_mm",          -- Y position in 3D plan space adjusted for corresponding CBCT location
          "bbByEPIDComposite"."zAdjusted_mm",          --  Z position in 3D plan space adjusted for corresponding CBCT location
          "bbByEPIDComposite"."tableXlateral_mm",      -- table position change (RTIMAGE - CT) in X dimension / lateral
          "bbByEPIDComposite"."tableYvertical_mm",     -- table position change (RTIMAGE - CT) in Y dimension / vertical
          "bbByEPIDComposite"."tableZlongitudinal_mm"  -- table position change (RTIMAGE - CT) in Z dimension / longitudinal
        FROM
          "bbByEPIDComposite",
          "institution",
          "machine",
          "machineType",
          "multileafCollimator",
          "output"
        WHERE
              ("bbByEPIDComposite"."outputPK" = "output"."outputPK")
          AND ("output"."machinePK" = "machine"."machinePK")
          AND ("machine"."institutionPK" = "institution"."institutionPK")
          AND ("machine"."machineTypePK" = "machineType"."machineTypePK")
          AND ("machine"."multileafCollimatorPK" = "multileafCollimator"."multileafCollimatorPK")
        ORDER BY
          "institution"."name",
          "machine"."id",
          "output"."dataDate";