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
"bbByEPID"."offset_mm", -- distance between measured EPID position and expected (plan) location (aka: positioning error)
"bbByEPID"."gantryAngle_deg", -- gantry angle in degrees
"bbByEPID"."epidImageX_mm", -- positive direction is to the right.
"bbByEPID"."epidImageY_mm", -- positive direction is up
"bbByEPID"."epid3DX_mm", -- X position in EPID in 3D plan space
"bbByEPID"."epid3DY_mm", -- Y position in EPID in 3D plan space
"bbByEPID"."epid3DZ_mm", -- Z position in EPID in 3D plan space
"bbByEPID"."tableXlateral_mm", -- table position in X dimension / lateral
"bbByEPID"."tableYvertical_mm", -- table position in Y dimension / vertical
"bbByEPID"."tableZlongitudinal_mm", -- table position in Z dimension / longitudinal
"bbByEPID"."bbStdDevMultiple", -- Number of times (multiple) that the BB's mean pixel value was of the background's standard deviation. A higher number means that the BB was more distinctive.
"bbByEPID"."pixelStandardDeviation_cu", -- not including BB pixels. In CU (calibrated units)
"bbByEPID"."pixelMean_cu", -- not including BB pixels. In CU (calibrated units)
"bbByEPID"."isOpenFieldImage" -- 011c LeafJawPositions were more open than the plan called for.
FROM
"bbByEPID",
"institution",
"machine",
"machineType",
"multileafCollimator",
"output"
WHERE
("bbByEPID"."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";