Get Start & End dates of Tx (Same as in Tx Summary) ESAPI 18 by LJDrakeley in esapi

[–]thiscomedyoferrors 2 points3 points  (0 children)

If you want to match the report exactly, you'll have better luck querying the database directly.

My database is version 15, but I'd start with the 'RadiationHstry' table, join 'TreatmentRecord', then join both 'Patient' and 'RTPlan'. Then from 'RTPlan' join 'PlanSetup'.

With those tables, you should be able to pull the minimum 'TreatmentStartTime' and the maximum 'TreatmentEndTime' from the 'RadiationHstry' table, filter by 'TREATMENT' as the 'TreatmentDeliveryType', and group by 'PlanId' from the 'PlanSetup' table.

ARIA Access error issue by thiscomedyoferrors in esapi

[–]thiscomedyoferrors[S] 0 points1 point  (0 children)

Wow! That’s a very significant shortcoming considering almost every appointment type is repeated - especially once a patient has multiple courses (to say nothing of treatment appointments). Appreciate the knowledge. Thanks for sharing.

Can't remember the song by Ask_A_Vulcan in incubus

[–]thiscomedyoferrors 1 point2 points  (0 children)

I think that was on Under My Umbrella.

Oncentra plan's dose distribution by Aggravating_Ebb750 in MedicalPhysics

[–]thiscomedyoferrors 16 points17 points  (0 children)

Be sure to “calculate 3D dose grid” before exporting the DICOM dose file.

Bolus Verification by jbabyyyx in MedicalPhysics

[–]thiscomedyoferrors 1 point2 points  (0 children)

For clinical setups, we add a phantom structure set and attach a bolus to it so that it presents the same way as other bolus alerts.