Refer to the VMAT user guide for background information.
SELECT
"institution"."name" as "Institution", -- anonymized name of institution
"machine"."id" as "Machine", -- anonymized name of machine
"machineType"."model", -- type of machine
"multileafCollimator"."model" as "Collimator", -- HD or Millenium
"output"."dataDate", -- time and date that data was collected
-- "output"."analysisDate", -- time and date that data was analyzed
"vmat"."beamNameMLC", -- name of VMAT beam in RTPLAN
"vmat"."beamNameOpen", -- name of open beam in RTPLAN
"vmat"."doseMLC_cu", -- average dose value in CU
"vmat"."doseOpen_cu", -- average dose value of open in CU
"vmat"."beamAverage_pct", -- average percent dose value for all VMAT readings for this beam
-- The following 4 columns are the top, bottom, left, and right positions of the
-- collimator in mm for this data as specified by the RTPLAN.
"vmat"."topRtplan_mm",
"vmat"."bottomRtplan_mm",
"vmat"."leftRtplan_mm",
"vmat"."rightRtplan_mm",
-- The following 4 columns are the the top, bottom, left, and right positions of position of
-- rectangle in mm used to take measurements. This is established by:
--
-- 1: Extracting the position from the RTPLAN
-- 2: Compensating for central axis shift
-- 3: Shrinking the rectangle by a configured amount to reduce the effects of edge penumbras
"vmat"."topAOI_mm",
"vmat"."bottomAOI_mm",
"vmat"."leftAOI_mm",
"vmat"."rightAOI_mm"
FROM
public."vmat",
public."institution",
public."machine",
public."machineType",
public."multileafCollimator",
public."output"
WHERE
("vmat"."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"
ASC LIMIT 10;